4gl Quesions (EASY, I hope...)
Posted in 1996
I have a couple of "simple" 4gl questions for the gurus out there...
1. If a user enters in a table name on a form ( into a variable called cTableName ),
how can I do the following:
LOAD FROM "converted.unl" INSERT INTO cTableName
Informix tells me that the table cTableName does not exist.
2. How do you create a table in 4gl. I have a "basic" table setup in my system. I have
a menu item that allows the user to "clone" the table. When they select this item,
I do the following:
LET cSQL = "CREATE TABLE ", cTable CLIPPED,
"(",
"column1 char(2),
" ..."
")"
PREPARE goSQL FROM cSQL
EXECUTE goSQL
The code works. The table is created. It shows up in Systables. It shows up in ISQL in the
big list of tables. However, I cannot access it. I get the error: Table not in database.
HELP!!!!
3. If I call a pop-up window and populate it with display array....the cursor flashes next to the
first letter of the currently selected row. This is not visually appealing. I would like to
show the current row in reverse. How is this done?
4. If I have 2 networked systems, running I-Net, How can I copy rows from one to the other.
FOREACH loses the cursor position. The only thing I've been able to do is to unload a file,
rcp it to the other system and run an rcmd to load it to the correct table. This method sucks.
is there a better way.
TIA,
John Cokos