Lantica User Forum - Help with XLookups

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Help with XLookups

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Page Index Toggle

Pages: 1

Send Topic

Print

Hot Topic (More than 10 Replies)

Help with XLookups (Read 1425 times)

Sheena1976 Member Offline No personal text Posts: 7 Joined: Nov 7^th, 2005	Help with XLookups Nov 7^th, 2005 at 10:24pm	Print Post
	Hello, this is the first database that I have ever tried to set up or manage and I have been doing pretty well except I cannot get the only Xlookup that I will need to use to work. What I am trying to do is simply look up a customer number and fill in the name, address, ECT based on that number. Any advice will be greatly appreciated. I am probably being sent to the classes in my area but they are not for a month or so and I would like to get this done sooner than that.


	IP Logged

Bob_Hansen Senior Member Members Offline WOW, They have the Internet on computers now! Posts: 1861 Location: Salem, NH Joined: Nov 24^th, 2002	Re: Help with XLookups Reply #1 - Nov 7^th, 2005 at 11:26pm	Print Post
	Just a quick reminder that XloopUps do not work in the current version with Preview mode. So be sure to save your changes, reconcile your database, and open the database to check to see if XLU statements are working correctly. We have been told that XLUs will work in Preview mode with Version 2. If this does not resolve your problem, it would be best for you to cut/paste the code section that is not working. It will be almost impossible to diagnose without your code sample.

	Bob Hansen Sesame Database Manager Professional Sensible Solutions Inc. Salem, NH 603-898-8223 Skype ID = sensiblesolutions
	WWW Skype/VoIP IP Logged

Sheena1976 Member Offline No personal text Posts: 7 Joined: Nov 7^th, 2005	Re: Help with XLookups Reply #2 - Nov 8^th, 2005 at 3:21pm	Print Post
	I have been testing the lookups in the live mode and they are still not working. I have pasted the code below for your convincience. Thanks again for the help. CUSTOMER_NAME = @XLOOKUP "DATA\CUSTDATA.DB", "CUSTOMER_NUMBER", "CUSTDATA!CUSTOMER_NUMBER", CUSTOMER_NAME)


	IP Logged

proudpoppy Full Member Members Offline Do What ?? Posts: 420 Location: South Carolina Joined: Apr 7^th, 2004	Re: Help with XLookups Reply #3 - Nov 8^th, 2005 at 3:59pm	Print Post
	Try this: LE38=@xlookup(@Fn,LE36,"tentreg!projapt","tenantname") Change names to represent your database.


	IP Logged

Sheena1976 Member Offline No personal text Posts: 7 Joined: Nov 7^th, 2005	Re: Help with XLookups Reply #4 - Nov 8^th, 2005 at 4:10pm	Print Post
	Ok I would love to try that but can someone explain what he just told me? I am REALLY inexpereinced with databases so this is all greek to me.


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Help with XLookups Reply #5 - Nov 8^th, 2005 at 4:44pm	Print Post
	He is basically asking you to try to do the XLookup against the application file that is calling XLookup. @fn returns the filename of the current application. The point would be to determine if the problem is in the file path you are specifying, or if it is in the field path. Try this: Code CUSTOMER_NAME = @XLOOKUP "DATA\CUSTDATA.DB", "CUSTOMER_NUMBER", "CUSTOMER_NUMBER", CUSTOMER_NAME)

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

Sheena1976 Member Offline No personal text Posts: 7 Joined: Nov 7^th, 2005	Re: Help with XLookups Reply #6 - Nov 8^th, 2005 at 5:01pm	Print Post
	I tried the code above and it does not work for me.


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Help with XLookups Reply #7 - Nov 8^th, 2005 at 5:17pm	Print Post
	In both your code, and the code that I posted we are missing the opening parenthesis. Try this: Code CUSTOMER_NAME = @XLOOKUP("DATA\CUSTDATA.DB", "CUSTOMER_NUMBER", "CUSTDATA!CUSTOMER_NUMBER", CUSTOMER_NAME) or this: Code CUSTOMER_NAME = @XLOOKUP(@fn, "CUSTOMER_NUMBER", "CUSTDATA!CUSTOMER_NUMBER", CUSTOMER_NAME)

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

Sheena1976 Member Offline No personal text Posts: 7 Joined: Nov 7^th, 2005	Re: Help with XLookups Reply #8 - Nov 8^th, 2005 at 7:01pm	Print Post
	Im getting the same result with each code. The system slows down like its trying to retrieve the data but nothing is added to the form that I am using.


	IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Help with XLookups Reply #9 - Nov 8^th, 2005 at 7:02pm	Print Post
	Do either of the applications have security? Is @error being set?

	Mark Lasersohn&&Programmer&&Lantica Software, LLC
	WWW IP Logged

proudpoppy Full Member Members Offline Do What ?? Posts: 420 Location: South Carolina Joined: Apr 7^th, 2004	Re: Help with XLookups Reply #10 - Nov 8^th, 2005 at 8:54pm	Print Post
	CUSTOMER_NAME = @XLOOKUP("DATA\CUSTDATA.DB", "CUSTOMER_NUMBER", "CUSTDATA!CUSTOMER_NUMBER", CUSTOMER_NAME) Try this::CUSTOMER_NAME = @XLOOKUP("DATA\CUSTDATA.DB", "CUSTOMER_NUMBER", "CUSTDATA!CUSTOMER_NUMBER", "CUSTOMER_NAME") Also is the custdata.db and the form the same name?


	IP Logged

Ray the Reaper Global Moderator Members Lantica Support Offline The One & The Only Posts: 2482 Joined: Aug 20^th, 2003	Re: Help with XLookups Reply #11 - Nov 8^th, 2005 at 9:02pm	Print Post
	Talked to Sheena on the phone earlier today and her @XLookup is now working. Her problem was Quotes around the second argument and no quotes around the fourth argument. -Ray

	Raymond Yoxall Consulting ray.yoxall@gmail.com ryoxall@lantica.com Sesame Applications, Design and Support
	WWW IP Logged

Sheena1976 Member Offline No personal text Posts: 7 Joined: Nov 7^th, 2005	Re: Help with XLookups Reply #12 - Nov 8^th, 2005 at 9:18pm	Print Post
	thanks again for all your help!


	IP Logged

Page Index Toggle

Pages: 1

Send Topic

Print

‹ Previous Topic | Next Topic ›

« Board Index ‹ Board Top

Top

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

Valid XHTML

Valid CSS

Powered by Perl

Source Forge