By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,490 Members | 897 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,490 IT Pros & Developers. It's quick & easy.

ADO Question

P: n/a
Hello,

I have an array from which I load values into a table.

My table creation is done using ADO.

Some of the fields in the Array can have null values and I want to
load the corresponding table field with the same values as in the
array - that is null or non-null values.

I have defined text fields in ADO in table creation as follows:

With tbl
..Name = "tbl_Name"
Set .ParentCatalog = cat
..Columns.Append "Case_Field", adWChar
End With

When the array contains null values I get a message saying "You tried
to assign a Null Value for a variable that is not Variant Data Type"

What should I change in the above code in order that this message does
not appear?

Thanks in advance.

Uttam
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
On 2 Nov 2003 17:12:22 -0800, u0***@hotmail.com (Uttam) wrote:

Are you SURE the error occurs in this code fragment? Make sure, by
setting a breakpoint and stepping through.

Rather I would think the bug is in the assignment of the array. For
example this code would fail:

dim v as variant
dim s(10) as string 'string array
v=null
s(0) = v 'error here.

-Tom.

Hello,

I have an array from which I load values into a table.

My table creation is done using ADO.

Some of the fields in the Array can have null values and I want to
load the corresponding table field with the same values as in the
array - that is null or non-null values.

I have defined text fields in ADO in table creation as follows:

With tbl
.Name = "tbl_Name"
Set .ParentCatalog = cat
.Columns.Append "Case_Field", adWChar
End With

When the array contains null values I get a message saying "You tried
to assign a Null Value for a variable that is not Variant Data Type"

What should I change in the above code in order that this message does
not appear?

Thanks in advance.

Uttam


Nov 12 '05 #2

P: n/a
rkc

"Uttam" <u0***@hotmail.com> wrote in message
news:77**************************@posting.google.c om...
Hello,

I have an array from which I load values into a table.

My table creation is done using ADO.

Some of the fields in the Array can have null values and I want to
load the corresponding table field with the same values as in the
array - that is null or non-null values.

I have defined text fields in ADO in table creation as follows:

With tbl
.Name = "tbl_Name"
Set .ParentCatalog = cat
.Columns.Append "Case_Field", adWChar
End With

When the array contains null values I get a message saying "You tried
to assign a Null Value for a variable that is not Variant Data Type"


If the error is in fact occuring when you try to add the values from the
array to the columns in the new table, it may be because you have not
defined the column(s) to allow null values.

This I know works with Jet:

Set col = New ADOX.column

With col
.Name = "Case_Field"
.Type = adWChar
.Attributes = adColNullable
End With

tbl.Columns.Append col


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.