I created a local table in Tessitura, followed all the directions in the help docs and made sure I had security rights to the table in Security, but can't add anything to the table in the client. I get an error message that says: String or binary data would be truncated. All I'm trying to add is a number.
I can add items to the table via SQL by using INSERT INTO, but no love in Tessitura. I' sure it's something small, but I can't find it and it's driving me crazy! Any ideas?
Thanks,
Melissa
Any chance you can list out the column data types? I usually find that one of those did not match as exactly as I thought (tinyint vs. int, varchar length, etc...). You can always try using CAST() to allow truncating, but as you say it probably should not be truncating. Or maybe there are some leading/trailing spaces that are affecting things?
Below are my columns and data types. Yeah, as you see all I'm really inserting is a list number so nothing to complex!
[id] [int] IDENTITY(1,1) NOT NULL, [list_no] [int] NULL, [created_by] [char](8) NULL, [create_dt] [datetime] NULL, [last_updated_by] [char](8) NULL, [last_update_dt] [datetime] NULL
Now I'm almost certain it's created by our last updated by.
If it is that, make sure you are using the database functions for that. dbo.FS_USER() for the user and dbo.FS_LOCATION() for the create_loc if I not mistaken.
Or at least something that trims those values to 8 characters.
I just up the value of the characters and I was able to add to the table. The issue was the created by field... Thanks for the suggestions.