Re: Strange Update query ...

Поиск
Список
Период
Сортировка
От Hélder M. Vieira
Тема Re: Strange Update query ...
Дата
Msg-id 000a01c6564a$da5e2750$580bfea9@hmv02
обсуждение исходный текст
Ответ на Strange Update query ...  (Thomas Chabaud <tc@geosys.fr>)
Список pgsql-odbc
Hiroshi, I made several tests, and the log always shows an UPDATE statement
filled with constant values, such as:

'UPDATE mytable SET myfield1=4,myfield2=5,myfield3=6
WHERE (id=6 AND myfield1=1 AND myfield2=2 AND myfield3=3 )'

I tried with several data types, with and without explicit declaration of
the 'myvaluex' variables, and never saw variable names in the generated
UPDATE statement.

Thomas Chabaud's log shows:

'UPDATE mytable SET myfield1=myvalue1,myfield2=myvalue2,myfield3=myvalue3
WHERE (id=6 AND myfield1=myvalue1 AND myfield2=myvalue2 AND
myfield3=myvalue3 )'

I can't figure out how variable names could appear in the UPDATE statement,
so I think Thomas Chabaud should provide some information about the nature
of those variables.


Hélder M. Vieira



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

Предыдущее
От: Hiroshi Inoue
Дата:
Сообщение: Re: Strange Update query ...
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: problem about maximum row size ?