FiveTech Software tech support forums

... from Class TWindow Method Activate() but providing it the right parameters. Now it is working as expected. * FWMariaConnection: - New method Record( cTable, [cWhere] ) --> Record Object using the new FWMariaRecord class (source\classes\mariarec.prg) derived from tDataRow class. This enables ...

... Bu then not run good, now when I click spacebar the buttons on buttonbar are changed and the record is not selected

... I see what's going on here. You're experiencing some issues with the selection and deselection of records in your xbrowse, specifically when using the spacebar to toggle selection. Let's break it down and see if we can fix this. First, let's analyze ...

... ), ) }  but if I use the mouse in the first column the system works, that is, if there are still records selected it does not change the buttonbar menu, if I use the space bar to deselect or select a record it puts the buttonbar buttons back on ...

If I made to select all record on xbrowse

oBrw:SelectRow( 4 )

and the I wish deselect only one record

If I made oBrw:SelectRow( 0 ) it deselect all

how resolve ?

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

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

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

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

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

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

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

... age from customer where id = 100" this function returns 58, instead of {{58}} 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", ...

... to obtain data from several tables for editing in multiple browsers becomes very large. For example, when i have a button to "insert' a new record, is there other way editing data without RowSet object? Thanks in advance.

... of the table, in this way the information returned is correct since when it finds the end of the line the reading position is reset to the next record. It is not a 100% correct solution but it works for me, since normally I will not use fields greater than 256 for the SQL queries that I will ...