FiveTech Software tech support forums

Gunther, I dont know why didnt get those errors. Its corrected for next posted version. Meanwhile please alter in adordd.prg : C:\adordd\adordd.prg(1906) Warning W0001 Ambiguous reference: 'XVALUE' with cFieldName C:\adordd\adordd.prg(1922) Warning W0001 Ambiguous reference: 'XVALUE' with uInfo C:\a...

Antonio, there are still warnings on compiling! You should use es2 as errorlevel in compiler. Compiling 'C:\adordd\adordd.prg'... C:\adordd\adordd.prg(486) Warning W0001 Ambiguous reference: 'OCATALOG' C:\adordd\adordd.prg(487) Warning W0001 Ambiguous reference: 'OCATALOG' C:\adordd\adordd.prg(1906)...

... una bds enorme. En la mía puedes consultar que día se trabajo hace 22 años y la bds guarda 12 registros por año no 365 que te obliga ha realizar dbs muy grandes o dbs históricos. Como te puedes imaginar tengo cosas hechas en clipper, harbour y fw. Todos los reportes son impresionantes con crystal ...

... fastest way to import big amounts of data to MySql is to export it first to csv file and then import it using LOAD DATA statement. I think other DBs engines have alternatives like this. You can try it like using the example in my previous post. In adordd we can do anything else to improve it ...

Biel,

DbFieldInfo( DBS_COUNTER, 1, 10) //Set autoincremt to 10

I am guessing that sets the next number to be 10?

James

... You'll see new adds deletes changes by others. You will always have the last info version. Cons: Navigation slower and server overload higher Many Dbs do not supported so you might get it through the ODBC OLedb driver. This means all navigation is transformed into queries by the driver itself delaying ...

... forgot that Filter2sql definitely does not work with ACCESS. I place filter2sql in adordd but still only works with oledb for ADS it misses other DBs syntax. If you want please try :FILTER with SQLTRANSLATE instead Filters will be done within coming weeks. About seek this was left overs from trials ...

Elvira, You must do it like this: Please note table1 instead of test2 in SET ADO... TABLES as the indexes are related to tables not to DBs and ID field in dbcreate. Like this should work ok. SET ADODBF TABLES INDEX LIST TO {{ "TABLE1", {"TEST1", "FIRST"} ...

QUE TAL ANTONIO COMPILE EL ARCHIVO ERP.PRG Y ME ENVIA ESTOS ERRORES BUSQUE MYSQL.H EN LA CARPETA FWH Y NO LO ENCONTRE ME PODRIAS AYUDAR SALU2 Error E2209 ERP.prg 194: Unable to open include file 'mysql.h' Error E2451 ERP.prg 200: Undefined symbol 'MYSQL' in function HB_FUN_MYSQL_INIT Error E2188 ERP...

Antonio, Yes and I checked with : msginfo(str(HB_Decode( aField[ DBS_TYPE ], "C", HB_FT_STRING, "L", HB_FT_LOGICAL, "M", HB_FT_MEMO, "D", HB_FT_DATE, "N", IIF( aField[ DBS_DEC ] > 0, HB_FT_DOUBLE, HB_FT_INTEGER ) ))) It returns HB_FT_STRING for &q...

Here it is [code]FOR n := 1 TO nTotalFields aField := Array( UR_FI_SIZE ) aField[ UR_FI_NAME ] := oRecordSet:Fields( n - 1 ):Name ADO_FIELDINFO( nWA, n, DBS_TYPE, @uInfo ) aField[ UR_FI_TYPE ] := uInfo aField[ UR_FI_TYPEEXT ] := 0 ADO_FIELDINFO( nWA, n, DBS_LEN, @uInfo ) aField[ UR_FI_LEN ] := uInfo...

... ellos definir una estructura de otra dbf y crearla ? Luego usa la dbf y al final graba en un ini y destuye la dbf . No seria mas logico no usar dbs, guardarlo en arrays y grabarlo ? No me creo que Tim codificase esto asi gratuitamente , pero que motivo existe ? . Alguien que me lo aclare ? seguro ...

Manuel, Creo recordar que cambié el nombre de la clase que maneja los índices para evitar conflictos con otros fuentes (creo que los propios de FiveWin). Entre mis notas pata TDBF tengo lo siguiente: /* > 01/06/2006 C.Gelabert - A la funció Str() li he afegit Str(...,5 ,0) doncs en Harbour pren e...

... demonstrates how to macro expand date variables in CA Visual Objects when used in a filter expression: ---------------- FUNCTION MemFilter() LOCAL dbs AS DbServer FIELD empid, first, last, hiredate STATIC dDate AS DATE // won't macro-expand MEMVAR cDate AS STRING // will macro-expand dbs := DBServer{"\\ufo\recreate\dirke\VO2\scopes\master",DBSHARED,,"AXDBFCDX"} ...

No, my approach is just

Code:
CASE cType = "L"
cQuery += aFld[ i, DBS_NAME ] + " INT, "


It works fine with Jet, MSSQL and MySQL.

Yes, this is what I remember and mentioned in my earlier post.