[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] Weird problem with load-lookup



Thanks Steve, as I mentioned, I did that and it worked fine.  Rewriting the 
program to do that select and populate an array instead of using the 
load-lookup is succesful; it's just the load-lookup that won't compile.

Denise M. White
Sr. Software Engineer
Vicor 
--__--__--

Message: 21
From: "Steve Cavill" <steve.cavill@infoclarity.com.au>
To: <sqr-users@sqrug.org>
Subject: RE: [sqr-users] Weird problem with load-lookup
Date: Fri, 16 Jan 2004 21:19:35 +1100
Reply-To: sqr-users@sqrug.org

Hi Denise,
you should try the exact select that the load-lookup is trying:
begin-select loops=9999
file#  (1,1,10)
substr(datacontrol,4,1)  ()
 from reports.v_employee@pay4win
      where status in ('A','L')
end-select

and see what happens.
Steve.

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users