Adolfo wrote:Mr Rao.
Is there something like oRowset:GetBlankRow() as in tDolphin, which I found quite easy to create a blank or default set of values for the current table to fiil with new values an insert it into the table.
Regards
From Chile
Adolfo
oRs := oCn:RowSet( "select * from customer" )
// or
oRs := oCn:RowSet( "customer" )
// or
oRs := oCn:Customer // fwh16.12
oRs:SetFilter( "state='NY'" )
// or
oRs:SetFilter( "state='WA' .and. age > 30" )
? oRs:cFilter // to know present filter
oRs:SetFilter( "" ) // Clear filter
oRs:SetOrder( "age" )
// or
oRs:Sort := "age"
//
? oRs:Sort // to know the present sort order
oRs:SetFilter( "state = ?", { "NY" } ) // same as "state = 'NY'"
// later change the filter to another state
oRs:ReFilter( { "WA" } ) // same effect as "state = 'WA'"
oRs:SetOrder( "age,date,id,..." )
// or
oRs:Sort := "age,date,id,..."
//
I have a large clients table, but in a xbrowse I just show 4 fields out of 20+,
I only show 4 out of 20+ fields,
oDbCli:LoadQuery(.F.)
oBrw:DrawLine()
oRs:Resync()
oBrw:RefreshCurrent() // same as oBrw:DrawLine()
oDbCli:Refresh(.F.)
oBrw:DrawLine()
oRs:ReQuery()
// position the record on the just appended record
oRs:Refresh()
Return to FiveWin for Harbour/xHarbour
Users browsing this forum: Google [Bot] and 93 guests