|
a/doc/sqlscreens.lyx |
|
b/doc/sqlscreens.lyx |
| 1 |
#LyX 1.1 created this file. For more info see http://www.lyx.org/
|
1 |
#LyX 1.2 created this file. For more info see http://www.lyx.org/
|
| 2 |
\lyxformat 218
|
2 |
\lyxformat 220
|
| 3 |
\textclass docbook-book
|
3 |
\textclass docbook-book
|
| 4 |
\language english
|
4 |
\language english
|
| 5 |
\inputencoding default
|
5 |
\inputencoding default
|
| 6 |
\fontscheme default
|
6 |
\fontscheme default
|
| 7 |
\graphics dvips
|
7 |
\graphics dvips
|
|
... |
|
... |
| 9 |
\spacing single
|
9 |
\spacing single
|
| 10 |
\papersize Default
|
10 |
\papersize Default
|
| 11 |
\paperpackage a4wide
|
11 |
\paperpackage a4wide
|
| 12 |
\use_geometry 0
|
12 |
\use_geometry 0
|
| 13 |
\use_amsmath 0
|
13 |
\use_amsmath 0
|
|
|
14 |
\use_natbib 0
|
|
|
15 |
\use_numerical_citations 0
|
| 14 |
\paperorientation portrait
|
16 |
\paperorientation portrait
|
| 15 |
\secnumdepth 3
|
17 |
\secnumdepth 3
|
| 16 |
\tocdepth 3
|
18 |
\tocdepth 3
|
| 17 |
\paragraph_separation indent
|
19 |
\paragraph_separation indent
|
| 18 |
\defskip medskip
|
20 |
\defskip medskip
|
|
... |
|
... |
| 40 |
\layout Chapter
|
42 |
\layout Chapter
|
| 41 |
|
43 |
|
| 42 |
Preface
|
44 |
Preface
|
| 43 |
\layout Standard
|
45 |
\layout Standard
|
| 44 |
|
46 |
|
| 45 |
This document describes SQLScreens release 1.1.5
|
47 |
This document describes SQLScreens release 1.1.7
|
| 46 |
\layout Standard
|
48 |
\layout Standard
|
| 47 |
|
49 |
|
| 48 |
With SQLScreens you can easily create screen forms, for querying and updating
|
50 |
With SQLScreens you can easily create screen forms, for querying and updating
|
| 49 |
a relational database.
|
51 |
a relational database.
|
| 50 |
\layout Standard
|
52 |
\layout Standard
|
|
... |
|
... |
| 416 |
\series default
|
418 |
\series default
|
| 417 |
is small, it should be easy to adjust if needed.
|
419 |
is small, it should be easy to adjust if needed.
|
| 418 |
\layout Standard
|
420 |
\layout Standard
|
| 419 |
|
421 |
|
| 420 |
The configuration script only looks for the MySQL library in /usr/local/mysql/li
|
422 |
The configuration script only looks for the MySQL library in /usr/local/mysql/li
|
| 421 |
b and /usr/local/lib/mysql.
|
423 |
b,/usr/local/lib/mysql, /usr/lib/mysql, /usr/lib.
|
| 422 |
If your installation is different, please make symbolic links or modify
|
424 |
If your installation is different, please make symbolic links or modify
|
| 423 |
the script.
|
425 |
the script.
|
| 424 |
\layout Standard
|
426 |
\layout Standard
|
| 425 |
|
427 |
|
| 426 |
When you're ready:
|
428 |
When you're ready:
|
|
... |
|
... |
| 472 |
to install the package.
|
474 |
to install the package.
|
| 473 |
This will create a
|
475 |
This will create a
|
| 474 |
\begin_inset Quotes eld
|
476 |
\begin_inset Quotes eld
|
| 475 |
\end_inset
|
477 |
\end_inset
|
| 476 |
|
478 |
|
| 477 |
/usr/local/lib/sqlsc
|
479 |
$TK_PREFIX/lib/sqlsc
|
| 478 |
\begin_inset Quotes erd
|
480 |
\begin_inset Quotes erd
|
| 479 |
\end_inset
|
481 |
\end_inset
|
| 480 |
|
482 |
|
| 481 |
directory and copy the shared library and TCL code there.
|
483 |
directory and copy the shared library and TCL code there.
|
| 482 |
It will also copy
|
484 |
It will also copy
|
|
... |
|
... |
| 485 |
\series default
|
487 |
\series default
|
| 486 |
to
|
488 |
to
|
| 487 |
\begin_inset Quotes eld
|
489 |
\begin_inset Quotes eld
|
| 488 |
\end_inset
|
490 |
\end_inset
|
| 489 |
|
491 |
|
| 490 |
/usr/local/bin.
|
492 |
$TK_PREFIX/bin.
|
|
|
493 |
TK_PREFIX is taken from the tkConfig.sh script for your wish interpreter.
|
|
|
494 |
You can change it by typing
|
|
|
495 |
\begin_inset Quotes eld
|
|
|
496 |
\end_inset
|
|
|
497 |
|
|
|
498 |
make install TK_PREFIX=yourdest
|
|
|
499 |
\begin_inset Quotes erd
|
|
|
500 |
\end_inset
|
|
|
501 |
|
|
|
502 |
instead, but you might then have to adjust your TCLLIBPATH for the package
|
|
|
503 |
to be found.
|
|
|
504 |
\newline
|
| 491 |
If the shared library link failed at the previous step, or if you get error
|
505 |
If the shared library link failed at the previous step, or if you get error
|
| 492 |
messages about unfound symbols during installation, either type
|
506 |
messages about unfound symbols during installation, either type
|
| 493 |
\begin_inset Quotes eld
|
507 |
\begin_inset Quotes eld
|
| 494 |
\end_inset
|
508 |
\end_inset
|
| 495 |
|
509 |
|
| 496 |
make install-static
|
510 |
make install-static
|
|
... |
|
... |
| 1439 |
texts
|
1453 |
texts
|
| 1440 |
\layout Standard
|
1454 |
\layout Standard
|
| 1441 |
|
1455 |
|
| 1442 |
This is a list of columns (typically text blobs) that should be displayed
|
1456 |
This is a list of columns (typically text blobs) that should be displayed
|
| 1443 |
in multiline text widgets.
|
1457 |
in multiline text widgets.
|
| 1444 |
Each entry is a triplet listing the column name, and the width and height
|
1458 |
Each entry is a triplet or quadruplet listing the column name, the width
|
| 1445 |
of the text widget.
|
1459 |
and height of the text widget, and a possible option field.
|
| 1446 |
Ex:
|
1460 |
Ex:
|
| 1447 |
\layout Code
|
1461 |
\layout Code
|
| 1448 |
|
1462 |
|
| 1449 |
set product(texts) {{description 20 70}
|
1463 |
set product(texts) {{description 20 70}
|
| 1450 |
\backslash
|
1464 |
\backslash
|
| 1451 |
|
1465 |
|
| 1452 |
\layout Code
|
1466 |
\layout Code
|
| 1453 |
|
1467 |
|
| 1454 |
{notice 10 70}}
|
1468 |
{notice 10 70 t}}
|
| 1455 |
\layout Standard
|
1469 |
\layout Standard
|
| 1456 |
|
1470 |
|
|
|
1471 |
If the option field is present, it should be a string where each character
|
|
|
1472 |
will select an option.
|
|
|
1473 |
There are currently 2 possible (and mutually exclusive) options:
|
|
|
1474 |
\layout Description
|
|
|
1475 |
|
|
|
1476 |
t will display a label (column name) over the text area
|
|
|
1477 |
\layout Description
|
|
|
1478 |
|
|
|
1479 |
l will display a label on the left of the text area
|
|
|
1480 |
\layout Standard
|
|
|
1481 |
|
|
|
1482 |
By default, no label will be displayed for text fields.
|
|
|
1483 |
\layout Standard
|
|
|
1484 |
\noindent
|
| 1457 |
|
1485 |
|
| 1458 |
\series bold
|
1486 |
\series bold
|
| 1459 |
SQLScreens
|
1487 |
SQLScreens
|
| 1460 |
\series default
|
1488 |
\series default
|
| 1461 |
will handle quoting and unquoting the blob contents.
|
1489 |
will handle quoting and unquoting the blob contents.
|
| 1462 |
\layout Standard
|
1490 |
\layout Standard
|
| 1463 |
|
1491 |
\noindent
|
| 1464 |
There is an exemple of
|
1492 |
There is an exemple of
|
| 1465 |
\series bold
|
1493 |
\series bold
|
| 1466 |
texts
|
1494 |
texts
|
| 1467 |
\series default
|
1495 |
\series default
|
| 1468 |
use in the
|
1496 |
use in the
|
|
... |
|
... |
| 1893 |
\layout Code
|
1921 |
\layout Code
|
| 1894 |
|
1922 |
|
| 1895 |
}
|
1923 |
}
|
| 1896 |
\layout Subsection
|
1924 |
\layout Subsection
|
| 1897 |
|
1925 |
|
| 1898 |
Miscellaneous
|
1926 |
Miscellaneous array entries
|
| 1899 |
\layout Subsubsection
|
1927 |
\layout Subsubsection
|
| 1900 |
|
1928 |
|
| 1901 |
hdl
|
1929 |
hdl
|
| 1902 |
\layout Standard
|
1930 |
\layout Standard
|
| 1903 |
|
1931 |
|
|
... |
|
... |
| 1945 |
\layout Standard
|
1973 |
\layout Standard
|
| 1946 |
|
1974 |
|
| 1947 |
This is the select result handle.
|
1975 |
This is the select result handle.
|
| 1948 |
\layout Subsubsection
|
1976 |
\layout Subsubsection
|
| 1949 |
|
1977 |
|
| 1950 |
sqlscshowstmts
|
|
|
| 1951 |
\layout Standard
|
|
|
| 1952 |
|
|
|
| 1953 |
You can set this variable to 1 or 0 to print the SQL statements to stdout
|
|
|
| 1954 |
(or
|
|
|
| 1955 |
\series bold
|
|
|
| 1956 |
SQLSCLOG
|
|
|
| 1957 |
\series default
|
|
|
| 1958 |
) when they are executed.
|
|
|
| 1959 |
This is not an array element but a global variable.
|
|
|
| 1960 |
\layout Subsubsection
|
|
|
| 1961 |
|
|
|
| 1962 |
sqlsc_colname_valsaved
|
1978 |
sqlsc_colname_valsaved
|
| 1963 |
\layout Standard
|
1979 |
\layout Standard
|
| 1964 |
|
1980 |
|
| 1965 |
The package uses these entries to save the database values when a query
|
1981 |
The package uses these entries to save the database values when a query
|
| 1966 |
is performed.
|
1982 |
is performed.
|
|
... |
|
... |
| 1968 |
\begin_inset LatexCommand \ref[Sql generation]{sqlGeneration}
|
1984 |
\begin_inset LatexCommand \ref[Sql generation]{sqlGeneration}
|
| 1969 |
|
1985 |
|
| 1970 |
\end_inset
|
1986 |
\end_inset
|
| 1971 |
|
1987 |
|
| 1972 |
section).
|
1988 |
section).
|
|
|
1989 |
\layout Section
|
|
|
1990 |
|
|
|
1991 |
Global customization variables
|
|
|
1992 |
\layout Subsection
|
|
|
1993 |
|
|
|
1994 |
sqlscshowstmts
|
|
|
1995 |
\layout Standard
|
|
|
1996 |
|
|
|
1997 |
You can set this variable to 1 or 0 to print the SQL statements to stdout
|
|
|
1998 |
(or
|
|
|
1999 |
\series bold
|
|
|
2000 |
SQLSCLOG
|
|
|
2001 |
\series default
|
|
|
2002 |
) when they are executed.
|
|
|
2003 |
This is not an array element but a global variable.
|
|
|
2004 |
\layout Subsection
|
|
|
2005 |
|
|
|
2006 |
sqlscnobell
|
|
|
2007 |
\layout Standard
|
|
|
2008 |
|
|
|
2009 |
You can set this to 1 to prevent use of the bell function when the end of
|
|
|
2010 |
a query is reached.
|
|
|
2011 |
The sound can become quite ennoying...
|
| 1973 |
\layout Section
|
2012 |
\layout Section
|
| 1974 |
|
2013 |
|
| 1975 |
Linking screens
|
2014 |
Linking screens
|
| 1976 |
\begin_inset LatexCommand \label{linkingscreens}
|
2015 |
\begin_inset LatexCommand \label{linkingscreens}
|
| 1977 |
|
2016 |
|