Click here to Skip to main content
15,884,298 members
Home / Discussions / Database
   

Database

 
AnswerRe: using ?: operation in sql server 2008 Pin
dasblinkenlight29-Jun-11 4:29
dasblinkenlight29-Jun-11 4:29 
GeneralRe: using ?: operation in sql server 2008 Pin
reza assar29-Jun-11 5:35
reza assar29-Jun-11 5:35 
GeneralRe: using ?: operation in sql server 2008 Pin
dasblinkenlight29-Jun-11 5:58
dasblinkenlight29-Jun-11 5:58 
GeneralRe: using ?: operation in sql server 2008 Pin
reza assar29-Jun-11 7:36
reza assar29-Jun-11 7:36 
QuestionParameterised SQL Insert fails; plain text Insert works Pin
hairy_hats29-Jun-11 1:53
hairy_hats29-Jun-11 1:53 
AnswerRe: Parameterised SQL Insert fails; plain text Insert works Pin
Mycroft Holmes29-Jun-11 12:57
professionalMycroft Holmes29-Jun-11 12:57 
GeneralRe: Parameterised SQL Insert fails; plain text Insert works Pin
hairy_hats29-Jun-11 21:35
hairy_hats29-Jun-11 21:35 
AnswerRe: Parameterised SQL Insert fails; plain text Insert works Pin
dasblinkenlight29-Jun-11 17:30
dasblinkenlight29-Jun-11 17:30 
Could you give more details on the exception that you are getting? Is it coming from POCO or from the DB?

The code appears lifted straight from the POCO example book - the only difference is that you use an int, while they use a string. Assuming that their example works, and that you also use SQLite, there's only a small number of places where you could get an error. First thing I would try is specifying the list of column names: INSERT INTO TableName (myIntColumn) VALUES(:size): the single-column syntax looks suspicious. Then I'd look at the error coming back, and try to decipher it.
QuestionDTS not working in sql 2008 Pin
Robymon28-Jun-11 22:21
Robymon28-Jun-11 22:21 
AnswerRe: DTS not working in sql 2008 Pin
Corporal Agarn29-Jun-11 3:41
professionalCorporal Agarn29-Jun-11 3:41 
AnswerRe: DTS not working in sql 2008 Pin
Mycroft Holmes29-Jun-11 12:59
professionalMycroft Holmes29-Jun-11 12:59 
QuestionChanging DAO to ADO Pin
Kyudos28-Jun-11 14:34
Kyudos28-Jun-11 14:34 
AnswerRe: Changing DAO to ADO Pin
Kyudos28-Jun-11 14:39
Kyudos28-Jun-11 14:39 
Questioncheck the key value before inserting data [modified]---ALREADY SOLVED--- Pin
Dhyanga28-Jun-11 10:46
Dhyanga28-Jun-11 10:46 
AnswerRe: check the key value before inserting data Pin
UNCRushFan28-Jun-11 11:11
UNCRushFan28-Jun-11 11:11 
AnswerRe: check the key value before inserting data Pin
Mycroft Holmes28-Jun-11 12:50
professionalMycroft Holmes28-Jun-11 12:50 
AnswerRe: check the key value before inserting data Pin
Chris Meech28-Jun-11 12:56
Chris Meech28-Jun-11 12:56 
GeneralRe: check the key value before inserting data Pin
Mycroft Holmes28-Jun-11 18:07
professionalMycroft Holmes28-Jun-11 18:07 
AnswerRe: check the key value before inserting data Pin
Eddy Vluggen29-Jun-11 2:35
professionalEddy Vluggen29-Jun-11 2:35 
GeneralRe: check the key value before inserting data Pin
Mycroft Holmes29-Jun-11 12:45
professionalMycroft Holmes29-Jun-11 12:45 
GeneralRe: check the key value before inserting data Pin
Chris Meech29-Jun-11 7:07
Chris Meech29-Jun-11 7:07 
AnswerRe: check the key value before inserting data Pin
PIEBALDconsult28-Jun-11 14:42
mvePIEBALDconsult28-Jun-11 14:42 
GeneralRe: check the key value before inserting data Pin
J4amieC28-Jun-11 22:21
J4amieC28-Jun-11 22:21 
GeneralRe: check the key value before inserting data Pin
PIEBALDconsult29-Jun-11 2:49
mvePIEBALDconsult29-Jun-11 2:49 
AnswerRe: check the key value before inserting data Pin
Eddy Vluggen29-Jun-11 2:36
professionalEddy Vluggen29-Jun-11 2:36 

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.