Dynamic Array size !

Posted in 1999

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL

nayan jain — Wed, 1 Sep 1999 11:47:20 +0530 (IST) — source: Informix-list mailing list archive (1991-1998)

Hi all, I want to know if the array size in 4GL program can be defined dynamically ? like ... DEFINE p_count INTEGER DEFINE ARRAY gr_cust[p_count] OF RECORD LIKE customer.* with this if i have 5 customer in table the array will be of 5 records. else it can be 1000 tooo... TIA, Nayan Jain ! - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - "A man is incomplete until he is married After that, he is finished. " -- Zsa Zsa Gabor

↪ replying to nayan jain

Art S. Kagel — Wed, 01 Sep 1999 13:16:06 -0400 — source: Informix-list mailing list archive (1991-1998)

No dynamic arrays yet. You can declare a reasonable array and open the cursor used to fill it as a SCROLL cursor and then treat the array as a window into the select set. If the user wants to scroll outside the current window shift some rows around in the array use the FETCH ABSOLUTE to fetch the next partial or full window in that direction. If you write the windowing code carefully you can package it as a generic library function set and reuse it. I have. Art S. Kagel nayan jain wrote: > > Hi all, > > I want to know if the array size in 4GL program can be defined > dynamically ? > > like ... > > DEFINE p_count INTEGER > DEFINE ARRAY gr_cust[p_count] OF RECORD LIKE customer.* > > with this if i have 5 customer in table the array will be of 5 records. > else it can be 1000 tooo... > > TIA, > Nayan Jain ! > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > "A man is incomplete until he is married After that, he is finished. " > -- Zsa Zsa Gabor

↪ replying to nayan jain

Jonathan Leffler — Thu, 02 Sep 1999 22:23:57 -0700 — source: Informix-list mailing list archive (1991-1998)

nayan jain wrote: > I want to know if the array size in 4GL program can be defined > dynamically ? > > like ... > > DEFINE p_count INTEGER > DEFINE ARRAY gr_cust[p_count] OF RECORD LIKE customer.* > > with this if i have 5 customer in table the array will be of 5 > records. else it can be 1000 tooo... No. It has been considered, occasionally, but never implemented. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>

↪ replying to nayan jain

Bernhard Gramberg — Mon, 27 Sep 1999 19:03:19 +0200 — source: Informix-list mailing list archive (1991-1998)

it is all like C. No variable array in C, as well no in 4GL nayan jain schrieb: > Hi all, > > I want to know if the array size in 4GL program can be defined > dynamically ? > > like ... > > DEFINE p_count INTEGER > DEFINE ARRAY gr_cust[p_count] OF RECORD LIKE customer.* > > with this if i have 5 customer in table the array will be of 5 records. > else it can be 1000 tooo... > > TIA, > Nayan Jain ! > > - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - > > "A man is incomplete until he is married After that, he is finished. " > -- Zsa Zsa Gabor

↪ replying to Bernhard Gramberg

Douglas Wilson — Mon, 27 Sep 1999 21:55:29 GMT — source: Informix-list mailing list archive (1991-1998)

Another possibility depending on your needs, is perl. Arrays will grow to whatever will fit in memory. On Mon, 27 Sep 1999 19:03:19 +0200, Bernhard Gramberg <mail@gramberg.de> wrote: >it is all like C. No variable array in C, >as well no in 4GL > >nayan jain schrieb: > >> Hi all, >> >> I want to know if the array size in 4GL program can be defined >> dynamically ? >> >> like ... >> >> DEFINE p_count INTEGER >> DEFINE ARRAY gr_cust[p_count] OF RECORD LIKE customer.* >> >> with this if i have 5 customer in table the array will be of 5 records. >> else it can be 1000 tooo... >> >> TIA, >> Nayan Jain ! >> >> - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - >> >> "A man is incomplete until he is married After that, he is finished. " >> -- Zsa Zsa Gabor >

Glossary

4GL (Informix-4GL)