aBZ+v      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstu 0+Differentiation of data types used in DBs.  HSQL returns  SqlUnknown tp for all ' columns for which it cannot determine  the right type. The tp here is the & internal type code returned from the  backend library   !"#$%&'()*+,-./0  !"#$%&'()*+,-./0/.-,+*)('&%$#"!  0//.-,+*)('&%$#"!    !"#$%&'()*+,-./0123456789:;<=>?@0123456789:;<=>?@0<;:9854321=>?6766@0<;:9854321=>?6766123456789:;<=>?@ AvwBBThis allows for faster conversion for eq. integral numeric types, ) etc. Default version uses fromSqlValue. CThe C6 type represents a result from the execution of given  SQL query. xyfield descriptors zclosing action {1incrementation of the row pointer and indication 2 whether this is still in range of available rows |8extraction of a field from the current result row, with  a column index  a column field definition 5 a generic field extraction function, specifiable by 2 a field definition, a C string and its length }field descriptors ~closing state of the statement DA D- type represents a connection to a database, * through which you can operate on the it. 7 In order to create the connection you need to use the connect function , from the module for your prefered backend. disconnect action .query execution action (without return value) query action with return value .retrieval of the names of the tables in reach 'retrieval of the field defs of a table begin of a transaction  commit of a pending transaction "rollback of a pending transaction  closing state of the connection EY  !"#$%&'()*+,-./0123456789:;<=>?@AvwBCxyz{|}~DEAvwBvwBCxyz{|}~xyz{|}~D E  FGHIJKLMNOPQR FGHIJKLMNOPQR QROPLNMJKHIFG FGGHIIJKKLNMMNOPPQRRSTUVWXYZSTUVWXYZTSUVWXYZSTUVWXYZ[\]^[\]^]^[\[\\]^^_`_``__`aif closed, nothing to do: closing state ref DB action to do if not closed bif closed, exception: closing state ref DB action to do if not closed c1Casts, if possible, an Exception to an SqlError: (the exception thinc to cast to SQLError d;DEPRECATED: catchSql: Use Control.Exception.catch instead. e=DEPRECATED: handleSql: Use Control.Exception.handle instead. abcdeabcdeabcdef"Closes the connection. Performing f on a connection that has $ already been closed has no effect. 8 All other operations on a closed connection will fail. g#Submits a command to the database. the database connection the text of SQL command h*Executes a query and returns a result set the database connection the text of SQL query /the associated statement. Must be closed with  the m function i!List all tables in the database. Database connection )The names of all tables in the database. j7List all columns in a table along with their types and nullable flags Database connection Name of a database table  The list of fields in the table kThe k7 function executes the specified action in transaction  mode. M If the action completes successfully then the transaction will be commited. H If the action completes with an exception then the transaction will be 4 rolled back and the exception will be throw again. - A transaction is to catch ANY exception, so  is adequate. Database connection  an action !the returned value is the result  returned from action ll6 fetches the next rowset of data from the result set. / The values from columns can be retrieved with p function. mm8 stops processing associated with a specific statement, I closes any open cursors associated with the statement, discards pending A results, and frees all resources associated with the statement.  Performing m- on a statement that has already been closed F has no effect. All other operations on a closed statement will fail. nReturns the type and the nullable$ flag for field with specified name o0Returns the list of fields with their types and nullable flags p6Retrieves the value of field with the specified name. result table data  field name  field value qr6Retrieves the value of field with the specified name.  If the field value is null2 then the function will return the default value.  Field name Default field value  Field value sThe s- function iterates through the result set in C 8 and executes the given action for each row in the set.  The function closes the C% after the last row processing or if ' the given action raises an exception.  an action the statement initial state  final state tThe 'forEachRow\'' function is analogous to s but doesn't  provide state.  The function closes the C) after the last row processing or if the # given action raises an exception. uThe u- function iterates through the result set in C L and executes the given action for each row in the set. The values returned I from action are collected and returned as list. The function closes the  C@ after the last row processing or if the given action raises an  exception. i  !"#$%&'()*+,-./0123456789:;<=>?ABCDEFGHIJKLMNOPQR[\]^cdefghijklmnopqrstukDfgChmlEABpqrnokstu0<;:9854321=>?6766decijQROPLNMJKFGHI]^[\/.-,+*)('&%$#"!  fghijklmnopqrstu    !"#$%&'()*+,-./0123456789:;<=>?@ABCDEF;GHIJ K L M N OPPQQRRSTUVVWWXYZ[\]^_``aabcdefghijklmnopqrstuvwx y z M { | } ~  N  hsql-1.8.1 DB.HSQL.Type DB.HSQL.Error Database.HSQLDB.HSQL.Type.GeometricDB.HSQL.Type.TimeDB.HSQL.Type.NetAddressDB.HSQL.Type.Numeric DB.HSQL.CoreDatabase.HSQL.TypesDB.HSQL.Type.DiverseSqlType SqlUnknownSqlBLOBSqlSETSqlLongVarBinary SqlVarBinary SqlBinary SqlMacAddr SqlCIDRAddr SqlINetAddr SqlCircleSqlLine SqlPolygonSqlBoxSqlPathSqlLSegSqlPointSqlENUMSqlBitSqlYear SqlDateTimeTZ SqlDateTime SqlTimeStampSqlAbsTimeIntervalSqlTimeInterval SqlRelTime SqlAbsTime SqlTimeTZSqlTimeSqlDateSqlWLongVarChar SqlWVarCharSqlWCharSqlTextSqlLongVarChar SqlVarCharSqlCharSqlMoneySqlFloat SqlDoubleSqlReal SqlNumeric SqlDecimal SqlMedInt SqlTinyInt SqlSmallInt SqlBigInt SqlIntegerSqlErrorSqlClosedHandleSqlUnsupportedOperationSqlUnknownField SqlFetchNullSqlBadTypeCast seFieldName seFieldType SqlNeedDataSqlStillExecutingSqlInvalidHandle SqlNoDataseState seNativeError seErrorMsg sqlErrorTcSqlBindfromSqlCStringLen Statement ConnectionFieldDefCirclePolygonBoxPath ClosedPathOpenPathLinePointmktime mkClockTimecurrTZparseTZf_readreadHMSreadYMD readDateTimeMacAddrINetAddr c_strtollc_atoi closeHandle checkHandle sqlExceptionscatchSql handleSql disconnectexecutequerytablesdescribe inTransactionfetchcloseStatementgetFieldValueTypegetFieldsTypes getFieldValuegetFieldValueMBgetFieldValue' forEachRow forEachRow' collectRows toSqlValue fromSqlValuestmtConn stmtClose stmtFetch stmtGetCol stmtFields stmtClosedconnDisconnect connExecute connQuery connTables connDescribeconnBeginTransactionconnCommitTransactionconnRollbackTransaction connClosedbase GHC.Exception SomeException findFieldInfo