Hello everyone..
Here is the result of my Insert. and also the insert works ok.
INSERT INTO MOD48_02 (ID, TE_INDI, TE_COGNOME, TE_NOME, TE_SESSO, TE_ATTNASC,
TE_LUONASC, TE_DTNASC, TE_PROVSTATO, TE_PROV, TE_PATERNITA, TE_RICHIESTA,
USERNAME, DATE_INSERTED, TIME_INSERTED) VALUES ('127001200745101033',
'england', 'bloom', 'orlando', 'M', 'ww', 'florida', '05/06/1984', 'america',
'UK', 'xx', 'no', 'demo', '05/04/2007', '10.10.33');
But before i insert this record i want to check if the it hasn't been inserted
before. I want to use the following fields as the riefferent. TE_COGNOME,
TE_NOME, TE_SESSO, TE_DTNASC
And if there is no record to match those 4 fields i want to insert it else just
a message saying that the record has been inserted b4.
any idea to start with?
Shavonne Wijesinghe
