General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>I have created a cursor from another cursor, and I need to Insert one record at the end of the file.
>>
>>I set up the CursorSetProp("Buffering", 5, "cData"), and attempt to Insert the record, I get the error "Cannot Update The Cursor".
>>
>>MULTILOCKS is ON
>>
>>The code is as follows:
>>IF CURSORSETPROP("Buffering", 5, "cData")
>> INSERT INTO cData (cDep, nFlights) VALUES ("TOTAL", lnFlights)
>>ENDIF
>>
>>TIA,
>>Mark
>
>Mark
>
>How did you create it? Is it ReadOnly? If so use it again to make it RW.
>
>Macer
I created the cursor using a SQLEXEC command for example:
=SQLEXEC(gnFileHandle, "SELECT * FROM AC_Schedule", "cSQLFlightData")
It is at this point, I need to make cSQLFlightData Read Write, so I can add one record.
To make things a little bit more complicated, this is an Internet application and therefore do not want to create (if possible) any tables, I want to use views only.
Is there a CursorSetProp("ReadOnly", .F.) ?
Regards
Mark
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only