Re: Can't figure out TUpdateSQL, HELP!

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

Article #663

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

#663

From: Mark Cashman
Date: Thu, 12 Apr 2001 01:49

23 lines
2199 bytes

Hi, Hank!

Please do not crosspost as it is against newsgroup guidelines.

Using UpdateSQL is not hard, but the reason you can't find code is that
there isn't any code involved. You need to have a query and a
TUpdateSQL. Set up the Query SQL. Make sure it works. Set the UpdateSQL
property to the TUpdateSQL object. Double-click the TUpdateSQL object
and generate the SQL. That should be it. Keep in mind that the Query has
to have CachedUpdates on, and in the AfterPost event you should
ApplyUpdates(); CommitUpdates();

I hope this helps, and that you still have a few minutes before
insanity... :-)

------
Mark Cashman (TeamB - C++ Builder), creator of The Temporal Doorway at
http://www.temporaldoorway.com
- Original digital art, writing, music and more -
C++ Builder / JBuilder Tips and The C++ Builder Programmer's Webring
(Join us!)
http://www.temporaldoorway.com/programming/index.htm
------

Technical Details

Message-ID: <3AD5099A.FF067782@temporaldoorway.com>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone2.usenetserver.com!news-out.usenetserver.com!atl1-feed1.news.digex.net!jfk3-feed1.news.digex.net!intermedia!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

References: <3acf4f3f_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,57bdc3cb4771155e
X-Google-Attributes: gidfcd2b,public
X-Google-Thread: f5c5c,57bdc3cb4771155e
X-Google-Attributes: gidf5c5c,public
X-Google-Thread: fc5f9,57bdc3cb4771155e
X-Google-Attributes: gidfc5f9,public
X-Google-ArrivalTime: 2001-04-11 19:18:02 PST
Message-ID: <3AD5099A.FF067782@temporaldoorway.com>
Date: Wed, 11 Apr 2001 21:49:14 -0400
From: Mark Cashman <mcashman@temporaldoorway.com>
Reply-To: mcashman@temporaldoorway.com
X-Mailer: Mozilla 4.7 [en] (Win98; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier,borland.public.cppbuilder.database.sqlservers,borland.public.cppbuilder.vcl.components.using
Subject: Re: Can't figure out TUpdateSQL, HELP!
References: <3acf4f3f_2@dnews>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.14.197.193
X-Trace: dnews 987040148 24.14.197.193 (11 Apr 2001 18:49:08 -0700)
Lines: 25
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!cyclone2.usenetserver.com!news-out.usenetserver.com!atl1-feed1.news.digex.net!jfk3-feed1.news.digex.net!intermedia!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews

Reply to Parent Message