Is he connecting with the old ODBC driver, or an out of date ADO, and this
table has varbinary or new field type in it?
Tracy
-----Original Message-----
From: MB Software Solutions General Account
Sent: Thursday, April 16, 2009 4:36 PM
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!
_______________________________________________
Post Messages to: ProFox@leafe.com
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/000d01c9bed5$4de40370$e9ac0a...@com
** 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.
