hi.
my guide to you depend on that,
you run it in shell or through cgi ??
explian more..
______________________
Try to have
simple habits,
deep thoughts .
_________________________
Hi,
I'm trying to execute a SQL statement asking three tables on a DBI database
connection.
The database is a commertiale one (diff from MySQL) .... I think that
my SQL statement is right :
my($stmt) = "select AS_QteSto from art F_ARTICLE,dep F_DEPOT,sto
F_ARTSTOCK where art.AR_Ref='$code' and dep.DE_Intitule='$depot' and
art.AR_Ref=sto.AR_Ref and dep.DE_No=sto.DE_No";
in spite of that I had :
DBD::ADO::st execute failed: Can't execute statement 'select sto.AS_QteSto
from art F_ARTICLE,dep F_DEPOT,sto F_ARTSTOCK where
art.AR_Ref='3095562806099' and dep.DE_Intitule='Depot Rungis' and
art.AR_Ref=sto.AR_Ref and dep.DE_No=sto.DE_No': -2147217900: OLE exception
from "Microsoft OLE DB Provider for ODBC Drivers":
[Simba][Simba ODBC Driver]Unknown table or correlation name [sto] in select
list.
Thankx,
asma
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
