|
| | | 
StrataFrame Beginner
Group: Forum Members
Last Login: 08/16/2007 1:23:47 PM
Posts: 14, Visits: 90 |
| 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 |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: 06/17/2008 9:28:35 AM
Posts: 2,649, Visits: 1,863 |
| Hrm... looks like the .pkg file needs to be updated to include the names of the stored procedures. Strange that no one has run into that problem before. Thanks Jerry 
www.bungie.net |
| |
| | | 
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176 |
| Here is the updated package file. Just copy it to Program Files\Common Files\MicroFour\StrataFrame. The reason other developers have not run into it is because most people embed their localization files, which is the fastest and recommended way if you are looking for the fastest message and localization solution. It also makes distribution easier. This is the same approach that we use...and why we did not catch it  . You can learn more about the different ways to distribute your localization files in the help docs, but our recommended way is by using the embedded approach.
|
| |
| | |
StrataFrame Beginner
Group: Forum Members
Last Login: 08/16/2007 1:23:47 PM
Posts: 14, Visits: 90 |
| Thanks Trent but the zip file is asking for a PASSWORD.
Just started to try out StrataFrame so thanks for the info about embedded files. I will take a look at the documentation.
Jerry J. Jansen |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176 |
| | Just right-click it and save to the above specified location. You do not need to open the PKG file itself, just copy it to the Program Files\Common Files\MicroFour\StrataFrame folder. The password is "framework" but there is no need for you to get into this package file directly. This will just resolve the issue the next time you click "Add Localization and Messaging Tables" |
| |
| | |
StrataFrame Beginner
Group: Forum Members
Last Login: 08/16/2007 1:23:47 PM
Posts: 14, Visits: 90 |
| Thanks Trent, there was not one there so thought it had to be opened. Sorry.
Jerry J. Jansen |
| |
| | |
StrataFrame Developer
Group: StrataFrame Developers
Last Login: Today @ 11:13:06 AM
Posts: 4,104, Visits: 4,176 |
| | Hmmmm....you should have a file with the same name in the following location....assumming your Common Files folder is the default location: C:\Program Files\Common Files\MicroFour\StrataFrame You should be overwriting the file that is there. |
| |
| | |
StrataFrame Beginner
Group: Forum Members
Last Login: 08/16/2007 1:23:47 PM
Posts: 14, Visits: 90 |
| Checked all subdirectories and no *.pkg files. Could it be because I am using the trial version?
Jerry J. Jansen |
| |
| | |
|