FiveTech Software tech support forums

... modifications to the table at another event. If you are wondering... I can not append a blank record to a dbf table as it would violate a data integrity rule enforced by ADS SQL engine where a record can not have a blank primary key and a blank foreign key. Having said that, I'm guessing xbrowsing ...

... .. I decided to honor the original promise to continue the 'free' support for the last 10 years or so up thru today.... How about that for integrity? If there is one lesson I have learned : "There is no perceived VALUE for any Software or Service that is Free" Rick Lipkin

... but I think that PG borned with the idea to be a enterprise database, MySql no, then the pression obligate to add Innodb to resolve problems with integrity.... I don't want to say which is better, is only an opinion. But I'm happy that FW has support to PG Thanks and best regards Marcelo Vía

... defaults and 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 * ...

... defaults and 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 * ...

... the case of our sample, the `amount` column is updated when invitems table is modified through triggers. This should normally guarantee the data integrity. But a bad front-end or program can fail this, by directly writing data to this field. However in similar cases, we may like to occassionally ...

... 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 of dependent columns e) updation ...

... Advantage 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 ...

... would question why would you allow anyone to do that? Shouldn't the table be built by you and maintained by you, and maybe an admin? Actually, for integrity you can't allow any item to be deleted from the table once it has been used. ...that value is missing from the array so when I edit or view ...

Rick, Is sounds like you have a referential integrity issue. Can't you just add "Dispute" to the array, or are there lots more possible items that aren't in the list? If so, you could create a UNIQUE index on the field and use that data ...

... SQL app is a completely different ballgame. 1) if the id is never going to be keyed-in by the user and you are only looking for a good referential integrity rule satisfying id, then try having a GUID field. GUIDs are implemented by most SQL engines and are auto generated when inserting a new record. ...

... 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 ...