(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › xlookups and security
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic xlookups and security (Read 3510 times)
Nancy
Member
*
Offline


No personal text

Posts: 9
Location: Pittsburgh
Joined: Feb 9th, 2006
xlookups and security
May 22nd, 2006 at 3:27pm
Print Post Print Post  
I cannot get my xlookup to work,  i do have security and have set the X User Name correctly (mine), yet I get nothing.  No lookup or error message.

Can anyone give me a clue.  I don't have quotations where I don't need them, I do have directory spec'd as necessary. Cry
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: xlookups and security
Reply #1 - May 22nd, 2006 at 3:31pm
Print Post Print Post  
Hello Nancy,

Could you post what your code looks like?

-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
IP Logged
 
Nancy
Member
*
Offline


No personal text

Posts: 9
Location: Pittsburgh
Joined: Feb 9th, 2006
Re: xlookups and security
Reply #2 - May 22nd, 2006 at 3:49pm
Print Post Print Post  
PRODBY = @xLOOKUP("D:\Sesame\Data\employee", PRODBY, "EMPLOYEE!Initials", "FullName")

//PRODBY IS THE NAME OF THE FIELD
  
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2480
Joined: Aug 20th, 2003
Re: xlookups and security
Reply #3 - May 22nd, 2006 at 4:00pm
Print Post Print Post  
Hello Nancy,

Is employee a Q&A file or a Sesame File?

If it is a Q&A file your code will need to be
Code
Select All
PRODBY = @xLOOKUP("D:\Sesame\Data\employee.dtf", PRODBY, "EMPLOYEE!Initials", "FullName")


If it is a Sesame file your code will need to be
Code
Select All
PRODBY = @xLOOKUP("D:\Sesame\Data\employee.db", PRODBY, "EMPLOYEE!Initials", "FullName")


-Ray
  
Raymond Yoxall Consulting
ray.yoxall@gmail.com
ryoxall@lantica.com
Sesame Applications, Design and Support
Back to top
WWW WWW  
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: xlookups and security
Reply #4 - May 22nd, 2006 at 6:49pm
Print Post Print Post  
Also, a reminder that XLUs do not work in Preview Mode.
  


Bob Hansen
Sesame Database Manager Professional
Sensible Solutions Inc.
Salem, NH
603-898-8223
Skype ID = sensiblesolutions
Back to top
WWW WWW Skype/VoIP Skype/VoIP  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2024. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge