Re: VB & ADO don't seem to handle numeric fields

Peter,

What is the "Type" property of the Field object? We want to see "adDecimal"
in there. Also, does the "Value" property of the Field object show correct
numeric data?

What I'm trying to determine is if the ADO driver itself is seeing the data
correctly.

Is the source of the data a table or stored procedure?


John Taylor
Canada

p.s. - feel free to take this offline if the delay of the listserver is not
acceptable.


----- Original Message -----
From: "Peter Dow" <pcdow@MailAndNews.com>
To: <MIDRANGE-L@midrange.com>
Sent: Monday, November 27, 2000 08:01
Subject: Re: VB & ADO don't seem to handle numeric fields


> Hi John,
>
> I thought of that earlier and put in code to iterate through AS400RS
fields
> collection showing the name, actual size, defined size, and type:
>
> RTCODE
>  2
>  10
>  200
> RTDESC
>  13
>  50
>  200
> RTAMT
>  16
> -1
>  14
>
> No trailing spaces as far as I can tell. I tried using the ordinal
positions
> (0 - 2) instead of names, and again, the 1st two work, but not the 3rd. It
> gets the same "Invalid procedure call or argument".
>
> What I can do is get it to successfully assign
>
>        RateAmt = AS400rs.Fields("RTAMT")
>
> when RateAmt is DIM RateAmt as Variant, but when I subsequently try to
> assign that variant field to another field, I'm back to "Invalid procedure
> call or argument."
>
> Thanks for the suggestions though. Any other ideas?
>
> Peter Dow
> Dow Software Services, Inc.
> 909 425-0194 voice
> 909 425-0196 fax
 +---

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---