search results

(...) BPS) to the content database, causing them to stop working. Therefore, they must be updated by changing the address, name, and/or credentials of the account used for the connections.   If sql queries (data sources, Run an SQL procedure actions, business rules containing the SQL COMMAND function) include explicitly defined database names, these must also be updated if they have changed.   (...)

Maybe this is simple and I'm just overthinking it. I'm creating new proposals, each new proposal has an automatically generated # associated with it (PFY2021-xxxx). I have the form rule built to create the string, but I need the number portion to append. The xxxx number needs to increment for each new record entered. I can't seem to create an "application wide" variable that I can reference, c

(...) Hi all, I was wondering what the best practice is when using sql queries in Webcon with attributes, tables or views that have different names in different environments. One example is the views. These are automatically generated by Webcon and the name is combined from the process name and the process ID. The process ID is of course always different in the three different environments. This means that (...)

(...) Hi, I have a problem with the execution of sql queries in different environments using a Default connection (after moving the system to AZUR-e servers). SQL Server Profiler shows that on the TEST server execution of queries using the Default connection uses a different user than on the Dev server - installation seems to be the same (the same users etc.). Is there any option/installation parameter that (...)

Hi everyone, This might be a big one, but on one of latest webinars I've heard that there is open 'Designer Studio' project at Webcon, so I'll give it a shot - if not now, then I'm not sure if there will be a better time ;) I think most of us have used SQL Server Management Studio or Azure Data Studio to test some queries, and maybe a VSCode / Notepad++ for some powershell - all of those suppo

(...) eciate any advice, ideas, or suggestions on how to approach this. Any pointers on how to capture and log these actions would be incredibly helpful. I was thinking of potentially tracking the internal sql queries but I need to know which user accessed the data specifically and I'm not sure I can engineer a solution that tracks background queries anyway. And this does not solve the issue of users accessing cac (...)