Need TUpdateSQL expertise

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

1 messages

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

1 total messages Started by Don Lindsey Sat, 30 Oct 1999 00:00

#1515

Author: Don Lindsey
Date: Sat, 30 Oct 1999 00:00

20 lines
1679 bytes

Help! I'm floundering. I can't get my TQuery component to recognize my
TUpdateSQL component when updating. I have a 3-tier application set up in
which the remote databroker on the app server has a Tquery, some TTables, a
TupdateSQL, and a TDatabase. My TQuery queries data from a non-updateable
view, therefore, I want to use a TUpdateSQL component to do the updating to
the relevant table and fields. Despite setting the TQuery->UpdateObject to
the TUpdateSQL, the automatically generated update code is insead executed
against the read-only view, and the TupdateSQL SQL stmts never get run.
I've also tried calling it through the TQuery->OnUpdateRecord() event, but
that event is never fired either. Cached updates is set to true, the
database's SQLPASSTHRU MODE is set to NOT SHARED (I tried SHARED AUTOCOMMIT
too), and I apply my updates on the client using
clientdataset->ApplyUpdates(-1). I've searched through newsgroups galore
to see what I'm missing, but I can't find the problem. Everything I've
found says setting the UpdateObject to the TUpdateSQL object is all you need
to do to get it to be used when doing an update to the dataset. Does
anybody have any other suggestions?

TTIA,
Don

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