|
|
|
1-10 of 25
< Previous Next >
|
Blobs are supported in your app, there is only one error. In sql procedure is declared parameter of type varbinary but it should be varbinary(max). In case of varbinary only 1st byte is saved. Orig...
id# 9740 | Planned Release: None | Last Updated: Mar 22 at 12:46 AM
by kloken
I have a reference to previous Email (email1 in attachment), which is identified by 3 values.
Load method is created with 3 parameters but called only with 1 (id).
id# 9276 | Planned Release: None | Last Updated: Feb 8 at 10:30 PM
by ld9474
Your generator is very nice. Made exactly for doing the thing I did by hand last time (very boring and time consuming and useless, of course).
There was only one big difference. You create (and des...
id# 9277 | Planned Release: None | Last Updated: Feb 4 at 12:36 AM
by ld9474
Timestamps declared as:
@DateModified timestamp(8)
Msg 2716, Level 16, State 1, Procedure sp_Addresses_Update, Line 3
Column, parameter, or variable #29: Cannot specify a column width on data type...
id# 9262 | Planned Release: None | Last Updated: Jan 30 at 2:04 PM
by ld9474
Its better to use SELECT scope_identity()
id# 9263 | Planned Release: None | Last Updated: Jan 30 at 2:04 PM
by ld9474
Example:
sp_Addresses_Select_All
sp_Addresses_Select_One
foreignKey:
sp_Select_Addressess_By_CountryID
should be
sp_Addressess_Select_By_CountryID
notice the addressess should be addresses
id# 9264 | Planned Release: None | Last Updated: Jan 30 at 2:04 PM
by ld9474
Msg 272, Level 16, State 1, Procedure sp_Countries_Update, Line 14
Cannot update a timestamp column.
Create Procedure sp_Countries_Update
(
@CountryID int,
@CountryName nvarchar(50),
@DateCreated ...
id# 9265 | Planned Release: None | Last Updated: Jan 30 at 2:04 PM
by ld9474
Msg 273, Level 16, State 1, Procedure sp_Countries_Insert, Line 13
Cannot insert an explicit value into a timestamp column. Use INSERT with a column list to exclude the timestamp column, or insert ...
id# 9266 | Planned Release: None | Last Updated: Jan 30 at 2:04 PM
by ld9474
sp_Select_CompanyCategoriess_By_CategoryID
should be
sp_Select_CompanyCategories_By_CategoryID
id# 9238 | Planned Release: Iris Generator 1.0.2 | Last Updated: Jan 23 at 9:02 PM
by ld9474
Just like tinyint, the length of bigint and smallint parameters are written while it should not.
id# 9240 | Planned Release: Iris Generator 1.0.2 | Last Updated: Jan 23 at 9:02 PM
by ld9474
|
|
1-10 of 25
< Previous 1 2 3 Next >
|
|
|
|
|
|
|
|
