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 |
|
notsosuper
Posting Yak Master
190 Posts |
 Posted - 2005-08-29 : 13:48:34
|
| Dim strsql As String strsql = "insert into MYENTRY(entryid) " strsql &= "VALUES (" strsql &= "'" & strtheEntryid & ")' "I am not sure if this is correct snytax? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-29 : 13:49:54
|
| Rather than us telling you if the syntax is okay, why don't you try it in your application? If you get an error, try to work it out. If you can't, then tell us what the error is and we'll see if we can help you out.Tara |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-08-30 : 00:40:32
|
| See what strsql has at the end and run that in Query AnalyserMadhivananFailing to plan is Planning to fail |
|
|
|
HCLollo
Starting Member
49 Posts |
Posted - 2005-08-30 : 04:42:18
|
Super, try changing your last line of code as such:strsql &= "'" & strtheEntryid & "')" That is, moving the bracket  HCL |
|
|
|
|
|
|
is this correct?