If you still want to use an UpdateSQL object, you might need to create a
descendant. You could override the SetParams event to map a parameter of
:field_one to the correct field "field one". However to really make it
useful you also need to create a new component editor that generates the
correct parameter names in the SQL.
I would use an OnUpdateRecord event instead of an UpdateSQL object. There
you can execute whatever statements you like how you like.
That's all assuming the problem really is in the UpdateSQL parameters, and
not just that Paradox won't cope with an update sometable."field one"
reference regardless. Maybe you should test that first.
HTH anyway.
Cheers,
Carl
-----Original Message-----
From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
<snip>
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).
<snip>
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.
<snip>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Database List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
