Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Seek record in cursor
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00410485
Message ID:
00410660
Views:
19
>>Can I create the cursor in the init of the form and then set the grids recordsource to it as a property???
>
> Your cursor has to be updatable in order to create index (index on command).
> To make cursor updatable you can either create it in Init method of your form (or the grid) (Create Cursor command) or use dbf('myCursor') again alias myUpdatableCursor or wait till VFP 7.0, where we will have ReadWrite option :)

Hello Nadya,

Sorry, I still need help.

This is in my grid1 init:
select name, yr_bred from master where type = "B" into cursor namebred
inde on name to name

The grid1 recordsourcetype is "4-SQl" and recordsource is "namebred".

The form and grid1 load but no data shows.

If I put "namebred.name" in the grid1.column1.controlsource and "namebred.yr_bred" in the grid.column12controlsource I get an error message that "Alias namebred is not found".

Am I getting close, I just want to learn how to popluate a grid with a cursor that's been indexed so I can search the cursor.

TIA,

Jim Harvey
jharvey@netrax.net
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform