Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-31 : 09:01:00
|
| einat writes "hi,I try to insert data USING VB to a row that has check contraints on SQL SERVER 7,and I got errors -2147217900CONN.EXECUTE (INSERT INTO STUD_INFO (CITY) VALUSE (' " & NY & " ')EVEN I HAVE THE NAME NY IN CHECK CONSTRAINTS, I GOT ERROR.IF YOU CAN HELP ME I WOULD BE HEPPYTHANKSEINAT" |
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2003-01-31 : 09:18:12
|
| You have some major syntax problems.conn.execute "INSERT INTO STUD_INFO (CITY) VALUES ('NY')"post your ddl if you want more help.Edited by - ValterBorges on 01/31/2003 09:18:43 |
 |
|
|
EINAT
Starting Member
3 Posts |
Posted - 2003-02-02 : 04:21:18
|
quote:
You have some major syntax problems.conn.execute "INSERT INTO STUD_INFO (CITY) VALUES ('NY')"post your ddl if you want more help.Edited by - ValterBorges on 01/31/2003 09:18:43
|
|
|
|
EINAT
Starting Member
3 Posts |
Posted - 2003-02-02 : 04:21:35
|
quote:
You have some major syntax problems.conn.execute "INSERT INTO STUD_INFO (CITY) VALUES ('NY')"post your ddl if you want more help.Edited by - ValterBorges on 01/31/2003 09:18:43
|
|
|
|
|
|
|
sql server +adodb + vb