Re: Parameterized ODBC queries with Oracle

From: Brian Sondergaard <bsonderg_at_msn.com>
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

Original text of this message