annotate tests/insert.ur @ 1866:9fc086e3c95a

Add hex SQL syntax for blobs, such as X'0ABC12343'. Works with sqlite.
author Sergey Mironov <grrwlf@gmail.com>
date Fri, 13 Sep 2013 10:09:15 -0400
parents bc89dfdbc495
children
rev   line source
adamc@299 1 table t1 : {A : int, B : string, C : float, D : bool}
adamc@299 2
adamc@299 3 fun main () : transaction page =
adamc@302 4 () <- dml (INSERT INTO t1 (A, B, C, D) VALUES (5, "6", 7.0, TRUE));
adamc@299 5 return <html><body>Inserted.</body></html>