MS Access select with a variable

[srmcmains]

Progress 9.1B

I am trying to use a select in progress that would check a variable instead of a constant.

Here is what I have:

def var project-id as int.

project-id = 2.

Assign ODBC-DSN = "PCDB"
ODBC-SERVER = "localhost"
OBDC-Userid = ""
ODBC-PASSWD = ""
ODBC-QUERY = "select tbltime.nProjectID
from tbltime
where tbltime.nprojectid = roject-id".

I am getting an error "Error occurred while accessing component property/method: OPEN. [Microsoft} {ODBC Microsoft Access Driver] Too few parameters. Expected 1. Error code: 0x0020009 (5890).

How would you code it to be able to see a variable instead of a constant or table field name? Any help would be appreaciated.

Thanks, Shawnna McMains

 

[stanhubble]

Assuming the rest of your syntax is correct, change the last line to:

where tbltime.nprojectid = :" + string(project-id).

 

[srmcmains]

Stanhubble,

Thanks for the reply, but it still gives me the same error. If I put a actual constant in there it works fine, which tells me all the syntax is correct, just doesn't want to allow me to use a variable. Any other suggestions would be helpful.

 

[harebrain]

Omit the colon--that's what makes it think you have a parameter following.