Re: Fwd: VDC Desktop
Alain Siverly <[email protected]>
| Newsgroups | gmane.comp.lang.4gl.aubit.general |
|---|---|
| Message-ID | <[email protected]> |
Hi,
the VDC stores the last sort on columns of Display Arrays. With
the right mouse key ("reset sort order" on the pulldown menu) one
can bring the sort to a neutral state again.
Cheers
Alain
VENTAS AG
Web: www.ventas.de
Am 18.05.14 17:17, schrieb Mike Aubury:
Alain - is there any built in ordering on a VDC DISPLAY ARRAY ?
---------- Forwarded message
----------
From: Michael Krauss <[email protected] >
Date: 18 May 2014 16:08
Subject: Re: [Aubit4gl-discuss] VDC Desktop
To: Mike Aubury <[email protected] >
error 6882 is in VDC
example for order by:
function kurs_help(f_isin)
#------------------------------------------------------------------------------
DEFINE d_cnt, idx,total_pa,sc_curr,
da,erf integer,
f_isin linke kurse_d.isin,
p_kurse_d2 array[8424] of record
datum like kurse_d.datum,
open like kurse_d.open,
high like kurse_d.high,
low like kurse_d.low,
close like kurse_d.close,
volume like kurse_d.volume,
adj_close like kurse_d.adj_close
end record
declare kurs_curs cursor for
SELECT datum,kurse_d.open,high,low,kurse_d.close, volume,
adj_close
FROM kurse_d
where kurse_d.isin = f_isin
order by datum desc
let d_cnt = 1
foreach kurs_curs into p_kurse_d2[d_cnt].*
let d_cnt = d_cnt + 1
if d_cnt > 8424 then
exit foreach
end if
end foreach
let d_cnt = d_cnt - 1
if d_cnt = 0 then
return "N"
end if
open WINDOW w_kurse WITH FORM "kurs_liste"
call set_count(d_cnt)
display array p_kurse_d2 to s_kurse_d2.*
before row
let sc_curr = scr_line()
let idx = arr_curr()
display p_kurse_d2[idx].* to s_kurse_d2[sc_curr].*
on key(return)
exit display
after row
let sc_curr = scr_line()
let idx = arr_curr()
display p_kurse_d2[idx].* to s_kurse_d2[sc_curr].*
end display
CLOSE WINDOW w_kurse
return "J"
end function
Am Sonntag, den 18.05.2014, 16:00 +0100 schrieb Mike Aubury:
> The "6882 Speicherzugriffsfehler" -
is that in the VDC - or the 4gl
> side ?
>
>
> For the ORDER BY - is this on a DISPLAY ARRAY/INPUT
ARRAY ?
>
>
> On 18 May 2014 15:54, Michael Krauss <[email protected] >
wrote:
>
> Error no for array record > 8425 is:
> 6882 Speicherzugriffsfehler
>
> This program runs also in aubit4gl and i
use many "order by"
> sort
> functions. Everything is fine.
>
> With change to VDC "order by" function is
out of order.
>
>
>
>
>
> Am Sonntag, den 18.05.2014, 15:36 +0100
schrieb Mike Aubury:
> > The ORDER BY is a function of the 4GL
side - not the UI side
> - can you
> > provide an example that doesn't work ?
> >
> >
> > There is no (sensible) upper limit on
the size of an array
> within
> > Aubit4GL - it will be the amount of
memory you have/c
> compiler can
> > handle/INT_MAX/LONG_MAX.
> > Thats not to say theres no limit on
the amount of data you
> could (for
> > example) display using a DISPLAY ARRAY
within the VDC.
> > I'm not sure if this is what you are
saying ? What error are
> you
> > getting ?
> >
> >
> >
> >
> >
> >
> >
> >
> > On 18 May 2014 15:27, Michael Krauss
<[email protected] >
> wrote:
> > Hi all,
> >
> > 1) is it correct, that array
record has max size
> limit?
> >
> > p_kurse_d2 array[idx] of
record
> > idx < 8425
> >
> > and
> >
> > 2) select ..order by.. sort
function doesn't work!
> >
> > SELECT datum, open, high,
low, close, volume,
> adj_close
> > FROM kurse_d
> > where kurse_d.isin =
f_isin
> > order by datum desc
> >
> >
> > Michael Krauss
> >
> >
> >
>
------------------------------------------------------------------------------
> > "Accelerate Dev Cycles with
Automated Cross-Browser
> Testing -
> > For FREE
> > Instantly run your Selenium
tests across 300+
> browser/OS
> > combos.
> > Get unparalleled scalability
from the best Selenium
> testing
> > platform available
> > Simple to use. Nothing to
install. Get started now
> for free."
> > http://p.sf.net/sfu/SauceLabs
> >
_______________________________________________
> > Aubit4gl-discuss mailing list
> > [email protected]
> >
> https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss
> >
> >
>
>
>
>
>
------------------------------------------------------------------------------
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.
Get unparalleled scalability from the best Selenium testing platform available
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs
_______________________________________________
Aubit4gl-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/aubit4gl-discuss