Dbm (discuter | contributions) (→SQLfast) |
Dbm (discuter | contributions) (→SQLfast) |
||
Ligne 74 : | Ligne 74 : | ||
:*SQLfast Tutorial - <b>5. Updating data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto05-Updating-data.pdf [full text]] | :*SQLfast Tutorial - <b>5. Updating data</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto05-Updating-data.pdf [full text]] | ||
+ | ::''Chapter contents'': Multiple-field user data entry. Dialogue box layout and mechanics. SQL data modification queries. Interactive data modification. Using variables in query building. Dynamic queries. | ||
+ | ::''Statements and functions'': <tt>insert</tt>, <tt>delete</tt>, <tt>update</tt>, <tt>ask</tt>. | ||
:*SQLfast Tutorial - <b>6. More on variables</b>, draft version, March 7, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto06-More-on-variables.pdf [full text]] | :*SQLfast Tutorial - <b>6. More on variables</b>, draft version, March 7, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto06-More-on-variables.pdf [full text]] | ||
+ | ::''Chapter contents'': Playing with dates and times. Measuring elapse time. Variable/value substitution operator. Computation. SQLfast procedures and variables. | ||
+ | ::''Statements and functions'': <tt>date</tt>, <tt>time</tt>, <tt>start-timer</tt>, <tt>timer</tt>, <tt>create index</tt>, <tt>drop index</tt>, <tt>output</tt>, <tt>wait</tt>, <tt>parameter delimiters</tt>, <tt>set-n</tt>, <tt>substitution</tt>, <tt>compute</tt>, <tt>execSQL</tt>. | ||
:*SQLfast Tutorial - <b>7. Taking decisions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto07-Taking-decisions.pdf [full text]] | :*SQLfast Tutorial - <b>7. Taking decisions</b>, draft version, June 2, 2014. [http://www.info.fundp.ac.be/~dbm/Documents/Tutorials/SQLfast/SQLfast-Tuto07-Taking-decisions.pdf [full text]] |
<Retour à la page d'accueil / Back>
Sommaire |