Updating SQL Grid? 1

[foxrainer]

Using a table which has patient data and return visits, I made a page on a pageframe which shows return visits per week for 5 weeks, using 5 seperate Grids, each populated with SQL results (see below). The grids work fine, but I can't come up with a good method of refreshing the grids in the data. Say, I change the ReturnDate of a patient in Grid1 (week 1). The date qualifies the patient to now show up in grid two.

Also, the

How can the grids be updated?

Here are the SQL statments for each grid:

SELECT name, LEFT(CDOW(return),2) AS ShortDay, TTOD(return) AS returnDt, code FROM patient WHERE Return > (Date() - DOW(date()) ) +1 AND return < (Date() - DOW(Date() ) )+ 7 AND UPPER(active) = 'YES' ORDER BY Return INTO CURSOR ReturnWeek1

SELECT name, LEFT(CDOW(return),2) AS ShortDay, TTOD(return) AS returnDt, code FROM patient WHERE Return > (Date() - DOW(date()) ) +8 AND return < (Date() - DOW(Date() ) ) + 14 AND UPPER(active) = 'YES' ORDER BY Return INTO CURSOR ReturnWeek2

... Same idea with SQL's grid 3-5, just different numbers at the end.

Any help would be greatly appreciated,

Rainer

 

[BPeisch]

Instead of regular SQL statements, you should be using Views, which are SQL statements that are stored in a DBC. You don't have to use the same DBC you use for your permanent data (in fact, I recommend against it). And you can simply REQUERY the view when you want to repopulate it.


-BP (Barbara Peisch)

http://www.peisch.com

 

[Mike Lewis]

Rainer,

Although I agree with Barbara's suggestion to use views, there is an alternative approach you could take. You might want to glance at my article, "Controlling grid data dynamically", which is at:

http://www.ml-consult.demon.co.uk/foxst-20.htm

Mike


Mike Lewis
Edinburgh, Scotland

My Visual Foxpro web site:

http://www.ml-consult.demon.co.uk

My Crystal Reports web site:

http://www.ml-crystal.com

 

[foxrainer]

Michael,

thank you very much, that actually is vry helpful!

Rainer
Gloversville, New York