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