hi i’m trying to insert a record in a navision table from vb, but it sends this error message "unexpected end of sql statement heres the code Dim conn As New ADODB.Connection Dim rs As New ADODB.Recordset conn.Open “nav1” sql = “insert into Secciones (IdPanteon,IdSeccion) Values(‘12’,12’)” rs.CursorLocation = adUseClient rs.CursorType = adOpenStatic rs.Open sql, conn

Hello Agsboy, maybe the sql statement should end …Values(‘12’,‘12’)" Pelle

yes, sorry, i didn’t see that mistake, thanks!!!

You’re welcome, Agsboy. How often do we not make silly mistakes that it takes another moron to find for us. I am happy to be that other moron. Pelle

that’s right, thanks