Antonio, next time it happens I provide screenshot. 1) I create a screenshot 1) I save dbf+fpt+cdx 2) reindex 4) restart app 5) post in this forum the screenshot
... How can I create a little prg that during execution go into this error in order to study the way to intercept it and for instance perform a reindex or simply try write a personlized error.log? it's painful when it happens marco
... think our data is valuable. At first I used the DBF file with the CDX index. Often there is damage to the index file and the time required to reindex it is also not short. Another problem is the speed of access if the number of records is very large. often the command 'seek' or 'locate for' ...
... management system and a fileting cabinet. 1+++++ I have been using the Oracle database for a long time. I don't want to be bothered with Index, Reindex, Backup, and other problems. and also the quality of hardware on database performance. that oracle is paid, yes, there will be no convenience ...
... management system and a fileting cabinet. 1+++++ I have been using the Oracle database for a long time. I don't want to be bothered with Index, Reindex, Backup, and other problems. and also the quality of hardware on database performance. that oracle is paid, yes, there will be no convenience ...
... + NTX after a write process . I have a DBF with 100 000 records and 5 NTX files and have no corruption . It is more than 10 years that i not have REINDEX this files. Anyway, the future is SQL and it is the best think to do . Realy fast and easy when you have relation between files . Philippe
... at the same mode ( txdata) or I must open it on esclusive mode ? Generally the only reason you need open files in exclusive mode is to pack and/or reindex them. If every user has to have access to these files, then you need to open them in shared mode. James
... require the exclusive use of a table with either SET EXCLUSIVE ON or USE...EXCLUSIVE: CONVERT DELETE TAG INDEX...TAG MODIFY STRUCTURE PACK REINDEX ZAP
... for the input. It just occurred to me, that I can add a check for the needed CDXs into the program. Actually, I already had: if ! file(work.cdx) …(reindex) endif For each CDX, but when I looked at the directory not all of them were there. That is what started the confusion. Anyhow, now I know the ...
Marc, it is not a real reindex it is a clean reset. All what I do is closing all areas and deleting the indexfiles. Next I force a < restart > There is a small program < restart.exe > from Daniel included. Because of the ...
... existing filter expression If cFilter is "", clears filter and if cFilter is nil, no action - New: ClearFilter() clears filter - New: ReIndex() - New Data: nBufRec. Represents recno() corresponding to the oDbf:aBuffer in memory. When oDbf:Blank() is called, this value is Zero. - Hint: ...
... to the record or appends new record if lNew is .t. 75. RecUnLock( [nRecNo] ) nRecNo defaults to current record. Unlocks specified record only 76. ReIndex() ReIndexes the database. FWH 17.08 77. RollBack() Cancels any changes made to current record of DBF, pending commit to disk. See also ::Updated() ...