OraFAQ Forum: Server Administration » Posting empty fields in SQL-statement

Home » RDBMS Server » Server Administration » Posting empty fields in SQL-statement

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Posting empty fields in SQL-statement [message #371827]

Tue, 12 December 2000 08:52

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!!!

Report message to a moderator

Re: Posting empty fields in SQL-statement [message #371829 is a reply to message #371827]

Tue, 12 December 2000 09:12

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

Report message to a moderator