SQL statements in Axiant
Montenegro Alex
almon@wmdata.com
Tue, 29 Jan 2002 12:37:10 +0100
Hi I have this problem with a simple qks program,
that works with no problems in Powerhouse..
This is my qks file..
;***********************************************************
SCREEN alex &
from 10,1 to 23,80 &
ACtivi FIND;,CHANGE
declare FIND_SEQ cursor for &
select SW_NR as FIND_NR &
, SD_SEQNR as FIND_SEQNR &
from SWIFTDATA &
where ( SD_ID = '35H')
cursor FIND_SEQ OCC 2
SKIP TO 3
ALIGN ( , 4, 43)
CLUSTER OCC WITH FIND_SEQ AT 3,1
ALIGN ( , 4, 15)
FIELD FIND_SEQNR DISP LABEL "Det.no...:" PIC "^^^^^"
FIELD FIND_NR DISP
BUILD
;**************************************************************'
And when I imported it via the Migration Profile and build it,
I got this errors..
;Screen Statement
SCREEN alex &
ACTIVITIES FIND
DECLARE FIND_SEQ CURSOR FOR &
SELECT SW_NR as FIND_NR , SD_SEQNR as & FIND_SEQNR from SWIFTDATA
where ( SD_ID = & '35H' )
;File/Cursor Statement
CURSOR FIND_SEQ &
OCCURS 2
;Layout Section
CLUSTER OCCURS WITH FIND_SEQ &
ID BASE 1
FIELD Unknown &
DISPLAY &
PICTURE "^^^^^"
FIELD Unknown &
DISPLAY
CLUSTER
;Screen Procedure Section
;Field Procedure Section
;Build Statement
BUILD LIST
Line(15) : error 0: *E* Can't find the item UNKNOWN.
Line(19) : error 0: *E* Can't find the item UNKNOWN.
Any know if axiant have any problem to handle this kind
of statements, or what is happening..
regards Alex