'input string was not in correct format'

[b_swati]

Hi,

d1 is date
bID is integer
Whats wrong with following sql statement while concatnetion

strSQL = "Insert into sessiondelayed (batchid,ActualEndDate) values (" & bID & ",'" & d1 & "')"

This is throwing error that 'input string was not in correct format'

Swati

[Sync]

strSQL = "Insert into sessiondelayed (batchid,ActualEndDate) values (" & bID & ",'" & d1 & "')"

This is throwing error that 'input string was not in correct format'

Swati

Hi Swati,

I guess that one of the value of variables (bID or d1) is missing in your coding.
Let me tell you one useful way to debug the SQL Statement..
1) Set the breakpoint on the line.
2) Run the project.
3) Check the value of the varibale "strSQL" after the debugging line has passed to the next line.
eg: maybe. you might see like ."Insert into sessiondelayed (batchid,ActualEndDate) values (1,'aa')"
Note: ensure that the value of "bID" and "d1" are shown in the string.

4) Then copy this value..
5) Paste it in the SQL Query Analyzer (if you are using SQL db).
6) then, Execute this string which is pasted in Query.
Note: You will see the reason why your statement is faild to execute.

P.S: If you still dont know what the problem is, please post the value of "strSQL" statement (Step 3) after debugging.

Hope you may find it useful..

[pclement]

If I had to take guess, I would say that since you're using a string variable for your Date it probably isn't in the format expected by the database.

[edburdo]

I'm with Paul on this one.

Try outputting the strSQL variable after you have it built. Copy that and run it in Query Analyzer (or a similar tool) and see if the insert works.

If it doesn't, then you found your problem.