;;;; Programmer: Kevin M. Rosenberg
;;;; Date Started: Apr 2000
;;;;
-;;;; $Id: sql.lisp,v 1.5 2002/10/16 16:05:23 kevin Exp $
+;;;; $Id: sql.lisp,v 1.6 2002/10/18 03:57:39 kevin Exp $
;;;;
;;;; This file, part of UMLisp, is
;;;; Copyright (c) 2000-2002 by Kevin M. Rosenberg, M.D.
(with-mutex-sql (conn)
(sql-query cmd conn :types types)))
-
-
-(defun make-usrl ()
- (with-sql-connection (conn)
- (sql-execute "drop table if exists USRL" conn)
- (sql-execute "create table USRL (sab varchar(80), srl integer)" conn)
- (dolist (tuple (mutex-sql-query "select distinct SAB,SRL from MRSO order by SAB asc"))
- (sql-execute (format nil "insert into USRL (sab,srl) values ('~a',~d)"
- (car tuple) (ensure-integer (cadr tuple)))
- conn)))
- (find-usrl-all))
-
(defun find-usrl-all ()
(let ((usrls '())
(tuples (mutex-sql-query "select SAB,SRL from USRL order by SAB desc")))