Mailing List Archive: 49091 messages
  • Home
  • Script library
  • AltME Archive
  • Mailing list
  • Articles Index
  • Site search


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: Sponsor: Obiettivo Laurea? basta con le pratiche burocratiche! Te le possiamo sbrigare noi. Per informazioni Clicca qui: