Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. WizZerD

    Error 01417 with INSERT

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

    Error 01417 with INSERT

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

    Calling a Procedure from a view

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

    Calling a Procedure from a view

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

    Create a view from a SELECT Statement

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

    Create a view from a SELECT Statement

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

    Create a view from a SELECT Statement

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

    Create a view from a SELECT Statement

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

Part and Inventory Search

Back
Top