What's the best way connect and update?

[foxbldr]

Hi,

I am new to Pervasive SQL. I am using VF8/ODBC to bring data from server to client's application.
Can somebody advise me on the following issues:

1. What's the best way to handle concurrent updates? What Pervasive SQL global variables available to client application to track transactions?

2. Should I stay connected in order for the server to handle concurrent updates? If not, what is the best way to do that?


Thanks everybody in advance.

Foxbldr

 

[TomKane]

Well, we just do our updates as in-line SQL - Pervasive is extremely stable and it's never caused us any problems.

 

[foxbldr]

Tom,

Thanks for the reply.

Will you direct me to a site where I can read more about Pervasive concurrent updates. I just read CHMs from Pervasive web site and found nothing much about updates.

Thanks

Foxbldr

 

[TomKane]

I can't think of a place off the top of my head (sorry) but if you're using Pervasive because of an app you have is based upon it then maybe you could go back to the vendor they may have some information that you might find useful.

Sorry I can't be any more help than that...

 

[mirtheil]

Multi-User Operations within Pervasive are handled in a FIFO (first in, first out) method. THat being said, if user A reads a record, user B reads a record, then User B updates the record, User A will get an error (Status 80, if I remember correctly) when they try to update the record. The only SQL Global variables Pervasive offers are @@RowCount, and @@Identity. These are only available in Pervasive.SQL V8 and 2000i SP4.
Staying connected or connecting on demand will not affect concurrent updates.


info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician