error 3137, Missing semicolon (;) at end of SQL statement

[jannordgreen]

I am using Winxp and Ms Access 2003.

I get this error message:

error 3137, Missing semicolon (;) at end of SQL statement

when I run this code:

Dim I As Integer
For I = 0 To Me.lstparcelblock.ListCount - 1
csql = "insert into parcelblockvaluation (parcelblockid,
valuationid) values (" _
& Me.lstparcelblock.Column(1, I) & ", " & Me.ValuationId & ")" _
& " where valuationid = " & Me.ValuationId & ";"
Debug.Print csql
DoCmd.RunSQL csql ' here the program stops with the error message
above

This is what is printed to the immediate window:

insert into parcelblockvaluation (parcelblockid, valuationid) values
(2, 3) where valuationid = 3;
insert into parcelblockvaluation (parcelblockid, valuationid) values
(2, 5) where valuationid = 5;

I do have a table called parcelblockvaluation and two of its fields are
parcelblockid and valuationid, they are both numerical.

Any help is greatly appreciated.

Regards,

Jan Nordgreen

[Steve Jorgensen]

You are trying to use a where clause with a Values insert? I'm pretty sure
that's the problem.

On 2 Mar 2005 11:53:05 -0800, ja**********@gmail.com wrote:

I am using Winxp and Ms Access 2003.

I get this error message:

error 3137, Missing semicolon (;) at end of SQL statement

when I run this code:

Dim I As Integer
For I = 0 To Me.lstparcelblock.ListCount - 1
csql = "insert into parcelblockvaluation (parcelblockid,
valuationid) values (" _
& Me.lstparcelblock.Column(1, I) & ", " & Me.ValuationId & ")" _
& " where valuationid = " & Me.ValuationId & ";"
Debug.Print csql
DoCmd.RunSQL csql ' here the program stops with the error message
above

This is what is printed to the immediate window:

insert into parcelblockvaluation (parcelblockid, valuationid) values
(2, 3) where valuationid = 3;
insert into parcelblockvaluation (parcelblockid, valuationid) values
(2, 5) where valuationid = 5;

I do have a table called parcelblockvaluation and two of its fields are
parcelblockid and valuationid, they are both numerical.

Any help is greatly appreciated.

Regards,

Jan Nordgreen

[jannordgreen]

Stupid me! What was I thinking?!

Thanks for pointing it out.

My only excuse must be that before this query I had written lots of
update queries where the where clause makes sense. :)