A question from newbie to A5, usual apologies.
I'm building an A5 app that does data manipulation on and reports from several dbfs from a non-A5 app, actually a networked legacy (DOS) Clipper app still in intensive daily use. That app by the way can look after its own compacting and indexing etc if the data is changed elsewhere, ie not by it. But I need to implement the same (exclusive use) integrity checks at the A5 end.
I need to ensure A5 can check out the target dbf's, have their deleted records removed, their A5 indexes rebuilt, they are compacted, and since we are porting versions from dvp to runtime areas during the development phase the data dictionaries checked out and fixed if necessary ... the full 9 yards.
Can someone please point me towards the optimal commands or methods to achieve this, preferably on all-files at once, through a button initiated script? I have read the documentation, but I have got myself thoroughly confused about the difference in A5 between packing and compacting, ensuring the data file itself is checked for corrupt records, removing them, not to mention whatever else is necessary to ensure the integrity of the A5 data dictionary etc.
Sorry if this is a big ask but it struck me I wouldn't be the only one interfacing legacy applications on the forum.
I'm building an A5 app that does data manipulation on and reports from several dbfs from a non-A5 app, actually a networked legacy (DOS) Clipper app still in intensive daily use. That app by the way can look after its own compacting and indexing etc if the data is changed elsewhere, ie not by it. But I need to implement the same (exclusive use) integrity checks at the A5 end.
I need to ensure A5 can check out the target dbf's, have their deleted records removed, their A5 indexes rebuilt, they are compacted, and since we are porting versions from dvp to runtime areas during the development phase the data dictionaries checked out and fixed if necessary ... the full 9 yards.
Can someone please point me towards the optimal commands or methods to achieve this, preferably on all-files at once, through a button initiated script? I have read the documentation, but I have got myself thoroughly confused about the difference in A5 between packing and compacting, ensuring the data file itself is checked for corrupt records, removing them, not to mention whatever else is necessary to ensure the integrity of the A5 data dictionary etc.
Sorry if this is a big ask but it struck me I wouldn't be the only one interfacing legacy applications on the forum.
Comment