Very Hot Topic (More than 25 Replies) Learning the ropes (Read 8154 times)
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Learning the ropes
Jan 4th, 2004 at 11:08pm
Print Post Print Post  
I'm just going through the tutorial and learning how to create a form etc.  When I tried to save my finished work I get an error message that says "the specified path does not have write permission".   What the heck does that mean? Undecided
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Learning the ropes
Reply #1 - Jan 4th, 2004 at 11:37pm
Print Post Print Post  
I also saw that a few times, but have had trouble reproducing it.  As I recall, when the message came up, I tried to save again 2 or 3 times, changed to a different path, and came back to desired path again.  Or else I had to closed Sesame and restarted again and it was OK.

For information purposes, my copy was installed to a mapped drive on a network, and the data files were also on a different path to a mapped network drive.

This problem has only happened to me twice, and I don't know of any special conditions.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #2 - Jan 5th, 2004 at 12:03am
Print Post Print Post  

I've tried several times to save it with the path suggested but keep getting the same error message.  Could it have anything to do with my OS Windows XP?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #3 - Jan 5th, 2004 at 12:25am
Print Post Print Post  
Quote:
I'm just going through the tutorial and learning how to create a form etc.  When I tried to save my finished work I get an error message that says "the specified path does not have write permission".   What the heck does that mean? Undecided


It means that you do not have write permissions on the directory where you are trying to save your file.

Are you using XP Pro or XP Home?

Are you the Administrator for your computer?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #4 - Jan 5th, 2004 at 12:32am
Print Post Print Post  
Hi,  
Thanks for responding.  I'm using XP pro.  I'm the admin.  Is there something I have to change?  I tried to save it to A:\..etc and got the same error message.
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Learning the ropes
Reply #5 - Jan 5th, 2004 at 1:04am
Print Post Print Post  
On my system with the problem, it is WIN98 SE.  No problems with access rights.  After 4-5 attempts, it was OK.  Again, mine was to a mapped external drive (not a computer), perhaps a timing issue in trying to resolve  mapping vs. UNC?

Reviewing my notes on 12/30/03:
1.  Had to try four times to create Application name on Tutorial, page 18.  Got message that could not write to that location.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #6 - Jan 5th, 2004 at 2:12pm
Print Post Print Post  
Do you have the term "[DRIVES]" appearing in your rootdirs.ini file and is the rootdirs.ini file someplace where Sesame can find it? Otherwise do you have the drive letter or UNC path you are saving to - specified in the rootdirs file?

If so, do you have write permission in that directory on the target computer and in all of its parent directories?
  

Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #7 - Jan 5th, 2004 at 2:39pm
Print Post Print Post  
On page 28 of the tutorial under "saving your design as an application" it tells the user to click on Application/Save as New Application and then type C:\Sesame\Data\MyContacts.DB   This is where I'm getting the error message "the specified path does not have write permission".  I've tried saving it to A:\ etc. and get the same message.  I've checked the root directory and under C:\ there is a folder called DRIVERS.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #8 - Jan 5th, 2004 at 2:58pm
Print Post Print Post  
Quote:
On page 28 of the tutorial under "saving your design as an application" it tells the user to click on Application/Save as New Application and then type C:\Sesame\Data\MyContacts.DB   This is where I'm getting the error message "the specified path does not have write permission".  I've tried saving it to A:\ etc. and get the same message.  I've checked the root directory and under C:\ there is a folder called DRIVERS.


Kathie,

The following instructions assume that you installed to the default directory (c:\Sesame) and are launching using the shortcuts that were automatically created for you without modification. If this is not the case, please let me know!  Grin

You should have a file on your hard drive c:\sesame\rootdirs.ini
That file should look like this:

Data
Data\Samples
.
[DRIVES]

If this is not the case, please let me know!  Grin

When you select Save As New Application, a dialog box will open asking you to name your file. The filename box should already say C:\Sesame\Data\
If this is not the case, please let me know!  Grin
You do not need to retype the "C:\Sesame\Data\" part. When you click Accept, the filename should say
C:\Sesame\Data\MyContacts.DB

Does it?

Open Notepad. Type a few characters. Try to save the file to the C:\Sesame\Data folder as testing.txt. Were you able to do so?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #9 - Jan 5th, 2004 at 3:28pm
Print Post Print Post  
I have a file called C:\Sesame Trial.  When I click on that folder it takes me to a list of other folders one of which is Data.  Clicking on that takes me to a folder called Samples and now the test.txt file I saved from notepad. When I tried to save the Application the words C:\Sesame\Data do not appear in the window.  Only the Data appears.  I haven't located a file called c:\sesame\rootdirs.ini or Data  Data\Samples  .  [DRIVES]
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #10 - Jan 5th, 2004 at 3:37pm
Print Post Print Post  
Quote:
I have a file called C:\Sesame Trial.  When I click on that folder it takes me to a list of other folders one of which is Data.  Clicking on that takes me to a folder called Samples and now the test.txt file I saved from notepad. When I tried to save the Application the words C:\Sesame\Data do not appear in the window.  Only the Data appears.  I haven't located a file called c:\sesame\rootdirs.ini or Data  Data\Samples  .  [DRIVES]


If you only have the trial version, you do not have a C:\Sesame directory. The tutorials are written to run against the installation locations for the full version. When you save your tutorial app, try saving it as
C:\SesameTrial\Data\MyContacts.DB

Note that there is no space between Sesame and Trial.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #11 - Jan 5th, 2004 at 3:41pm
Print Post Print Post  
Okay, I'll try that later today when I get back.  Gotta go to a meeting now.  Thanks for your help.

Kathie
  
Back to top
 
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Learning the ropes
Reply #12 - Jan 6th, 2004 at 1:02am
Print Post Print Post  
My rootdirs.ini is in Q:\Sesame\ folder where I installed Sesame.  Applications and DSRs are in Q:\Data\Sesame folder.

Content of rootdirs.ini file is here.  Matches your definition:
Quote:
Data
Data\Samples
.
[DRIVES]


Clicked on Save as New Application.  Default path already in filename field is:q:\Data\Sesame\.  Matches your definition.

Problem occured when doing the following: left click mouse on field for database root directories, drag down to letter q:, releasing mouse.  Double clicking + on Q:\Data folder to expand, left click on Sesame folder at Q:\Data\Sesame, entering "newname" (no extension included) in the filename field, and left click on Apply.

It just happened now ??? Grin ???, as I was recording my steps on the forum.  Got the message "Error: The specified path does not have write permission." 

Clicked on OK button.

View returned to New Sesame Application tree.  Tried again, Save as New Application, same decisions and steps , file was saved.  Confirmed that the DB and DAT files were saved with the correct date/time. 

This time the saving happened on just the second attempt.  Earlier instances took 4-5 attempts before it would save.  I was surprised that I was able to duplicate it, because it does not always happen.  Just did it again with a new application filename, accepted the first time, no error message. ??? Grin ???

Again, drive Q is an external drive, mapped, not using UNC.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #13 - Jan 6th, 2004 at 1:43am
Print Post Print Post  
[If you only have the trial version, you do not have a C:\Sesame directory. The tutorials are written to run against the installation locations for the full version. When you save your tutorial app, try saving it as
C:\SesameTrial\Data\MyContacts.DB

Voila!!  It worked.  Now on to creating reports.  I'm a Q&A user (not programer).  So far I like Sesame and will probably buy the full version.

Thanks guys for all the help. 

Kathie

  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #14 - Jan 6th, 2004 at 12:45pm
Print Post Print Post  
Bob,

There is actually a small bug in the file selector. If you expand and contract folders, it will sometimes  strip off the drive letter, leading to this message.  The second time, you make the exact same choices, buy very carefully to make sure. So you don't cause the condition and the file saves.   Wink

This will be fixed in the next bug release. Until then, look carefully at the file path before hitting Accept and make sure that it is complete.

Kathie,

I'm glad the right path worked for you. Enjoy Sesame!  Grin
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #15 - Jan 7th, 2004 at 2:56pm
Print Post Print Post  
Still learning the ropes.  Got to where I want to format a field as money and another as a date field.  Does the trial version allow for this function?  I'm in the design/redesign mode, format tab, clicked on the field I want to format and highlighted money format but it says "not set".  What am I missing here?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #16 - Jan 7th, 2004 at 3:04pm
Print Post Print Post  
Quote:
Still learning the ropes.  Got to where I want to format a field as money and another as a date field.  Does the trial version allow for this function?  I'm in the design/redesign mode, format tab, clicked on the field I want to format and highlighted money format but it says "not set".  What am I missing here?


You are looking at the Property Viewer. This displays current settings. The control panel above it is the Property Editor, where you can actually change settings. The instructions for doing this begin on page 86 of the User Guide.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #17 - Jan 7th, 2004 at 4:01pm
Print Post Print Post  
I've followed the instructions from page 86 thru 90. I get a message when I click on close design tab  that says the current design has been changed but not commited to the database. I know I'm missing a step some where. Sorry for being such a dunce.

I went back and made sure I double clicked save layout design.  Then I went to the db in trial version and tested the elements to see if the format had been applied.  It had not.  The money field is just numbers and so is the date field.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #18 - Jan 7th, 2004 at 4:12pm
Print Post Print Post  
Whenever you make changes, you need to save them. The Save Layout Design command is in the Commands panel near the top of the Control Panels area. Click once in the Commands panel to set the focus, then click Save Layout Design.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
BOBSCOTT
Senior Member
Members
*****
Offline


That Darn Computer #$X#
{curse words}

Posts: 1195
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #19 - Jan 7th, 2004 at 4:42pm
Print Post Print Post  
Quote:
I want to format a field as money and another as a date field.


Kathie,

Another easy way to change a field type if you already created it  is in Sdesigner under manage a database manage fields.

Open your dsr in Sdesigner
Click Manage A database
Under the database your working on
Click Manage fields
In the box that opens click on the Action field
Click on change field type
Under field name select field
Click add to batch
When you have selected all fields you want to change
Click
Run batch.

Like Magic its done. Its that easy

Hope this might be of some help.  Smiley
  

Team – Together Everyone Achieves More
Back to top
 
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #20 - Jan 7th, 2004 at 5:05pm
Print Post Print Post  

Okay, I'm really getting frustrated here.  I did as you suggested with the "manage a database" etc.  and the format is not working.  My dsr file has two elements which need to be formatted for my reports to work.  One is Sale Price as a money field the other Sale date (in January 7, 2004 format)  I clicked on add transaction to batch after assigning the formats and then run batch.  I then went back to the db in trial version and tried adding data to the db.  The money field is still text numbers and the date is too.  What the heck am I doing worng??
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #21 - Jan 7th, 2004 at 5:21pm
Print Post Print Post  

I'm getting a little confused too.

Which of the following are you trying to do?
1. Change a Text field to be a Money field.
2. Change the way an element bound to a Money field displays the field value?
3. Both.

Are your changes working in Preview mode?

After making your changes, did you Reconcile to apply the changes to the db?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #22 - Jan 7th, 2004 at 5:42pm
Print Post Print Post  
In Q&A to set a field as a date or money field I used design menu, customize menu, format value and then typed MC for the money field and D for the date and then set the way the date should appear in the db.  In Sesame I'm trying to set the money field so it appears as $123,456 and the date as January 7, 2004 format.   So to answer your question I guess I'm trying to do both.  Preview mode??  Not sure what that is.  I'm a realtor with a prospect database of 4700 records.  I do reports of current sales from my Q&A db.  I'm hoping to convert the db to Sesame mostly because of the printing restrictions of Q&A.
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #23 - Jan 7th, 2004 at 5:45pm
Print Post Print Post  
Open your dsr in Designer.
From the Design Menu tree, choose Application / Preview Application

This opens your design in Preview mode.  It will behave exactly like Sesame with a few minor exceptions.

Is your data correctly formatted in Preview mode?
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #24 - Jan 7th, 2004 at 5:59pm
Print Post Print Post  
In preview mode/add data the money and the date are correctly formatted.  Now I'm REALLY confused. <G>

Oops the date entered as 1/7/04 returns January 7, 1704
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #25 - Jan 7th, 2004 at 6:45pm
Print Post Print Post  
Quote:
In preview mode/add data the money and the date are correctly formatted.  Now I'm REALLY confused. <G>

Oops the date entered as 1/7/04 returns January 7, 1704


Okay, then you need to Reconcile the changes to the db. The db doesn't know that you changed things in the dsr until you Reconcile. See page 131 of the User Guide.

BTW, 1/7/04 does not return Jan 7, 1704 but 1704 does. I think you may have been caught by the bug that makes the / on the numeric keypad not work.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #26 - Jan 7th, 2004 at 7:00pm
Print Post Print Post  
Thank you for all your help.  BTW is that an internet bug or Sesame bug??
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #27 - Jan 7th, 2004 at 7:36pm
Print Post Print Post  
Sesame bug!   Smiley
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Bob_Hansen
Senior Member
Members
*****
Offline


WOW, They have the Internet
on computers now!

Posts: 1861
Location: Salem, NH
Joined: Nov 24th, 2002
Re: Learning the ropes
Reply #28 - Jan 8th, 2004 at 12:39am
Print Post Print Post  
Quote:
If you expand and contract folders, it will sometimes  strip off the drive letter, leading to this message.  The second time, you make the exact same choices,

Thanks Erika, I will watch closely to see is that is happening.
  



Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #29 - Jan 8th, 2004 at 9:46pm
Print Post Print Post  
In creating reports I've read all the info and followed it correctly I think.  Created a report and saved it etc.  What I didn't notice at the beginning was a pop up that asked if I wanted to replace the current file name.dsr?  with a yes or no button choice.  I hit yes and now have discoverd that it wiped out my form, db, the works. I've recreated my form and db and again went to Application  utilities/redesign current application and am sitll getting that same pop up.  Where did I goof?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #30 - Jan 8th, 2004 at 11:08pm
Print Post Print Post  
Kathie,

It sounds to me like, at some point, instead of redesigning your existing app, you clicked on Design New Application. Then, you told it to overwrite your existing dsr with the new blank dsr.

You will always get that popup when you select Redesign Application.  If you have actually selected Redesign, then overwriting should do no harm and is, in fact, often exactly what you want to do. Perhaps we should reorganize the command tree so these commands are not together...?

FYI: if this happens again, remember that your db is untouched by this. Close Designer. Go back to Sesame. Click Redesign Current Application. The dsr file you save will have your design back, good as new!
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #31 - Jan 9th, 2004 at 1:17am
Print Post Print Post  

Hammer you have the patience of Jobe, thank heaven.  Okay got the report set up, very basic, can't figure out how to seperate the columns farther apart but I'll get to that later. In Q&A I just call up the records I want and fill in the sort spec's and I get the results I'm looking for.  (Will all that transfer over from Q&A)  I've opened the database in Search/Update mode. On Page 376 the next step is Retrieve/Sort the records to include in the report.  Do I type the sort spec's in the fields on the form?  I don't see a sort option on the tree.

Again thanks for you patience and help.

Kathie
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #32 - Jan 9th, 2004 at 1:12pm
Print Post Print Post  
The Sort Spec is one of the specs available in the Spec Window at the lower left corner of your screen.  Instructions begin on page 230 of the User Guide.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged
 
Kathie
Member
*
Offline


No personal text

Posts: 17
Joined: Jan 3rd, 2004
Re: Learning the ropes
Reply #33 - Jan 9th, 2004 at 9:08pm
Print Post Print Post  
Thanks again Hammer for your help.  I've got the sort spec figured out but still have questions.  My report in Q&A sorts four fields as follows: Model 1,DS   Sale Date 2, DS, YB, F(D3)   Sale Price 3, SA and Location 4.  Is there a way to put in these sort commands?
  
Back to top
 
IP Logged
 
Hammer
YaBB Administrator
Lanticans
*****
Offline


Fire bad. Tree pretty.

Posts: 3436
Location: Ohio
Joined: Nov 22nd, 2002
Re: Learning the ropes
Reply #34 - Jan 9th, 2004 at 9:37pm
Print Post Print Post  
The report will use your current retrieved records in their current sort order. Retrieve the records you want, sort them, and run your report.

If you always want the report sorted a certain way, you can attach specs to reports. Look at pages 369-370 of the User Guide.
  

- Hammer
The plural of anecdote is not data.
Back to top
IP Logged