Yes! I use only this method.
Yes! I use only this method.
Samuel Pizarro
Hey Peter van Mil,
thanks for the suggestion but will that not only change it so that all DFate (DAT) will become SQL:date?
I need the opposite here.
Sadly, I don't find any "MAP_SQLDATETIME_TO_DFTYPE DateTime".
You mean checking every time?
Or do you mean the way to "CREATE TABLE" and then adding to filelist?
It works but I run into following error when connecting to the new table via Builder:
Error1:
Followed by
Error2:
and
Error3:
I then can not open the table because of following error:
Error4:
and finally
Error5:
It only works after I delete the new VALUES.int file in the Data-folder and replace it with the values.int of the first workspace.
(I then have to change the DFCONNID and it works as wanted).
I do:
1. In MSSQL Management-Studio I auto-generate a script "CREATE TABLE" for table "VALUES" in a new sql-window.
2. I change "USE [TestDataBase1]" to "USE [TestDataBase2]" (I previously deleted the table "VALUES" in "TestDataBase2").
4. I start my workspace / studio -> start the database builder (I previously deleted the entry for that table from the filelist, ofc.)
5. I click "Connect to SQL Server Database" and choose my table "VALUES".
6. I only check the thing with the Dummy Date and leave the rest as default.
7. Error1 on continue (see above).
8. Next -> Error2 (see above)
9. Next -> Error3 (see above)
10. I now try to "Open Table" my new table. That does not work -> Error 4 and Error 5 (see above)
11. I then delete the "VALUES.int" file in the Data-folder of my second workspace, replace it with the "values.int" file of my first workspace.
12. I change the connection inside the (new) "values.int".
13. Again I "Open Table" my new table -> It works.
Are these errors "normal" and this is the supposed way? Or should I do something differently?
Thanks in advance. I can live with clicking away errors like that (when in the end everything works fine) but I don't like to do so.
Hi Pascal,
But there is a mapping of DataFlex DAT datatypes. You can choose datetime for all DataFlex DAT fields. (I would prefer DAT --> DATE and DateTime --> DateTime2). Maybe you have to check your DEF files. Are they correct?
Code:; MAP_DFDATE_TO_SQLTYPE datetime MAP_DFDATE_TO_SQLTYPE date
Best regards,
Peter van Mil
Appvantage b.v.
Did you include the creation of indexes in your create table script?
In SQL Management Studio you have to turn an option on to include the indexes:
Tools/Options/SQL Server Object Explorer/Scripting/Script indexes(I know, I always forget where it is and always have trouble finding it back...)
Best regards,
Data Access Worldwide
Martin Moleman