Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
 Password:
Save Password
Forgot your Password?

 All Forums
 Community Forums
 Code Support: ASP (Non-Forum Related)
 Disconnected RS and NULLs		  New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

snaayk
Senior Member

USA
1061 Posts
Posted - 17 September 2003 :  10:58:50  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
Is there a way to make a disconnected recordset accept NULLs in the fields? I can't find anything that stipulates the syntax for this.

Gremlin
General Help Moderator

New Zealand
7528 Posts
Posted - 17 September 2003 :  11:31:28  Show Profile  Visit Gremlin's Homepage
Disconnected recordsets should work exactly the same as a normal recordset in every way as far as I know (I haven't coded one for quite some time though).

What sort of error are you getting, maybe a snippet of your code posted would be handy for us to try and help you with.
Kiwihosting.Net - The Forum Hosting Specialists
Go to Top of Page

snaayk
Senior Member

USA
1061 Posts
Posted - 17 September 2003 :  12:35:04  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
I got it...

rsVeri.Fields.Append "d_rem", adVarChar, 200, [color=red]adFldIsNullable[/color]

If you don't do that it won't allow nulls in the field
Go to Top of Page

HuwR
Forum Admin

United Kingdom
20584 Posts
Posted - 17 September 2003 :  13:15:04  Show Profile  Visit HuwR's Homepage
the error may help

Have you got a value defined for adFldIsNullable ?
Go to Top of Page

snaayk
Senior Member

USA
1061 Posts
Posted - 26 September 2003 :  18:12:07  Show Profile  Visit snaayk's Homepage  Send snaayk an AOL message  Send snaayk an ICQ Message  Send snaayk a Yahoo! Message
The error was cannot insert null into field (becuase nulls are not allowed). I set the AdFldIsNullable and the field will accept NULLs. AdFldIsNullable is a constant set in the adovbs.inc (or meta tag in my case) I believe. didn't look into it - since it worked.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts
Posted - 26 September 2003 :  20:28:30  Show Profile
If the field in the underlying data source doesn't accept nulls you won't be able to reconnect and update the db even though you have allowed nulls in your disconnected recordset.
======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.27 seconds. Powered By: Snitz Forums 2000 Version 3.4.07