FreeTDS Development Group

[Chad Wagner <vdr781 AT yahoo.com>]

--- "James K. Lowden" <jklowden AT schemamania.org>
wrote:
> Sorry to be so parochial, but if could you phrase
> the question in terms of
> ct-lib, I might be able to answer.  I googled
> "Nested statement handles"
> to:
> 
>
http://www.bitmechanic.com/mail-archives/dbi-users/Nov1998/0340.html
> 
> which left me unsure there's anything we can/should
> do.  
> 
> FreeTDS's ct-lib implementation has its
> deficiencies, but afaik we don't
> impose any serialism not already present in the
> protocol.  


It didn't appear to be limited to ctlib, as the ODBC
drivers seemed to have the same problem.  But the URL
you provided is what I was attempting to do.  It
returns a SQLExecute failure on the second (nested)
execute.


#!/usr/bin/perl

use DBI;

$dbh = DBI->connect('DBI:ODBC:DSN=mssql', 'sa', '',
   { RaiseError => 1, PrintError => 1, AutoCommit => 0
});

$st_a= $dbh->prepare("
   select \@\@version
");


$st_a->execute();

while (@data = $st_a->fetchrow_array()) {
   print "@data\n";

   $st_b = $dbh->prepare("
      select \@\@version
   ");
   $st_b->execute();
   while (@data = $st_b->fetchrow_array()) {
      print "@data\n";
   }
   $st_b->finish();
}

$st_a->finish();
$dbh->disconnect();



__________________________________________________
Do you Yahoo!?
Yahoo! Platinum - Watch CBS' NCAA March Madness, live on your desktop!
http://platinum.yahoo.com