I badly need help. My scenario:
I have a query which retrieves a value from a table in a MS SQL 2000 database.
WHERE Field_Card_Id = $MyVar_EnteredID
$MyVar_EnteredID is the "passed" value.
This working fine.
Now, we have migrated the Database on Oracle version 10 and have recreated the ODBC connection. The table structure is similar to that in the Ms SQL.
The problem is that the query do not work anymore when passing value.
Anyone, faced similar issue and have a solution for same?
Thxs in advanced for your help