Click here to Skip to main content
15,915,086 members
Home / Discussions / C#
   

C#

 
AnswerRe: .Tag File Pin
OriginalGriff12-Jul-21 21:18
mveOriginalGriff12-Jul-21 21:18 
AnswerRe: .Tag File Pin
Eddy Vluggen13-Jul-21 0:18
professionalEddy Vluggen13-Jul-21 0:18 
GeneralRe: .Tag File Pin
harold aptroot13-Jul-21 7:45
harold aptroot13-Jul-21 7:45 
AnswerRe: .Tag File Pin
Dave Kreskowiak15-Jul-21 8:25
mveDave Kreskowiak15-Jul-21 8:25 
Questionusing all drives Pin
Mr Shah 411-Jul-21 0:39
Mr Shah 411-Jul-21 0:39 
AnswerRe: using all drives Pin
OriginalGriff11-Jul-21 1:23
mveOriginalGriff11-Jul-21 1:23 
GeneralRe: using all drives Pin
Mr Shah 411-Jul-21 1:33
Mr Shah 411-Jul-21 1:33 
GeneralRe: using all drives Pin
OriginalGriff11-Jul-21 1:40
mveOriginalGriff11-Jul-21 1:40 
GeneralRe: using all drives Pin
Mr Shah 411-Jul-21 1:45
Mr Shah 411-Jul-21 1:45 
GeneralRe: using all drives Pin
OriginalGriff11-Jul-21 1:51
mveOriginalGriff11-Jul-21 1:51 
GeneralRe: using all drives Pin
Mr Shah 411-Jul-21 1:56
Mr Shah 411-Jul-21 1:56 
GeneralRe: using all drives Pin
OriginalGriff11-Jul-21 2:21
mveOriginalGriff11-Jul-21 2:21 
GeneralRe: using all drives Pin
Richard MacCutchan11-Jul-21 2:45
mveRichard MacCutchan11-Jul-21 2:45 
GeneralRe: using all drives Pin
OriginalGriff11-Jul-21 3:12
mveOriginalGriff11-Jul-21 3:12 
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
Mr 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
Mr 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
Alex 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
Alex 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
Alex Dunlop8-Jul-21 7:57 

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.