Click here to Skip to main content
15,042,814 members
Home / Discussions / C#
   

C#

 
GeneralRe: using all drives Pin
Richard Andrew x6411-Jul-21 4:01
professionalRichard Andrew x6411-Jul-21 4:01 
GeneralRe: using all drives Pin
Eddy Vluggen11-Jul-21 7:06
professionalEddy Vluggen11-Jul-21 7:06 
GeneralRe: using all drives Pin
Mr Shah 411-Jul-21 7:19
MemberMr Shah 411-Jul-21 7:19 
GeneralRe: using all drives Pin
Eddy Vluggen11-Jul-21 12:25
professionalEddy Vluggen11-Jul-21 12:25 
GeneralRe: using all drives Pin
Mr Shah 411-Jul-21 15:43
MemberMr Shah 411-Jul-21 15:43 
GeneralRe: using all drives Pin
Eddy Vluggen12-Jul-21 7:57
professionalEddy Vluggen12-Jul-21 7:57 
QuestionWhat is the syntax error in this SQLite query? Pin
Alex Dunlop8-Jul-21 7:29
MemberAlex Dunlop8-Jul-21 7:29 
AnswerRe: What is the synntax error in this SQLite query? Pin
OriginalGriff8-Jul-21 7:46
mveOriginalGriff8-Jul-21 7:46 
First off, don't INSERT like that - always list the columns into which you want to ISNERT values - if someone (very sensibly) adds an ID column for example, it can really mess up your code, even if the ID column is of IDENTITY type so you can't INSERT to it!
Listing the columns in the order you supply their values makes your code safer and easier to maintain in future.

Secondly, you can't add a WHERE clause to an INSERT operation because it doesn't affect any existing rows - it only ever adds new ones.
If you want to do an insert if no matching rows exist use IF[^] or CASE[^] instead.

I'd probably use COUNT(...) = 0 instead of EXISTS(...) as well.
"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

GeneralRe: What is the synntax error in this SQLite query? Pin
Alex Dunlop8-Jul-21 7:55
MemberAlex Dunlop8-Jul-21 7:55 
GeneralRe: What is the synntax error in this SQLite query? Pin
Dave Kreskowiak8-Jul-21 8:32
mveDave Kreskowiak8-Jul-21 8:32 
GeneralRe: What is the synntax error in this SQLite query? Pin
Alex Dunlop8-Jul-21 7:57
MemberAlex Dunlop8-Jul-21 7:57 
GeneralRe: What is the synntax error in this SQLite query? Pin
Richard MacCutchan8-Jul-21 21:12
mveRichard MacCutchan8-Jul-21 21:12 
GeneralRe: What is the synntax error in this SQLite query? Pin
Alex Dunlop8-Jul-21 8:50
MemberAlex Dunlop8-Jul-21 8:50 
AnswerRe: What is the syntax error in this SQLite query? Pin
SeeSharp29-Jul-21 5:47
MemberSeeSharp29-Jul-21 5:47 
GeneralRe: What is the syntax error in this SQLite query? Pin
OriginalGriff9-Jul-21 19:04
mveOriginalGriff9-Jul-21 19:04 
GeneralRe: What is the syntax error in this SQLite query? Pin
Victor Nijegorodov9-Jul-21 21:39
MemberVictor Nijegorodov9-Jul-21 21:39 
GeneralRe: What is the syntax error in this SQLite query? Pin
OriginalGriff9-Jul-21 22:31
mveOriginalGriff9-Jul-21 22:31 
GeneralRe: What is the syntax error in this SQLite query? Pin
Richard Andrew x6410-Jul-21 0:03
professionalRichard Andrew x6410-Jul-21 0:03 
GeneralRe: What is the syntax error in this SQLite query? Pin
OriginalGriff10-Jul-21 0:10
mveOriginalGriff10-Jul-21 0:10 
GeneralRe: What is the syntax error in this SQLite query? Pin
SeeSharp212-Jul-21 1:11
MemberSeeSharp212-Jul-21 1:11 
QuestionHow to create Shared memory between C# application and VC++ console application Pin
manoharbalu8-Jul-21 1:46
Membermanoharbalu8-Jul-21 1:46 
AnswerRe: How to create Shared memory between C# application and VC++ console application Pin
Richard Deeming8-Jul-21 2:18
mveRichard Deeming8-Jul-21 2:18 
GeneralRe: How to create Shared memory between C# application and VC++ console application Pin
manoharbalu9-Jul-21 0:21
Membermanoharbalu9-Jul-21 0:21 
GeneralRe: How to create Shared memory between C# application and VC++ console application Pin
Richard Deeming9-Jul-21 0:44
mveRichard Deeming9-Jul-21 0:44 
AnswerRe: How to create Shared memory between C# application and VC++ console application Pin
OriginalGriff8-Jul-21 2:20
mveOriginalGriff8-Jul-21 2:20 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.