SqlQueryBuilder Question
- Advice
- Daryl Foster
- SnapObjects
- Monday, 25 May 2020 08:16 AM UTC
Hi, I'm looking to develop my first web API in Powerbuilder 2019R2 to replace some aging PHP applications. Our PHP applications create a lot of dynamic sql (generally the from and where clauses) based on the arguments passed from the client. I'm looking to replicate this dynamic creation of SQL with SqlQueryBuilder. Is that the preferred way to go? Or is it possible to create dynamic SQL with the new .Net DataStore?
My other question regarding the SqlQueryBuilder is whether it can load an existing SQL statement that I can then modify, or whether I need to create it from scratch by specifying everything?
Find Questions by Tag
Helpful?
If a reply or comment is helpful for you, please don’t hesitate to click the Helpful button. This action is further confirmation of their invaluable contribution to the Appeon Community.