Thanks Gary

Sorry for all the stupid questions. You have really been a great help since I am totally new to the cde and SQL development.


>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