Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Seek record in cursor
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00410485
Message ID:
00410846
Vues:
21
>>>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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform