FiveTech Software tech support forums

... * Nuevo: Nuevos métodos en la clase FWMariaConnection: - ListCollations() --> oRs - ListCharSets() --> oRs - TableCollation( cTable ) --> cCollation - TableCharSet( cTable ) --> cCharSet * Nuevo: Nueva función FW_IsUtf8( cText, [@lAscii] ) --> lUtf8 en FWH\SOURCE\WINAPI\msgsapi.c ...

... * Class FWMariaConnection New Methods: ListCollations() --> oRs ListCharSets() --> oRs TableCollation( cTable ) --> cCollation TableCharSet( cTable ) --> cCharSet * New function FW_IsUtf8( cText, [@lAscii] ) --> lUtf8 (msgsapi.c) * New functions: ...

Recordar que existe una función llamada hb_dbdrop la cual elimina la tabla y sus archivos de índices y memo file asociados.

hb_dbDrop([<cTable>],[<cIndex>])->Nil

hi,

nageswaragunupudi wrote:Ofcourse, NO. Errors is correct

If you read the error log again, you will see that the error is becase oCn is NIL.

That means in the function call FW_ADOINDEXES( oCn, cTable ), oCn must have been NIL.

Ok you are right, sorry

IMHO it must be "oCn:Error" without "s"

Ofcourse, NO. Errors is correct

If you read the error log again, you will see that the error is becase oCn is NIL.

That means in the function call FW_ADOINDEXES( oCn, cTable ), oCn must have been NIL.

Descubriendo más misterios... Si se usa SR_UseDeleteds(.F.) ANTES de la apertura con USE ( cTable ) EXCLUSIVE VIA ( cRDD ), SQLRDD crea el campo sr_deleted, si no lo tiene, de forma automática Entiendo que SR_UseDeleteds(.F.) no conserva el valor globalmente, si no se ...

... --- i have learn to use Nextval() when APPEND Data to Table but TABLE must be create using   cQuery += " CONSTRAINT " + cTable + "_pkey PRIMARY KEY (__record)"  // "__record" == "ID" when "edit" cPreText := "INSERT INTO " ...

Descubierto el misterio ... Si queremos abrir una tabla con USE cTable VIA SQLRDD, que no haya sido creada con el RDD, tendremos que modificar la estructura y añadir un campo en dicha tabla     `sr_recno` BIGINT(20) NOT NULL AUTO_INCREMENT, UNIQUE ...

hi,

nageswaragunupudi wrote:Modified FW_OpenADOExcelBook()
Now we can use this function with cTable, instead of using our own connection string.

GREAT, thx

Modified FW_OpenADOExcelBook()
Now we can use this function with cTable, instead of using our own connection string.

... FIELD ("__xxx") which are "usefull" PRIMARY KEY is based on "__record"    cQuery += " CONSTRAINT " + cTable + "_pkey PRIMARY KEY (__record)" when INSERT it increment next UNIQUE number this Way   cIns += "nextval('" + cTable + "___record_seq')" ...

cIns += "nextval('" + cTable + "___record_seq')" + "," // use nextval() for Sequence ! In Oracle, we use sequences to generate unique IDs and use NEXTVAL(..) for the next value. Is there a similar facility in ...

... funciona perfectamente. Maestro Rao, creo que hay un pequeño error en la documentación de la clase nativa de fivewin. Dice: 1) oRs := oCn:RowSet( cTable(or)cSql, [lShowError] ) // simple and normal Pero me parece que el segundo parámetro es lreadonly y por eso no funcionaba, porque en .t. no permite ...

In the native class I already found it, it's oRs:PivotArray(cTable, cRowFld, cColFld, cValFld, cAggrFunc ) No. PivotArray(..) is a method of Connection class, not Rowset class. You can use TDolphin mainly for the entire application. At the same time you ...

En la clase nativa ya la encontre, es oRs:PivotArray(cTable, cRowFld, cColFld, cValFld, cAggrFunc )

En Dolphin, lo que hice está incompleto, ya que muestra la tabla con los resultados agrupados pero no pivotea...