SteveS
Posts: 41
|
Posted: 02/27/2004, 6:45 AM |
|
Hi,
This question is also linked to the "syntax error (missing operator)" thread i've posted.
As well as having that syntax error I also get:
[Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO statement. (Microsoft OLE DB Provider for ODBC Drivers)
when clicking 'add' to add records.
I'm guessing that all of these problems are due to the way I have my Access 2000 database setup?
I have 9 tables in all. Looking at one in particular (the Asset Condition table) - this only has one field which is also the primary key - so this is about as simple as it gets and it doesn't want to work!! HELP! Ahhhh.
I'm sure it's something simple, but I can't work it out.
Thanks!
Regards,
Steve.
|
|
|
DonB
|
Posted: 02/27/2004, 7:51 AM |
|
Create a BeforeExecuteInsert event on the Record doing the Insert:
Put in these 2 lines of code to see what query is actually being executed:
print "query = " & objectname.command.SQL & objectname.command.WHERE
response.end
Substitute the objectname of your Record object Look at the function
declaration, it will say
Function "objectname_DataSource_BeforeExecuteInsert()"
if you are unclear what the object name should be.
This will show you the query so you can debug it.
--
DonB
http://www.gotodon.com/ccbth
"SteveS" <SteveS@forum.codecharge> wrote in message
news:6403f5809bc9a2@news.codecharge.com...
> Hi,
>
> This question is also linked to the "syntax error (missing operator)"
thread i've posted.
>
> As well as having that syntax error I also get:
>
> [Microsoft][ODBC Microsoft Access Driver] Syntax error in INSERT INTO
statement. (Microsoft OLE DB Provider for ODBC Drivers)
>
> when clicking 'add' to add records.
>
> I'm guessing that all of these problems are due to the way I have my
Access 2000 database setup?
>
> I have 9 tables in all. Looking at one in particular (the Asset Condition
table) - this only has one field which is also the primary key - so this is
about as simple as it gets and it doesn't want to work!! HELP! Ahhhh.
>
> I'm sure it's something simple, but I can't work it out.
>
> Thanks!
>
> Regards,
>
> Steve.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
|