Search results for query: *

Silly mistake... I was missing an index on the table. 8-}

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)...

Great, Now I am getting results ... Thanks !!!

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...