Re: Find sql behind a view

[Allen Cunningham <allen.cunningham@SONOMA.EDU>]

Thanks Jamie,

Someone told me about that about a year ago, but I didn't write it down, and
forgot.

Allen

-----Original Message-----
From: Discussion of SQR, Brio Software's database reporting language
[mailto:SQR-USERS@list.iex.net]On Behalf Of Jamie Allen
Sent: Monday, March 18, 2002 4:47 PM
To: SQR-USERS@list.iex.net
Subject: Re: Find sql behind a view


Hi Allen,

I'm assuming that the view PS_VNDR_COPYB_VW is the prompt table you wish to
see.  To access the view definition for this record select the record
properties (ALT+ENTER) from tke record display and go to the type tab.

Regards,

Jamie Allen
Analyst Programmer
Century Yuasa Batteries
49 - 65 Cobalt Street
Carole Park QLD 4300
Australia
Ph (07) 3361 6134

-----Original Message-----
From: Allen Cunningham [mailto:allen.cunningham@SONOMA.EDU]
Sent: Tuesday, 19 March 2002 10:30
To: SQR-USERS@list.iex.net
Subject: Find sql behind a view


I am trying to find the criteria used to fill a prompt table with vendors on
the RUN_1099_COPYB_RPT panel. A certain vendor should be in the prompt table
and is not, and I need to find out why he is not in the prompt table. If I
have the name of the view (PS_VNDR_COPYB_VW) what is a good debug technique
to find what the criteria is to load the table. I did a sql trace on the
panel and I see a SQL select being done that selects all vendors from the
view so the user can pick one, but need to know whay my vendor did not get
into the table.

Using SQR 4.3.4
PS 7.5 Financials

*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
Allen Cunningham
Sonoma State University
Administrative Information Systems
allen.cunningham@sonoma.edu
ph 707.664.2052
fx 707.664.2505
*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*