FiveTech Software tech support forums

nageswaragunupudi wrote:Please see
viewtopic.php?f=3&t=44175

What is different between ::RowSet() and ::RecSet()?
Which the latest table FWH version of TRECSET ?

I have FWH2304 but not much of information of TRECSET, such as full parameter.

Thanks in advance,

... it is essential to read and display a big table in full. This is not possible with other libraries like ADO,etc. But we recommend avoid using TRecSet to the extent possible and to use RowSet reading required parts of the table using WHERE clause. This is the standard practice.

... why you do not find many examples directly using TDataRow is because you do not need to deal with it explicitly. XBrowse and classes like RowSet, TRecSet, TDatabase. etc implicity internally use this class to provide Edit()

... }, .t. )   if oCn == nil      ? "connect fail"      return nil   endif   oRs   := TRecSet():New( nil, "select * from customer", oCn )   oRs:Open()   if oRs:IsOpen      ? oRs:Married, ValType( ...

I am looking into this.

I am looking into this.

... cUser, cPassWord }, .t. )  Now I need to open a Table using this code       cSql:= "SELECT * FROM CUSTOMER"      oTable:=TRecSet():New():Open( cSql, oAp:oMySql ) For this line, I need to retrieve a Logical field, I set this field as BIT @ 5.7, 22 ...

... from C:\XBASE\HARBOUR32\LIB\FIVEH.LIB|DATAROW Error: Unresolved external '_HB_FUN_HSETCASEMATCH' referenced from C:\XBASE\HARBOUR32\LIB\FIVEH.LIB|TRECSET Error: Unresolved external '_HB_FUN_HGETCASEMATCH' referenced from C:\XBASE\HARBOUR32\LIB\FIVEH.LIB|TRECSET Error: Unresolved external '_HB_FUN_STRTOHEX' ...

Yes.
FWH has a built-in library for MySQL.
Can connect to MySql, open tables, and use them just like TDatabase.

Full documentation:
viewtopic.php?f=3&t=33286

If you are already using ADO for MySQL, you can use TRecSet class, which works similarly to TDatabase.

... referenced from X:\HARB\FWH\LIB\FIVEH.LIB|DBFFUNC2 Error: Unresolved external '_HB_FUN_HGETCASEMATCH' referenced from X:\HARB\FWH\LIB\FIVEH.LIB|TRECSET Error: Unresolved external '_HB_FUN_STRTOHEX' referenced from X:\HARB\FWH\LIB\FIVEH.LIB|TRECSET Error: Unresolved external '_HB_FUN_HB_ENUMINDEX' ...

With ADO,

Code: Select all  Expand view

oRs:Fields( 'ID' ):Value

is the only way, unless you use FWH TRecSet class.

ADO from here
https://www.w3schools.com/asp/ado_intro.asp

Good tutorial for SQL
https://www.w3schools.com/sql/

FWH complete documentation for this TRecSet Class?

We did not prepare documentation for this class.
Please study the source code provided.

... be displayed on oBrw2. - oBrw2 can only display the correct data in the oBrw2:Filter command only. please I was given a full explanation about TRecSet Class, starting from the beginning of the formation, and the commands that can be used for that. I am interested in using this class, where ...

Field code is VarChar(5) and you are storing only 3 char value. TRecSet pads the value to 5 chars So, instead of             xcode := ors1:Code    use             xcode := Trim( ors1:Code ...

Please help for my case like this: if open data with FW_OpenTRecSet(oCon, cSql) then the data in oBrw2 is not refreshed, but if it is open in FW_OpenRecordSet( oCon, cSql ) mode then the data in oBrw2 can be displayed. in TRecSet mode can run if only filter ...