Parameterized Query

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

Article #694

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#694

From: 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

Technical Details

Message-ID: <3ae9c467_2@dnews>

Path:

arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!zeus.visi.com!news-out.visi.com!hermes.visi.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,ddcf65c55890562f,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-04-27 12:18:04 PST
From: "Nirmal Shrestha" <nirmals@flowcal.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Parameterized Query
Date: Fri, 27 Apr 2001 14:14:28 -0500
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
NNTP-Posting-Host: 216.89.39.71
Message-ID: <3ae9c467_2@dnews>
X-Trace: dnews 988398695 216.89.39.71 (27 Apr 2001 12:11:35 -0700)
Path: arc1-ca.pugleaf.net!newsfeed.google.com!sn-xit-03!supernews.com!zeus.visi.com!news-out.visi.com!hermes.visi.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews