🚀 go-pugleaf

Why don't you try

INSERT INTO tbl_Semesters VALUES (:SemesterCategory, :Year, :Active);

It should work. It works on mine anyway. Good luck.

Lee Gan

<jqpdev> wrote in message news:3bc85e2c$1_2@dnews...
> 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.
>
>