Whenever you have an application that fails at runtime but not in the IDE you can run the application with a /PBDEBUG command line argument and the application will start logging out everything it's doing.  Note that the application will run *much* slower as a result.  When the application crashes, you can check the last few lines of the file and get some idea what was going on when it crashed.

If you can create a small sample application that causes the same behavior on attach it on an issue or discussion on the Open Source PFC repo I can take a look at it.  I'm trying to create one of my own to see if I can replicate the behavior.  That's only something i can do in what little free time I have and it's not guaranteed that I'm going to be able to reproduce the problem.

I've solved the SQL error at least. For some reason, and this is making me think I didn't get the latest PBLs from github - if anyone can tell me how to get the latest PFC PBLs LMK, anyway in this data window:

d_pfcsecurity_controllist

The where clause had double quotes around the table and column names like this:

Old SQL Syntax:

So, I removed them.

New SQL Syntax:

That solved my SQL error.

...but with Tabbed UI on, in the executable only, I get a window flash up and then the app crashes.

Back to MDI Open Sheets :-(

Yes. When I put the previous versions of the PFC PBLs back into my library list, full build and run my app I don’t get the SQL error above, but I get the problem with the tabbed dialog (only in the exe)

I think I’m just going to give up trying to use the tabbed UI functionality in my app. It works fine if I use the PBLs I manually changed to match the changes that Bruce made to the ones in GitHub. It just doesn’t work in the executable. 

Going back to plain old MDI UI :-(

Thanks for your help though Chris. Maybe if I ever start a new PB project I will start with your framework. 

Thx again. 

Chris

Looks like something is going wrong in some call to check security:

(0FE07008): SELECT security_info.window , security_info.control , security_info.status , security_users.priority FROM security_info , security_users WHERE ( security_users.name = security_info.user_name ) and ( "security_info"."window" = ? ) and ( "security_info"."user_name" = ? ) and ( "security_info"."application" = ? ) ORDER BY security_info.control ASC, security_users.priority ASC
(0FE07008): VCHAR Length=17 ID=:winname *w_aims_asset_list*
(0FE07008): VCHAR Length=6 ID=:username *iwells*
(0FE07008): VCHAR Length=4 ID=:appname *aims* (5.142 MS / 37.499 MS)
(0FE07008): BIND SELECT OUTPUT BUFFER (DataWindow): (0.007 MS / 37.506 MS)
(0FE07008): ,len=65,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(0FE07008): ,len=129,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(0FE07008): ,len=2,type=CHAR,pbt=1,dbt=0,ct=0,prec=0,scale=0
(0FE07008): ,len=80,type=LONG,pbt=22,dbt=0,ct=0,prec=0,scale=0
(0FE07008): EXECUTE: (1.021 MS / 38.527 MS)
(0FE07008): *** ERROR 102 ***(rc -1) : SQLSTATE = 37000
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near 'window'.
(0FE07008): CANCEL: (0.026 MS / 38.553 MS)
(0FE07008): COMMIT: (0.022 MS / 38.575 MS)

In the pre-open event of all my windows I have this script and it seems like this is the culprit.

Just to make sure I made all the manual changes correctly to my code based upon Bruce's updates, instead I downloaded the 2022 PFC versions from github and compiled my code with these new PFC pbls. No errors

When I run my code now I get this popup every time I open any window. THis is with the tabbed UI on or off:

After getting the error the app still works and opens the windows.

I feel I have broken something bad.

Any help would be greatly appreciated.

Hi Ian;

  Are yo using the 2022 PFC version with your PB 2022 App?

FYI: https://github.com/OpenSourcePFCLibraries

Regards ... Chris