Normal Topic @xlookup (Read 1388 times)
09510951
Member
*
Offline



Posts: 33
Location: Hulshorst, the Netherlands
Joined: Jul 21st, 2008
@xlookup
Jul 23rd, 2008 at 7:09am
Print Post Print Post  
bedrijf=@xlookup("d:\Sesame2\program\klant.db","nummer","nummer","naam")

This program line I have entered, saved and reconciled the form, opened the database in Sesame and it just won't work, whatever changes (i.e. removing ") I make.
I have imported it from Q&A where I worked with field numbers. The first thing I tried was just changing the field numbers into element names.
  
Back to top
 
IP Logged
 
alex_smits
Member
*
Offline


No personal text

Posts: 27
Location: Arnhem, The Netherlands
Joined: Dec 15th, 2003
Re: @xlookup
Reply #1 - Jul 23rd, 2008 at 7:26am
Print Post Print Post  
try
bedrijf= @XLookup("D:\SESAME2\DATA\KLANT.DB", NUMMER, "NUMMER", "NAAM")
you must remove tje " by the source field en check the location of the file most of time at the folder data and not the program folder.

Alex
  
Back to top
IP Logged