Subject Re: Paremeter for SQL SELECT
From Mervyn Bick <invalid@invalid.invalid>
Date Sat, 28 Mar 2015 08:47:41 +0200
Newsgroups dbase.getting-started

On Sat, 28 Mar 2015 07:34:44 +0200, WJS <warrawarra@warra.com> wrote:


>> I find that where the query is created as a standalone object the rowset
>> doesn't display  in a grid on the form.  ........
>
> What happens when you specifically set the datalink to the grid for the  
> standalone query



    function PUSHBUTTON1_onClick
       form.q = new Query()
       form.q.sql=[SELECT * FROM mbJob WHERE Id = "A"]
       form.q.requestLive := false
       form.q.active:=true
       form.grid2.datalink = form.q.rowset
       return

https://www.dropbox.com/s/j874kds5tvt8249/q%20on%20form.jpg?dl=0


    function PUSHBUTTON1_onClick
       q = new Query()
       q.sql=[SELECT * FROM mbJob WHERE Id = "A"]
       q.requestLive := false
       q.active:=true
       form.grid2.datalink = q.rowset
       return

https://www.dropbox.com/s/6ui9v3b6wmm49kq/q%20in%20variable.jpg?dl=0

Mervyn.