Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Major mixup in two ASP.NET transactions
Message
From
25/09/2006 01:29:42
 
 
To
25/09/2006 00:47:21
General information
Forum:
ASP.NET
Category:
Other
Environment versions
Environment:
VB 8.0
OS:
Windows XP SP2
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01150471
Message ID:
01156831
Views:
45
>Weird. I have no ideas at the moment. I think I'll sleep on it ... I might >have a suggestion in the morning (but I'm not promising anything <g>).

>Just so to show how stupid those error messages are, here is one that says >it all:
>SQL: Column 'MODULE' is not found.

>SELECT Message.Notes_E AS String FROM Message WHERE UPPER(Message.Module)=? >AND UPPER(Message.Key)=?

>Module=MEMBER              
>Key=YOUMAY                   
>This SQL is really simple. If anyone could explain me why it says that the >Module column is not part of the SQL, I would be curious to hear about it.

Michel,
Is it concerned to case-sensitivity of SQL collate?
Steven
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform