🚀 go-pugleaf

Hello All,

I'm trying to do and SQL Insert with an ADO Command Component.  I checked
several times
and the SQL statement looks legit.  I get an error message that says there is a
syntax error with the insert into statement.
Here is the SQL statement:
---------------------------------------
INSERT INTO tbl_Semesters(SemesterCategory, Year, Active)
VALUES(:SemesterCategory, :Year, :Active  );
---------------------------------------

I'm currently using Access2000.  In my DB I have a table called "tbl_Semesters",
with the following fields:
Semester_ID = AutoInc
SemesterCategory = LongInt (Foriegn Key Ref)
Year = LongInt
Active = Boolean (Access2000 say Yes/No Field Type)

All values placed in the parameters are valid... I double checked.
I have another command component with a SQL statement similar to the one above,
but for another table. The only difference is the field names/parameter
names/param data types are different.

Am I missing something with the SQL syntax, the ADO Command Component, or proper
use of the ADO Command Component?

Just in case you wanted to know I'm using
- BCB v5 Enterprise with Update Pack1
- MDAC v2.5
- Access2000
- Win2K Server
- P3-500
- 512Meg of RAM
- 6 Gig partition with 3.13gig free
- 1.5gig swap file
- Hard drive scanned for errors and there were none
- Hard drive was defraged
- Only the bare essentials for development and use have been installed on the
partition.
- NO 3rd party controls/experts/IDE adds.