What is Revdb_commit() for anyway?

[Ruslan Zasukhin]

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.

Yes,

This is about COMMIT TRANSACTIONs -- logical set of steps.


-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]