I'm trying to do a modify to pass variables from an html page. The fex then uses a modify using freeform to update the db2 table. However I'm getting the following error for each of the fields.
(FOC705) THERE HAS BEEN AN INVALID USE OF A TEXT FIELD IN FIXFORM
Any suggestions?This message has been edited. Last edited by: Kerry,
WebFOCUS 8.0.07 and 8.2.01M UNIX, WINDOWS, ORACLE PDF, CSV, Excel, TXT, XML, HTML
January 09, 2013, 02:13 PM
Danny-SRL
Tom,
If I remember right, a text (FORMAT=TXn) field has to be the last in the list of fields.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
January 09, 2013, 03:34 PM
Waz
Yes, I think I remember that as well.
Can you post the code and master ?
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 10, 2013, 08:35 AM
TomS.
Thanks, that appears to be the case. The error message is present for all fields after the first TXn field.
However, I have multiple text fields...can there be more than one? If so should they all be listed at the end?
I would suggest using a second master that has the TX fields defined as A295.
Waz...
Prod:
WebFOCUS 7.6.10/8.1.04
Upgrade:
WebFOCUS 8.2.07
OS:
Linux
Outputs:
HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!
January 11, 2013, 03:35 AM
Danny-SRL
Tom (Flyn), If Tom(S) says he is using FREEFORM, this means that his data is comma-delimited. Are you suggesting he switches to FIXFORM? Also, did you ever try a variable-length input with MODIFY?
Waz, This might work. I hope that SQLDS would know how to convert a fixed length field into a variable one.
Good luck to all...
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
January 14, 2013, 09:46 AM
TomS.
Sorry for the delay, I was pulled onto another project...So, moving all the tx fields to the end of the FREEFORM cleared up the INVALID USE OF A TEXT FIELD error. However, now nothing is being passed and I'm getting the following result
I tried doing multiple MODIFY's and get the same result.
Waz, how can I create a second master for the table?This message has been edited. Last edited by: TomS.,
WebFOCUS 8.0.07 and 8.2.01M UNIX, WINDOWS, ORACLE PDF, CSV, Excel, TXT, XML, HTML
January 14, 2013, 01:23 PM
TomS.
I tried leaving out some of the TX fields so there was only one at the end of the MODIFY and it came back with this error.
Not sure where to go from here...
(FOC14069) SYNTAX ERROR ON LINE 8 AT 'T24' -- Data type not found (FOC14112) STATEMENT WAS NOT BOUND (FOC1400) SQLCODE IS 14069 (HEX: 000036F5) : SYNTAX ERROR ON LINE 8 AT 'T24' -- Data type not found (FOC1740) EXECUTE ERROR : MYTABLE 0 TRANSACTIONS: TOTAL = 1 ACCEPTED= 1 REJECTED= 0 SEGMENTS: INPUT = 0 UPDATED = 0 DELETED = 0
WebFOCUS 8.0.07 and 8.2.01M UNIX, WINDOWS, ORACLE PDF, CSV, Excel, TXT, XML, HTML
January 14, 2013, 03:11 PM
Danny-SRL
Tom(S),
Copy your MASTER and ACX files. Give them another name, e.g. NEWTABLE In your master replace all TXs with A295V. Run your program replacing the filename in the MODIFY command. See if this works.
Daniel In Focus since 1982 wf 8.202M/Win10/IIS/SSA - WrapApp Front End for WF
January 18, 2013, 01:16 PM
TomS.
My delay in responding is due to me being pulled in a few different directions...
Anyways, I've tried editing the master, creating a new master, switching to fixform, and removing all but one of the tx fields. All to no prevail.
It turns out that we are making some changes to the information being collected so I'll be creating a new DB with less fields. This new DB wont have any tx fields so i'm hoping that will clear up the issue.
Thank you all for your help. -Tom
WebFOCUS 8.0.07 and 8.2.01M UNIX, WINDOWS, ORACLE PDF, CSV, Excel, TXT, XML, HTML