Subscribe for automatic updates: RSS icon RSS

Login icon Sign in for full access | Help icon Help
Advanced search

Pages: [1] 2 3 ... 10
 1 
 on: Today at 03:14:22 pm 
Started by Keshen P. - Last post by Keshen P.
Hi guys,

We are constantly being asked to produce BI Reports with pivot tables and have it output into Excel. Has anyone developed a BI tool to work with Genero BDL ?

 2 
 on: Today at 11:54:33 am 
Started by Sean H. - Last post by Sebastien F.
Hello,

Please always provide environment details (Genero and DB engine type/version), FGLPROFILE settings and provide sample code (with SQL DDL so we can see the table structure)

Inserting a specific value into a SERIAL/BIGSERIAL and having the DB engine fix the underlying serial generator is an Informix feature.
PostgreSQL does not reset the underlying sequence when doing this.

The following "fix" (workaround) should solve your problem:
https://4js.com/support/issue/?id=FGL-05500#startissue

Ideally, you should use SEQUENCEs to produce the new auto-incremented columns yourself, so you can use it as regular value in the INSERT, on a table defining a regular INTEGER or BIGINT column.

https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_sql_programming_076.html

Seb

 3 
 on: Today at 11:01:33 am 
Started by Sean H. - Last post by Sean H.
Hello everyone,

I was wondering if it is possible to allow inserts into a Serial Column under certain conditions where the value is known (specifically PostgreSQL).

Under most cases I am doing an insert like the below, which works fine:

define
   sql string,
   col2 like sometable.col2,
   col3 like sometable.col3

let sql = "insert into sometable values(default, ?, ?)"
prepare generalInsert from sql

let col2 = "Col 2"
let col3 = "Col 3"
execute generalInsert using col2, col3


The issue is when trying to do inserts into the same table under certain conditions when the Serial Value is known:

define
   sql string,
   col1 like somtable.col1, # serial column
   col2 like sometable.col2,
   col3 like sometable.col3

let sql = "insert into sometable values(?, ?, ?)"
prepare generalInsert from sql

let col1 = 1
let col2 = "Col 2"
let col3 = "Col 3"
execute generalInsert using col1, col2, col3


What's strange is that if the sql's execute is wrapped in a try catch then it does do the insert but is raising an error:

currval of sequence "sq_sometable" is not yet defined in this session

 4 
 on: June 28, 2022, 03:05:06 pm 
Started by Laurent G. - Last post by Laurent G.
Second post is the corrected one with the error listed. Sorry about that!

 5 
 on: June 28, 2022, 03:03:12 pm 
Started by Laurent G. - Last post by Laurent G.
Hi,

I'm sharing this in case in can help someone else. Best,

Laurent

----

Environment:
Windows 10 64bit

λ nvm use 16.15.1 (required for GBC 1.00.61)
Now using node v16.15.1 (64-bit)

λ node -v
v16.15.1

λ npm -v
8.11.0

λ nvm -v | head -2
Running version 1.1.7

Error:
λ npm install
npm ERR! Unexpected token '.'

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\LaurentGalais\AppData\Local\npm-cache\_logs\2022-06-14T17_58_40_210Z-debug-0.log

Solution:

The key to success was to update nvm to 1.1.9 following the steps described here https://tecadmin.net/install-nodejs-with-nvm-on-windows/
The github project is located here https://github.com/coreybutler/nvm-windows/releases
Note that I had to run nvm-setup.exe as admin
Consequently, I had to run 'nvm install 16.15.0' (did also 'nvm uninstall 16.15.0') + 'nvm use 16.15.0' in a command prompt with Admin privileges
Every other subsequent documented commands could be run with standard user privileges
Finally the GBC dev project was polluted from the previous test, so I had to wipe it and unzipping 'fresh' again from the downloaded package
Note also that I patched npm + npm.cmd to avoid the -g / global warning and now 'npm -v' runs without warning. However, npm run install-gbc still displays the warnings ... not sure why (didn't spend much time investigating, this is more of an FYI at this point since everything else works)

 6 
 on: June 28, 2022, 02:59:10 pm 
Started by Laurent G. - Last post by Laurent G.
Hi,

I'm sharing this in case in can help someone else. Best,

Laurent

----

Environment:
Windows 10 64bit

λ nvm use 16.15.1 (required for GBC 1.00.61)
Now using node v16.15.1 (64-bit)

λ node -v
v16.15.1

λ npm -v
8.11.0

λ nvm -v | head -2
Running version 1.1.7

Error:

Solution:

The key to success was to update nvm to 1.1.9 following the steps described here https://tecadmin.net/install-nodejs-with-nvm-on-windows/
The github project is located here https://github.com/coreybutler/nvm-windows/releases
Note that I had to run nvm-setup.exe as admin
Consequently, I had to run 'nvm install 16.15.0' (did also 'nvm uninstall 16.15.0') + 'nvm use 16.15.0' in a command prompt with Admin privileges
Every other subsequent documented commands could be run with standard user privileges
Finally the GBC dev project was polluted from the previous test, so I had to wipe it and unzipping 'fresh' again from the downloaded package
Note also that I patched npm + npm.cmd to avoid the -g / global warning and now 'npm -v' runs without warning. However, npm run install-gbc still displays the warnings ... not sure why (didn't spend much time investigating, this is more of an FYI at this point since everything else works)[/li][/list]

 7 
 on: June 28, 2022, 04:59:08 am 
Started by Reuben B. - Last post by Reuben B.
Sound can be played by Genero applications through the playSound front-call.  Like images, the key point is to get the sound file from the back-end to the front-end.  Your sound file will typically be bundled in with the rest of your application files on the back-end server but needs to be on the front-end server in order for the end user to hear the sound.

To learn more about the playing of sound in a Genero application, read https://4js.com/ask-reuben/ig-131/

 8 
 on: June 28, 2022, 04:57:21 am 
Started by Reuben B. - Last post by Reuben B.
When transitioning to Universal Rendering, one of the questions asked is what is the panel on the left hand side that appears when my Genero application launches another Genero application?  This is known as the Application List or the Sidebar.  This is needed because if there are two or more Genero applications running in the same browser tab, the user needs a way to toggle between these applications.
 
Similarly the Window List in the Chromebar allows the user to view other windows in the application.
 
To learn more about the Application List (Sidebar), and also the Window List, read https://4js.com/ask-reuben/ig-130/

 9 
 on: June 28, 2022, 04:55:34 am 
Started by Reuben B. - Last post by Reuben B.
In transforming from Informix-4gl to Genero, there is a focus on the user interface.  That includes using GUI widgets (COMBOBOX, DATEEDIT etc)  and arranging the fields on a form into containers (TABLE, SCROLLGRID, GROUP, FOLDER etc) , that is transforming the form file.  The user typically still experiences the same combination of dialog instructions (MENU, PROMPT, INPUT, MENU, CONSTRUCT, DISPLAY ARRAY, INPUT ARRAY).
 
In a GUI environment the user expects to be able to click or touch fields they can see on the screen.  These dialog instructions may only apply for a subset of the fields on the screen and it is a source of frustration for users that they cannot click on these other fields on the screen, typically to go back and correct something they just entered in the previous dialog.
 
Multiple Dialog was introduced in Genero 2.10 and consisted of a keyword DIALOG that allowed the developer to combine multiple INPUT, CONSTRUCT, DISPLAY ARRAY, INPUT ARRAY statements together in a single dialog.  For a user this meant that all the fields in the various sub-dialogs were active and the user could now click on any of these fields.  This gives the user a similar user experience to other GUI applications.
 
In this article I identified a number of patterns that have been identified as potential uses of Multiple Dialog.
 
To learn more about Multiple Dialog read https://4js.com/ask-reuben/ig-129/
 

 10 
 on: June 27, 2022, 05:33:38 pm 
Started by francesco f. - Last post by francesco f.
Thanks Seb,
when we are done with the setup i'm going to post the solution just in case someone else stumble on the same problem

Pages: [1] 2 3 ... 10
Powered by SMF 1.1.21 | SMF © 2015, Simple Machines