Jump to content


Photo
- - - - -

Embedded SQL in Global Logics


1 reply to this topic

#1 John Robson

John Robson

    Member

  • Members
  • PipPip
  • 11 posts
  • Gender:Male
  • Location:Melbourne, Australia

Posted 09 October 2003 - 03:43 AM

Has anyone experiened any problems trying to put frequently used embedded SQL into global logics and calling them from multiple functions.

It seems to work OK, UNTIL I try and use a bind variable then all hell breaks loose. Well ProIV gives me a SUBSCRIPT OUT OF RANGE ERRROR:

@RFUNCT

qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq
The following error occurred, causing your function to
be aborted and an automatic rollback to be performed. 13:39:24

@MSG [ 15]
@MSGTEXT [015 - SUBSCRIPT VALUE NOT WITHIN RANGE OF DIMENSION - -717171717]
@MSGARGS [] x

@SYSERR [ ]
@SYSERRTEXT [ ]


Press [ ]
qqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqqq

Has anyone experienced this before and managed to overcome it?

Cheers

John

#2 CSuarezdelReal

CSuarezdelReal

    Advanced

  • Members
  • PipPipPip
  • 91 posts
  • Gender:Male

Posted 12 October 2003 - 01:25 AM

Hi there!

I use SQL in Global Logics everytime I have to use the same or similar SQL sentences in more than one place. Could you post some code to better understand where the problem is?

Regards,
Claudio Suárez del Real
"It is not the strongest of the species that survive, nor the most intelligent, but the ones most responsive to change."



Reply to this topic



  


0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users