J
John Wilson
I have a sql string that I put through a connection object to fetch my data
out of vfp tables using the oledb driver, and then bind it to a datagrid in
vs.net 2003. The sql contains a left join between 2 numeric fields, and
every time the table on the right side of it has no matching record for the
first row of the left side table, it causes
an error. This never happens if the right side table has a record though,
nor on records other than the first.
The error is: "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."
Any idea where I am going wrong?
out of vfp tables using the oledb driver, and then bind it to a datagrid in
vs.net 2003. The sql contains a left join between 2 numeric fields, and
every time the table on the right side of it has no matching record for the
first row of the left side table, it causes
an error. This never happens if the right side table has a record though,
nor on records other than the first.
The error is: "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."
Any idea where I am going wrong?