> faster so I'll try using a DSQL component instead of a cursor. Often
> the application needs to update about 40 fields per record, is DSQL
> still the way to go??

Yes, of course.
If updating 40 fields with a cursor why should that be (internally)
different to DSQL?
The update has to be done anyway.
An update is happening by an UPDATE .. SET ... statement, if you use a
cursor or DSQL. The cursor will build a statement internally, that looks
like the one that DSQL is using...

Luc.