Manolo Garrido wrote on Wed, 6 Feb 2002 15:26:41 +0100:
>>> I am trying to connect to a MySQL database on a remote machine with a
MySQL
>>> plugin, but unfortunately it is not allowing me to update or delete
>records.
>>>
>>> Is there any other way to do this?
>>>
>>> Maybe with the general RealBasic ODBC driver, but then I need to
>install the
>>> MySQL driver, do I? but don't know how.
>>>
>>> Has anyone any hints on this?
>>>
>>> Thanks
>>>
>>> Manolo
>>
>> It wouldn't be a MySQL permissions issue would it?
>
>I don't thin so as I don't have any problems to connect or even to insert
>new records. I am using MySQL Plugin Demo from Essence and it actually
>specifies that deletion and updates are not allowed...
It is an issue regarding the way MySQL result sets work. In MySQL,
there is no such thing as a cursor. All there is a batch of results
which are sent back to the client. The server doesn't know what the
active row in the database is for your result set, so you can't update
or delete using a DatabaseCursor.
You can update and delete using SQLExecute, however.
--
James Milne
Essence Software
<http://www.essencesw.com/>
<mailto:james at essencesw dot com>
|