How to get (return) current Query MySql (FWMARIADB)?

[dutch]

I want to revised current query but still keep current query alike.

oCn:Rowset('select * from customer where id=1')

revised query to
::cQuery += ::cQuery+' or id=2'

How can I do it?

Thanks in advance,

[nageswaragunupudi]

With all previous versions:

Code: Select all  Expand view

cSql := "select * from customer ?"

oRs := oCn:RowSet( cSql, { "where id = 1" } )
// Later
oRs:ReQuery( { "where id = 1 or id = 2" } )
 

Alternatively, if this suits:

Code: Select all  Expand view

cSql := "select * from customer where id between ? and ?"

oRs := oCn:RowSet( cSql, { 1, 1 } )
// Later
oRs := oCn:RowSet( cSql, { 1, 2 } )
 

With FWH 1805 (under release)

Code: Select all  Expand view

cSql := "select * from customer where od = 1"
oRs := oCn:RowSet( cSql )
// later
cSql += " or id = 2"
oRs:Requery( cSql )
 

[dutch]

Dear Mr.Rao,

Thank you, but the query is dynamic. It is not exactly the same in a procedure.
In many scenario, I don't need to requery(). But in some case, I have to revised.
Example.
=========
1. I query reservation (booking) with unique number (id) and I copy to new reservation and requery(). I cannot show all lists after copy.
2. I query reservation (booking) with customer name. It will show well after copy and requery(), because it is the same name.

Thanks once again.

[nageswaragunupudi]

With FWH 1805, you have the maximum possible flexibility.

Example:

Code: Select all  Expand view

oRs := oCn:RowSet( "select * from customer" )
// later
oRs:Requery( "select * from states" )
 

What more flexibilty you want?

[dutch]

Dear Mr.Rao,

It's ok for now. I'm waiting for upgrade to 1805.

With FWH 1805, you have the maximum possible flexibility.

Example:

Code: Select all  Expand view

oRs := oCn:RowSet( "select * from customer" )
// later
oRs:Requery( "select * from states" )
 

What more flexibilty you want?

Thank you so much for your kindness help.