[Ur] Why won't this compile?

David Snider david at davidsnider.net
Sat Oct 20 06:57:36 EDT 2012


Nevermind, it was the stray semi-colon. Why did it spit out field 
specification errors for that though?


On 10/20/2012 06:38 AM, David Snider wrote:
> I can't figure out what I'm doing wrong here. The number of fields in 
> the insert statement is exactly the same number in the user table.
>
> table user : {
> Id : int,
> Email : string,
> Password : string,
> FirstName : string,
> LastName : string
> }
> PRIMARY KEY Id
>
> table addresstype : {
> Id : int,
> DisplayName : string,
> Value : string
> }
> PRIMARY KEY Id
>
> table address : {
> Id : int,
> UserId : int,
> AddressTypeId : int,
> Address1 : string,
> Address2 : string,
> City : string,
> State : string,
> Zip : string,
> Country : string
> }
> PRIMARY KEY Id
> CONSTRAINT FK_User FOREIGN KEY (UserId) REFERENCES user(Id) ON DELETE 
> CASCADE,
> CONSTRAINT FK_AddressType FOREIGN KEY (AddressTypeId) REFERENCES 
> addresstype(Id) ON DELETE CASCADE
>
> sequence userSeq
>
> fun create email password firstname lastname  =
>     id <- nextval userSeq;
>     dml (INSERT INTO user (Id, Email,Password, FirstName, LastName)
>      VALUES ({[id]},{[email]},{[password]},{[firstname]},{[lastname]})
>     );
>
> Error Message:
>
> david at ubuntu:~/Projects/UrShop$ urweb urdemo
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:37:8: (to 39:2) Length mismatch in 
> INSERT field specification (5 vs. 4)
> /home/david/Projects/UrShop/user.ur:41:0: (to 41:0) syntax error found 
> at EOF
> Parse failure
>
>
>
> _______________________________________________
> Ur mailing list
> Ur at impredicative.com
> http://www.impredicative.com/cgi-bin/mailman/listinfo/ur




More information about the Ur mailing list