Re: Connector does not handle SUM(table_name.Column)
Posted by: Reggie Burnett
Date: October 29, 2004 12:37PM

The custom auth, user roles and perms would have nothing to do with successfully executing a SUM. The only complexity you have in your SQL is the extra table and I'll add that to my nunit case and test.

Concerning the ? syntax, there is no "standard" for using @ to mark parameters. SQL Server and Oracle (I guess) do it, but the OleDbClient and OdbcClient use ?. We are using ? mark since @ sign marks user variables in MySQL. We started out using @ sign, but with that the connector could not tell for sure if the following sql has parameters or not.

SET @myvar=5;
INSERT INTO mytable VALUES( 1, @myvar, @myparameter );

Now how can the connector tell which one is a user variable and which one is a parameter?

Options: ReplyQuote


Subject
Written By
Posted
Re: Connector does not handle SUM(table_name.Column)
October 29, 2004 12:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.