Click here to Skip to main content
15,041,025 members
Home / Discussions / C#
   

C#

 
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 
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 
Some have given you the answer but not really shown you what they mean. You can't use WHERE without a SELECT. So, you do something like this:

SQL
INSERT INTO Table1(Field1, Field2, ...)
SELECT '2021', 'Alex', ...
WHERE NOT EXISTS (...)

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 
AnswerRe: How to create Shared memory between C# application and VC++ console application Pin
Gerry Schmitz8-Jul-21 6:49
mveGerry Schmitz8-Jul-21 6:49 
GeneralRe: How to create Shared memory between C# application and VC++ console application Pin
manoharbalu9-Jul-21 0:17
Membermanoharbalu9-Jul-21 0:17 
GeneralRe: How to create Shared memory between C# application and VC++ console application Pin
Gerry Schmitz9-Jul-21 5:39
mveGerry Schmitz9-Jul-21 5:39 
AnswerRe: How to create Shared memory between C# application and VC++ console application Pin
jschell17-Jul-21 10:54
Memberjschell17-Jul-21 10:54 
QuestionHow to read value of a cell in GridView (DevExpress)? Pin
Alex Dunlop7-Jul-21 5:18
MemberAlex Dunlop7-Jul-21 5:18 
GeneralRe: How to read value of a cell in GridView (DevExpress)? Pin
Richard MacCutchan7-Jul-21 5:39
mveRichard MacCutchan7-Jul-21 5:39 

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.