Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Crazy SQL in COM Server
Message
From
23/07/2003 17:20:51
 
 
To
23/07/2003 17:05:54
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Miscellaneous
Thread ID:
00812876
Message ID:
00812951
Views:
10
Hmm... could it be a rights issue coming from the web server?

>Craig,
>
>Thanks for your suggestion:
>I blew the indexes away and recreated them. I tried using the table with NO indexes. I tried using a different field in the WHERE clause. I tried using NO WHERE clause. I've tried a simplified UPDATE expression. I have the proc return the SQL string to the calling browser window and it appears to be correct and intact. I tried compiling as a Single DLL instead of a MTDLL.
>I am now getting NO UPDATE action at all.
>HOWEVER:
>If I call the proc from the VFP command window using CreateObject it behaves correctly. If I call it from a browser/asp page, it doesn't. I've tested the variables being passed and they all appear correct when they arrive at the proc.
>
>David
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform