>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
Ron,
Database might be the same but are tables really the same? Their names look like aliases for temp cursors.
If you log:
dbf('tmpTemp')
dbf('tmpConstantsSPPU')
dbf('tmpUsedPrSPPU')
tmpConstantsSPPU.ctCode
are they same IOW?
Cetin