FiveTech Software tech support forums

... work with ADO without any of these functions, but using adofuncs makes your life very easy. 3) If there is a need to do maintenance on compaction, reindexing No need for SQLEXPRESS, MSSQL, ORACLE, etc. Well, you need to do it if you are using MSACCESS and adofuncs have function to do this. 2) How ...

... Rlock or Flock to prevent two users from working on the same record or groups of records. 3) If there is a need to do maintenance on compaction, reindexing Thank you Maurizio Menabue

Very nice!!!

And reindexing?

... in shared mode, locking and unlocking records with automatic-retrys, etc. that are needed for multi-user apps. But there are other issues, such as reindexing, zapping, and packing that can't be done like they were in a single-user app whether you are using database objects or not. In your app these ...

... some facts : 1. All CDX-files on the server suddenly disappear without any reason. 2. If I try to reindex the files on the server, suddenly the reindexing stops and results into an open error of the CDX-file. If I start reindexing again, it can happen to another file or it can go all right. ...

Ok Antonio,

Close the area ( USE)
then reload with index ( without reindexing)

at the moment is the only work around!

Anyway this will be a problem not only for my singular case, almost with windows 8.1.

Thamks a lot! Antonio
Lorenzo

... file so it will work correctly with both versions without any problem. In short words: People using DB_DBFLOCK_HB64 should remember that after reindexing with new Harbour applications old ones cannot read new CDX indexes. ; In next step I plan to add support for user defined page size in CDX ...

... a stored procedure 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, ...

Sory , reindexing the dbf solves the problem.

Frank

... Note that if the table is in an Advantage Data Dictionary, then only the administrator connection can be used to change the page size when reindexing a table. Remarks sp_Reindex rebuilds all auto-open indexes associated with the given table. Because the reindex operation requires exclusive ...

... leave locks open on the server ( ADS versions 7 to 9 ), perhaps by Ctrl-Alt-Del or power failure. Then if we try to get an exclusive lock ( ie. reindexing ), it is denied. I know the lock table is maintained on the server ( Advantage Database Server ? ). Is there a command, or process, we can ...

Guys:

How can I disable closing a window when clicking the X at the top right of it ? If the user is reindexing the databases I want to disable closing the window in the middle of the process. Thank you.

... is processed in the controlling order. The WHILE condition is transient (i.e., it is not stored in the file and not used for index updates and REINDEXing purposes). The WHILE clause creates temporary orders, but these orders are not updated. Frank

... has not the problem. The indices are not rebuild when the program starts again. If you are running different versions of the same program without reindexing this could be the problem. The index could be different due to changes in (x)Harbour. I suggest running the new version and reindexing first ...

... it is being used. It must be in exclusive use and it takes way too long. My suggestion as before is to reuse records. Or, you can pack during reindexing which also requires exclusive use. When you delete records with SET DELETED ON, they will be invisible so there is no need to pack. Also ...