Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Problems with SQL-statement
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Divers
Thread ID:
01131056
Message ID:
01131073
Vues:
20
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform