Re: INSERTing when there is a foreign key table

[Nolan Sunico]

Hi;

You can do it!
use stored procedure to be able to execute more than one commands.
first you need to create a cursor to check if the filename exists
second if it exist, you may either update the data row or you can delete it for good.
third if it does not exist, perform an inserts.
use the command:

call CheckInsert('Rudy');

CheckInsert is the name of the procedure
'Rudy' the name


The Programmer