• You are here:  
  • Home
  • Q&A
  • Q&A
  • PowerBuilder
  • How to Check SQL in DataWindow During Full Build using the Database Connection

Subscribe via RSS
Toggle Submenu
  1. Categories
  2. Recent
  3. Tags
View Replies (2)

Resolved How to Check SQL in DataWindow During Full Build using the Database Connection

  1. How-to
1
Votes
Undo
  1. Peter Thiem
    Peter Thiem
  2. PowerBuilder
  3. Thursday, 8 December 2022 07:25 AM UTC

Hi Everyone,

Is it possible to have the SQL in all the applications DataWindows data source "checked" against the database using the database connection during a full build, or some other development process? 

If so, how would I do it?

I observe that if I edit a DataWindow sql data source, the IDE will validate when I close the window, so maybe there is a way to do this is a bulk process.

Due to an oracle upgrade, we would like to recompile the SQL throughout the application to check that it is valid.

Cheers Peter.

P.S. The embedded SQL can be checked using the full build coupled with the "Disable Database Connection When Compiling and Building" (unchecked) setting. It seems to be buggy for me, these errors are not reported to the IDE, but I can at least turn SQL Trace on for the database connection, and the trace log records the SQL that failure checking. The IDE used to report these in the past for me, I remember using that checkbox to stop the error messages.

P.S. For reference

Column 2 has an invalid name and/or length
Error "ISAM error -104: ISAM error: too many files...
Accepted Answer
Andreas Mykonios
Andreas Mykonios Accepted Answer Pending Moderation
  1. Thursday, 8 December 2022 09:02 AM UTC
  2. PowerBuilder
  3. # Permalink

Hi.

I don't know if powerbuilder can do that. But (once again) PBL Peeper has an option for that.

I've never tried-tested against Oracle. And of course you must be aware that PBL Peeper is to old and in case of issues you won't get any support.

Andreas.

Comment
Peter Thiem
  1. Peter Thiem
  2. Friday, 9 December 2022 00:56 AM UTC
Thanks Andreas, I used PBL Peeper's "Verify DW SQL" report, and it worked without any fuss! Someone put a lot of love into that tool.
  1. Helpful
Chris Pollach @Appeon
  1. Chris Pollach @Appeon
  2. Friday, 9 December 2022 01:07 AM UTC
PBLPeeper was built by Terry Voth from Toronto.
  1. Helpful
Andreas Mykonios
  1. Andreas Mykonios
  2. Friday, 9 December 2022 07:47 AM UTC
Yes...

Terry Voth was very active in sybase news groups... Helped a lot.

Andreas.
  1. Helpful
There are no comments made yet.
Responses (2)
Chris Pollach @Appeon
Chris Pollach @Appeon Accepted Answer Pending Moderation
  1. Thursday, 8 December 2022 21:57 PM UTC
  2. PowerBuilder
  3. # 1

Hi Peter;

  Another alternative is if you have the "CloudPro" edition of PowerBuilder. If so - and even if you are not going to deploy the PB App as a Cloud App - create a PowerServer project. Then perform a Build & Deploy on that PS Project. During this type of compilation, the PS Project will verify every DML command that is either in-line or within a DWO as it needs to do this to ensure proper Web API generation.  ;-)

Food for thought.

Regards ... Chris

Comment
Olan Knight
  1. Olan Knight
  2. Thursday, 8 December 2022 22:08 PM UTC
That's a great tip, Chris! Thank you!
  1. Helpful
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.