SQL statements in Axiant

[Edis, Bob]

Alex

I would suggest two things:

a. qualify the fields with the data source name as -

FIELD FIND_SEQNR OF find_seq DISP  LABEL "Det.no...:" PIC "^^^^^"
FIELD FIND_NR    OF find_seq DISP  

b. check the ODBC reference in the dictionary carefully and make sure the
PHD reference to the database and the ODBC DSN are exactly the same.  I.e.
even the case should be identical.

Regards,
Blue

-----Original Message-----
From: Jones Allen (Van) [mailto:Allen.Jones@vpgroup.com]
Sent: Tuesday, January 29, 2002 9:12 AM
To: 'Montenegro Alex'; 'powerh-l@lists.swau.edu'
Subject: RE: SQL statements in Axiant


Check your cursor definition in the "data access" section of the screen.
Make sure you enter the name of the database in the "Database" property.

If you want to fix it before you migrate, use the syntax:

sql in <database name> declare FIND_SEQ cursor for ....

It seems that in prior versions of Powerhouse we didn't have to name the
database, but in Axiant we do.

-----Original Message-----
From: Montenegro Alex [mailto:almon@wmdata.com]
Sent: Tuesday, January 29, 2002 3:37 AM
To: 'powerh-l@lists.swau.edu'
Subject: SQL statements in Axiant


     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

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe" in message body to
powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.