MB Software Solutions General Account wrote:
> MS Visual Studio Server Explorer
> VFP9SP1 free tables
>
> Vendor is claiming the following:
> ---------------------------------------
> I am getting the following error wile reading the table :
>
> The provider could not determine the Decimal value. For example, the row
> was just created, the default for the Decimal column was not available,
> and the consumer had not yet set a new Decimal value. for:
>
> SELECT *
> FROM erl_sub
> WHERE (createdate >= {^2009-01-16})
> ORDER BY idnum ASC
>
> When I open the erl_sub in MS Visual Studio using the Server Explorer it
> gives me unable to read binary data for the records below.
>
> I have seen this error before when the value in the field was out of
> boundary (e.g. putting 999 in decimal(2,0))
>
> ---------------------------------------
>
> I told him that he shouldn't get an error on SELECT, but he verified that
> it's indeed when he does a select. I'm wondering if one of the fields has
> an overflow (***) condition?
>
> Other ideas?
>
> tia!
It was an overflow condition...forget it!
--
Mike Babcock, MCP
MB Software Solutions, LLC
President, Chief Software Architect
http://mbsoftwaresolutions.com
http://fabmate.com
http://twitter.com/mbabcock16
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
Searchable Archive: http://leafe.com/archives/search/profox
This message:
http://leafe.com/archives/byMID/profox/[email protected]
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
