FiveTech Software tech support forums

... constraints * SQL scripting language and some query tools * Triggers * Stored procedures and User defined functions * Referential integrity (RI) * Transactions * Fast Text Search indexes (FTS) * Database Event Notifications * Enhanced DB security and Encryption * Replication * Online Backup Daniel ...

... constraints * SQL scripting language and some query tools * Triggers * Stored procedures and User defined functions * Referential integrity (RI) * Transactions * Fast Text Search indexes (FTS) * Database Event Notifications * Enhanced DB security and Encryption * Replication * Online Backup Daniel ...

... \fwh\samples\yunus.prg An approach that can be adopted for quotations, purchase orders, etc. mariainv.prg Points of interest: 1) Implementation of Transactions. 2) Database integrity at server level through a) Foreign key relationships b) Unique constraints c) column validations d) calculation ...

... Tools ADT vs DBF Full Text Search Understanding Data Dictionaries Encryption and security Defining data constraints and referencial integrity Transactions SQL Triggers Stored Procedures Notifications Backup and Restore Replication I understand we probably won't have enough time to speak in ...

... instead of HB_FAILURE. ADOOPENCONNECT if engine its not supported or wrongly set alerts the user. ADOBEGINTRANS if workarea not specified opens a transactions for each opened connection ADOCOMMITTRANS and ADOROLLBACKTRANS the same as ADOBEGINTRANS New function ADONESTEDTRANS( nWA ) returns nr ...

... if in a transaction or if it is signaled when the transaction is committed. That is parameter #2 above. If you are not using or don't know what transactions are, then just send false. The data option allows you to send a data string to the receiving client/workstation running an ADS enabled ...

... , MF_ENABLED + MF_STRING, "RE&VERSE SELL FUTURES DIST", {|| REVSELFUT1()}) ******************************** TRANSACTIONS ****************************** HPOPUPMEN1 := CREATEPOPUPMENU() APPENDMENU(AMENU ,"XACTION" , MF_ENABLED + MF_POPUP , "&XACTION" ...

UTILITIES: UpdateSummary() This method makes it easy to update aggregates from transactions table into master/summary table. For this purpose this method uses function MYSQL_UpdateSummarySQL() with the same parameters and executes the SQL. Example-1: ? MYSQL_UpdateSummarySQL( ...

... connection otherwise it starts in the connection of the current work area. 2) ADOROLLBACKTRANS( nWA ) : without any work area it rolls back all transactions in all open connections otherwise it rolls back transaction in same connection as that work area. 3) ado_create was adding an extra position ...

... connection otherwise it starts in the connection of the current work area. 2) ADOROLLBACKTRANS( nWA ) : without any work area it rolls back all transactions in all open connections otherwise it rolls back transaction in same connection as that work area. 3) ado_create was adding an extra position ...

... 12) Does it has transaction control ? It has everything your SQL engine might offer. If your chosen SQl engine is Transactional you will have transactions control in adordd. 13) What SQL engines can I use ? ADS ACCESS ANYWHERE DBASE POSTGRE FIREBIRD FOXPRO INFORMIX MSSQL MYSQL ORACLE POSTGRE ...

... Lan and / or Wan Nr of users Concurrent use (new additions by others) and locking Does app use ? Relations Scopes Filters Indexes with UDFs Locks Transactions do you use ado or sql directly through for example adofuncs.prg or any class and does adordd catch well eventually new additions by those ...

... I don't know. If you have an app on a hundred sites, this could get really complicated. I get that there are a lot of benefits too; speed, transactions, rollbacks, larger number of users, etc. I haven't decided on a SQL database yet, and I will keep ADS in mind. Regards, James

... the KISS principle. In SQL you achieve this same effect by having the whole piece of code inside a transaction; i.e., this is what I described as transactions. Still, I rather have that coupled with a unique indexes. As for being able to have SQL and non SQL installations, this is were ADS is ...

... are implemented by most SQL engines and are auto generated when inserting a new record. A GUID is guaranteed to be GLOBALLY unique. (2) implement transactions. Most SQL engines allow you to start-end-roll back a transaction. Records involved during a transaction remain locked from other users ...