I am trying to use a cursor (ReadWrite) as the RecordSource for a grid with RecordSourceType = 1 (Alias).
At design-time the grid's
RecordSource property will occasionally change to a Table from the desired cursor. When I change this property back to the desired cursor, it also resets (clears out) all of the Grid Column
ControlSources.
What am I doing wrong ????
PS. The cursor is created in both the Main.Prg (before any Forms are invoked) and also in the Form's DataEnvironment
BeforeOpenTables event using the following SQL statement:
SELECT cLineNo, cPart, cDescript, cColor, nQty, cLength, cStatus ;
FROM OrDetail ;
INTO CURSOR curCurrentOrder ;
WHERE cLineNo = "1" ;
READWRITE