By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,662 Members | 1,765 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,662 IT Pros & Developers. It's quick & easy.

How do I build a dynamic array from a SQL select statement

P: 1
Hey,
In our application, we need to build an array by selecting from a MS-SQL table.
We want to process as follows:

1) Load the array with the SQL select statement
2) Process the array item-by-item (loop)
3) Once a single item is processed, we want to delete the item from the array,
or at least never process that item again (in the process loop)

Can anyone please assist

Thanks
Scott
Mar 16 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 112
I assume from the wording you are using SQL server? What are you using for the front end?
Mar 16 '08 #2

NeoPa
Expert Mod 15k+
P: 31,271
Basic DAO recordset loop using two recordsets may prove helpful.

Welcome to TheScripts.
Mar 18 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.