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 - 2001-05-06 : 14:36:15
|
Robert writes "Hello,
This is a border line question. But I figure what good is SQL if you can't connect to it.
My problem is with the empty strings. Previously not supported very well in SQL 6.5 and support provided in SQL 7.0. I am using SQL 7.0 but the VB 6 code I am writing appears to not be able to take advantage of the new empty string interpretation.
For both reads and writes I get the old SQL 6.5 handling.
rs("field") = "" or vbNullString will actually update the database field with a single space character!
str = rs("field") will return a space for an empty field.
Do you know a way around this? Some compatibility feature in ADO2.1 to enable?
Regards,
Robert" |
|
|
|
|
|
ADO Support for SQL 7 Empty Strings.