[Ur] Length mismatch in INSERT field specification

Adam Chlipala adamc at csail.mit.edu
Thu Apr 7 16:26:45 EDT 2016


Yes, there is something "obvious": that final semicolon shouldn't be 
there.  Sorry for the suboptimal error message; yacc diagnostics are 
notoriously tricky!

On 04/06/2016 07:31 PM, Yves Cloutier wrote:
> Hello,
>
> I'm getting an error using a dml statement which I *can't* figure out:
>
> Length mismatch in INSERT field specification (4 vs. 3)
>
> I'm not sure why as the number of fields in my table definition are 
> the same as the ones in my INSERT satement:
>
> table tblEmployers : {Id: int, Description: string, From: time, To: time}
>
> fun add r = nextid <- nextval uidEmployer;
>                     dml(INSERT INTO tblEmployers (Id, Description, 
> From, To)
>                             VALUES ({[nextid]}, {[r.Description]}, 
> {[r.From]}, {[r.To]}));
>
> Is there something obvious that I'm not seeing?
>
> Thank you!



More information about the Ur mailing list