pro_imaj Posted October 5, 2022 Share Posted October 5, 2022 Hi, On the MSSQL side, I keep a field of Date type, this field is data entry via DBGrid. This is how the DateTimePickert to which the editor is connected on the DBGrid Very interesting data is coming. I expect it to behave like this when both displaying the Grdi data and entering the data. DD/MM/YYYY These are the corresponding server module Create event PFmtSettings.ShortDateFormat := 'dd/mm/yyyy'; I added it but nothing changed. What is the correct solution? * If I format the date on the SQL side, it does not enter the editing mode on the Grid this time. Datetimepicture does not detect it as a date. 20221005_134927.mp4 1 Quote Link to comment Share on other sites More sharing options...
pro_imaj Posted October 12, 2022 Author Share Posted October 12, 2022 On 10/5/2022 at 1:50 PM, pro_imaj said: Hi, On the MSSQL side, I keep a field of Date type, this field is data entry via DBGrid. This is how the DateTimePickert to which the editor is connected on the DBGrid Very interesting data is coming. I expect it to behave like this when both displaying the Grdi data and entering the data. DD/MM/YYYY These are the corresponding server module Create event PFmtSettings.ShortDateFormat := 'dd/mm/yyyy'; I added it but nothing changed. What is the correct solution? * If I format the date on the SQL side, it does not enter the editing mode on the Grid this time. Datetimepicture does not detect it as a date. 20221005_134927.mp4 I can't fix this problem, what should I do? Quote Link to comment Share on other sites More sharing options...
pro_imaj Posted October 20, 2022 Author Share Posted October 20, 2022 I can't conclude this issue, what is the solution? @Farshad Mohajeri Quote Link to comment Share on other sites More sharing options...
Hayri ASLAN Posted October 21, 2022 Share Posted October 21, 2022 3 hours ago, pro_imaj said: I can't conclude this issue, what is the solution? @Farshad Mohajeri Hello Are you using UseSystemFormats? Quote Link to comment Share on other sites More sharing options...
pro_imaj Posted October 21, 2022 Author Share Posted October 21, 2022 7 hours ago, Hayri ASLAN said: Merhaba UseSystemFormats kullanıyor musunuz? @Hayri ASLAN It worked fine when I used it, thanks. Quote Link to comment Share on other sites More sharing options...
pro_imaj Posted October 21, 2022 Author Share Posted October 21, 2022 5 minutes ago, pro_imaj said: @Hayri ASLAN It worked fine when I used it, thanks. @Hayri ASLAN When I translate the field type as text, it gets fixed, but when the field type is date on the mssql side, the following error occurs. Quote Conversion failed when converting date and/or time from character string. Quote Link to comment Share on other sites More sharing options...
Hayri ASLAN Posted October 21, 2022 Share Posted October 21, 2022 6 hours ago, pro_imaj said: @Hayri ASLAN When I translate the field type as text, it gets fixed, but when the field type is date on the mssql side, the following error occurs. Which user are you using for hyperservice? Can you make sure you are using a user with correct regional settings? Please make sure you applied your regional settings to Welcome Screen and System Accounts. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.