FiveTech Software tech support forums

frose wrote:But when I want to use hex codes for the search string, MariaDB has HEX() and UNHEX().
What is the equivalent in plain SQL?

Why do you want to use hex codes for the search string? This is the first question you have to answer.

... _utf8'\u00DF', '%'); doesn't work. ChatGPT has obviously made a mistake here. But when I want to use hex codes for the search string, MariaDB has HEX() and UNHEX(). What is the equivalent in plain SQL? ChatGPT says: Certainly, if you're constrained to plain SQL without access to specific ...

Graciasa tods.
Willy te mande email

libmariadb

Code: Select all  Expand view

::oDetalle := ::oCon:RowSet( cSql )
      aItems         := ::oDetalle:GetRows()
 

gracias

MI estimado. } cObj := "SELECT * FROM productos"oObj := oCn:Execute( cObj )if oCn:nError != 0    //     //   Msg_Error(ALLTRIM(oCn:cError), "Error:" + ALLTRIM(STR(oCn:nError,8,0)), , ,15)  //    ...

Good Morning,

Just try

aRet := ::oCnx:Execute( PAISES)

Hola. He buscado en el foro pero no encunetro los apuntes de Mr Mao, quiero luego de obtener la consulta pasar los valores a un array pero no recuerdo como hacerlo. METHOD cargarPaises() CLASS TCliente   LOCAL PAISES   TEXT into PAISES   Select   a.nombre AS c0,   FROM tbpaises a   ORDER BY ...

... AnsiToUtf8()! Because I have completely switched from mixed ASCII-Cp850/Ansi environment to UTF8, i.e. source code (UEStudio) and database DBF/MariaDB. From now on, I no longer have to worry about the encoding. No more conversions between the code pages HB_OemToAnsi()/HB_AnsiToOem(). Of course ...

Do you know if is possible to use Transaction with BEGIN SEQUENC/RECOVER? Something like this: BEGIN SEQUENC      oCn:BeginTransaction()         oCn:Insert(...)         oCn:Insert(...)         oCn:Insert(...)     oCn:CommitTransaction()RECOVER USING oError    ...

Antonio Linares wrote:Todos los wikis estan ahora aqui:

https://github.com/FiveTechSoft/FiveTech_wiki

Estimado Antonio

Los enlaces no funcionan.

Saludos

José

Enviado desde mi Lenovo TB-J606F mediante Tapatalk

Dear Sir , I am using XBROWSE , DATAROW to edit data of MariaDB Rowset in batch mode. I am not expert on using XBROWSE to edit data. I am seeking help to use XBROWSE more effectively. I have written below code but I am not sure whether it is correct ...

Dear Rao Sir ,

As requested , could you please provide code to use extended the feature of XBROWSE , DATAROW & ROWSET.

Thanks
Shridhar

Hace muchísimos años que MySQL dejó de apoyar el sistema embebido y MariaDb nunca lo soportó...

True.
But, do we need to bother about it?
Did any one of us ever sought the support of Oracle to maintain our MySQL databases?

Hace muchísimos años que MySQL dejó de apoyar el sistema embebido y MariaDb nunca lo soportó... Por lo que no te recomiendo eso. Tal vez lo mejor es que porgas el servidor y el cliente en el mismo ordenador. Si aún así quieres un sistema con base de datos ...