Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Freaky SQL?
Message
From
17/02/2003 12:33:13
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Freaky SQL?
Miscellaneous
Thread ID:
00754144
Message ID:
00754144
Views:
49
Anybody ever run across this scenario? I have a SQL select--only mildly complicated, it calls a UDF--that throws a syntax error when I run it. Not unusual, right? But get this: I can step up to it in the debugger trace window, cut and paste the entire statement, exactly as is, from the trace window into the command window and it executes there just fine. Go back to the trace window, execute it there and the error is back. This happens the same way when I execute in the command window after the error--it's fine there. Also happens with an INKEY wait thrown in. (The UDF is a simple lookup for a field code in a completely separate table not involved in the select.)
Ray Roper
Next
Reply
Map
View

Click here to load this message in the networking platform