VFP 愛用者社區

[Ruey]

Sending the data returned from SQL to our local cursor
However, this isn’t the name of the cursor that you bound the form’s controls to. When you design a form, you drag fields from a DBF in the data environment to the screen, thus automatically setting the ControlSource of each field. The ControlSource contains the name of the cursor, a period, and the name of the field (e.g., Customer.Phone.) You can’t use the existing cursor as the third parameter, because SQLExec expects to create a new cursor. But if you append it into the cursor that was opened in the Load event, it won’t break the data bindings. All you have to do is make sure that the field names are the same.

Of course, you can’t simply write

SQLExec ( Handle, [], [ABC] )
SELECT XYZ
APPEND FROM ABC
because ABC is an alias, not a DBF, and the APPEND FROM statement requires a DBF name. However,

APPEND FROM DBF ( [ABC] )
works just fine, since the DBF() function returns the temporary file name that the alias is using (usually something like 30324142.tmp).