Hello Chris,



If I change the SQL statement in the SQLpreview event nothing is returned anymore. Probably the only solotion is to except that we need to have a copy of the dw's to handle the columns we want in the json. Also checked if it was possible to delete a item in the json but could not find anything.



Thanks

Eric

Hi Eric;

Yes, if the dynamic SQL changes do not meeting your processing challenge, then multiple tailored DWO's would be the next best thing.

Regards ... Chris

Great idea. But, string handling is not the best part of Powerbuilder. Replacing 3 strings per line in 10000 lines might give a performance problem. I normally use the Chilkat stringbuilder object for string handling because of the speed and possibilities. But, in this case I am not able to use it. Lets try and see what happens.

you're right. Powerbuilder is horrible at string manipulations, but you could:

1. Use Blob variables and functions like BlobMid which will speed up things (Roland Smith on Topwizprogramming has some great code for that).

2. Or even better: Create a C# DLL to do the string manipulations and import it into a PB nvo.

Eric,

Here's a link you might be interested in: https://community.appeon.com/index.php/qna/q-a/use-c-for-replace-function

It includes a little sample application.

Thanks for sharing the solution!