[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
- Subject: RE: [sqr-users] Weird problem with load-lookup
- From: "White, Denise" <DEWhite@vicr.com>
- Date: Fri, 16 Jan 2004 09:08:56 -0500
- List-id: This list is for discussion about the SQR database reporting language from Hyperion. <sqr-users.sqrug.org>
- Thread-index: AcPcOYI/eBrfbQhsRaq1sre09H+BrQ==
- Thread-topic: 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