FiveTech Software tech support forums

cQuery += aFlds[ i, DBS_NAME ] + " NUMERIC ( " + NTRIM( aFlds[ i, DBS_LEN ] + 1 ) + ", " + NTRIM( aFlds[ i, DBS_DEC ] ) + " ), " Should be : cQuery += aFlds[ i, DBS_NAME ] + " NUMERIC ( " + NTRIM( aFlds[ i, DBS_LEN ] + 1 ) + " ), " Or you can also CA...

Hello, I have a problem with a numeric column , using CASE cType = "N" cQuery += aFlds[ i, DBS_NAME ] + " NUMERIC ( " + NTRIM( aFlds[ i, DBS_LEN ] + 1 ) + ", " + NTRIM( aFlds[ i, DBS_DEC ] ) + " ), " to build the table. I tryed to reduce the code as much as po...

Hello , With the help from Rick Lipkin and enrico i have no a working example. Taking Customer.dbf as source , rick builds the SQL-statement literal as : cSQL := "CREATE TABLE " + cTab //Customer" cSQL += "( " cSQL += "[CustomerEid] Counter NOT NULL, " // primary k...

Hola estoy intentando probar la clase tdolphin y al compilar un pequeño programa me da errores de la librería, y también algunos de fwh, las librerías de fwh las utilizo con otros programas y ningún problema. les muestro el resultado Compilando surgom.prg... Compilando funcion.prg... Compilando data...

He compilado el programa xcomunity.prg que viene con la tmysql y me arroja los siguientes errores: ┌────────────────────────────────────────────────────────────────────────────┐ │ FiveWin for xHarbour 9.08 - Aug. 2009 xHarbour development power │▄ │ (c) FiveTech, 1993-2009 for Microsoft Windows 9X/N...

This fixed it : // returns NOT NULL if extended structure has DBS_NOTNULL field to true local cNN := {|aArr| iif(Len(aArr) > DBS_DEC, iif(aArr[DBS_NOTNULL] # 0 , " NOT NULL ", ""), "")} Somehow it was assumed to be logical! PS TyMSQL seems to me unfinished and untest...

Gracias Antonio, pero no reconoce la función FieldType... Hé conseguido una aproximación mediante el siguiente código: ------------------------------------------------------ Use cuenta.dbf aEstruct = DBStruct() For i = 1 To Len(aEstruct) ? aEstruct[i, DBS_NAME], aEstruct[i, DBS_TYPE], aEstruct[i, DB...

... debo instalar el motor con muuuucha informacion predefinida ( 2 a 3 millones de registros aprox ) y no me sirve instalar el motor, crear las DBs y Tablas y despues levantar la info con algun load file o similar, se tardaria un buen de tiempo en los equipos de algunos clientes que no estan ...

Rimantas, I don't know anything about limitation of files, but you could try these options to isolate the cause of error: - Open the dbs without applying an order to find out, if an index is corrupted or not usable - Open the program locally on the computer(s) that are causing the problems ...

Hola Antonio. Despues de un rastreo al error reportado, fue solucionado adicionando asi: static function ADO_CREATEFIELDS( nWA, aStruct ) local aWAData := USRRDD_AREADATA( nWA ) local n aWAData[ WA_SQLSTRUCT ] := "" for n := 1 to Len( aStruct ) if n > 1 aWAData[ WA_SQLSTRUCT ] += "...

... para que se realize el proceso de manera automatica. Hay un "pequeño gran" detalle que no comente, que es cuando en MySQL tengo datos ( DBs ) de varios clientes, pero esa.... esa es otra historia :wink: Saludos

I'm getting compiler errors on these 2 (red) lines. What is wrong ? Thank you. The errors are the same. Error E0030 Syntax error: "syntax error at '['" Error E0030 Syntax error: "syntax error at '['" Under Clipper 5.2e they compile with no problems. // Scatter / Gather #include &...

... 20 rows only Select * from clientes where RN between 10 and 20 so.. although is not "STANDARD" sql you have the equivalent in ALL main dbs'.. now you are done... tou can do paging with them... well not in STANDARD sql, but paging. :wink: From Chile Adolfo

Ollie,

I guess that you could use:

DbInfo( DBI_BLOB_OFFSET )
http://www.ousob.com/ng/53guide/ng28fbc.php

and/or

DbFieldInfo( DBS_BLOB_OFFSET )
http://www.ousob.com/ng/53guide/ng25343.php

... tools to help administer and manage DBF Databases. Incuded tools are: dbfExport dbfGrep dbfList dbfPack dbfReIndex dbfUnZip dbfValidate dbfZip dbs More features : DBScript Editor ----------------- The DBScript Editor and engine ( uses VOScript) is a powerful Database scripting language based ...