Hi all!

I used Q&A before coming to Sesame so I am well aquainted with the xlookup family and their use.  I have been working on getting xlookups working in Sesame under Linux and have so far not gotten a single one to work ever!

I have tried everything and so far have figure nothing out.

I am using the LE names not the labels or database names.
I am stating the layoutname followed by an exlamation mark then the key field for the external key.

I read and worked through Alec Mulvey example in the April 2004 Inside Sesame and even it does not work to lookup when the zip code is typed in.

I have tried the slashes going both ways it the path to the external database.
(Data/Samples/   or  Data\Samples)
I have tried both the old linux and new linux versions.
I have tried external lookups and lookups on the same database.

I am starting Sesame in the /root/Sesame directory right under this is the Data directory.

At this point I am at my wits end after working several days over the past week on this. Is anyone else out their running Sesame 1.1.3 on Linux that has the xlookups working?

Anyone  have any ideas? I am starting to thing that the xlookup functionality got broken in this Linux version.

Frederick   ???

I am not in preview mode. I reconcile the database each time to test. Too bad lookups could not work in Preview mode. I could real use this feature.

By absolute path do you mean /root/Seasame/Data/MyDatabase.db ?

I have tried this too.

Is the working directory where you start the program from?  Not neccessarily where the executable is.  I am guessing the working directory would be where the open file dialog would take you unless your rootdir.ini says different.

It's probably pure coincidence,  but I have two applications where the xlookups quit working after weekend programming changes and reconciliation to the live database. 

One of the apps has been running for over a year  on a linux server with no problems in the xlookup function.  I am still debugging, but so far nothing.

I always use the @fn and have had no problems before.  When I display the value of @fn to the screen, it appears to have the correct path.  I have also tried using an absolute path and a relative path. 

The backup files are still functioning properly. 

My next step is to transfer the applications off the server and try them locally to see if that makes any difference.

Hello Don,

It has been a while. How have you been?

If your element names did not change, check your security. Make sure that the X Username and X Password is still a valid login for that application. I saw this about a week ago in another app.

-Ray

Thank everyone!

I got it them working. One was a case sensitivity issue. The other was a xlookup user password issue.

Mark, I think the command you meant was pwd not cwd. pwd stands for Present Working Directory. But you proabably knew that. I put it here for reference for someone looking latter at this thread.

In Alec's article from Inside Sesame the folder "Sample" was not capitalize in the command I cut and pasted. I also figured out that the case matters down to the file name as well as in Alec's article  in the code it was named zipcode.db and in the "Sample" folder ZipCode.db and it would not work until named so.

Another thing that I figured out is that even if you have set all the users passwords to nothing the file still has security and will not even perform a lookup on itself. I thought with it like that it was open but the security manager thought othewise.

Thanks to Ray and Mark for the help!

Now one other question regarding casesensitivity. The other day I downloaded the Inside Sesame Index database. I could not get it to run  after I unzipped it. In the zip file the names inculding the extensions were all capitals. It would tell me that it could not find a necessary file and then abort. On a whim I rename the file with all small letter and it worked. Now the question is why?   

Now while you figure that out I am going to go level the playing field so to speak. I am going to change all my Sesame folders and file names to all lowercase so I am not second guessing myself when I go to program an x-family command. 

Quote:

Yes. Your key value is the literal text "Car". Try removing the quotes from the key parameter.