FiveTech Software tech support forums

... derived from tDataRow class. This enables editing a single existing record or a new record and saving to a table without having to open RowSet object, thus saving time. Usage: oCustRec := oCn:Record( "customer" ) // creates a blank record oCustRec:Edit() // edit and save (append) ...

He armado este ejemplo con un rowset pero con la clausula AUTOSORT y no ordena las columnas, solo al colocar // XbrSetupBar( oBrw ) vueve a ordernar, podria verificar si es asi o estoy haciendo algo mal ? Please modify xbrowse and apply ...

Excelente Alejandro,
! Viva la libertad carajo !
tienes un ejemplo mas completo ?
saludos !

Solucionado! En principio, decidí separar apellido y nombres, el problema que tenía lo pude solucionar de la siguiente manera y dejé de tener el error TYPE MISMATCH    aCols     := { "legajo",;                      "apellido",;                      "nombres",;     ...

Tengo el siguiente RowSet en MariaDB:    TEXT INTO cQuery      SELECT legajo,             apellido,             nombres,             colegios.detalle as colegio,             grupo        FROM padron   LEFT JOIN colegios ON padron.grupo ...

He armado este ejemplo con un rowset pero con la clausula AUTOSORT y no ordena las columnas, solo al colocar // XbrSetupBar( oBrw ) vueve a ordernar, podria verificar si es asi o estoy haciendo algo mal ? Yes. This is a bug. Thanks a lot ...

Rao He armado este ejemplo con un rowset pero con la clausula AUTOSORT y no ordena las columnas, solo al colocar // XbrSetupBar( oBrw ) vueve a ordernar, podria verificar si es asi o estoy haciendo algo mal ? Muchas gracias. #include "fivewin.ch"static ...

Thanks for the confirmation.
Fixed properly in the next version

Thank you very much for pointing out this error. This example works perfectly fine with Harbour but fails with xHarbour with this run-time error. This bug is due to my ignoring the difference in the behavior between Harbour and xHarbour of a function PValue(). We regret the inconvenience. You can f...

In the next release we will have: oRec := oCn:Record( cTable )oRec:Edit() for editing and saving a blank record. oRec := oCn:Record( cTable, cWhere )oRec:Edit() for editing a single existing record and saving the modifications. oCn:Record(...) creates a FWMariaRecord ...

Thank you very much for pointing out this error. This example works perfectly fine with Harbour but fails with xHarbour with this run-time error. This bug is due to my ignoring the difference in the behavior between Harbour and xHarbour of a function PValue(). We regret the inconvenience. You can fi...

nageswaragunupudi wrote:

Run time error:

Which version of FWH did you test with please?

Mr Rao,
Fivewin 23.10 xHarbour 123, BCC 77.

Run time error:

Which version of FWH did you test with please?

Please try this for adding new record. This is working for me and should work for you too. First run this program as it is without changes before you adopt to your tables. function MariaNewRecord()   local oCn := maria_Connect( "209.250.245.152,fwh,fwhuser,FiveTech@2022" )...

Hello Mr. Rao. I am try this: aRow := oCn:QueryResult( "select field1,field2 from states where code='WA'" )if aRow == NIL // not found, then inserts    aRow := { "aa","bb" }    oCn:Upsert( "states", nil, { aRow } )endif  But...