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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2006-07-26 : 11:50:35
|
| My query works well in QA but when I run VB i get the error:unclosed quotation mark before character string "Any ideas |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-07-26 : 11:55:58
|
| There's something wrong with the VB code?Difficult to guess anything more without more info.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-07-26 : 12:07:43
|
| IT S A vb6 CODE. I LL TRY TO COPY THE REQUESTTHANKS |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-07-26 : 12:58:04
|
| In VB Source Code:Just before executing the code (passing the SQL query to SQL server) - put a break point and find the SQL string used to pass to the SQL server.Copy & Paste it in QA & run it & C.Srinika |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2006-07-26 : 15:12:20
|
| it s working well in QA. Is it possible that a Query executes in QA but the same query gives an error when executed in VBThanks |
|
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-07-27 : 09:09:48
|
| Did u do whatever I told u?In VB, the created SQL statement may have a syntax error. I was telling u the way to catch that error.The 2 queries maynot be EXACTLY same. Please post the coresponding VB code.Srinika |
|
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
Posted - 2006-07-27 : 13:36:07
|
| Use parameters, or better yet, stored procedures.- Jeff |
|
|
|
|
|
|
unclosed quotation mark before character string