Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Developers

Author Message
 Post subject:
PostPosted: Wed Oct 04, 2006 8:09 am 
Offline

Joined: Sat Sep 30, 2006 12:36 pm
Posts: 1
I would like to know the possiblities of getting multiple rows with single SQL statement. Then need know the logic to retrieve entire data found in the returned rowset/records from the database. <br> <br>Thanks in advance.


Back to top
 Profile  
 
 Post subject:
PostPosted: Wed Oct 04, 2006 10:06 am 
Offline

Joined: Wed Mar 19, 2003 4:28 pm
Posts: 510
Location: Canada
You can get multiple or all of the rows with a single SQL Statement step, but you have to fetch them one row at a time. <br> <br>Immediately after your SQL Statement step, use a SQL Fetch step to get a row. After you have done whatever you want with that row, go back and fetch another using the same SQL Fetch. When you reach the SQL Fetch and it goes down the bomb, or fail path, you have fetched all the rows for your query.


Back to top
 Profile WWW 
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 

Board index : TeleFlow Forums : TeleFlow Developers


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Style by Midnight Phoenix & N.Design Studio
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group.