JAMES
asked on
IF(not exist .... not working...(for me)
Hi,
I am old to databases but new to Firebird! Could you help with the syntax for the following statement please :-
IF (not exists(select PlayerID from Player where Site = 'SITE' and Alias = 'JAMES'))
insert into Player(Site,Alias) values ('SITE','JAMES')
Im getting invalid token on IF and it's Driving me mad!
Thanks.
James.
I am old to databases but new to Firebird! Could you help with the syntax for the following statement please :-
IF (not exists(select PlayerID from Player where Site = 'SITE' and Alias = 'JAMES'))
insert into Player(Site,Alias) values ('SITE','JAMES')
Im getting invalid token on IF and it's Driving me mad!
Thanks.
James.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.