Hi all

I am using a simple function which loops through a
resultset for a remote DB query.

so 

Server stmt Fetch Next
While ...EOT(stmt)
    counter + 1
    Server stmt Fetch Next
Wend

and return the counter value. I then want to resize my array of types and loop through 
the stmt again. (fine up to this point) - I then try to use Fetch First and my program 
crashes, I've tries telling it to go to "Fetch Rec 1" but it doesnt like that. I also 
tried to create a temp to store the stmt and use that but no difference. If I just try 
to use Fetch Next and a loop with guard "Server_EOT(stmt)" it never gets in the loop 
as its at the EOT, this is a tad confusing:-~

Any ideas much appreciated

Thanks

Mark

 

Reply via email to