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!
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.