SQLCommand - Weird SQL Issue - Please help!
OK - I have the below (thanks to angelIII) which works great:
UPDATE MobileInvoiceImport SET QuantityReceived = '12' WHERE OrderDetailID = '345'
GO
INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) SELECT '345', '88' WHERE NOT EXISTS (SELECT 1 FROM MobileInvoiceImport WHERE OrderDetailID = '345')
However, when I try to execute on a single line, such as:
UPDATE MobileInvoiceImport SET QuantityReceived = '12' WHERE OrderDetailID = '345' GO INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) SELECT '345', '88' WHERE NOT EXISTS (SELECT 1 FROM MobileInvoiceImport WHERE OrderDetailID = '345')
I get an error - is there a way to get it to work as I am executing it via a SQLCeCommand
UPDATE MobileInvoiceImport SET QuantityReceived = '12' WHERE OrderDetailID = '345'
GO
INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) SELECT '345', '88' WHERE NOT EXISTS (SELECT 1 FROM MobileInvoiceImport WHERE OrderDetailID = '345')
However, when I try to execute on a single line, such as:
UPDATE MobileInvoiceImport SET QuantityReceived = '12' WHERE OrderDetailID = '345' GO INSERT INTO MobileInvoiceImport (OrderDetailID, QuantityReceived) SELECT '345', '88' WHERE NOT EXISTS (SELECT 1 FROM MobileInvoiceImport WHERE OrderDetailID = '345')
I get an error - is there a way to get it to work as I am executing it via a SQLCeCommand
Last Comment
ASKER CERTIFIED SOLUTION
![Avatar of Guy Hengel [angelIII / a3]](https://filedb.experts-exchange.com/files/public/2013/11/25/ddbe0ea6-aa6e-4279-b781-57b735dd3ea0.jpeg){kind=small}
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
C#
C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).
98K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
this is the same as your SQL question
http:Q_21838811.html#0 "SQLCommand - Weird SQL Issue - Please help!":
you should use a pointer question or have them both for 250 points each
hope this helps a bit
bruintje