PROBLEM WITH INSERT ON C/ODBC

Dynamics 365 Business Central/NAV Developers Forum
1

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

2

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

3

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

4

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

5

that’s right, thanks