Click here to Skip to main content
12,357,409 members (72,420 online)
   

Database

 
AnswerRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Richard MacCutchan23-Jan-13 23:22
mvpRichard MacCutchan23-Jan-13 23:22 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 5:48
memberPIEBALDconsult24-Jan-13 5:48 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 5:54
memberIgaBaro24-Jan-13 5:54 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 6:00
memberPIEBALDconsult24-Jan-13 6:00 
You're more familiar with what exactly you are doing.
Typically, names aren't allowed to start with a digit.
My experience with Access (via OleDb) is that question marks (?) are preferred, but that names can be used if they're kept in order (as yours are).
I have also only see a colon (:) used for parameter names in Oracle.
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 7:11
memberIgaBaro24-Jan-13 7:11 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
PIEBALDconsult24-Jan-13 7:56
memberPIEBALDconsult24-Jan-13 7:56 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
Richard MacCutchan24-Jan-13 22:35
mvpRichard MacCutchan24-Jan-13 22:35 
GeneralRe: Syntax error (Missing Operator) in Query expression ':0:1 Pin
IgaBaro24-Jan-13 5:51
memberIgaBaro24-Jan-13 5:51 
Questioncreated tables not dropped in a transaction rollback Pin
Danzy8320-Jan-13 16:13
memberDanzy8320-Jan-13 16:13 
AnswerRe: created tables not dropped in a transaction rollback Pin
Mycroft Holmes20-Jan-13 16:32
memberMycroft Holmes20-Jan-13 16:32 

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.


Advertise | Privacy | Mobile
Web02 | 2.8.160621.1 | Last Updated 29 Jun 2016
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid