lo_metrics_log_cad = CREATEOBJECT("metrics_log_cad") lo_metrics_log_cad.NoData = (( .t. )) lo_metrics_log_cad.CursorFill() && Produces csr_metrics_log as a cursor ... SELECT csr_metrics_log && My SQL Server cursor APPEND FROM metrics_log && My local log data in a local DBF file (C:\TEMP) TABLEUPDATE( (( .t. )) ) && Stores my data over to SQL ServerThere are times when, for whatever reason, the Cursor Adapter fails and does not return a cursor. I do not understand why this is. However, I have noted that I NEVER have a failure when using SQLEXEC(). So, as you might surmise, I'd like to use SQLEXEC exclusively because in this application, I CANNOT have this function fail.
SELECT TOP 0 * FROM tab_metrics_logIn SQL Server Query Analyzer, this returns what I expect: An empty cursor. However, when I issue the SQL through SQLEXEC it fails to return an updateable cursor (i.e. I cannot APPEND and then TABLEUPDATE(.t.) and get the records to move back to SQL Server successfully).