1. Andres Slachevsky
  2. PowerBuilder
  3. Thursday, 21 March 2019 14:18 PM

Hello All,

I have a DW with column names like :
Column1, FirstName,LastName

when i create the json file using exportJson

the Json is generated with names in lowercase 

column1,firstname,lastname

and that cause a problem when i try to import it in the targer application (non PB)

if i edit the names to keep the UpperCase then it import works.

any way i can solve it or i must use the JsonParser object?

Robert Purser Accepted Answer Pending Moderation
  1. Thursday, 16 January 2020 17:20 PM
  2. PowerBuilder
  3. # 1
0
Votes
Undo

I'm having the same problem but for what I want to do I would have dozens of Datawindows and hundreds of column names. Is there no way to have mixed-case column names in a Datawindow?

Comment
There are no comments made yet.
Kevin Ridley Accepted Answer Pending Moderation
  1. Thursday, 21 March 2019 17:04 PM
  2. PowerBuilder
  3. # 2
0
Votes
Undo

Not ideal but if it's only 1 dw and you know the column names, you can just write a find/replace utility to replace the lowercase for each column, since JSON is really just a string.

Comment
FYI the pfc has a great string replace function. Check out pfc_n_cst_string.of_globalreplacenew it should have everything you need. You can put "old" and "new" values into arrays and loop through calling the replace function. Also looks like you can just copy the function right from the pfc without all the usual pfc "hooks".
  1. Kevin Ridley
  2. Thursday, 21 March 2019 17:30 PM
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.