Hello all,
I have seached for learning OLE DB syntax for accessing database, and all
informations converge to this statement for
join use but it does not work.
require "connexion.pl";
my $Statement = "SELECT F_FAMILLE.FA_Intitule, F_ARTICLE.AR_UniteVen,
F_ARTICLE.AR_SuiviStock, F_FAMILLE.FA_CatProduit FROM F_ARTICLE INNER JOIN F_FAMILLE
ON StrComp(F_ARTICLE.FA_CodeFamile,F_FAMILLE.FA_CodeFamille,0) == 0 WHERE AR_Ref like
'$codeB' AND AR_Design like '$inti'";
if(! ($RS = $Conn->Execute($Statement)))
{
print Win32::OLE->LastError() ;
exit;
}
OLE exception from "Microsoft OLE DB Provider for ODBC Drivers": [Simba][Simba ODBC
Driver]Syntax Error. Win32::OLE(0.1502) error 0x80040e14 in METHOD/PROPERTYGET
"Execute"
What it the problem ???? can some one help me, thanks.
asma
