General information
Category:
Coding, syntax & commands
>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:)
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only