|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
August 24th, 2004, 04:15 AM
|
|||
|
|||
|
Missing operator Error
SHow me the correct way of doing this query please
strSQL = "INSERT INTO EmpSkill ([EmployeeNo]) VALUES ('" strSQL = strSQL & TestArray(lngCount).EmpNo & "') 'Need to place this at then end WHERE EmployeeName = & TestArray(lngCount).EmpName Ive found out you cant use WHERE clauses with insert satements, so i am trying to use UPDATE strSQL = "UPDATE EmpSkill SET EmployeeNo = " & TestArray(lngCount).EmpNo & " WHERE EmpoyeeName = " & TestArray(lngCount).EmpName Getting missing operator in query expression 'EmployeeName = Karl Diggle'
|
|
#2
August 24th, 2004, 04:34 AM
|
||||
|
||||
|
the employee name string needs to be delimited by single quotes
i cannot understand what you're doing but it seems a bit unusual to change an employee's number based on their name
|
|
#3
August 24th, 2004, 09:21 AM
|
|||
|
|||
|
Basically im importing the data from excel, and the table didnt have any employee numbers so im having to get them from another table and rehash the table so it is relational
|
|
#4
August 24th, 2004, 09:43 AM
|
||||
|
||||
|
Quote:
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > Missing operator Error |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
