I have a csv file, I'm trying to import it with the LOAD command. However, this file has asmash kartsheader. How do I import the file without importing the first line, which is the header?

If you are trying to import a CSV file with a header using the LOAD command, you can use the IGNORE keyword to skip the first line of the file. Here’s an example:

LOAD DATA INFILE 'filename.csv'
INTO TABLE tablename
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ROWS;

The IGNORE 1 ROWS statement tells MySQL to skip the first row of the file, which is the header. This will allow you to import the data from the CSV file without including the header row.

LOAD DATA INFILE works only for mysql.
We work with postgresql, sql server, informix and oracle

I had the same problem in Genero BDL 4.01.06. happy wheels

The message "Error calling docXML.loadfromstring" has been recognized as an error. I question whether readXmlRequest() is a preferable choice to readFormEncodedRequest in the case where the input is an XML document rather than a key-value dataset. eggy car

[Genero Enterprise 4.01 Maintenance Release :Genero Browser Client 4.01.21]

Genero Enterprise 4.01 Maintenance Release : Genero Browser Client 4.01.21

Four Js is pleased to announce a Maintenance Release of Genero Browser Client 4.01.21.

What's new ...

• The Home page has been simplified.
• Some variables from the application launcher have been removed.
• Rows in a TABLE with FLIPPED attribute or in a SCROLLGRID with WANTFIXEDPAGESIZE=NO can be rendered as cards when the rowAspect style attribute is set to "card".
• GBC now supports the "position" presentation style attribute at the toolbar level. It can be used to display toolbars individually at the top or bottom of the window, in the chromebar, or to hide the toolbar completely.
• For clarity and to be consistent with the naming convention chosen for toolBar (instead of toolbar), some CSS classes have been modified.

Please refer to see  https://4js.com/online_documentation/fjs-gbc-manual-html/index.html#gbc-topics/gbc_whatsnew_40121.html


This version also includes the following bug fixes: https://4js.com/support/issue/GBC/4.01.21


It is now downloadable from the website: https://4js.com/download/products/.


All Four Js Genero customers under maintenance have free access to the new release.

Best regards,

Four Js Development Tools

Thanks Olivier,

Useful information indeed.
We will run some experiments and see how we can cleanly terminate the entire process tree of our 4GL app (which itself has called many sub-processes, which also need to be cleanly terminated).

Hi François,

Does the following "Ask-Reuben" topics answer your questions?

https://4js.com/ask-reuben/ig-74/

https://4js.com/ask-reuben/ig-176/

Olivier

We have  been reading the "Front-end termination" page of the manual (https://4js.com/online_documentation/fjs-fgl-manual-html/#fgl-topics/c_fgl_programs_010.html) so we mostly understand how 4GL generally handles that

Sorry for my typing, I am not used to not being able to correct a post.

When the Google Chrome browser is killed (using the Windows task manager), the 4GL code keeps running (until  some sort of GAS timeout, where the VM gets killed).

Is there a way to get the 4GL pre-notified before the VM gets killed by the GAS?

I meant GBC, not GWC.

When we use:

OPTIONS ON  CLOSE APPLICATION CALL end_app

upon closing the closing of the entire Google Chrome window, Google Chrome closes immediately, but the 4GL code keeps running until the end_app() function completes.

This is mostly good, but is there a way to hold off Google Chrome closing until the 4GL completes?

Also when the tab is closed, could the same holding off be implemented?

Hi,

Targeting Genero 4.01 GWC via GAS.

When writing a simple Hello World GUI with only 1 label ("Hello World"), how can the Google Chrome window.closed / window.closing event ('beforeunload' event) be trapped to tell the 4GL that the web client is closing?

Is there a way to add the following javascript to the web page served by the GAS?

<script type="text/javascript">
window.addEventListener('beforeunload', function (e) {
  // Tell the 4GL program that Google Chrome is closing
});
</script>