requestLive and SQL where clause

I may be wrong here so please correct me if needs be, but the use of  the
'where' clause in a query SQL statement causes the requestLive setting to be
ignored. See example below.

If this is the case how can I get round this and optionally (based on some
setting) protect my data.

Regards,
  Graham

#include <vdbase.h>
** END HEADER -- do not remove this line
//
// Generated on 26/01/2008
//
parameter bModal
local f
f = new RequestLive_TestForm()
if (bModal)
   f.mdi = false // ensure not MDI
   f.readModal()
else
   f.open()
endif

class RequestLive_TestForm of FORM
   with (this)
      height = 18.1364
      left = 53.0
      top = 0.0
      width = 59.7143
      text = ""
   endwith

   this.EMPLOYEES1 = new QUERY()
   this.EMPLOYEES1.parent = this
   with (this.EMPLOYEES1)
      left = 50.4286
      top = 1.3182
      sql = 'select * from "C:\Program
Files\dBASE\PLUS\dQuerySamples\employees.dbf" where EmployeeID > 0'
      requestLive = false
      active = true
   endwith

   this.GRID1 = new GRID(this)
   with (this.GRID1)
      dataLink = form.employees1.rowset
      height = 12.3636
      left = 3.2857
      top = 4.9545
      width = 53.5714
   endwith

   this.rowset = this.employees1.rowset

endclass

PS I do not want to use Filter as it is used for other purposes, and would
mean extensive changes to the app.


"Graham Monk" <graham@astutesoftware.co.nz> wrote in message
news:uzv9sr%23XIHA.940@news-server...
> I may be wrong here so please correct me if needs be, but the use of  the
> 'where' clause in a query SQL statement causes the requestLive setting to
be
> ignored. See example below.
>
> If this is the case how can I get round this and optionally (based on some
> setting) protect my data.
>
> Regards,
>   Graham
>
> #include <vdbase.h>
> ** END HEADER -- do not remove this line
> //
> // Generated on 26/01/2008
> //
> parameter bModal
> local f
> f = new RequestLive_TestForm()
> if (bModal)
>    f.mdi = false // ensure not MDI
>    f.readModal()
> else
>    f.open()
> endif
>
> class RequestLive_TestForm of FORM
>    with (this)
>       height = 18.1364
>       left = 53.0
>       top = 0.0
>       width = 59.7143
>       text = ""
>    endwith
>
>    this.EMPLOYEES1 = new QUERY()
>    this.EMPLOYEES1.parent = this
>    with (this.EMPLOYEES1)
>       left = 50.4286
>       top = 1.3182
>       sql = 'select * from "C:\Program
> Files\dBASE\PLUS\dQuerySamples\employees.dbf" where EmployeeID >
0'
>       requestLive = false
>       active = true
>    endwith
>
>    this.GRID1 = new GRID(this)
>    with (this.GRID1)
>       dataLink = form.employees1.rowset
>       height = 12.3636
>       left = 3.2857
>       top = 4.9545
>       width = 53.5714
>    endwith
>
>    this.rowset = this.employees1.rowset
>
> endclass
>
>
>