movie collection starter kit  
Author Message
Benjj





PostPosted: Visual Basic IDE, movie collection starter kit Top

Hi there

I trying to run movie collection1 and I have a problem

When I try to add some dvds to the collection via online, I get a error message saying that the movie cannot be added to the collection, and it is not. It adds some dvds and I get the error message with others.

For instance, it cannot add the sound of music or The Firm to the list, but I can add DUEL

All of this is with the movie collection template I downloaded.

Any suggestions

Thanks



Visual Basic15  
 
 
DRLonsbery





PostPosted: Visual Basic IDE, movie collection starter kit Top

I am having the same problem. An exception is being thrown when a row is being added. Copied the de**** output here.

{"Cannot set column 'Actors'. The value violates the MaxLength limit of this column."} System.Exception {System.ArgumentException}

It seems that there is a limit some where on the number of actors (or at least the total of all their names concantenated together) that is exceeded. I can't add any of the 101 Dalmations and 8 out of ten Batmans are accepted.



 
 
Eric Knox - MSFT





PostPosted: Visual Basic IDE, movie collection starter kit Top

This issue is something that we're tracking internally (we being the team that owns the Movie Collection starter-kit), and here's the current answer for this problem.

Please let me know if this doesn't help answer your question.

The problem:

The problem is that the max length for the Title and Actors fields in the Movie Collection DB is not currently set large enough, to allow for some of the movie details that you've entered. For comparison, you can take a look at the Description column of the DB, which is set to a much better max length.

How to fix it:

Here's where you can go to make the appropriate changes...

First, update DVDCollectionDataSet.xsd:

1) Go to Solution Explorer and double-click to open DVDCollectionDataSet.xsd

2) Single-click to select the 'Title' field of the DVDs table.

3) Go to the Properties window, which should show the corresponding values for that column.

4) Change the MaxLength value from 255 to 2147483647. (You can click on the 'Description' field, and get a comparison by looking at its corresponding Properties window values.)

5) Similarly, select the 'Actors' field in the table, and change its MaxLength value from 255 to 2147483647.

6) Just to be safe, you might as well go ahead and do the same for the 'Director' and 'Genre' fields as well. :)

Next, update the database:

1) Go to View -> Server Explorer

2) Expand the nodes to get to Data Connections -> DVDCollectionDatabase.mdf -> Tables -> DVDs, and double click on DVDs to open the table.

3) Change the DataType for Title, Actors, Director, and Genre from nvarchar(255) to nvarchar(MAX). (Again, you can look at the Description column's value, for an example...).

4) Save that opened MDF file.

hth,

e-



 
 
ano1





PostPosted: Visual Basic IDE, movie collection starter kit Top

Hi,

I just downloaded the movie collection starter kit. I am experiencing the same error.

The only time I can see the properties you describe above is when I am in DEBUG mode. So I cannot make any of the suggested changes.

How do I change the project so I can look at the code, properties, or customize the starter kit, etc. when I am not in debug mode.

Thanks,


 
 
Shailen





PostPosted: Visual Basic IDE, movie collection starter kit Top

Change the size of the Actor field to VARCHAR(1000)

Change the XSD Dataset Actor field's maxlength to 1000.

REcompile and test



 
 
ano1





PostPosted: Visual Basic IDE, movie collection starter kit Top

I get an error that editing is not allowed in DEBUG mode.
 
 
Peters1





PostPosted: Visual Basic IDE, movie collection starter kit Top

I've tried what you've written, but it still doesn't work. And one thing i've noticed, is that in "SimpleAmazoneWS.vb", we got this code:

*************************************************

Me.AmazonASINToString(amazonItem), _

Me.AmazonItemDescriptionToString(amazonItem), _

.ItemAttributes.Actor, _

.ItemAttributes.Director, _

.ItemAttributes.AudienceRating, _

Me.AmazonItemRunningTimeToString(amazonItem), _

Me.AmazonDateFormatToString(.ItemAttributes.TheatricalReleaseDate), _

.DetailPageURL, _

Me.AmazonItemLargeImageURLToString(amazonItem))

**************************************************************

Actor and Director are not of the same kind. That must have something to do with it not working. It's code all over the entire project where actor and director are of a different kind than all the others.

Or may it be because of a difference between VB 2005 express and VB 2005 Pro


 
 
mattyc1984





PostPosted: Visual Basic IDE, movie collection starter kit Top

I have been playing around with this for a few hours. I tried the solution that Microsoft recommended and it did not work. I ended up changing every data type in the DVD table to nvarchar(MAX) except for the primary key, length, image, and rating. It worked inside of the .Net environment after that, but the .exe would still get the same error. Since it worked inside of the .Net environment I knew that it should work so I published it and the executable that was produced from setup.exe works fine. Hope this works out for everyone else as mine is pulling data from Amazon and storing it fine with every DVD now.

 
 
Homer J Simpson





PostPosted: Visual Basic IDE, movie collection starter kit Top

I was able to change this by stopping debugging, right clicking on DVDCollectionDataSet.xsd file, selecting "View Designer", and setting the length of "Actors" to 2147483647.

After that it worked fine.

I note, however, that the actors don't show on the display; and also that the film rating is stored in the database but doesn't seem to link to the on screen display.