FiveTech Software tech support forums

... for just about anything, like disconnecting a user, getting a table structure, getting a list of current locks and their owner, reindexing, packing, zapping, renaming or deleting a table, getting the current server type, creating users and groups, encrypting and decrypting tables, creating ...

... the common past ( in the USSR ) we know russian language . And I'm preparing program in 3 languages - lithuanian , russian and all invoices and packing-slips in english also . So the cyrillics it's needfull for me . With lithuanian I can write , as we are naming "tongue-tieded" ... ...

... can not have binary data, I am not sure. Please note that FPT files will be very large because it contains all image data. May require periodical packing. Still this is a lot better than dealing with number of different files. Works with all RDMS with ADO.

... a split second, so you won't need to know who locked it. An alternate answer to question 2 is to reuse deleted records instead of removing them by PACKing the file. This would lessen the need to get EXCLUSIVE USE. Regards, James

... a file. As Stefan pointed out, you don't really need to open the file (DBF) without the indexes when you PACK. If you leave the indexes open when PACKing, then the indexes are updated also. If you don't leave the indexes open, then you have to reopen the file and rebuild the indexes after PACKing. ...

Salvo, An even better solution is to reuse deleted records instead of packing. With my TData class there is an optional subclass to reuse deleted records automatically. This way you never have to PACK a DBF. You can find more information about TData on this ...

... it. That is the point of exclusivity. Why does it need to be opened exclusively? Generally, this is only needed for such housekeeping chores as packing and indexing. I am also curious as to why you have two exact copies of the same database in different directories? How are you insuring that ...

Hi Antonio,

No rush ... I was just following up.
I am currently in Quebec City. When I return home I will be busy packing (I move to my new house on June 25th) so my time too is limited these days

... 148: 'bResult' is declared but never used in function Ctl3dEnabled Warning W8059 C:\fwh\source\winapi\ctrl2chr.c 144: Structure packing size has changed Warning W8080 C:\fwh\source\winapi\ctrldraw.c 211: 'hDC' is declared but never used in function HB_FUN_LBXDRAWITEM Warning ...

... recycles deleted records, so it is no problem to add and then delete a record (the most deleted records you would ever have is one). No database packing ever required. James This is a very good feature. We don't really have to bother about inserting a ghost row.

Rao,

Actually, it is easy using TData. TData has an optional subclass that automatically recycles deleted records, so it is no problem to add and then delete a record (the most deleted records you would ever have is one). No database packing ever required.

James

... I already have implemented this and get filesizes of 1200 to 1500 Byte, which i can split into 2 files. Questions: Is there a better solution for packing the data ? If not, can someone point me to how to rebuild the signature from the array data or have a sample code for this ?

... (@/T) MODTIME (=) Regards, Otto HB_FILEEXISTS() HB_DIREXISTS() HB_INI*() RDD 298 ============================= 299 - added support for memo file packing in PACK operation 300 - added new DBF fields like: AUTOINC (+), ROWVERSION (^), TIME (T), 301 DAYTIME (@/T), MODTIME (=), binary integers with ...

... registered users only. The new code is beta-test code right now. There are actually two new features, 1) automatic deleted record reuse (no more PACKing!) and 2) auto-incrementing primary-key fields. Almost no code changes will be required to implement these new features. TData is an enhanced ...

Ok...now that Ive solved all my browse issues (thanks James!!!), Im ready to tackle re-using deleted records to avoid that pesky downtime for packing. Ive read a few posts but not sure I completely understand.... Right now im just doing the standard oDbf:append()....load()....save() Can I get ...