FiveTech Software tech support forums

... a little) I hope it helps you and gives you the opportunity to use these wonderful tools with which you will notice the big difference in the performance of your systems.

... el ejecutable) Espero les ayude y sea la oportunidad de utilizar estas maravillosas herramientas con las cuales notaran la gran diferencia en la performance de sus sistemas

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...

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&qu...

I am try this: Code: 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 insert not work. Table `states` has 3 fields: id...

I am thinking of adding method to get a single record from a table ( existing or new ) and then edit and save the data. May be something like this: oRecord := oCn:Record( cSql, [lBlank] ) // returns FW_Record / TDataRow objectoRecord:Edit() This would be very good, I believe...

when i have a button to "insert' a new record, is there other way editing data without RowSet object? Please try this and let us know.   oData := TArrayData():New( oCn, "select * from <tablename> limit 1" )   oData:Record(,.t.):Edit()   oData:Sav...

As you indicated above, if we want to edit just one record in a table, we can aRow := oCn:QueryResult( "select * from states where code='WA'" )//We get a single dim array { "WA", "Washington" }// Edit the array and thenoCn:Upsert( "states", nil, &...