<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I am old to databases but new to Firebird! &nbsp;Could you help with the syntax for the following statement please :-<br />
<br />
IF (not exists(select PlayerID from Player where Site = 'SITE' and Alias = 'JAMES'))<br />
insert into Player(Site,Alias) values ('SITE','JAMES')<br />
<br />
Im getting invalid token on IF and it's Driving me mad!<br />
<br />
Thanks.<br />
<br />
James.<br />

</div>
</div>


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.


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 = &#39;SITE&#39; and Alias = &#39;JAMES&#39;))
insert into Player(Site,Alias) values (&#39;SITE&#39;,&#39;JAMES&#39;)

Im getting invalid token on IF and it&#39;s Driving me mad!

Thanks.

James.


Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.