From: | Carlos Alberto Ibañez <liccarlos2001(at)yahoo(dot)com(dot)ar> |
---|---|
To: | pgsql-es-ayuda(at)postgresql(dot)org |
Subject: | invalid input syntax for type date |
Date: | 2006-07-07 12:17:55 |
Message-ID: | 20060707121755.33517.qmail@web53307.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Hola lista.
Tengo una aplicación en Visual Fox 6.0 con Postgresql
8.1.3. cuando inserto un registro lo hace bien pero
cuando actualiza el obdc me da un error en la fecha :
invalid input syntax for type date.
Le error en el archivo de log de odbc es:
conn=2cb0048, query='INSERT INTO transporte.propiet
(cuilcuit,tipodat) VALUES ('45550',E'11 ')'
el insert da bien pero el udpate me da este error:
conn=2cb0048, query='UPDATE transporte.propiet SET
alta='2004-10-10'::date WHERE cuilcuit='45550' AND
alta=E'''
ERROR from backend during send_query: 'SERROR'
ERROR from backend during send_query: 'C22007'
ERROR from backend during send_query: 'Minvalid input
syntax for type date: ""'
ERROR from backend during send_query: 'Fdatetime.c'
ERROR from backend during send_query: 'L3411'
ERROR from backend during send_query:
'RDateTimeParseError'
STATEMENT ERROR: func=SC_execute, desc='(null)',
errnum=7, errmsg='Error while executing the query'
------------------------------------------------------------
hdbc=2cb0048, stmt=27d8548,
result=27d2310
prepare=0, internal=0
bindings=27da870,
bindings_allocated=46
parameters=2cb9358,
parameters_allocated=3
statement_type=2, statement='UPDATE
transporte.propiet SET alta=? WHERE cuilcuit=? AND
alta=?'
stmt_with_params='UPDATE
transporte.propiet SET alta='2004-10-10'::date WHERE
cuilcuit='45550' AND alta=E'''
data_at_exec=-1,
current_exec_param=-1, put_data=0
currTuple=-1, current_col=-1,
lobj_fd=-1
maxRows=0, rowset_size=1,
keyset_size=0, cursor_type=0, scroll_concurrency=1
cursor_name='SQL_CUR027D8548'
----------------QResult Info
-------------------------------
fields=27da360, backend_tuples=0,
tupleField=0, conn=0
fetch_count=0, num_total_rows=0,
num_fields=0, cursor='(NULL)'
message='ERROR: invalid input syntax
for type date: ""', command='(NULL)', notice='(NULL)'
status=7, inTuples=0
CONN ERROR: func=SC_execute, desc='(null)',
errnum=110, errmsg='ERROR: invalid input syntax for
type date: ""'
muchas gracias
___________________________________________________________
1GB gratis, Antivirus y Antispam
Correo Yahoo!, el mejor correo web del mundo
http://correo.yahoo.com.ar
From | Date | Subject | |
---|---|---|---|
Next Message | La Pasion Del Rio | 2006-07-07 12:24:51 | Postgres con Vpopmail |
Previous Message | AS Gustavo Rodriguez | 2006-07-07 12:03:37 | Re: Que recomiendan usar con el ODBC |