Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek
Message
 
To
02/06/1999 15:11:56
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Re: Seek
Miscellaneous
Thread ID:
00225552
Message ID:
00225778
Views:
13
James,
The string you seek has to be identical in form to your index. Does your index contain "Alltrim()" for each field?

1. Using Trim() or AllTrim() in an index is NOT a good idea, as an empty string will disappear. You will get strange results.

2. You may need to pad your "Form1.a1social.value" and other values to the exact length of the fields they match.

3. Do you have the same Upper() lower() or Proper() functions in the string you are SEEKing and the index?

All of the above will cause a SEEK to fail.

HTH
Barbara

>seek(alltrim(form1.a1social.value)+alltrim(form1.accession.value)+form1.a4drawdate.value)
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform