Hi
I am using EA 6.0.778 at work and am unsure whether updating is an option, so put that to oneside for a moment. If it is the only way then at least I can take my case to whomever I need to
Let's say we create a table called Nationality, with 4 fields a PK (int), code (varchar, length 5), longName (varchar, length 25) and an adjective (varchar, length 25).
Now on top of this I create an operation called 'NationalityInsert'. Under the tab
'Behaviour' I add the following to the
'Initial Code' section.
INSERT INTO Nationality (Code, LongName, Adjective)
VALUES (@Code, @LongName, @Adjective) Under the
'Columns' tab, I add the columns
Code,
LongName and
Adjective.
Save, save, save.
Now if I go to:
Project Menu -> Database Engineering -> Generate Project DDL
And ensure on the next window that 'Generate Stored Procedures' is ticked, I get a .sql file with the table generated correctly.
However, the stored procedure is generated thus:
CREATE PROCEDURE [dbo].[NationalityInsert]
(
@Code varchar,
@LongName varchar,
@Adjective varchar
)
AS
INSERT INTO Nationality (Code, LongName, Adjective) VALUES (@Code, @LongName, @Adjective)And the problem (if it wasnt obvious) is that the params only accept strings of length 1, rendering the SP pretty useless!
What am I doing wrong? Have I misunderstood this feature or can anyone point me in the right direction?
Thanks in advance
