Extracting data from an Oracle database using TableAdapters

[Steve Kershaw]

I have a need to extract data from an Oracle database using an SQL
query. The problem is that I need to insert a parameter into the query.
For example:

SELECT EMPLOYEE, DED_CODE FROM QUARTDED WHERE STATE = @STATE

The problem is that the "@STATE" Dosen't work. When I try to execute
the query in Query Builder I get a Invalid column error.

Further the query changes from WHERE STATE = @STATE to WHERE STATE =
"@STATE".

I'm a SQL Server guy and this works on SQL Server 2005. Can anybody
help please!

[asflp]

Hi Steve

Oracle uses a colon to bind variables, try substituting a colon for the
@ sign.
Steve Kershaw wrote:

I have a need to extract data from an Oracle database using an SQL
query. The problem is that I need to insert a parameter into the query.
For example:

SELECT EMPLOYEE, DED_CODE FROM QUARTDED WHERE STATE = @STATE

The problem is that the "@STATE" Dosen't work. When I try to execute
the query in Query Builder I get a Invalid column error.

Further the query changes from WHERE STATE = @STATE to WHERE STATE =
"@STATE".

I'm a SQL Server guy and this works on SQL Server 2005. Can anybody
help please!

[Steve Kershaw]

Thanks that worked just fine!!!

Steve

asflp wrote:

Hi Steve

Oracle uses a colon to bind variables, try substituting a colon for the
@ sign.
Steve Kershaw wrote:

I have a need to extract data from an Oracle database using an SQL
query. The problem is that I need to insert a parameter into the query.
For example:

SELECT EMPLOYEE, DED_CODE FROM QUARTDED WHERE STATE = @STATE

The problem is that the "@STATE" Dosen't work. When I try to execute
the query in Query Builder I get a Invalid column error.

Further the query changes from WHERE STATE = @STATE to WHERE STATE =
"@STATE".

I'm a SQL Server guy and this works on SQL Server 2005. Can anybody
help please!