FiveTech Software tech support forums

When you face such problems, I suggest you compare the
oCn:InsertSQL( ... )
with
oCn:CreateTableSQL( <table> )

or
Please create a small sample that we can execute at our end on the above cloud server.

... nil This is working well for me: https://imagizer.imageshack.com/v2/xq70/923/043Ca8.png This is the creation SQL of the table CREATE TABLE `testinsert` (  `id` int NOT NULL AUTO_INCREMENT,  `ftext` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,  ...

Hi Rao,
yes,
this is default in my Std management of table,

::oBrw:SetMultiSelectCol( )

I rarely disable it using the property :

::oBrw:oMultiSelCol:lReadOnly := .T.

TIA

I can Know how many records are on xbrowse ?
I explain

I would like to activate the arrows for moving the records (up and down) only when the records are greater than the normal number displayed in the xbrowse table

... DB Provider for ODBC Drivers Args: [ 1] = C SELECT * INTO oRsWrk FROM oRsDet oRsWrk and oRsDet are RecordSets. You should not use recordsets. Use table names. if the table names are "original" and "work", then the sql is SELECT * INTO [WORK] FROM [ORIGINAL]

...        oRsWrk:ReQuery()         oRsWrk:MoveFirst()  The temporary table has 5 records, checked with navicat, but the xBrowse only shows 2 records Best regards

... ways. Let us now try the 1st method. FWH provides a cloud server for our testing. Let us use this server for our tests. Creating temporary table with data from the permanent table: oCn:Execute( "SELECT * INTO [TBL_TEMP] FROM [TBL_PERM]" ) Copying back modified data from ...

Mr. Rao:

Yes, I want to copy the records from a non-temporary table and pass them to a temporary table to modify them
and then return them to the non-temporary table

There are 5 records in the non-temporary table and only 2 are passed to the temporary table

Best regards

Do you want to copy all records from one table to another table and display them in XBrowse?

... := { "aa","bb" }    oCn:Upsert( "states", nil, { aRow } )endif  But insert not work. Table `states` has 3 fields: id, code, name where id is autoincrement field This should work: oCn:Upsert( "states", nil, { { ...

... // not found, then inserts aRow := { "aa","bb" } oCn:Upsert( "states", nil, { aRow } ) endif But insert not work. Table `states` has 3 fields: id, code, name where id is autoincrement field This should work: oCn:Upsert( "states", nil, { { ...

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

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

... 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:SaveData() I am thinking of adding ...

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