Information générale
Catégorie:
Codage, syntaxe et commandes
>When you dbl-click on grid row, you actually move pointer exactly on this recordsource (cursor) record. If you want to take data not only from this record, but from other tables/cursor then your grid cursor should carry primary key from the underlying table(s).
But if you have a primary key in the grid...wouldn't it show up in the grid?
>Copule more considerations, not required generally. There is no necessity to run SQL-Select twice to get identical cursors, you may just
>USE (dbf()) AGAIN ALIAS newcursor
>to reopen it in another work area and then use both independently. Also, you may index a cursor, i.e. you don't need to re-run SELECT-SQL with different ORDER clauses. Create your cursor once, and index it with few tags.
So I can just use INDEX on the cursor? I thought that would create and index file...I'm sooo fresh with using SQL, I appreciate your patience
> One more thing, when you create cursors (SELECT_SQL) for subsequent data manipulation, you will be safer if use NOFILTER clause.
I've heard this over and over again, could you explain exactly what NOFILTER accomplishes, or safeguards me from?
Thanks, Ed, you've always got good suggestions:)
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement