>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
>*- This will always result in the selection of one row.
See
Grid reconstruction and how to avoid it FAQ #8019.
--sb--