Unix Technical Forum

Re: Display Array

This is a discussion on Re: Display Array within the Informix forums, part of the Database Server Software category; --> Prateek.Jain@ril.com wrote: > With the use of logic before row and next field i could work > in that ...


Go Back   Unix Technical Forum > Database Server Software > Informix

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 04-20-2008, 08:42 AM
Marco Greco
 
Posts: n/a
Default Re: Display Array


Prateek.Jain@ril.com wrote:
> With the use of logic before row and next field i could work
> in that default row which is one . but i have to get out from the
> current default row which is one
> by default
> Is there any way to set the content of arr_curr or scr_line function
> which are by default one .
> so that some way can be established


God! you serve people a solution on a silver tray, and that's not enough
OK, there we go then:
- add a dummy invisible noentry field to your array, call it dummy
- let's say that your required row in the array is reqrow
- in the BEFORE ROW clause do something like

BEFORE ROW
IF (arr_curr()<reqrow)
THEN
NEXT FIELD dummy
END IF

remember to do some housekeeping with reqrow, so not to drive your input array mad
in those cases in which you don't want to jump to a different row. Or do I have to
explain how to do this too?

> Regards,
> Prateek Jain
> Reliance Industries Limited
> (M) - 09426387793
> (O) - 079 - 30215010 (Ext - 383)


Don't post HTML
Don't top post
Be a bit more grateful when you receive free help


> Inactive hide details for Marco Greco <marco@4glworks.com>Marco Greco
> <marco@4glworks.com>
>
>
>
>
> Marco Greco <marco@4glworks.com>
>
> 07/08/05 04:00 PM
>
>
>
> To: Prateek.Jain@ril.com
> cc: informix-list@iiug.org
> Subject: Re: Display Array
>
>
>
> Colin Bull wrote:
> >
> >
> > Prateek.Jain@ril.com wrote
> >
> > You will probably be ignored if you send in HTML. Plain text works
> > better for everyone.
> >
> >
> >
> > Can anyone tell how to control the cursor movement in input
> > array
> > and display array statement.
> > The cursor by default is at first position . I want to be as per
> > my requirement
> > is there any way.
> >
> > What operating system
> > What database and version
> > What client
> >
> > Give us a clue
> >
> > Colin Bull

>
> What, none of the old timers can give an answer to that?
> I'll give you a clue then
> - INPUT ARRAY: a skillful combination of BEFORE ROW and NEXT FIELD is
> what you
> need to achieve the functionality you require
> - DISPLAY ARRAY: nope can't be done, but you can use INPUT ARRAY instead


--
Ciao,
Marco
__________________________________________________ ____________________________
Marco Greco /UK /IBM Standard disclaimers apply!

Informix faq http://www.iiug.org/techinfo/faq/informix.htm
4glworks http://www.4glworks.com
Informix on Linux http://www.4glworks.com/ifmxlinux.htm

sending to informix-list
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 10:24 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com