Well, it turned out to be a bonehead developer issue at this end after all, although, MS might consider saving us from ourselves by removing all chr(13)/chr(10)'s from the .SelectCmd (and perhaps other properties like .UpdatableFieldList, .UpdateNameList, .KeyFieldList etc) or throwing a meaningful error.


Here's the repro (the problem is caused by the chr(13) in the SelectCmd):

close tables
loCursor = CREATEOBJECT("CursorAdapter")
WITH loCursor
  .Alias          = 'CustomersCursor'
  .DataSourceType = 'Native'
  .DataSource     = _samples+"northwind\northwind.dbc"
  .SelectCmd      = "select CUSTOMERID , COMPANYNAME, CONTACTNAME from CUSTOMERS where .t."+chr(13)
  .KeyFieldList   = 'CUSTOMERID'
  .Tables         = 'CUSTOMERS'

  *-- will open a "query" browse on the next line
  .cursorFill() 
  *-- after completion, the "query" cursor is renamed "Customercursor" as expected
  .cursorDetach()
endwith
set
*-- if the cursor is left open, the error will not occur the second time this test is run
use in [CustomersCursor]