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]