The DF form completion event submits the query below, but the query will not wotk.  I ran the query under Host/SQL and it works just fine!

How do I resolve this?

Here is what I am running:
Ver:3.3.40.0 / 5.4.4

Here is the error (table name has xxx's):

An error occurred when attempting to run this SQL query:

update xxxxxxxxxxxx set GameDate = '07/31/2010 ', GameTime = '01:45', AMPM= 'pm', GameType= 'Showcase', EventName= 'RCS Unsigned Sr Showcase', EventURL= '', Country= 'United States', VenueState= 'Texas', Venue= 'Harvest Time Church Gym', VenueAddr= '7770 Imperial Valley Dr', City= 'Houston', zip= ' 77060 ', Opponent= 'Other Seniors', HomeOrVis= '', MyTeam = 'Unsigned Seniors', WorL= 'W', GameURL1= '', LinkType1= ' ', LinkType2= ' ', GameURL2= '', LinkType3= ' ', GameURL3= '', OurScore= '87 ', TheirScore= '78 ', Att2s= '7 ', Made2s= ' 4 ', Att3s= ' 2 ', Made3s= ' 1 ', FTAtt= ' 5 ', FTMade= ' 3 ', TotRebs= '7 ', TotPts= '14 ', Assists= '4 ', GameLevel= 'High School', Steals = '2 ', GameNote= 'This is game 1 of 3 games that I will play (#31)' WHERE GameID = '1'

String or binary data would be truncated. The statement has been terminated.

Hello "The Dad",

The following error your getting "String or binary data would be truncated. The statement has been terminated." basically means that one or more of your columns are not large enough to contain what you're trying to insert into the column.

You will need to find the size of your columns by going to your server and look at the table with these columns. Find the datatype and size, my guess is that the field that isn't large enough is "GameNote".

Once you find the field that you need to enlarge in size. Use this query to alter the size of the column:

Alter Table yourTableName
Alter GameNote nvarchar(500)

Then execute under Host-> SQL

Note: First find the column that needs altering.

Thanks,

Ryan

Thanks Ryan,

I will give it a whirl.

Hello,

Please let me know how this works for you.

Thanks,

Ryan

Sorry about the delay. I had to use this syntax:

Alter Table dbo.bbc_mygames
Alter column GameNote nvarchar(500)

So far, so good. Thx.

Hello ,

If you ever have any questions or comments please refer them to us via forum thread or our "Contact Us" from our menu.

Thanks,

Ryan