Hey guys, this is really starting to get up my nostels so if anyone knows
how to handle this please let me know :)
I'm (trying) to use cached updates and a TUpdateSQL component to edit a
detail tables data, unfortunately some of the tables I'm updating have
spaces in their fieldnames (and no, I can't just rename the fields).
The problem I'm getting is (I'm assuming) with the parameters passed to
the modify/insert queries, due to the fieldnames having spaces, I have a
query like this:
update sometable
set
sometable."field one" = :"field one",
sometable."field two" = :"field two"
where
sometable."field one" = :"OLD_field one"
When ApplyUpdates is called with this in the cache, I get "Cabability not
supported", this is with the BDE and Paradox tables. Someone suggested
lasst week using different parameter names, and this would be fine if I
wans't using a TUpdateSQL component as -it- defines the param names.
Or failing this, does anyone else have any suggestions on how to gain the
effect of instant updating of underlying datasets. I only have D5 Pro so
don't think I have any TClientDataset stuff to play with?
Help :)
Mark, he that is getting balder by the minute...
--
Inspired by the taste of horror, proud to be insane forever
Let out the killer in me! (c) Dismal Euphony
Now Playing: Spock's Beard - The light
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
