Re: ADO, multiple statements and Perl

[mpeppler]

(any other comment or criticism on the code is warmly welcome)

I'll point out a SQL bug in your code:

    my $sql = << "__SQL__";

declare \@AZIONE    int;
set \@AZIONE = (SELECT id FROM desAz WHERE az LIKE 'XXXX%' );
select * from desCc where id = \@AZIONE;
    
__SQL__

It is possible that SELECT id FROM desAz WHERE az like '...' could return more than one row, @AZIONE will get set to the last value returned. That's one of the reasons why using a JOIN here would be a lot better.

Michael

[l3nz]

Yes, I know; in fact the problem does not arise for the very data that area in the "original" query that I used when developing. In the case it should, it means that such data is corrupted and I want everything to abend and be notified when looking at the logs. Anyway thanks.