Hello!
first: Thanks to Hiroshi Inoue for the interest and help
Sorry for the slow answer. Here is an example from the
Cygwin window:
ERROR: Function to_fck(numeric) does not exist
Unable to identify a function that satisfies the given argument
types
You may need to add explicit typecasts
LOG: statement: SELECT
to_fck(gcpf_topics.topic_hidden),gcpf_topics.topic_name,
gcpf_topics.topic_no_messages ,
gcpf_topics.topic_start_date,
gcpf_topics.topic_id,gcp_users.user_nick
as user_name
FROM gcpf_topics,gcp_users
where gcpf_topics.user_id=gcp_users.user_id
order by topic_start_date desc
to_fck() is a non-existing function - a fantasy name :)
Using latest postgresql ODBC from Smalltalk, I got a cursor with NO ERROR
(!)
and no rows in it. So I've got an empty result_table but no error
message at all. My application this way believes that everything is fine and
there are no rows in the reply.
Running the same from PGADMIN III the result is error, which is the right
behavior.
ERROR: Function to_fck(numeric) does not exist
Unable to identify a function that satisfies the given argument types
You may need to add explicit typecasts
Smalltalk uses ODBC3 interface.
ODBC subsystem details:
OS: XP Hungarian, SP1
App. dev tool: IBM VisualAge Smalltalk 5.5.2 using built in ODBC connector
(ODBC3 compliant)
Win XP ODBC manager: many components with different versions.
odbccp32.dll 3.520.9030.0
odbcint.dll 3.520.7713.0
odbc32.dll 3.520.9030.0
odbccr32.dll 3.520.9030.0
odbccu32.dll 3.520.9030.0
odbccp32.dll 3.520.7713.0
odbcad32.exe 3.520.9030.0
thanks
Robert
