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 - 2002-08-16 : 08:49:23
|
| Mike writes "I'm running Visual Basic 6.0 as my frontend and connecting to a Sql database. I'm still getting errors when saving a field to the database that has an apostrophe in it. Here is my SQL statement, Can you help out in anyway?UPDATE CLIENTINFO SET CLAST = 'D''Aquila', CFIRST = 'Nicholas', CMID = 'A', DOB = NULL, Date_Time = '08/13/2002 12:05:32 PM' WHERE RECNUM = 53" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-08-16 : 09:19:39
|
| 1.) What's the error?2.) There are many reasons to use Stored Procedures rather than Embedded SQL, and few for the opposite.3.) What's that double-quote after 53?Jay White{0} |
 |
|
|
|
|
|
Apostrophe errors