When trying to update a number of records with an SQL-statement I ran into problems when doing this from a COM+ component.
When issuing a SQL update command in development:
UPDATE tmpTemp SET prOwner = tmpConstantsSPPU.ctCode ;
WHERE UPPER(ALLTRIM(STRIPLF(prsppu))) == ;
UPPER(ALLTRIM(STRIPLF(tmpUsedPrSPPU.prsppu))) AND ;
EMPTY_ISNULL(prOwner)
VFP returns that 12 records are updated.
However, when doing this from a COM+ dll no records are updated. Both environments are looking to the same database etc.
I must be missing something here but I have no clue why this is happening.
All suggestions are welcome.
Thanks,
Ron Brahma