New topic: loop of sql-queries - need for a stored procedure?
<http://forums.realsoftware.com/viewtopic.php?t=25886> Page 1 of 1 [ 1 post ] Previous topic | Next topic Author Message Goofie Post subject: loop of sql-queries - need for a stored procedure?Posted: Mon Jan 05, 2009 8:09 am Joined: Tue Nov 13, 2007 11:48 am Posts: 66 I'm able to do 'some' sql-queries (simple ones and more complex ones (for me that is )) Now i've come to a more complex problem (again: for me!). For each record in table A, I want to count the number of occurences in table B+C. I would like this query to run every hour. I know I could use a RB-loop and a string to do this, but I was thinking that maybe 'stored procedures' could be the way to do this. Any hints? THX Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 1 post ] -- Over 900 classes with 18000 functions in one REALbasic plug-in. The Monkeybread Software Realbasic Plugin v8.1. <http://www.monkeybreadsoftware.de/realbasic/plugins.shtml> [email protected]
