Lantica User Forum - Q&A Xlookups not returning accurate results

(UTC)

Lantica User Forum › Lantica Discussions › Lantica Discussion › Q&A Xlookups not returning accurate results

(Moderator: Forum Admin)

‹ Previous Topic | Next Topic ›

Pages: 1

Q&A Xlookups not returning accurate results (Read 1192 times)

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Q&A Xlookups not returning accurate results Nov 11^th, 2006 at 4:47pm	Print Post
	I'm finding that lookups into certain Q&A databases are returning 'aged' data. For instance, I changed the data in Q&A and the Xlookup in Sesame is still showing the old data before I made the change. Restarting the Server software does not seem to help. Do I need to physically turn off the Server computer in order to 'refresh' the data that sesame is looking up? Very strange. Steve


	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Q&A Xlookups not returning accurate results Reply #1 - Nov 11^th, 2006 at 5:14pm	Print Post
	Nope, rebooting the server and client machines did not help. Here is the code that I'm using (RS note is the field I'm changing data in through Q&A but the new data is not showing up in Sesame): var vfooter as string = "" vfooter = (@xlookup("C:\q&a\vendor.dtf","ABC","lookup name","RS Note")) writeln(vfooter)


	WWW IP Logged

The Cow YaBB Administrator Offline Posts: 2530 Joined: Nov 22^nd, 2002	Re: Q&A Xlookups not returning accurate results Reply #2 - Nov 11^th, 2006 at 5:22pm	Print Post
	Is it a Q&A 5.0 database or is it 4.0?

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

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Q&A Xlookups not returning accurate results Reply #3 - Nov 11^th, 2006 at 5:23pm	Print Post
	Steve, I think you are seeing a false symptom. Sesame does not retain the results of an XLookup to Q&A or have any way to get older/different data that what exists in the Q&A database. I would suspect one of the following: 1. You are not changing the copy of the Q&A database you think you are changing. 2. You are not looking into the copy of the Q&A database you think you are looking into. 3. Your XLookup is not running at all and is simply not changing the earlier data. 4. The Q&A database is corrupt and has created multiple duplicate records (a common effect of Q&A index corruption). Any of these sound likely?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Q&A Xlookups not returning accurate results Reply #4 - Nov 11^th, 2006 at 5:55pm	Print Post
	Mark, we're running ver 5.0 Erika, I double checked 1-3 and all seems to be fine. I tried the 'recover database' option in Q&A and that worked for the next xlookup (Gave the results I was looking for earlier). However, all subsequent changes in Q&A are not returned with Sesame Xlookups (I keep getting the same data returned just after the 'recovery). Seems like the Xlookups only return accurate results after running a 'recovery' in Q&A. Perhaps a corrupt Q&A database problem and beyond the scope of Sesame support. Not a big deal, as we're trying to phase out Q&A, anyways. Thanks for the 'after hours' tech support. You guys have been fantastic in the past, and it's great to see you haven't changed a bit. Thanks, Steve


	WWW IP Logged

Hammer YaBB Administrator Lanticans Offline Fire bad. Tree pretty. Posts: 3436 Location: Ohio Joined: Nov 22^nd, 2002	Re: Q&A Xlookups not returning accurate results Reply #5 - Nov 11^th, 2006 at 6:01pm	Print Post
	Is the Q&A database still open in Q&A while you are doing this?

	- Hammer The plural of anecdote is not data.
	WWW IP Logged

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Q&A Xlookups not returning accurate results Reply #6 - Nov 11^th, 2006 at 6:05pm	Print Post
	No, the database is closed. I just made some changes, saved the record, �closed the database, closed Q&A completely then ran my xlookup from Sesame and I'm still getting the same data that was returned just after the last 'recovery' in Q&A. Also, I'm the only user in the office today and all other computers are shut down. The server has been rebooted so no other copies of Q&A are currently running...or sesame for that matter. Steve


	WWW 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: Q&A Xlookups not returning accurate results Reply #7 - Nov 11^th, 2006 at 7:43pm	Print Post
	Do you get the correct result if you use the same XLU in Q&A? Make a temp field in a Q&A database and try the EXACT same syntax to see what you get back as a result. Then make changes in Q&A Source field and compare results in Q&A and Sesame.

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

Steve_in_Texas Senior Member Offline No personal text Posts: 893 Location: San Antonio Joined: Feb 21^st, 2004	Re: Q&A Xlookups not returning accurate results Reply #8 - Nov 11^th, 2006 at 7:47pm	Print Post
	Bob, good suggestion, but I am not familiar enough with Q&A to test your suggestion. I can get by with 'semi-correct' data until we ween ourselves off of Q&A. Thanks, Steve


	WWW IP Logged

Pages: 1

‹ Previous Topic | Next Topic ›