Parameterized Query

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Nirmal Shrestha Fri, 27 Apr 2001 19:14

#694

Author: Nirmal Shrestha
Date: Fri, 27 Apr 2001 19:14

13 lines
1242 bytes

  Hello,

    userID = SomeText
    String sql = "UPDATE " + SomeTableName + " SET  LASTUSER=:LASTUSER";
      Query->Params("LASTUSER") = userID;
      Query->SQL->Text =   sql;
      Query->ExecSQL();
Why this works with Oracle ODBC for Oracle but not Microsoft ODBC for
Oracle?
I can make it work with out parameterized querry. How can I make it work
with parameterized query?

Nirmal

Re: Parameterized Query

#695

Author: Jerry Bloomfield (TeamB)
Date: Sun, 29 Apr 2001 01:11

18 lines
1812 bytes

On Fri, 27 Apr 2001 14:14:28 -0500, "Nirmal Shrestha" <nirmals@flowcal.com>
wrote:

>Why this works with Oracle ODBC for Oracle but not Microsoft ODBC for Oracle?
>I can make it work with out parameterized querry. How can I make it work
>with parameterized query?

This could be a bug in the Microsoft ODBC driver for Oracle.  What do you
find in your ODBC trace log if you enable tracing in your ODBC layer?  I
have found that this can determine of the problem is in the ODBC driver,
or the BDE.  In almost every case I have seen,  the problem has been in the
ODBC driver when working with Oracle databases...

Jerry Bloomfield (TeamB)
-- 
http://www.teamb.com                                      JersWork@wwa.com
Please do *NOT* send private e-mail without prior permission (my anti-spam 
filters will probably just delete it anyway <g>)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads