problem with INSERT INTO command

[devilz]

Hello Readers,

I'm facing problem in one of my different INSERT command. the code is:

sql = "INSERT INTO DayWiseRoster (id) select UserOFTheMonth (id) where emp_id='" & txtempid.text & "'"

This command prompting: DATA TYPE MISMATCHED.

Couldnt find what the problem is. I need such code for data validation. I guess passing integer value with reference of another integer value creates the problem. Is there any different SQL code for passing integer value.

the same command i used in my program for different table. That one is:

ssql=" INSERT INTO UserOfTheMonth (emp_id) SELECT users (Emp_id) where name='" & cboname.text & "'"

Its working fine but the first one is creating problem. Can any one rid me of it??
Please.....


regards

[Shuja Ali]

Welcome to the forum
What database are you using?

[sotoasty]

What are the field definitions of "UserOFTheMonth (id)" and "DayWiseRoster (id)" Are they exactly the same?

[d.paulson]

My guess is that emp_id is an interger or a long integer, so the string delimiter should be removed.

sql = "INSERT INTO DayWiseRoster (id) select UserOFTheMonth (id) where emp_id= " & clng(txtempid.text)

[devilz]

hello d.paulson,

Thank you very much for the support.

regards,