The reports in our project use the procedure ChangeODBCDataSource to create a connection string in production. This works great. Currently I am working on an SQL function and it works if I use the...
Type: Posts; User: Peter van Mil
The reports in our project use the procedure ChangeODBCDataSource to create a connection string in production. This works great. Currently I am working on an SQL function and it works if I use the...
I use the settings below:
Set Form_Button_Bitmap 0 to "CalendarPrompt.bmp"
Set Prompt_Button_Mode to PB_PromptOn
Set Form_Datatype to Mask_Date_Window
Set Form_Mask to "dd-mm-yyyy"
If you want to use different colors you can use the different Microsoft Office colors with Windows10.cjstyles.
Hi Marcia,
My statement in the previous message wasn't correct. "This should be supported" needed to be "This isn't supported yet". It was clear to me, but is was a confusing message. Thanks for...
DataFlex 20.1 is using CodeJock 20.0.0. I don't have DataFlex 20.0 anymore, but it used an older version.
Currently I am only using Windows10.cjstyles with the "Normal Microsoft Office Outlook.ini"...
You can set the Combo_Sort_State to False
Hi Michael,
I see that you are using the ODBC Driver 18 for SQL Server. This should be supported according to a reply in this forum message:
...
Hi Vincent,
I see what you are saying, but you can't read that in the article. The article says " Use varchar when the sizes of the column data entries vary considerably".
Hi Vincent,
I was a bit surprised about the 8000 size. This applies to VarChar(MAX):
If you use char or varchar, we recommend to:
- Use char when the sizes of the column data entries are...
Maybe you are right. But I am hoping that someone at Data Access Europe also wants this feature for his/her own projects. Sometimes beautiful things happen ....
Hi Michael,
This is absolutely a serious issue. When running SQL queries to select data for RDS data in DataFlex Reports, it is always a struggle when you have European settings (comma as a...
Sometimes it helps when the business analyst and the developer are wearing the same hat :)
Missing reboot between uninstall and install????
When mixing character mode and modern versions of DF, it always has been a good policy to use exactly the same (and latest) MSSQL drivers. Currently this is version 6.3.0.25. DF 2021 uses another...
Hi Stephen,
Thanks for the clarification.
Accidentally I found the new Microsoft ODBC Driver 18 for SQL Server. Currently this new version isn't recognized by the driver attribute DF_DRIVER_SQLSERVER_CLIENT_VERSION. Not a surprise, because...
Thanks for your message. Finally I was able to reproduce these errors and better: to solve it.
Hi Garret,
I am using the Outlook skin as defined below. It is in production with DF 19.1. Windows 10.cjsyles is part of DataFlex 20.1. I don't use other styles. I have an issue with the...
I never trust the system PATH environment with runprogram. I remember being bitten by this before.
I think that you have to define the complete path for Powershell.exe.
Hi Dave,
Even if you don't want to use Managed Connections in your applications you can use them in DBBuilder and DBExplorer. I don't exactly see the problem.
Good to hear. Thanks for letting me know.
You can download the runtime installers from dataaccess.eu (also 32-bit).
I haven't used it, but there is a runtime installaer for DataFlex Reports 8.