Help : EXEC SQL PREPARE

From: Karim <karim.kiared_at_standardlife.ca>
Date: 15 Feb 2002 19:06:57 -0800
Message-ID: <305b8f.0202151906.7efc143f@posting.google.com>

Hi,

I'm trying to execute a very long querry that requires several lines. I'm looking for the right syntax accepted by Proc*C.

example :
strSQL = " SELECT a,b,c,d,e,f,g,h,i,j,k

           FROM L,M,O,P,Q 
           WHERE R = :xxxx
           AND   S = :yyyy
           AND   T = :zzzz;

This following line causes an error (invalid column name) EXEC SQL PREPARE S FROM :strSQL

Thanks for your help
karim.kiared_at_standardlife.ca Received on Fri Feb 15 2002 - 21:06:57 CST