FiveTech Software tech support forums

Mr.Rao With lib libmysql32.lib worked !! Thank you ┌────────────────────────────────────────────────────────────────────────────┐ ?FiveWin for Harbour 18.02 and GCC - Feb. 2018   Harbour development power  │▄ ?(c) FiveTech 1993-2018 for Microsoft Windows 9X/NT/200X/ME/XP/Vista/7/8/10 │█ └───────────...

Mr.Rao use the lib libySQL.Lib that is in the lib folder of version FWH 18.02 Look: ┌────────────────────────────────────────────────────────────────────────────┐ ?FiveWin for Harbour 18.02 and GCC - Feb. 2018   Harbour development power  │▄ ?(c) FiveTech 1993-2018 for Microsoft Windows 9X/NT/200X/M...

up

Mr.Rao, error compiling with FWH 18.02 and MinGW 7.2.0 libraries: FiveHG.lib and FiveHGC.lib do not contain the class FWMariaDB eg: c:\devfw\fwh_1802\samples\buildg maria01 ┌────────────────────────────────────────────────────────────────────────────┐ ?FiveWin for Harbour 18.02 and GCC - Feb. 2018  ...

Mr Rao

Ok, I'll be waiting

thank you

the error happens only if there is a Requery before insertion:

Look

oGrupos := oDB:Query( 'select * from ADMD0013 where CODGRU = ?',{0} )
...
oGrupos:ReQuery({27})
...
oGrupos: Append ()
oGrupos: NOMGRU: = cNOMGRU
oGrupos: ALTERA: = date ()
oGrupos: save () << error happens here
...

Mr.Rao, error when inserting a new record, when primary key is numeric table structure: CREATE TABLE `admd0013` ( `CODGRU` INT (3) NOT NULL AUTO_INCREMENT, `NOMGRU` VARCHAR (30) NULL DEFAULT NULL, `ALTERA` DATE NULL DEFAULT NULL, PRIMARY KEY (`CODGRU`) ) oGrupos := oDB:Query( 'select * from ADMD0013...

habilitar el archivo de Log de FwhMariaDB:

oCn: lLog: = .t.
oCn: lLogErr: = .t.
oCn: cLogFile: = 'sql.log'

y vea los comandos y errores de sql generados

Este recurso existe desde la versión 16.11

mira:

* New DATA bToExcel OF TPrinter object.
If specified this codeblock is used by the Preview class
for exporting to Excel

fwh\samples\prn2excel.prg

Mr.Rao oRs:SetOrder( "age" ) // or oRs:Sort := "age" // ? oRs:Sort // to know the present sort order Is it possible to sort by more than one column? example : oRs:SetOrder( "age,date,id,..." ) // or oRs:Sort := "age,date,id,..." // ? oRs:Sort // to know the pr...

Mr.Rao

Could you post an example of using MYSQL EMBEDDED SERVER ??

Att

João Carlos
VinheSoft

Mr. Rao

Thanks

Joao Carlos
VinheSoft

Mr Rao The method: len is not returning the correct field size see below { {'CODGRU', 'N', 3,0}, {'NOMGRU', 'C', 30,0}, {'VALUE', 'N', 12,2} } oRs: = oCn: Query ('select * from grupo') oRs: Fields (1): len -> field size 'CODGRU' returns 3 -> Ok oRs: Fields (2): len -> field size 'NOMGRU' returns 30 ...

Thanks,

Mr.Rao and Cnavarro

Att

Joao Carlos
VinheSoft

Mr.Rao

What is the method for deleting a database?

OCn: DeleteDB (cDB)
OCn: DropDB (cDB)
OCn: Delete (cDB)
OCn: Drop (cDB)

I just managed this way:

OCn: QueryResult ('drop databases' + cDB)

Is there any method for this?

Att

João Carlos
VinheSoft