ERROR in Table Class

[JTmartins]

Just a quick note, on something I've just found

If we use the table class together with an SQL DB, if a field is empty (null), the class will thrown an error, and will not work.

So if you use it make sure all your fields are populated, or check programmatically and change to something as NA, before calling Table.AddRow.

Thanks
José

 

[Mahares]

@Jose:
Did you try to replace in the Table class module this:

Values() As String

with this:

Values() As Object

There are about 5 places or so. Also, replace in the man module this:

Table1.AddRow(Array As String(

with:

Table1.AddRow(Array As Object(

I tried it and it worked for me with one field with its data all blank (empty)

 

[JTmartins]

Wil try

Thanks.

I will try that.

As a novice, I always am afraid of touching classes..I examine them, to learn, and there are still many things I do not understand.

Thanks

José

 

[Harris]

Yes, I find this also in many samples and classes I try.

Is there a rule when to use Object vrs String when defining Array As?

My rule is if string throws error - I try object... Sometimes, string works with numbers and other times not.

Thanks

 

[Erel]

Is there a rule when to use Object vrs String when defining Array As?

It depends on which array you need. Array of objects can hold any values. Array of strings can only hold string values.

Different methods expect different types of arrays.