Filling a grid with a query

[martinmcc]

Hi,

I am trying to fill a grid with a SQL query, but having a few problems. The query is running OK, but instead of filling the grid it opens up in a seperate window, as though the query had been run seperatly. The hackers guide states -

"With both query choices, make sure the query results are directed somewhere (the easiest is into a junk cursor) or the default Browse pops up before the grid gets filled"

I am not sure how to accomplish this? Any suggestions?

Cheers,
Martin McCann

 

[itflash]

Your sql statement needs &quot;into cursor <cursorname>&quot; at the end of it.

For example:

select col1, col2 from table into cursor tempcursor1

 

[weedz]

SELECT * FORM MyCursor INTO CURSOR myCursor

if you do not add the INTO CURSOR it will show it in a browse window.

HTH,
Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

CrownBase source code can be downloaded !!

 

[weedz]

Hmmm, bad example, it should be something like:

SELECT * FROM MyTable INTO CURSOR myCursor

HTH,


Weedz (Wietze Veld)
My private project:

http://www.crowncap.demon.nl\info\crwnbase

CrownBase source code can be downloaded !!