Re: Parameterized ODBC queries with Oracle
Date: 1997/02/19
Message-ID: <01bc1e2d$0ad4a180$a7312399_at_default>#1/1
Interestingly, in my case, I don't have the problem you described with
insert.
Inserts always work, as do updates when the filter contains no parameters.
Any thoughts would be helpful.
Thanks!
Brian
david R. Tibbot <dtibbot_at_seanet.com> wrote in article
<01bc1df7$176cb8a0$05810ccf_at_tek_mgr>...
> Having same problem with "insert into...values(?,?)
> cutting the query out and using SQL+ it works fine.
> no errors on SQLPrepare, SQLBindParameter, but
> SQLExec generates a constraint violation error, parrent key not found.
>
> using VB4.0 with Oracle 7.2 and Oracle 1.11.0105 ODBC drivers.
> no solutions only more problems
> Dave T.
>
> Brian Sondergaard <bsonderg_at_msn.com> wrote in article
> <01bc1d24$d1ec8c60$0f3f2399_at_default>...
> > I'm having a time trying to get a parameterized query to work with
Oracle.
> > The same code works perfectly against MS Access.
> >
<snip>
> >
> > Thanks in advance!
> >
> > Stumped in Atlanta,
> > Brian
> >
> >
>
Received on Wed Feb 19 1997 - 00:00:00 CET