Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Grid Set Near/recno(0) won't work
Message
From
23/01/2001 11:33:34
 
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00462328
Message ID:
00467365
Views:
13
Martin:

Thank you very much for the reply. using an ALLTRIM() for my search string resulted in it working. Apparently, it was the phenomenon you were describing. I also had to user UPPER() for my search string since the data in the field being searched was in upper format.

Again, thanks for the insight.

>Hello, Wesley.
>
>Check for the lenght of the string. If you'are using SET NEAR, and look for the string "WES" you can find "WESLEY", but if you look for "WES ", and there is no record begining with these exact characters, you'll end at EOF.
>
>Hope this helps. Tell me if the problem persist.
>
>>I have been searching the archives here for a while now and find several threads that seem on point, yet a solution is eluding me. I am simply trying to do a seek on an indexed table, which is bound to a grid on a form. I need the pointer to stop where it would as in SET NEAR ON. It's going to EOF.
>>
>>Pertinent info:
>>-no dataenvironment is being used.
>>-in the .init of the form, I SET NEAR ON, open the table, set the index order, set rowsourcetype=1 and rowsource='mytable'
>>-form launches and displays the content of 'mytable' in the grid
>>-I put the search string in a memory variable, and then conduct the search (SEEK) with a command button and then call grid.setfocus
>>-the pointer keeps coming out at EOF.
>>
>>I know I'm probably missing something simple. Any help would be appreciated. Thanks.
Wesley T Kozeny
Wesley T Kozeny LC
1303 Red Oak Plantation Drive
Ballwin MO 63021
314-991-0255 phone
314-991-6755 fax
wkozeny@wkozeny.com
Previous
Reply
Map
View

Click here to load this message in the networking platform