Обсуждение: Money type mapping to VB5 Jet workspace

Поиск
Список
Период
Сортировка

Money type mapping to VB5 Jet workspace

От
"Bill Hutto"
Дата:
Hi,
    I'm having problems with the mapping of the money type to an
appropriate type in Visual Basic 5.0. Presently, it is coming across
as type float8, and if that were acceptable to me, it isn't when I
update, because I get an error '524':

 parser: attribute 'amount'  is of type 'money' but expression is of
type 'float8'
You will need to rewrite or cast the expression.

I can successfully update only with an ODBC direct workspace, where I
can add single quotes around the value. I would prefer to be able to
use the Jet workspace, however, as well as data bound controls.
Is it possible to have it map to the currency data type?

Thanks,
Bill