db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From rico16135 <rico_16...@hotmail.com>
Subject BEGIN
Date Sat, 05 Apr 2008 11:42:18 GMT
SET @Exists = 0;
IF EXISTS (SELECT 1 FROM table WHERE PK =
 @PK)
BEGIN
SET @Exists = 1;
END
RETURN;
END
Help with use of exists
 with java-netbeans
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Nabble-From: rico_16135@hotmail.com


I am trying to write a sql query that checks for the existence of a call_num
in my table rico.calls so i can either enter it there if it doesn't exist or
another table.

so, in netbeans I try and execute something like this:
I found this example

BEGIN
SET @Exists = 0;
IF EXISTS (SELECT * FROM rico.calls WHERE call_num = 8)
BEGIN
SET @Exists = 1;
END
RETURN;
END
GO




it complains about finding BEGIN at line 1 column 1    ok, so what
am I doing wrong?





Error code -1, SQL state 42X01: Syntax error: Encountered "BEGIN" at line 1,
column 1.
Line 1, column 1

Error code -1, SQL state 42X01: Syntax error: Encountered "IF" at line 1,
column 1.
Line 3, column 1

Error code -1, SQL state 42X01: Syntax error: Encountered "END" at line 1,
column 1.
Line 6, column 1

Error code -1, SQL state 42X01: Syntax error: Encountered "END" at line 1,
column 1.
Line 8, column 1

Execution finished after 0 s, 4 error(s) occurred.
-- 
View this message in context: http://www.nabble.com/BEGIN%0D%0ASET-%40Exists-%3D-0-%0D%0AIF-EXISTS-%28SELECT-1-FROM-table-WHERE-PK-%3D-%40PK%29%0D%0ABEGIN%0D%0ASET-%40Exists-%3D-1-%0D%0AEND%0D%0ARETURN-%0D%0AEND%0D%0AHelp-with-use-of-exists-with-java-netbeans-tp16512198p16512198.html
Sent from the Apache Derby Users mailing list archive at Nabble.com.


Mime
View raw message