X-Git-Url: http://git.kpe.io/?p=clsql.git;a=blobdiff_plain;f=doc%2Fref-ooddl.xml;h=da340c7662fc4d7e6b7190a7f0aa0b62db01cead;hp=ebe7de14b369f8d5b4ed360773f9f5b41a717023;hb=bb71f27c241187a32c7839aea501114d65e29f85;hpb=39ee7191fd3087c2d7e149b33dd3e985db021721 diff --git a/doc/ref-ooddl.xml b/doc/ref-ooddl.xml index ebe7de1..da340c7 100644 --- a/doc/ref-ooddl.xml +++ b/doc/ref-ooddl.xml @@ -50,33 +50,49 @@ - *DEFAULT-VARCHAR-LENGTH* - + *DEFAULT-STRING-LENGTH* + Default length of SQL strings Variable Value Type - + Fixnum Initial Value - nil + 255 - Description - + Description + + If a slot of a class defined by + DEF-VIEW-CLASS is of the type + STRING or VARCHAR and does + not have a length specified, then the value of this variable + is used as SQL length. + Examples - + (let ((*default-string-length* 80)) + (def-view-class s80 () + ((a :type string) + (b :type (string 80)) + (c :type varchar)))) + (create-view-from-class 's80) + + The above code causes a SQL table to be created with the SQL command + + CREATE TABLE (A VARCHAR(80), B CHAR(80), C VARCHAR(80)) Affected By - None. + Some SQL backends do not support VARCHAR + lengths greater than 255 . See Also @@ -84,14 +100,14 @@ Notes - None. + This is a CLSQL extension to the CommonSQL API. CREATE-VIEW-FROM-CLASS - + Create a SQL table from Lisp class Function @@ -121,7 +137,7 @@ Side Effects - + Causes a table to be created in the SQL database.