DDT automaticly created stored procedures with wrong naming


Author
Message
Philipp Guntermann
Philipp Guntermann
StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)
Group: Forum Members
Posts: 141, Visits: 263
when i add the localization deployment packages to the ddt through the "Create packages using the deployment package wizard" function, it creates the stored procedures wrong.

it adds them with names "dbo." instead of "dbo.MessageItems_Insert" and "dbo.MessageLanguages_Insert"

as shown here in the stored procedures view on the ddt:

i tried deleting the tables in the ddt and from the database and re-adding the localization deployment packages through the wizard, but he does it again Smile

any idea ?

Trent Taylor
Trent Taylor
StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
If you will search the forum you will see that this is already a known issue and you can see that there is an easy work around.  Just right-click the MessageItems and MessageLanguages tables, go to properties, and just clear out the INSERT and UPDATE sprocs, uncheck the items, then re-check them and it will correct the issue.
Philipp Guntermann
Philipp Guntermann
StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)
Group: Forum Members
Posts: 141, Visits: 263
ok thanks.
Ivan George Borges
Ivan George Borges
Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)Strategic Support Team Member (2.9K reputation)
Group: StrataFrame MVPs
Posts: 1.9K, Visits: 21K
Hey Philipp.

You probably have a good reaoson to add the Message and Localization tables into your Database, but if not, have a look at the help file under "Using Embedded XML Files", which is the recommended way, and will probably give your application a performance boost.

Cheers.

Philipp Guntermann
Philipp Guntermann
StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)StrataFrame User (205 reputation)
Group: Forum Members
Posts: 141, Visits: 263
Ivan George Borges (07/29/2008)
Hey Philipp.

You probably have a good reaoson to add the Message and Localization tables into your Database, but if not, have a look at the help file under "Using Embedded XML Files", which is the recommended way, and will probably give your application a performance boost.

Cheers.

hi Ivan,

how much of a performance boost are we talking here ? there a few reasons why i'd want the localization inside the database rather than using the xml approach, however if it raises a serious slowdown (which i havent seen indications for yet) i might get my head around it and find some solutions for the problems that arise when using xml based localization with this application.

thanks !

Trent Taylor
Trent Taylor
StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)StrataFrame Developer (8.7K reputation)
Group: StrataFrame Developers
Posts: 6.6K, Visits: 6.9K
how much of a performance boost are we talking here ?

This can depend on a number of factors, especially on whether you intend to localize labels, etc.  The more you localize, then the more of a performance boost you will gain.  It is embedded within the EXE so no trips to the server are required.  The embedded option will be 100% instantaioneous and not impact load performance.  If you are pulling from SQL Server, then you can experience a load delay as a trip to the server will be made for each request (until it has been loaded once then it is cached during the run).

So the performance boost is extremely significant and if you intend on localizing every facet of your application, you would be well advised to embed your localization files.  If you are only going to pull messages, then it will not be that big of a deal.

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...




Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search