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!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
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...- WizZerD
- Thread
- Replies: 1
- Forum: Centura Software / Gupta : SQLBase
-
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)...- WizZerD
- Thread
- Replies: 1
- Forum: Centura Software / Gupta : SQLBase
-
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...- WizZerD
- Thread
- Replies: 5
- Forum: Centura Software / Gupta : SQLBase
