Can't figure out TUpdateSQL, HELP!

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

4 messages

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

4 total messages Started by Slike Sat, 07 Apr 2001 17:32

#658

Author: Slike
Date: Sat, 07 Apr 2001 17:32

24 lines
1826 bytes


Greetings all,

I am about 15 minutes away from going insane.

I am working with Borland CPPBuilder 5.0 for a new client project. And I can
access the database with TQuery just fine. But I am trying to update the
data with
the help of TUpdateSQL (Into MS SQL 2000). And I am having a heck of a time
dong that.
Could some kind soul point me to some example code that I can look at.??

Whatever I do I can not get it to work. And short of jumping from a
building, a
piece of example code would be great.!

I have been trying to find it. The online docs with Borland are somewhat
'sparse' with
examples. And I can not find anything on the web for some example code.

Thanks!

Hank Janssen

Re: Can't figure out TUpdateSQL, HELP!

#663

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

Re: Can't figure out TUpdateSQL, HELP!

#669

Author: Clara D�az
Date: Mon, 16 Apr 2001 16:34

37 lines
2437 bytes

I think TUpdateSql doesn�t work in  a multitier enviromment. I have had to
change the enviromment (not to use the multitire) in a form because it
didn't work with Sql Server and C++ Builder 4.

Another think, you sign as (TeamB - C++ Builder). Where can I find help of
this team?

Thanks in advance (sorry about my english)
-------------------------------------------

"Mark Cashman" <mcashman@temporaldoorway.com> escribi� en el mensaje
news:3AD5099A.FF067782@temporaldoorway.com...
> 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
> ------
>
>

Re: Can't figure out TUpdateSQL, HELP!

#674

Author: Mark Cashman
Date: Wed, 18 Apr 2001 03:08

17 lines
1618 bytes

I don't know of any reason it wouldn't work in a multi-tier environment,
but you wouldn't use it on the client - only in the remote data module.

On the client side you use TClientDataSet.

The Developer's Guide offers a good description of how this works.

For more info on TeamB, see http://www.teamb.com

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

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