Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-10 : 08:10:01
|
| Ole writes "I did a SQL Statment:SQL="SELECT COUNT (NameOfMyColumn) as myCount FROM [MyTable]"to count the numbers of rows to create an Array as long as the table. --> NumberOfRows=rs(myCount)then Redim TableArray(NumberOfRows+1)at the same Time I want to Put the Value of each Row into the Array.---> TableArray(i)=(rs("NameOfMyColumn"))But it gives me the error : object not found....So I guess I have to make a new SQL query :(How can I do two queries at the same time? Is it possible?thanks in advanceOle" |
|
|
|
|
|
Two SQL Statments in one Procedure?