X-Git-Url: http://git.kpe.io/?a=blobdiff_plain;ds=sidebyside;f=doc%2Fref-ooddl.xml;h=da340c7662fc4d7e6b7190a7f0aa0b62db01cead;hb=8a13e05588cb35ffeed91cca2dc26c313e387d70;hp=ebe7de14b369f8d5b4ed360773f9f5b41a717023;hpb=39ee7191fd3087c2d7e149b33dd3e985db021721;p=clsql.git
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.