🚀 go-pugleaf

Thanks for your time and replay Lee.
I tried what you suggested, but it didn't work.
I got an EoleException message that said the "number of query values and
destination fields are not the same".

"Lee Gan" <leegan@hotmail.com> wrote in message news:3bcb51f8$1_2@dnews...
> 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.
> >
> >
>
>