Hi Willie,

>Ok so if I understand you correct I do not use views for Local SQL PT cursors but I do use them for MS SQL/ODBC.

Local SQLPT cursors are the same as non-updateable SQLPT cursors (for SQL server access). You specify the SELECT statement in the cSource property. You only specify a view name in three circumstances; 1) When using a Remote View; 2) When using a Local View; 3) When using an Updateable SQLPT cursor.

When you are using a SQLPT cursor (non-updateable) you specify SQL syntax starting with the word SELECT - this assumes that you are specifying pure T-SQL as it is being executed by the back end SQL server. When you are executing a Stored Procedure, the first word specified in cSource is EXEC followed by the sproc name. When you are using an LSQPT cursor, you specify a pure VFP select statement, again starting with the word SELECT.

>If I ignore this error the data is displayed. However, changes to the data is not saved.
>In my csource propery I used the following:
>
>select * from (cdatadir + 'client')

First, a LSQLPT cursor is "READ ONLY". You cannot update the data - period. I assume "cdatadir" is a variable and that it is in scope when the query is executed?

>This is working except for one error:
>Visual FoxPro 07.00.0000.9465 for Windows [Jan 4 2002 02:58:33] Product ID 55181-015-6059796-03084
>CodeMine 7.1.02
>Error #1468 in Setrelation line 16
>"m.cSourceTable = CURSORGETPROP('Tables', .cWorkarea)"
>Property is invalid for table cursors.

Are you assuming an index here? Remember, the cursor is read only - it must be some sort of configuration problem due to your misunderstanding of the LSQPT cursor.

Best