bm014d0190
|
| Posted: 07/25/2005, 6:07 AM |
|
I've added a table called Items to the Employee example (Interanet.mdb)
I've created a Page using the application wizard.
When I try to "add" an item to this "items" table - I get an error
Syntax error in INSERT INTO statement. (Microsoft JET Database Engine)
The additing to other tables in the example is fine
What have I done wrong???
|
|
|
 |
bm014d0190
|
| Posted: 07/25/2005, 6:11 AM |
|
the "items" table is simple; it has:-
ID - AutoInc
Product
Description
Price
Status
Date
"bm014d0190" <bm014d0190@blueyonder.co.uk> wrote in message
news:dc2o5r$ls$1@news.codecharge.com...
> I've added a table called Items to the Employee example (Interanet.mdb)
>
> I've created a Page using the application wizard.
>
> When I try to "add" an item to this "items" table - I get an error
>
> Syntax error in INSERT INTO statement. (Microsoft JET Database Engine)
>
> The additing to other tables in the example is fine
> What have I done wrong???
>
>
>
|
|
|
|
Nicole
Posts: 586
|
| Posted: 07/25/2005, 6:22 AM |
|
Hello,
The error indicates that there’s something wrong in INSERT statement. To debug it you can print SQL from Before Execute Insert event
response.write form_name.Command.SQL
Then copy a query and test it in Access, it should return more detailed error message that let you find what’ wrong.
_________________
Regards,
Nicole |
 |
|
|
