Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Listbox - SQL
Message
 
 
To
27/04/2001 09:57:51
Chuck Tripi
University of Wisconsin - Milwaukee
Milwaukee, Wisconsin, United States
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Title:
Miscellaneous
Thread ID:
00497353
Message ID:
00500652
Views:
38
Chuck,

Highlighting the first record in a listbox is easy: use
thisform.list1.selected(1)=.t.
(check first, if you have records in a listbox, of course - I added check by _tally)

Seek should work, I believe, or you can use locate.

>:) Thanks. That did really helped me. BTW, since I was out yesterday, I didn't test for the SEEK to locate back to the live table. Now, my little boy boss gave me something else, didn't quite like it (hey?). He wants the first record hitelited after the 'Find' button (if a record showed up on the listbox). I worked quite hard on this making it that way, to prevent errors, to force the user to mouse over the listbox and pick the record, to be safe, but now... But, thanks for the help to get me this far. I told him few times if he wants to FINISH this project or around with PREFERANCES... I don't think he understand that.
>
>Chuck
>
>>He-he, too late :) I already took a look. The problem was, that the laSQL should be a form property, not a local array. BTW, the name is better to change to aSQL instead of laSQL...
>
>>>Sure, send me the zip and I'll take a look.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform