FiveTech Software tech support forums

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

... other relevant information which makes usage faster. First time reading is a bit slower when compared to other libraries. Once opened, updates, inserts, deletes, sorts, filters, etc. are all extremely faster than the other libs. If we look back in the forums, we posted speed comparison with ...

... other relevant information which makes usage faster. First time reading is a bit slower when compared to other libraries. Once opened, updates, inserts, deletes, sorts, filters, etc. are all extremely faster than the other libs. If we look back in the forums, we posted speed comparison with ...

I need to add items to a scrollpanel initially the dialog inserts only one item, but if the user press the 2 or 3 button he can insert 2 or 3 items https://i.postimg.cc/QdQw6GFV/gg.png the test I made add the items the second oitem is ...

Hello friends, Open a form in "Edit mode" to change Form labelling. Calling the form with a GET request inserts a button at each of the individual labelling elements. You can then edit the individual labels in a modal form and save them in a DBF file. Best regards, Otto ...

... do? the procedure starts from the last record and in the first line (delay 0) puts all the 55 numbers out. From the second line (delay 1) he inserts the number he finds in the penultimate record but if a number is the same in the previous line / lines he does not write it but puts a zero. ...

I need to insert xbrowse into a dialog not with xbrowser

XBROWSER also inserts XBrowse into a Dialog.
What is the difference?

... [<aValues>] ) Provides same functionality as INSERT command of DBase, which is not supported by Clipper/Harbour. Suitable for small dbfs. Inserts a blank record at current position and pushes all records down by one record. Optionally writes non empty values of aValues to the inserted ...

When I convert from a csv file to an array, the fw_ArrayToDBF (aData ,, bProgress) function inserts me an empty record, how do I avoid this   local  csvfile:=".\csv\file.csv"   local  cSymbol := ","   local  cText := StrTran( MemoRead( csvfile ...

... FROM ' + cTable) + 1  It is not as simple as that. Even MySql server does not know the next autoinc value, till the time it actually inserts the record in the table. Between the moment server answers the query "SELECT MAX(fld) FROM table" and the time the new record is actually ...

... able to delete with adel (adata, 1) but later when I use oDbf: fw_ArrayToDBF (aData, , bProgress) to save aData in the dbf archive, the procedure inserts a first empty record and then in any case inserts all the other records for a sample here pubblish a little csv fille CodUM,DescrUM,Molt,NumDec,Tipo,CodDescrUMCF10,Confezione ...

... able to delete with adel (adata, 1) but later when I use oDbf: fw_ArrayToDBF (aData, , bProgress) to save aData in the dbf archive, the procedure inserts a first empty record and then in any case inserts all the other records for a sample here pubblish a little csv fille CodUM,DescrUM,Molt,NumDec,Tipo,CodDescrUMCF10,Confezione ...

... able to delete with adel (adata, 1) but later when I use oDbf: fw_ArrayToDBF (aData, , bProgress) to save aData in the dbf archive, the procedure inserts a first empty record and then in any case inserts all the other records for a sample here pubblish a little csv fille CodUM,DescrUM,Molt,NumDec,Tipo,CodDescrUMCF10,Confezione ...

... aData ) ) < 2 ASize( aData, Len( aData ) - 1 ) endif Adel(aData,1) <---------------- erase the first line But when I save aData on Archive, inserts an empty record as you can see here https://i.postimg.cc/jd0QGbyr/frfr.png Now you see it at the bottom because the dbf is indexed ...

... you write your own sql statements for INSERT/UPDATE then use the format 'YYYY-MM-DD' for date constants. But we advise you to use the methods for inserts and updates (which are very powerful) instead of writing your own sql statements.