FiveTech Software tech support forums

... to (2) recreate your tables or (3) will never need to merge data in any way or (4) will never restructured the table or (5) implement referential integrity rules, then perhaps auto increment fields as unique primary keys is a safe and easy solution. Keep in mind that an auto-inc field IS NOT an ...

Pieter,

Thanks for the response. In my case the table already has the HBRECNO field so that is not the issue. Today I will try a different database and try checking the integrity of the original one.

Perhaps you can post your error log when yours crashes.

James

... One can install a procedure at the server to run at certain hours when no one its connected to clean up this table. Its a trade off between integrity and speed. This is only primary proposal study phase and at the end we might go other way. We will start working it middle August. Nevertheless ...

... process, it would not necessarily be accurate. That's why we call it a "dirty" read. <g> To offer some type of solution to this integrity problem, semaphore management functions (Sx_MakeSem(), Sx_KillSem(), etc) have been included so that you may have a mechanism through which ...

... manipulate like a dbf tables. Migrate from classic DBF/CDX/NTX is really easy ADS has many of features of DBMS, triggers, procedures, referential integrity and more, you can use it in stand alone (no server) way or in Client/Sever architecture, all with the same source code. And yes, we need to ...

... with drivers, customers, and other users. Text messages do not work properly for this automated back and forth. Emails have drawbacks also. Data integrity requires some program control. Cloud will work but you still need to control access and provide data validation and control. Thanks for your ...

ADutheil wrote:Did you check disk integrity?

How can I do that?

Did you check disk integrity?

dbfcdx works very well, so there is no reason to use ads locally, unless you have a plan to use ADS on a crowdy network in a near future, so you will increase the data integrity.

FYI - The problem of orphan child records can be solved using .Adt tables with a primary index key and simple Referential Integrity rules on the data dictionary. ...and it works with the local (free) version of the server just as well. One other thing: In the old days, before I used ...

MyISAM is very fast , but not have "referential integrity" and support for "transactions".


http://stackoverflow.com/questions/1261 ... -vs-innodb

Spanish
http://www.arsys.info/programacion/myis ... nto-mysql/

... remote desktop does not add a web-clients such as a PHP client, Java client, web services, etc... Neither will it give you triggers, referential integrity rules, and extended field types. Again, as long as you keep your app restricted to older technologies and a few number of concurrent users, ...

... to get started. But once you have migrated to ADS REMOTE server, you need to start taking it a step further and learn SQL, triggers, Referential Integrity rules, Web Services + Mobile data access, data dictionary. It takes time. The good news is that you get to keep working with .dbf/fpt/cdx ...

... renaming or deleting a table, getting the current server type, creating users and groups, encrypting and decrypting tables, creating referential integrity... the list is endless. To see a complete list of available stored procedures, open the help file on the Index tab and type sp_. Move the ...

... appropriate action takes place even if the table is being accessed from some other application other than your own. 2. Constraints and referential integrity. When managing many tables from many different apps it can become a nightmare to avoid orphan records on a parent child table relationship. ...