[thelist] VB6/ADO GetString compile error

Tab Alleman Tab.Alleman at MetroGuide.com
Mon Feb 9 13:54:48 CST 2004

Well, ya know, I did read the reference and was confuzzeled about the
StringFormat parameter.  It looks like it's required but there's only
one possible value?  My MSDN says this:


StringFormat   Specifies that the Recordset should be converted to the
following format.

Constant Description 
adClipString Rows are delimited by RowDelimiter, columns by
ColumnDelimiter, and NULL values by NullExpr. These three parameters are
valid only with adClipString. 

So I have to go through the (apparent) formality of typing
"adClipString", since the first parameter is required, and it's the only
possible value for the first parameter?  How dumb.  :)

...further study has revealed that I also need to omit the "Set" at the
beginning of the line, even though MSDN says that "Set" should be used.
Nonetheless, changing my code to:

            NewStr = rsSprocReturn.GetString(adClipString)

...got me past the error.

The contents of this email and any attachments are confidential.
It is intended for the named recipient(s) only.
If you have received this email in error please notify the system manager or  the 
sender immediately and do not disclose the contents to anyone or make copies.

** eSafe scanned this email for viruses, vandals and malicious content **

More information about the thelist mailing list