Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with insert
Message
From
18/11/2005 10:27:30
Keith Payne
Technical Marketing Solutions
Florida, United States
 
 
General information
Forum:
ASP.NET
Category:
ADO.NET
Environment versions
OS:
Windows Server 2003
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01070180
Message ID:
01070216
Views:
20
>Daniel,
>
>You posted the line that read....
>
>
command.CommandText = "insert into backup (id,descr) values (2,'danny');"
>
>You have a semicolon in there, I don't know if that's needed or not.
>
>If the table BACKUP exists, and the columns are called id and descr, then remove the semicolon and try it again.
>
>Kevin

Kevin,

The semi-colon will not hurt anything. It is an optional statement separator/terminator (like PL/SQL and C#).

OOPS. I was thinking SQL Server. Ignore this.
Previous
Reply
Map
View

Click here to load this message in the networking platform