Help ! - Syntax Fail i INSERT INTO-sentence

EDN Admin · Aug 26, 2012

<span lang="EN-US Hi!
<span lang="EN-US I’m having some difficulty to add a new line in my data base.
 with a single column table and it works OK, but now I’m trying to add a line in a more complex table and the code crashes.
-<span style="font:7pt Times New Roman
<span lang="EN-US My first column is ID which is a Auto number , index not repeated – I’m not setting this field as I suppose the system adds is automatically – is that correct
-<span style="font:7pt Times New Roman
<span lang="EN-US I’m not setting all the field in my new row, my table has several columns of types DateTime, yes/no, text and as I mentioned the ID field. Could it be the problem that I send some fields not initiated and how can I do
so without problem ? I need to say that none of the fields in the table is defined as ‘compulsory’
<span lang="EN-US I can not think of any more reasons, here is a sample of my code

<p style="line-height:normal; margin-bottom:0pt <span lang="EN-US B y the way, my code crashes at the line “ with a fail message “Syntax Fail i INSERT INTO-sentence”

<span lang="EN-US Can you please help me !!!

<p style="line-height:normal; margin-bottom:0pt <span lang="EN-US" style="font-family:Consolas; color:blue; font-size:9.5pt Dim<span lang="EN-US" style="font-family:Consolas; font-size:9.5pt my_connstr

my_connstr = <span style="color:#a31515 "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=""C:UsershtrendafDocuments1_Skretting workProsjekter 2011proj - VB stopploggextractorDBskr_pn_V05.mdb"""

<span style="color:blue Dim my_objCon <span style="color:blue As
<span style="color:blue New System.Data.OleDb.
my_objCon.Open()

<span style="color:blue Dim my_dataadapter <span style="color:blue
As <span style="color:blue New System.Data.OleDb.<span style="color:#2b91af OleDbDataAdapter(
<span style="color:blue Dim my_dsPubs <span style="color:blue As
<span style="color:blue New System.Data.
my_dataadapter.FillSchema(my_dsPubs, 
my_dataadapter.Fill(my_dsPubs, 
<span style="color:blue Dim my_tbl 
my_tbl = my_dsPubs.Tables(
<span style="color:blue Dim my_row <span style="color:blue As





my_row = my_tbl.NewRow

my_row(<span style="color:#a31515 "Kommentar") = 
my_row(
my_row(
my_row(
my_row(
 my_row(
my_row(

my_row(
<span style="color:green my_row("Område") =

my_tbl.Rows.Add(my_row)

<span style="color:green ----------------------------------------------

<span style="color:blue Dim my_commandBuilder <span style="color:blue
As <span style="color:blue New Data.OleDb.
my_dataadapter.Update(my_dsPubs, <span style="color:#a31515 "es_stopplogg")
<p style="line-height:normal; margin-bottom:0pt

my_objCon.Close()

my_objCon.Dispose()

View the full article

Help ! - Syntax Fail i INSERT INTO-sentence

EDN Admin

Well-known member

Similar threads