>>>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.
>
Hi James,
In your case you should just use RecordSourceType=1 && Alias
All other code looks just fine.
HTH
If it's not broken, fix it until it is.
My Blog