Home » RDBMS Server » Server Administration » Posting empty fields in SQL-statement
Posting empty fields in SQL-statement [message #371827] Tue, 12 December 2000 08:52 Go to next message
Tim Bertens
Messages: 2
Registered: December 2000
Junior Member
Hi,
I have a problem when I want to post empty fields in an access 2000 database. The SQL-statement is working correctly when all field are present... but when one or more fields is empty I get an error. This is the statement I'm talking about.

INSERT INTO TblKandidaatGegevens (RijksregisterNummer, Naam, Voornaam, Straat, Nummer, Postcode, Gemeente, TelefoonPrefix, TelefoonAbonneeNummer, FaxPrefix, FaxAbonneeNummer, GSMPrefix, GSMAbonneeNummer, Email, Geboortedatum_dag, Geboortedatum_maand, Geboortedatum_jaar, Geslacht, Nationaliteit, Rijbewijstype, Vervoertype, Werkloosheidsdatum_dag, Werkloosheidsdatum_maand, Werkloosheidsdatum_jaar, VDAB_dag, VDAB_maand, VDAB_jaar, OCMW_dag, OCMW_maand, OCMW_jaar, Motivatie) VALUES (75040630155, 'Bertens', 'Tim', 'Straat', '148a', 1040, 'Brussel', 9, 1213456, 2, , 475, , 'tim.bertens@atel.be', 6, 4, 1975, 'Man', 'Belg', 'Geen', 'Fiets', , 2, , , 1, , , 1, , 'ja');

Can somebody please help??
Thanks!!!
Re: Posting empty fields in SQL-statement [message #371829 is a reply to message #371827] Tue, 12 December 2000 09:12 Go to previous messageGo to next message
Shanthi Ramayanapu
Messages: 22
Registered: October 2000
Junior Member
My access database knowledge is limited, but my assumptions was that access does not have varchar datatype, it only has char type, which implies you need to use some function equivallent to nvl (not null value) in oracle (I think it is IIF) to pass null if no data found. i.e atleast '' or ' '.
Hope this helps. By the way I could not understand the column names. What language is it? Just curious.

Shanthi
Shanthi
Re: Posting empty fields in SQL-statement [message #371830 is a reply to message #371829] Tue, 12 December 2000 09:19 Go to previous messageGo to next message
Tim Bertens
Messages: 2
Registered: December 2000
Junior Member
Thanks, i'm gonna try it... For your curiosity : the language used in de column names is dutch; I live in Belgium...
Re: Posting empty fields in SQL-statement [message #371835 is a reply to message #371830] Tue, 12 December 2000 11:37 Go to previous message
Shanthi Ramayanapu
Messages: 22
Registered: October 2000
Junior Member
Thanks.
Previous Topic: SQLPLUS Command-file execution
Next Topic: Re: mailing through oracle
Goto Forum:
  


Current Time: Sun Dec 22 20:35:08 CST 2024