Insert into a TEXT column in R4GL (RDS)

[eferreyra]

Hello, simple question, in Informix 4GL RDS, no C functions.

I have some text in a VARCHAR variable and need to insert the text into a column of type: TEXT ...

How i do that in plain R4GL or with a PREPARE ?

"INFORMIX 11".7 and "IBM INFORMIX-4GL Version 7.50.FC1"

Thanks

[armsiee]

Post by eferreyra
Hello, simple question, in Informix 4GL RDS, no C functions.
I have some text in a VARCHAR variable and need to insert the text into a column of type: TEXT ...
How i do that in plain R4GL or with a PREPARE ?
"INFORMIX 11".7 and "IBM INFORMIX-4GL Version 7.50.FC1"
Thanks

INSERT or UPDATE?

Insert puts a new run in the database

LET mySQL="INSERT INTO [TABLE] ([COLUMNS]) VALUES (?,?,?,..)"
PREPARE pr_insert FROM mySQL
EXECUTE pr_insert USING [VARIABLES]

Update; updates an existing row.

LET mySQL="UPDATE [TABLE] SET [COLUMN] = ? WHERE [CONDITION]"
PREPARE pr_update FROM mySQL USING [VARIABLE]
EXECUTE pr_update USING [VARIABLE]