invalid input syntax for type date

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

Browse pgsql-es-ayuda by date

  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