Data Access Worldwide Forums - Database Connectivity https://support.dataaccess.com/Forums/ All things related to connecting and optimizing your DataFlex application with SQL databases. en Thu, 10 Sep 2026 03:36:35 GMT vBulletin 60 https://support.dataaccess.com/Forums/images/misc/rss.png Data Access Worldwide Forums - Database Connectivity https://support.dataaccess.com/Forums/ parameter limit https://support.dataaccess.com/Forums/showthread.php?73557-parameter-limit&goto=newpost Mon, 07 Sep 2026 20:05:25 GMT DF-25 Windows app

Is there a limit to the number of parameters I can add using SQLSetParameter? I don't see anything in the help about it. I'm not using SQLExecutor at this point. My query requires 14 parameters and I can't get it to work correctly, getting odd error messages like a string being called an integer. A query with only a few parameters works as expected. ]]> Database Connectivity Bob Worsley https://support.dataaccess.com/Forums/showthread.php?73557-parameter-limit 1/1/0001 https://support.dataaccess.com/Forums/showthread.php?73549-1-1-0001&goto=newpost Thu, 03 Sep 2026 18:46:45 GMT Hi, What needs to be done to stop the default date of “1/1/0001” from displaying in a view? MS SQL Express 2025 and DF 25.0. Thanks, Tom Hi,

What needs to be done to stop the default date of “1/1/0001” from displaying in a view? MS SQL Express 2025 and DF 25.0.

Thanks,
Tom ]]> Database Connectivity Tom https://support.dataaccess.com/Forums/showthread.php?73549-1-1-0001 Dynamically changing the DB connection using command line parameter https://support.dataaccess.com/Forums/showthread.php?73542-Dynamically-changing-the-DB-connection-using-command-line-parameter&goto=newpost Tue, 01 Sep 2026 17:57:18 GMT I wanted a clean solution to dynamically change the DB connection using a command line parameter. I found some solutions here, but they didn't always work. For example, augmenting the ConnectionIniFile function didn't work if the application is run from the shell (i.e. double-clicking from Windows Explorer or launching from another DataFlex application). I am not sure why. I also couldn't use the the command line parameter "dfconnid=" because the INI file name is dynamically built, based on the parameter.

Attached is a solution that augments the AutoConnect procedure that works, in case anybody else needs to do this. It is a simple example to switch databases between test mode and production mode, and is meant as a foundation to use for a possibly more complex implementation. Note that the various databases MUST be identical. Otherwise, there will be errors.

Also note that obtaining the command line parameter could be done directly in the AutoConnect procedure. However, I chose to use the OnCreate event in the oApplication object and setting a property, in case it needs to be referenced elsewhere in the application. If any command line parameters are to be referenced elsewhere in the application, I prefer to save them as properties in the oApplication object and reference them from there. If you don't need that, you may obtain the command line parameter directly in AutoConnect.

Hope this helps!
Attached Files
]]> Database Connectivity adityagir https://support.dataaccess.com/Forums/showthread.php?73542-Dynamically-changing-the-DB-connection-using-command-line-parameter Express VS Standard https://support.dataaccess.com/Forums/showthread.php?73515-Express-VS-Standard&goto=newpost Fri, 21 Aug 2026 17:29:16 GMT Hi, I have a customer with about 40 users that is now using the MS Sql Express DB. The customer has MS SQL Server 2022 Standard but would have to... Hi,

I have a customer with about 40 users that is now using the MS Sql Express DB. The customer has MS SQL Server 2022 Standard but would have to purchase almost 40 CALs. How much of a performance boost would there be to justify the almost $13,000.00 investment.

We are going to go to SQL 2025 Express if not the SQL Server 2022 Standard.

Thanks,
Tom ]]> Database Connectivity Tom https://support.dataaccess.com/Forums/showthread.php?73515-Express-VS-Standard