In article <000f01c1b8b8$61d7a420$f389933e@w3w6d9> wrote "Mb" <[EMAIL PROTECTED]>:
> 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.
I regret, that's not an SQL list.
> 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'
^ ^^
However, it seems, an 'l' is missed or too much
> 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"
You should also check the content of $inti and $codeB.
It's an SQL syntax error, nut a perl syntax error.
>
> What it the problem ???? can some one help me, thanks. asma
Greetings,
Andrea
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
