[Ur] Length mismatch in INSERT field specification

Yves Cloutier yves.cloutier at gmail.com
Wed Apr 6 19:31:29 EDT 2016


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!
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.impredicative.com/pipermail/ur/attachments/20160406/c48331a7/attachment.html>


More information about the Ur mailing list