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
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