FiveTech Software tech support forums

James,

You re right but now I havent the time to remake it.

Ill try to do it as soon as I have the time.

Thanks

... 32N 33N 34N 35N 36N 37N 38N 39N 40N 41N 42' WHERE HBRECNO = 72 Same problem it errors! If I try ADO :Update() recordset becomes nuts. Ill try fmimenc()

... with a query to limit the range of the set. After loading the set it only re read the table again when new additions by others are made. Next week Ill post a new version with big changes, much much faster, UDFs in indexes etc. Im now converting another app to SQL and this app does not have historic ...

... ADORDD place VIA "ADORDD"USE sqltablenameBROWSE()  ADORDD has a bug and this will only works with SET ADO FORCE LOCK ON. Ill post a new version with this and other minor corrections tomorrow. This is usable for small tables ( < 10.000 records) as it takes sometime. ...

... and corrected some index management to mimic exactly index behavior and copy to now copies all records both with SET ADO FORCE LOCK ON or OFF. Ill post a new version within the next days.

... May be there is a bug in locks as it should in COPY TO open the destination table exclusively only in APPEND FROM ADORDD locks record by record. Ill check it. Thanks for your helpful feed back.

... in sql. I notice that maromano added a new field to be used a deleted record control and I dont know if he added support for it in ado_create. Ill get into it. Resuming every time you create a new sql structure adordd enforces that the recno field its always present you dont need to defined ...

James, Antonio, Im back from holidays and Im glad to see that more people is using ADORDD. New functionalities have been added by maromano and Ill give it a look asap. Im using adordd with MySql and I dont have any speed issues. Normally to import dbf files I use : SELECT 0USE XTABLE ALIAS XTABLEX ...

... only for trials and make sure you dont change order after otherwise adordd will issue again: "SELECT * FROM ccrgst ORDER BY ....." Ill correct this bug but only in August because Ill go on holidays tomorrow.

... do it. SELECT `AUTO_INCREMENT` FROM INFORMATION_SCHEMA.TABLESWHERE TABLE_SCHEMA = 'DatabaseName' AND TABLE_NAME = 'TableName'; This might be it! Ill keep you posted. Is it supported by all engines ?

... only for trials and make sure you dont change order after otherwise adordd will issue again: "SELECT * FROM ccrgst ORDER BY ....." Ill correct this bug but only in August because Ill go on holidays tomorrow.

Gunther,

Done!

Thanks.

Ill post new version today.

... as view. That function as well as ADORDD hb_adoRddExistsTable( oCon,cTable, cIndex ) only checks the schema for table or index. As soon as I can Ill change it to hb_adoRddExistsTable( oCon,cTable, cIndex, cView ) also check views. In meantime you can workaround like: TRY  CREATE VIEWCATCH  ...

... no es el caso de MED Que la mayoría de ustedes están utilizando. Tan pronto como me puedo voy a pasar a través de MED conseguirlo todo alineado y Ill publicada.

... there it seems thats not the case with MED that most of you are using. As soon as I can I will passed it through MED to get it all aligned and Ill posted.