Hmm,

What do functions EMPTY_ISNULL(),STRIPLF()?

MartinJ

>Martin,
>
>I'm doing a "==" compare. I thought the SET('ansi') was of no relevance in this. Isn't it?
>
>Regards,
>
>Ron
>>How is value for SET ANSI under COM+?
>>
>>MartinJ
>>
>>>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