FiveTech Software tech support forums

... "code='WA'" ) // un registro existente oStatesRec:Edit() // modifica y guarda el registro existente - Métodos CreateTable() e ImportFromDBF() utilizados para crear campos DateTime y TimeStamp sin soporte para fracciones de segundos. Ahora admite fracciones de segundos, milisegundos. ...

... "code='WA'" ) // one existing record oStatesRec:Edit() // modify and save the existing record - Methods CreateTable() and ImportFromDBF() used to create DateTime and TimeStamp fields without support for fraction of seconds. Now support fraction of seconds milliseconds. ...

hi, this CODE is to Import DBF into PostgreSQL Table "ala Xbase++" it is different than FWPG_ImportFromDBF() as it include "internal" FIELD which Xbase++ use after Table is create try use BROWSEr and "edit" it. when "save" you will got the Problem FUNCTION DoI...

hi, i have Problem with "existing" PostgreSQL Table when use with Fivewin it seems to work only when FWPG_ImportFromDBF() DBF Data using "Fivewin Way" where FIELD "ID" was add FIELD "ID" is used as PRIMARY KEY and work "autoincrement" but METHOD Save...

hi, i do understand when you say that PRIMARY KEY "can" have a.) more that 1 x FIELD b.) other than Type SERIAL but it is not the Situation i talk about --- i talk about User which want to "upgrade" from DBF to SQL and use Postgre and have no Idea how a.) xBase have RecNo() which...

hi, when try to use "existing" PostgreSQL Table i have Problem with METHOD SavePQQ() it seems to work when use FWPG_ImportFromDBF() to create a "new" SQL Table --- in METHOD SavePQQ() it is "WHERE"   FOR n := 1 TO LEN( aKey )      IF n == 1         cSql += "...

Hola amigos:

Por supuesto InnoDB es mucho mejor al permitir llaves foraneas pero para inserciones masivas
es mucho mejor cambiar por lo menos de manera temporal a MyIsam ya que es alrrededor de 12 veces mas rapido,
lo cual es logico al no realizar ninguna validacion.

Saludos.

Jose.

Leandro.. Buena tarde.

Si ya cambié el mysql.ini... y ya lo crea como innoDB

Gracias

Hola buenas tardes Puedes cambiar el motor de base de datos por defecto en la configuración de mysql, en el archivo my.cnf default-storage-engine=ELMOTORADEFINIR  o tambien si ya esta creada la base de datos, puedes ejecutar el siguiente comando: ALTER TABLE nombre_tabla ENGINE = InnoDB  Con ADO se ...

Buen día..
Estoy implementado mysql nativo con fw, es posible que la tablas importadas con ImportFromDBF, se pueda definir el motor : MyIsam o InnoDB, por defecto lo crea como MyIsam.

Gracias

... to use "latin1_swedish_ci" and it seems there is not any problem with turkish characters. There may be a converting charset problem in Importfromdbf method. For example, I try to use "utf8_turkish_ci" and there is "?" problem in my application both fw_SetUnicode ...

Hi Mr. Rao, I have found the smssablon.dbf that is referred by you. I have transferred to mariadb via Importfromdbf with "latin5_turkish_ci" charset. http://www.objekt.com.tr/fwh_test/11-Mariadb.jpeg http://www.objekt.com.tr/fwh_test/12-Mariadb.jpeg ...

nageswaragunupudi wrote:Please give me a little time.
We both will try and find a solution soon.

OK.

Please give me a little time.
We both will try and find a solution soon.

Hi Mr. Rao,

Is there any hope?