Hello,
how can I insert into the sql compact edition 3.5 multiple rows.
I have following query
INSERT INTO network (name, adname, timezone) VALUES
('rm', 'rm', 1),
('pm', pm', 1) ,
('PLURIELLES', 'PLURIELLES', 1),
('SPORTS', 'SPORTS', 1);
if I do this in the editor of the microsoft visual studio 2008 I get following error
'Unable to parse query text.'...
gerbrandc
Last Activity: Mar 20 '08, 11:30 AM
Joined: Feb 27 '08
Location:
-
SQL compact edition 3.5 insert multiple rows
-
Okay I solved it.
The solution was in the url itself. I'm passing thru table names to retrieve there statistics, now with that sniffer I saw I got a message that 2 tables that was passed thru, couldn't make a query. So I thought, lets remove those 2 tables from the query and suddenly I got my report.
So thanks for the help. -
No I don't think so, I already putted that in comment. That was my first thought also.
I don't see why it doesn't work. Especially when it does work in java.Leave a comment:
-
hmm,
I tried this but when i'm looking at ws it says that it is "null". So I don't get to see his values.
If I'm looking at the values in "wr.GetResponse ()" in the watch, is see that the Response = null
and
Status = ServerProtocolV iolation
I looked also in the Non-Public members
InternalStatus = RequestFatal
m_InternalStatu s = RequestFatalLeave a comment:
-
Okay, and how do I do that?
Because the exception is triggered in the part "wr.GetResponse ()" ?Leave a comment:
-
httpWebRequest
Hello,
I hope somebody has a good explanation for this issue.
Okay I'm having troubles with the httpWebRequest method. I need to download reports from a specified server (can't give these details). Now I don't have trouble with an "HTTPS" url but I with an "HTTP" url I get the error :
error: The server committed a protocol violation. Section=Respons eHeader Detail=Header name is invalid...
No activity results to display
Leave a comment: