Snitz Forums 2000 - 3.4 Fields set to not allow zero length value

Snitz Forums 2000

Username:	Password:
Save Password
Forgot your Password?

All Forums

Snitz Forums 2000 DEV-Group

DEV Discussions (General)

3.4 Fields set to not allow zero length value

New Topic

Topic Locked

Printer Friendly

Author

Topic

Page: of 2

coolguyz
Starting Member

11 Posts

Posted - 01 October 2002 : 09:43:33

Hi Doug

I'm getting this Error after I ran the code

FORUM_A_REPLY

ADODB.Properties error '800a0cc1'

ADO could not find the object in the collection corresponding to the name or ordinal reference requested by the application.

/forum/untitled.asp, line 17

Any ideas?
This is my code below:

<%
set con = server.createobject("ADODB.Connection")
set cat = server.CreateObject("ADOX.Catalog")
strConnString = "NSOFFORUM"

con.Open strConnString
set cat.ActiveConnection = con

Dim objTable, objColumn
for each objTable in cat.Tables
if objTable.Type = "TABLE" then
Response.Write objTable.Name & "<br>"

for each objColumn in objTable.Columns
if objColumn.Type = 202 or objColumn.Type = 203 then
objColumn.Properties("Jet OLEDB:Allow Zero Length") = true
Response.Write " " & objColumn.Name & "(" & objColumn.Type & ") AllowZeroLength set to True<br>"
end if
next
Response.Write "<p>"
end if
next

set cat = nothing
set cnn = nothing
%>

pixelator
Starting Member

14 Posts

Posted - 24 November 2003 : 17:12:30

quote:
Originally posted by ruirib

quote:
Originally posted by RichardKinser

The actual state of an existing Database is going to be different for certain people.

Agreed.
quote:

If you open an Access DB in Microsoft Access, field properties can be changed.

Not unless you change them, AFAIK. Never seen that happen with my Access apps.
quote:

If you compact a Database, field properties can be changed.

They shouldn't change. After all the way you define your properties may be of fundamental importance for your database application. Also never noticed any changes.

I have confirmed that the fields infact can change
http://forum.snitz.com/forum/topic.asp?TOPIC_ID=49477

Page: of 2

Topic

New Topic

Topic Locked

Printer Friendly

Jump To:

Snitz Forums 2000

This page was generated in 0.12 seconds.