Re: -2147217842 Operation was canceled

Поиск
Список
Период
Сортировка
От Hiroshi Inoue
Тема Re: -2147217842 Operation was canceled
Дата
Msg-id EKEJJICOHDIEMGPNIFIJEEIKFKAA.Inoue@tpf.co.jp
обсуждение исходный текст
Ответ на Re: -2147217842 Operation was canceled  ("Ryan C. Bonham" <Ryan@srfarms.com>)
Список pgsql-odbc
> -----Original Message-----
> From: Ryan C. Bonham [mailto:Ryan@srfarms.com]
>
> Ok,
> On exploring this issue some more here is what have. The field I
> was having
> this problem with was a date field, so I believe what was happening was it
> was trying to insert a value of '' into a date field, and
> actually returning
> a "Bad date external representation."  so I added the following
> commands to
> the form.
> If txtdate3ties.Text = Empty Then
>     DataEnvironment1.rscmdRecentHeats.Fields("date3ties").Value = Null
> End If
>
> Now is actually does make the change to that field, but it still fails on
> the move, and spits out the error.. Weird..

Please start the postmaster with -d option and see what queries are
issued at server side in the log.

regards,
Hiroshi Inoue


В списке pgsql-odbc по дате отправления:

Предыдущее
От: Jim Dickenson
Дата:
Сообщение: Mac OS X problem
Следующее
От: Denis Gasparin
Дата:
Сообщение: Re: Writing BLOBS to pgsql via ODBC using VB