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

write NULL value in a Database...

 [1/1] from: riusa::email::it at: 1-Feb-2002 0:19


Hi! I have Rebol/Command and can manage databases. I have a very big problem: I created an Access DB (via ODBC), I created a table with a field "datetime". Ok... I need to INSERT (SQL) a null value... but I cannot! my "table1": field type size ----------- ---------- --------- name varchar 20 surname varchar 20 date_born datetime CODE: db: open odbc://accessODBC ; this is ok dbp: first db ; this is ok insert dbp [{insert into table1 (name,surname,date_born) values (?,?,?)} myName mySurname myDate ] ^^^^^^ | my problem!!! I want to insert a NULL! can you help me?! thank you! bye! ++++++++++++++++++++++++++++++++++++++++++++ Alessandro Manotti Presidente dell'Associazione di volontariato "RIUSA" (ONLUS) Sito web: http://riusa.apritisesamo.net email: [riusa--email--it] mailing-list: [riusa-ml--yahoogroups--com] Telefono: 347.63.43.23.1 -- Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f Sponsor: Studi e lavori? Con LOL ti prepari da casa con l’assistenza on-line di un docente. Clicca qui: http://adv.email.it/cgi-bin/foclick.cgi?mid=59&d=1-2