Erro in query

[thiru_rajamani]

Hi all please tell me where I am doing the mistake iun the fllowing query

Query = "Insert into TblHrt (FldName,FldValue,FldType) Values (" & PrOpNam(j) & "," & PrOpVal(j) & "," & PrOpTyp(j) & ");"

Conn.Execute Query, IntAffRowCnt



Thanks

[brucevde]

There are no syntax errors in your code. The only thing I can suggest, for fields that are strings delimit the values with single quotes.

Post the error message.

[de Porres]

you do not need the last semicolon in your syntax

[thiru_rajamani]

Thank you brucevde,
It is working now , as you said I missed the single quotes

Rajamani