Dr Gerard Hammond wrote:
>Roll your own SQL and give up on the REABasic API's
Unless you are working with blobs, right?
>This'll allow you to use multiple cursors.
Using multiple cursors isn't a question of using or not using the Realbasic
API, IMHO. I'd love to know what makes you think there is no way of
achieving this. There were issues with using multiple cursors when using the
Openbase plugin, but those have been resolved in RB4.
Also, the task as posted in the question doesn't require multiple cursors,
as far as I can see. EOF doesn't mean there is someone else trying to get a
hold of the record. It just means the filepointer is at the end of the file,
which is nothing to worry about.
Burke, could you post some code?
Maxmilian Tyrtania
>>Hi All,
>>
>>Does anybody have some insight on using multiple database cursors. I
>>would idealy like to use on ODBC connection (in this case MS SQL
>>Server 2000) for multiple Selects, Inserts, etc. What if I have a
>>cursor I am looping through and at each row I want to insert a
>>result into the database? Many times I get a EOF issued with
>>cursor.MoveNext because RB thinks there are multiple people
>>accessing the same records.
>
>>Thanks in advance.
>
>>Burke
|