Re: INFORMIX 4GL MASTER DETAIL

calyanram@xxxxxxxxxxx wrote: 
I AM HAVING DETAIL SCREEN LIKE THIS
NO       DATE   S  NAME    RES.DT  STATUS
10001 12/12/98 1  SCOTT   12/01/98   y
10002 12/12/98 2  NEILL   12/02/98   Y

DATABASE NAME
AUSS

CONTACT NAME
SCOTT


WHENEVER I MOVE THE CURSOR IN THE DETAIL UPPER PART
IT SHOULD AUOTOMATTICALLLY FETCH THE RECORD AT THE BOTTOM

AFTER COMING TO THE ROW I  HAVE TO HIT RETURN OR I HAVE TO WRITE
THE CODE IN ON KEY AFTER DISPLAY.

IS THERE ANY WAY TO WRITE A CODE TO DO AUTO SCROLLING . WHEN I ENTERS
ROW IT SHOWD THE CONCERNED DB NAME AND CON NAME


Please don't shout.

Are you using a DISPLAY ARRAY or an INPUT ARRAY? Which version of I4GL? Which platform?

Simply moving the cursor won't automatically fetch and display anything. However, you can use the BEFORE ROW clause of an INPUT ARRAY to look up the data for the database and contact names, and display those. Offhand, I don't recall whether DISPLAY ARRAY has a BEFORE ROW or equivalent clause - I think it does, in which case you can do the same there, too.

If you want to get fancy, you can consider treating the database and contact names in a separate screen array (of dimension 1) and using SCROLL UP or SCROLL DOWN to navigate them. This would allow you to establish the data once - before entering the main INPUT ARRAY or DISPLAY ARRAY - and then scroll the secondary array in parallel. The SCROLL statement is one of the least used statements in I4GL. I'm also wondering if there's a problem that it doesn't replace the data that it scrolls out, so it is only really useful in multi-row arrays on the screen. RTM to find out, but I would not use it myself - I would simply display the correct data to the simple screen record (consisting of database name and contact name).


--
Jonathan Leffler                   #include <disclaimer.h>
Email: jleffler@xxxxxxxxxxxxx, jleffler@xxxxxxxxxx
Guardian of DBD::Informix v2005.02 -- http://dbi.perl.org/
.

Relevant Pages

  • Re: Bit surprised there arent more virtual listbox controls/code available
    ... How about stick the MIDI data into a recordset then as a listbox can only ... would scroll the list as if it was a normal full listbox. ... You mean, display, say, 20 rows in the list box (e.g events 0 through ... processing would be standard database stuff. ...
    (microsoft.public.vb.general.discussion)
  • Re: MFC MDI for binary db
    ... i think the 'right' method to do this is to have an array of views. ... be used to display different sections of the same document in copies of the ... > structure represent one record of a database. ... > selected record. ...
    (microsoft.public.vc.mfc)
  • Cannot locate dynamically declared array
    ... database and display them on a web application, ... field names from the database alright. ... the field names as elements of an array, ... Does that mean eval cannot be used to dynamically declare an array? ...
    (comp.lang.perl.misc)
  • Re: Cannot locate dynamically declared array
    ... database and display them on a web application, and when a user selects one table, display all its fields and the corresponding values on the web. ... I'm doing it in Perl. ... I can get the table names and field names from the database alright. ... I thought the eval will actually declare @USER array. ...
    (comp.lang.perl.misc)
  • display array data in a smarty tpl file
    ... i am having an issue with displaying the array that gets inserted into the data base some background on what i have. ... I start off with a regular form and pass the info as an array over to the php and insert it into the database as a string with the following ... this will actually display array array and if i do not use the unserialize function i get the ...
    (alt.php)