sybperl-l Archive

From: salvatore dot sferrazza at BANKERSTRUST dot COM
Subject: Re: results pending error
Date: May 6 1998 5:41PM

are you doing something like:


dbcmd($dbproc, "SELECT table FROM tables");
dbsqlexec($dbproc);
dbresults($dbproc);

while (@ret = &dbnextrow($dbproc)) {

     &drop_table($dbproc, @ret[0]);

}

???

if you are the problem is that your first dbproc is already ties up in the
SELECT and can't be used at this time.
open up a new dbproc in your drop_table sub.

I also hope there is a good reason you are still using perl 4.

HTH,

Sal