[REBOL]
From: riusa:email:it at: 4-Feb-2002 15:16
Hi,
I have a problem (!)... (sorry!)
I must update some field in a DB (ODBC->Ms Access).
I have to write a date or, if the user doesn't insert the date, I want
to write "NULL".
DB Access has a field "myDate (type: DateTime)".
E.G.:
Using DB functions in Rebol/Command:
type? newDate = string (got from a field in layout... InputDate/text).
db: open odbc://accessODBC
dbp: first db
insert dbp { [update myTable set myDate=?] newDate }
if newDate is a date, everything is ok, but... if the user does not
insert the date (blank)...
I always obtain the error:
** Script Error: ODBC error: [Microsoft][Driver ODBC Microsoft Access]
Data types do not correspond in the function-criteria.
** Where: func [face value][panels/pane: none
show panels
Help me! I need to accept either valid date or null values!
Thanks !
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Obiettivo Laurea? basta con le pratiche burocratiche! Te le possiamo sbrigare noi.
Per informazioni
Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=216&d=4-2