What is Revdb_commit() for anyway?
sunshine at public.kherson.ua
Tue Jan 13 02:24:43 CST 2009
On 1/13/09 12:07 AM, "Jan Schenkel" <janschenkel at yahoo.com> wrote:
> --- Bob Sneidar <bobs at twft.com> wrote:
>> Hi all.
>> I have always been a bit confused at this. So far as
>> I can tell, I
>> cannot get data back INTO a cursor, I can only read
>> data FROM the
>> cursor. In order to write data back to the database,
>> I have to execute
>> an SQL query. So what is Revdb_commit() for? Commit
>> what? I just wrote
>> the data directly to the SQL database in a query
>> didn't I?
>> Or am I mistaken about the ability to write data
>> back to a cursor?
>> Bob Sneidar
> The revdb_commit function isn't meant for committing
> changes to cursors - revdb cursors are by default
> read-only; though I think if used with Valentina
> Server and the VXCMD you can have read-write cursors,
> but I digress.
Yes, Valentina is rare DBMS, which offers you API of Vcursor class that can
do READ and WRITE. AddREcord / UpdateRecord / DeleteRecord.
> It is meant for committing transactions. Depending on
> the database, all the INSERT, UPDATE and DELETE
> statements are each seen as a separate transaction, or
> will be considered one giant transaction until you
> effectively call revdb_commit or revdb_rollback.
This is about COMMIT TRANSACTIONs -- logical set of steps.
VP Engineering and New Technology
Paradigma Software, Inc
Valentina - Joining Worlds of Information
[I feel the need: the need for speed]
More information about the use-livecode