I am testing DDT and I imported my data structure from VFP and then added from the Profile menu, "Add Messaging and Localization Tables". I kept getting an error when deploying the database to SQL server. The error mention something about an empty procedure field. I checked all of the my data tables procedures and everything looked ok. I checked all of the Messaging and Localization Tables in DDT and they looked ok.



Then I checked the actual DBETables in SQL server and found the field tbl_insertsprocname EMPTY for the MessageItems and MessageLanguages tables with the fields tbl_insertprocs set to true. However, the insert procedures showed up OK in DDT.



So there must be an error in the importing of the Messaging and Localization Tables in DDT in updating the SQL table.



I then went back to DDT and unchecked/rechecked the "Create INSERT Stored Procedure" in the table properties for both MessageItems and MessageLanguages tables and then the fields tbl_insertsprocname were filled in the SQL DBETables table.

Jerry J. Jansen