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!

_______________________________________________
Ur mailing list
[email protected]
http://www.impredicative.com/cgi-bin/mailman/listinfo/ur

Reply via email to