try this
INSERT into [primary] (empName)
VALUES ('bob')
empName = ur desired column name.
On Tue, Mar 9, 2010 at 6:01 PM, Stephen Russell <[email protected]>wrote:
> On Mon, Mar 8, 2010 at 12:20 AM, [email protected] <[email protected]>
> wrote:
> > Hi,
> >
> > When I run the code below I receive an error message of Incorrect
> > syntax near the keyword 'primary' after executenonquery is run.
> > Primary being my table name for my database. I've tried to simplify
> > this code down as much as I can, but I can't seem to fix the syntax
> > issue.
>
> -------------------
>
> try this type of syntax
>
> Insert into MyTable ColumnName values("theData")
>
>
> --
> Stephen Russell
>
> Sr. Production Systems Programmer
> CIMSgts
>
> 901.246-0159 cell
>
