FiveTech Software tech support forums

... to do. Can you try relations and seeks with a medium size table (> 100.000 records) (both parent and child) on a browse to check performance? Transactions are automatically called so please dont forget to issue dbcommit after each transaction or data wont be saved. In this trial transacts ...

... features are: 1) To have all indexes, record movement, seek, locates and relations emulating 100% ISAM as dbf and ADS. 2) Concurrent access with Transactions. I dont foresee problems in other features but still not initiated. As I told you I'm not looking yet for field replaces ,writes etc. It ...

... that locks are virtual and arent placed in the files so in fact dont protect others from writing the locked file / record. This is assured by transactions (new change from last adordd) Locking only give us the records lock array to allow us to go back to the locks records wihtout disrupt the ...

New adordd with relations and transactions https://github.com/AHFERREIRA/adordd.git

Antonio,

What Rdd function DbCommit() and DbCommitAll() are calling ?

I need it to design the transactions.

... types. Can you find out with Mr Rao how to know or force that all recordsets are opened with the same connection obj. This is imperative for transactions for locking concurrency Now we ve a demand to prevent 100% SQL INJECTION. I have to study this ? Do you or Mr Rao have any ideas? Cross ...

... application. We can also open recordset with pessimistic locking and if we update a record, it is locked till unlocked. Wont do for me. Concept of TRANSACTIONS is different. On quite a few occasions we need to update two or more tables for recording a single transaction. We need to either alter ...

... and re-orient our thinking. We can also open recordset with pessimistic locking and if we update a record, it is locked till unlocked. Concept of TRANSACTIONS is different. On quite a few occasions we need to update two or more tables for recording a single transaction. We need to either alter ...

Antonio,

In order to finish network and concurrent activity I need to work with transactions.

For that I need to know if in ADORDD each time we open a new recordset its in the same connection.

Its crucial to know this because transactions are per connection.

Do you have any idea how to test that?

Antonio, Its absolutly necessary to keep the locklist array. In transactions we lock and append all necessary records and then we loop trough the locklist with dbgoto to make all replaces. If a lock fails the transaction fails. Altough with ADO never fails ...

Antonio, Its absolutly necessary to keep the locklist array. In transactions we lock and append all necessary records and then we loop trough the locklist with dbgoto to make all replaces. If a lock fails the transaction fails. Altough with ADO never fails ...

... locked like any other rdd to be used by dbrlocklist() that are either Bookmarks or column RECNO. In our case this is very important because in our transactions we lock and append all needed records and when updating we go through an array of locked records returned by dbrlocklist() using dbgoto(). ...

... your market, then MSSQL is much more expensive. I think of this because I store a lot of blob data (images, documents, ids, xml, audit-log of all transactions) which make the db grow very fast. On the other hand, bigger customers (bigger data) probably wouldn't mind paying for MSSQL and you wouldn't ...

... We all use Harbour language but we use different data structures that very likely contain more or less the same data: customers, orders, invoices, transactions, bill of materials and so on. The problem is that the field's name is different, table's name is different and probably they have a meaning ...

... DATA lUseTrans .t. or .f. ( default .f. ) Programmer may assign logic to begin, commit or rollback transaction to the three codeblocks and enable transactions by setting the data lUseTrans to .T. In case the table is an ADO table, the class by default assigns the proper codeblocks and programmer ...