Insert into Error = Too few parameters. HELPPP

[VeganLiving]

Hello,
I'm hoping some of the programming gurus will be able to help this newbie with her code.


I am trying to insert values from a form into a temp table I have created. I have the columns correct in the statement but I still getting this error. I watch this video on Youtube that helped me alot by something is up with my coding.
http://www.youtube.com/watch?v=BH_LNnNuK-k


Error:
Run-Time error '3601'
Too Few parameters. Expected 1.

Code:
'add data to table
CurrentDb.Execute "INSERT INTO METAFIELDS_TEMP_TABLE(DB_SCH, DB_OBJ_NAME, DB_COL_NAME, BIZ_NAME, BIZ_DEF, DRVD_IND, BIZ_LOGIC, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE) " & _
" VALUES(" & Me.addSch & ",'" & Me.addTable & "','" & Me.addCol & "','" & Me.addBizName & "','" & _
Me.addBizDef & " ','" & Me.addDrvd & "','" & Me.addBizLogic & "','" & Me.addDataLength & "','" & Me.addDataType & "','" & _
Me.addPrecision & "','" & Me.addDataScale & "','" & Me.addNullable & "');"

[pbaldy]

Here's a commonly used method to debug SQL built in code:

BaldyWeb-Immediate window

[VeganLiving]

Thanks I put the SQL in a new query and i figured out that the order of my columns were incorrect. When I ran the query it works great BUT when I insert it into the Click() area i still keep getting the same error.
CurrentDb.Execute "INSERT INTO METAFIELDS_TEMP_TABLE(DB_SCH, DB_OBJ_NAME, DB_COL_NAME, BIZ_NAME, BIZ_DEF, DRVD_IND, BIZ_LOGIC, " & _
"DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE) " & _
"VALUES(" & Me.addSch & ",'" & Me.addTable & "','" & Me.addCol & "','" & Me.addBizName & "','" & Me.addBizDef & "','" & _
Me.addDrvd & "','" & Me.addBizLogic & "','" & Me.addDataType & "','" & _
Me.addDataLength & "','" & Me.addPrecision & "','" & Me.addDataScale & "','" & Me.addNullable & "')"

[pbaldy]

What is the result of the Debug.Print suggested in my first response?

[June7]

Are all those fields using apostrophe delimiters really text type?

[VeganLiving]

No there are 3 fields DataLength, DataPrecision and DataScale that are numeric. Guess I'm missing something there huh?

[June7]

Number fields do not use delimiters, remove the apostrophes. Same for boolean (yes/no). Date fields need # delimiter for values.

[VeganLiving]

so how would I code the DataLength, DataPrecision and DataScale in my statement?

"VALUES(" & Me.addSch & ",'" & Me.addTable & "','" & Me.addCol & "','" & Me.addBizName & "','" & Me.addBizDef & "','" & _
Me.addDrvd & "','" & Me.addBizLogic & "','" & Me.addDataType & "','" & _
Me.addDataLength & "','" & Me.addPrecision & "','" & Me.addDataScale & "','" & Me.addNullable & "')"

[June7]

Just remove the apostrophes for those three variables, like you have Me.addSch without apostrophes.

[VeganLiving]

Still getting the error too few parameters Expect 2. SMH

[June7]

I suspected that would happen but those were errors that would need fix anyway. I can't see anything wrong with the query syntax.

Post the exact output of the Debug.Print.

Otherwise, don't think we can help unless you want to provide db for analysis. Follow instructions at bottom of my post.

[VeganLiving]

HELP!!!I have debugged and i'm still getting the same error. Can anyone see anything in the syntax that could be off? I have checked the column names, ran the sql by itself and it ran fine. 3 fields are numeric and the rest are not.

Error:
Run-Time error '3601'
Too Few parameters.

CurrentDb.Execute "INSERT INTO METAFIELDS_TEMP_TABLE(DB_SCH, DB_OBJ_NAME, DB_COL_NAME, BIZ_NAME, BIZ_DEF, DRVD_IND, BIZ_LOGIC, DATA_TYPE, DATA_LENGTH, DATA_PRECISION, DATA_SCALE, NULLABLE) " _
& "Values(" & Me.addSch & ", " & Me.addTable & "," & Me.addCol & ",'" & Me.addBizName & "','" & Me.addBizDef & "', " _
& Me.addDrvd & ",'" & Me.addBizLogic & "'," & Me.addDataType & "," & Me.addDataLength & "," & Me.addPrecision & ", " _
& Me.addDataScale & "," & Me.addNullable & ");"

[pbaldy]

I guess it's time to ask again for the results of the Debug.Print. If you want to learn how to fish, that is an important tool in sorting out these types of problems.

[June7]

If only 3 fields are number why are 9 fields now set up as number?