Questions tagged [4gl]

A programming language with a specific domain intended, such as business or science, in which the basic units are of a higher abstraction or power.

Following on the heels of 3GL languages such as C, COBOL and Pascal, the promise of the 4GL was to solve the problem at a higher level of abstraction. A 4GL would be designed with a specific problem domain in mind, such as commerce.

Many 4GLs did not go on to fulfill their initial promise, as 3GLs continued to expand in power and scope, and standardized libraries became more pervasive. The line today between a 3GL and a 4GL is blurry; most modern languages could be considered 4GLs.

Simply tagging your post should be avoided. It's better to tag your post with a tag of your specific 4GL-language. Or at least add the language tag to the 4GL-tag.

Examples:

Informix 4gl can be tagged .

Progress 4GL/ABL -->

Ingres -->

etc.

175 questions
1
vote
2 answers

After updating the record set the Screen must update

In informix 4gl(genero 4JS) how can I refresh the screen after updating the record set in the database? Right now I can only update the record but the screen is not updating. I think I am missing something. The following set is working fine. after…
MJJ3
  • 127
  • 1
  • 12
1
vote
2 answers

Informix 4GL after field

Hi I want to add an after field logic, I have 4 check boxes (check1, check2, check3 and check4). When I put a check mark on either check2, check3 and check4, I want to put check mark on check1 automatically. Any idea. Thank you.
MJJ3
  • 127
  • 1
  • 12
1
vote
3 answers

How can I order a selection by the results of a function (sum)?

I have a table with a bunch of columns. Three columns are integers, and are labeled consumption, consumption2, and consumption3. I would like to select each full row of the table, but order the selection by the sum of the three consumption fields…
octopusgrabbus
  • 10,555
  • 15
  • 68
  • 131
1
vote
2 answers

how can I map the jdbc resultSet to user defined class generally?

I have some problems that do the same function from 4gl to java. There are some brief explanation to 4gl code. First,AFPOPF1 is table,and IO_AFPOPF1 is variable that store contents of AFPOPF1. Excuting WK_QUERY and store row result to IO_AFPOPF1.*…
user1774492
  • 71
  • 2
  • 3
1
vote
2 answers

temp table creation in informix 4GL SE

How should I create and populate data in a temp table? then how can I print data retrieved on temp table? I saw example like this; but no further help. SO I need some help. SELECT DISTINCT * FROM Table INTO TEMP Temp1;
MJJ3
  • 127
  • 1
  • 12
1
vote
2 answers

FOREACH I4GL SE

I am trying to get the customers last name, first name - dob, I am getting all but everything printing the same place, any idea? declare n_curs cursor for select unique pin,surname,given1,given2,dob from crcharge where …
MJJ3
  • 127
  • 1
  • 12
1
vote
1 answer

Internal error and statement error- I4GL

When I run the program (Informix 4GL SE) I am getting the following error. IS there anybody know the solution? FORMS statement error number -6327. Internal error in the run time library file Report.c(933):
MJJ3
  • 127
  • 1
  • 12
1
vote
1 answer

I4GL Loop query

I am trying to solve this issue for last couple of days, but no idea how to do it. What I am trying is to get 3 records from a column table. If any Informix 4GL gurus are out there I need some help please. declare s_curs cursor for …
MJJ3
  • 127
  • 1
  • 12
1
vote
2 answers

Informix 4GL, how to print?

I have a column (chgkey) with 17 rows of record. How can I print first 3 records in the same line (like, raw1, raw2, raw3). Now I can print the raw1 without any problem. Any help would be appreciated. below is my code. let rpt.chgkey = null …
MJJ3
  • 127
  • 1
  • 12
1
vote
1 answer

What does this SQL statement do in this Informix 4GL code?

I am missing something. Please can someone tell me how this works? let rpt.chgkey = null select cuschage.chgkey from cuschage where cuschage.cuschnum in (select shtwrd_no from crbookid where crbookid.book_no = rpt.book_no and…
MJJ3
  • 127
  • 1
  • 12
1
vote
1 answer

am pm display in Informix 4GL

How can I display am or PM with a time display in informix 4GL. In my database the field called crttime_a_p and stores for am "A" and for pm "P". How can I display this in my application as "AM" or "PM". Any help would be appreciated. Thank you.
MJJ3
  • 127
  • 1
  • 12
1
vote
2 answers

form-only lookup

How can I create a form-only look up in Informix 4GL? I am using form painter plus the informix SE. Any help would be appreciated. I tried to create the form but the field is empty while selecting the choice. I think I am missing the relation or…
MJJ3
  • 127
  • 1
  • 12
1
vote
1 answer

Enforcing a minimum character length on a form field in I4GL

How can I add character length in a field on Informix 4GL. I have a description column, and I want to enforce a minimum length 10 characters in this field; if the entered string is less than 10 characters, send the user back to re-enter the data.
MJJ3
  • 127
  • 1
  • 12
1
vote
1 answer

Informix 4GL and triggers

I want a simple SQL (trigger) for duplicate checking. My table name is test1 with 2 columns, code and sname. Before inserting a new record, check if the record already exists: if it does, generate an error and do not insert; if it does not, let the…
MJJ3
  • 127
  • 1
  • 12
1
vote
2 answers

Append results of a query in a single line

I am unloading the results of a query to a file. I need the result records to be displayed in a single line. For example, unload to file.unl select col from table where col = "test"; The resulting file.unl would be like test| test| .... test| But…
C0de_Hard
  • 72
  • 1
  • 9