(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Problem with @xlookupSourceList
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Problem with @xlookupSourceList (Read 611 times)
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Problem with @xlookupSourceList
Feb 17th, 2006 at 12:45am
Print Post Print Post  
Hello!

i have a problem with the usage of the @xlookupSourceList
when i type in the following code the @xlookupSourceList  it does not work.
when i use a @xlookup i get a value back (also no path problem)

Please tell me what i`m doing wrong.

hier is the code:

FUNCTION GetLocationInfo(vCode As String)  as String
var vRet as String

   vRet = ""
   vRet = @XlookupSourceList(@fn , vCode, "VariaTemplate!Code", "Code1;Code2;Code3;Code4;Code5")
// vRet = @Xlookup(@fn , vCode, "VariaTemplate!Kode", "Code1")   
Return(vRet)

END FUNCTION
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Carl Underwood
Senior Member
Members
*****
Offline



Posts: 1351
Location: New Hampshire
Joined: Mar 11th, 2003
Re: Problem with @xlookupSourceList
Reply #1 - Feb 17th, 2006 at 1:12am
Print Post Print Post  
You have a different form name in the @XLookup. Is the form name correct in @XLookupSourceList?
  

Carl Underwood
CDU Computer Consulting LLC
Epsom, New Hampshire
Back to top
WWW WWW  
IP Logged
 
Amor
Full Member
Members
***
Offline


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Problem with @xlookupSourceList
Reply #2 - Feb 17th, 2006 at 11:15am
Print Post Print Post  
Hello Carl,

Sorry the Formname is the same but it does not work!
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
IP Logged
 
Ray the Reaper
Global Moderator
Members
Lantica Support
*****
Offline


The One & The Only

Posts: 2482
Joined: Aug 20th, 2003
Re: Problem with @xlookupSourceList
Reply #3 - Feb 17th, 2006 at 1:41pm
Print Post Print Post  
Hello,

Try the code below. If it works then add ";Code2" to the 4 argument. and so on until it does not work anymore. When it stops working you will want to check the element name of the one you just added to make sure that the name is correct.

Code
Select All
FUNCTION GetLocationInfo(vCode As String)  as String
var vRet as String

   vRet = ""
vRet = @XlookupSourceList(@fn , vCode, "VariaTemplate!Code", "Code1")
Return(vRet)

END FUNCTION


So if the above code works try this code

Code
Select All
FUNCTION GetLocationInfo(vCode As String)  as String
var vRet as String

   vRet = ""
vRet = @XlookupSourceList(@fn , vCode, "VariaTemplate!Code", "Code1;Code2")
Return(vRet)

END FUNCTION


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


No personal text

Posts: 366
Location: Germany
Joined: Feb 7th, 2004
Re: Problem with @xlookupSourceList
Reply #4 - Feb 17th, 2006 at 6:19pm
Print Post Print Post  
Hello Ray,

I used your recommendation and finally my error is found:

one element name was incorrect.
  
Dr. med. Amor Belhareth&&Medizin Labor &&Germany
Back to top
 
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