Syntax error in insert statement

[eric dugal]

Hi all!!

I need your help.... i'm working since 2 hours on a simple insert statement,
but couldn't handle it.

Here is my code :

public int ExecQuery(string SqlString)

{
OleDbConnection oCoon = new OleDbConnection(connectionString);

oCoon.Open();

OleDbCommand cmd3 = new OleDbCommand();

cmd3.Connection = oCoon;

cmd3.CommandText = SqlString;

if(oCoon.State == ConnectionState.Closed)

{

oCoon.Open();

}

cmd3.ExecuteNonQuery();

return 1

}

When the code reach the cmd3.ExecuteNonQuery(); I always receive the
followin error :

SYNTAX ERROR IN INSERT INTO STATEMENT....

But, i tried to put some debug info (Debug.Write) and my SQL statement seem
ok.

SQL Statement : INSERT INTO COLORS (agent_no,primary,secondary) VALUES
(3,'fff','ALLO')

Any idea??

Thanks,

[William Gower]

primary is a reserved word. Put this instead [primary]

"eric dugal" <er********@videotron.ca> wrote in message
news:d8**********************@wagner.videotron.net ...

Hi all!!

I need your help.... i'm working since 2 hours on a simple insert statement, but couldn't handle it.

Here is my code :

public int ExecQuery(string SqlString)

{
OleDbConnection oCoon = new OleDbConnection(connectionString);

oCoon.Open();

OleDbCommand cmd3 = new OleDbCommand();

cmd3.Connection = oCoon;

cmd3.CommandText = SqlString;

if(oCoon.State == ConnectionState.Closed)

{

oCoon.Open();

}

cmd3.ExecuteNonQuery();

return 1

}

When the code reach the cmd3.ExecuteNonQuery(); I always receive the
followin error :

SYNTAX ERROR IN INSERT INTO STATEMENT....

But, i tried to put some debug info (Debug.Write) and my SQL statement seem ok.

SQL Statement : INSERT INTO COLORS (agent_no,primary,secondary) VALUES
(3,'fff','ALLO')

Any idea??

Thanks,

[eric dugal]

Thanks, that was the problem!!
"William Gower" <w_*****@hotmail.com> a écrit dans le message de
news:%2****************@TK2MSFTNGP12.phx.gbl...

primary is a reserved word. Put this instead [primary]

"eric dugal" <er********@videotron.ca> wrote in message
news:d8**********************@wagner.videotron.net ...

Hi all!!

I need your help.... i'm working since 2 hours on a simple insert

statement,

but couldn't handle it.

Here is my code :

public int ExecQuery(string SqlString)

{
OleDbConnection oCoon = new OleDbConnection(connectionString);

oCoon.Open();

OleDbCommand cmd3 = new OleDbCommand();

cmd3.Connection = oCoon;

cmd3.CommandText = SqlString;

if(oCoon.State == ConnectionState.Closed)

{

oCoon.Open();

}

cmd3.ExecuteNonQuery();

return 1

}

When the code reach the cmd3.ExecuteNonQuery(); I always receive the
followin error :

SYNTAX ERROR IN INSERT INTO STATEMENT....

But, i tried to put some debug info (Debug.Write) and my SQL statement

seem

ok.

SQL Statement : INSERT INTO COLORS (agent_no,primary,secondary) VALUES
(3,'fff','ALLO')

Any idea??

Thanks,