Error messegae

[cmcmcm]

Hi all I'm using access database for search and displaying data it's works fine
but when tring to add record I recive the folloing error

System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32 hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior behavior,
Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
at DreamweaverCtrls.DataSet.DoInit()

[Paul Whitham TMM]

Syntax errors normally come when you try to add a text value into a numeric
field. Check that this is not happening. A common mistake is when you format
a number up and then try to insert it with the $ sign.

The other things that can cause a problem if you have commas in an insert
field which the sql statement may mistake for a field delimiter

--
Regards

Paul Whitham
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
[url]www.valleybiz.net[/url]

Team Macromedia Volunteer for Ultradev/Dreamweaver MX
[url]www.macromedia.com/support/forums/team_macromedia[/url]

"cmcmcm" <webforumsuser@macromedia.com> wrote in message
news:d2tp5d$c2g$1@forums.macromedia.com...

> Hi all I'm using access database for search and displaying data it's works

fine

> but when tring to add record I recive the folloing error
>
> System.Data.OleDb.OleDbException: Syntax error in INSERT INTO statement.
> at System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32

hr)

> at
>

System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orSingleResult(tagDBPARAMS

> dbParams, Object& executeResult)
> at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&

executeResult)

> at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior

behavior,

> Object& executeResult)
> at System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
> behavior, String method)
> at System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
> at DreamweaverCtrls.DataSet.DoInit()
>