I know it's basic, but I just can 't get round this problem.
INSERT INTO INSTANCE_LBL_EV_TB(INSTANCE_LABEL,STATUS,EVENT_TYPE) values(1,2,3);
results in the following:
^
Error: 00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 01417
Yes the table is there & I am connected with sysadm.
Any...
Maybe I need to clarify myself.
I need to call a procedure from a select statement, and ultimately from a view..
For example
SELECT UserID, NAME, GetAddress(UserID) FROM CONTACTS
Where GetAddress() is a Procedure that returns an address string for the UserID.
Can anyone help ?
/Nigel
Now my next problem..
I have made this simple Procedure & stored it.
PROCEDURE: GetAnmarkning
Parameters
Receive String: sAnmarkning
Local Variables
String: sSQL
Actions
Set sSQL = 'select ANMARKNING from UPPSKICKSRAD where BESTID = :sAnmarkning into :sAnmarkning'
Call SqlImmediate(sSQL)...
Thanks readingcoops.
I have removed the order by line, but am still getting:
Error: 00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 00330
for the third set of || which I use to build up a string.
If I remove the column with the ||, I get an error at each of my @IF statements.
Doe this mean...
If I remove the ORDER By line, I get the following error:
SELECT @LEFT(EPISOD.PRODNR,2)||'-'||@MID(EPISOD.PRODNR,3,2)||'/'||@RIGHT(
^
Error: 00134 SQL CNO ERROR.SQL NOT FOUND LOOKING UP ERROR 00330
Why does it fail on the third set of ||´s ??? not the first?
btw.. SQLBase V 7.5.1
Thanks...
Hi I have run the following Select statement and got a result:
SELECT @LEFT(EPISOD.PRODNR,2)||'-'||@MID(EPISOD.PRODNR,3,2)||'/'||@RIGHT(EPISOD.PRODNR,4) AS Prodnr,EPISOD.EPISODKOD AS Avs,UPPSKICK.UPPSKICKSDATUM AS Datum,BAND.BANDNR AS Matid, PROD.SVENSK AS...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.