Hi Ian;

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

FYI: https://github.com/OpenSourcePFCLibraries

Regards ... Chris

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.

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.

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. 

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 :-(

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.