Uses of Class
generalDatabase.SQLTypes

Packages that use SQLTypes

Package	Description
generalDatabase
generalDatabase.pamCursor

Uses of SQLTypes in generalDatabase

Subclasses of SQLTypes in generalDatabase

Modifier and Type	Class and Description
class	MSAccessSQLTypes
class	MySQLSQLTypes
class	OOoDBSQLTypes
class	UCanAccessSqlTypes

Methods in generalDatabase that return SQLTypes

Modifier and Type	Method and Description
SQLTypes	UCanAccessSystem.getSqlTypes()
SQLTypes	OOoDBSystem.getSqlTypes()
SQLTypes	MySQLSystem.getSqlTypes()
SQLTypes	MSAccessSystem.getSqlTypes()
abstract SQLTypes	DBSystem.getSqlTypes() Get the SQLTypes object which can be used to preform system specific formatting of SQL strings.

Methods in generalDatabase with parameters of type SQLTypes

Modifier and Type	Method and Description
static boolean	TableUtilities.addColumn(java.sql.Connection con, SQLTypes sqlTypes, java.lang.String systemName, EmptyTableDefinition tableDef, PamTableItem tableItem)
java.lang.String	EmptyTableDefinition.getBasicSelectString(SQLTypes sqlTypes)
java.lang.String	EmptyTableDefinition.getSQLInsertString(SQLTypes sqlTypes) gets an sql insert string for the table that selects all fields.
java.lang.String	PamTableDefinition.getSQLSelectString(SQLTypes sqlTypes)
java.lang.String	EmptyTableDefinition.getSQLSelectString(SQLTypes sqlTypes) Get a very basic select string which queries for all items in the table, no ordering or selection
java.lang.String	PamTableDefinition.getSQLSelectString(SQLTypes sqlTypes, PamViewParameters pamViewParameters) gets an sql select string for the table that selects all fields.

Uses of SQLTypes in generalDatabase.pamCursor

Methods in generalDatabase.pamCursor with parameters of type SQLTypes

Modifier and Type	Method and Description
java.lang.String	PamCursor.getInsertString(SQLTypes sqlTypes)
java.lang.String	PamCursor.getSelectString(SQLTypes sqlTypes, boolean includeKeys, boolean includeCounters, boolean orderById) Generate a standard SQL select string for everything in the table.
java.lang.String	PamCursor.getSelectString(SQLTypes sqlTypes, boolean includeKeys, boolean includeCounters, java.lang.String clause) Generate an SQL select string with an optional clause which may include WHERE and ORDER
java.lang.String	PamCursor.getUpdateString(SQLTypes sqlTypes)