DBRecordODBC3 Class Reference

[DataWidget Index] [DataWidget Hierarchy]

More...

#include <dbrecordodbc3.h>

Inherits: DBRecord

Public Members

• DBRecordODBC3 (SQLHENV env, SQLHDBC dbc)
• virtual ~DBRecordODBC3 ()
• virtual bool isReadOnly ()
• virtual const QString &getErrorInfo ()
• virtual void setQuery (const QString &str, bool removeTables = false)
• virtual void addTable (const char *table, const char *primaries, const char *columns)
• virtual bool open ()
• virtual void close ()
• virtual bool refresh ()
• virtual bool first (bool *invalid)
• virtual bool prior (bool *invalid)
• virtual bool next (bool *invalid)
• virtual bool last (bool *invalid)
• virtual bool moveBy (bool *invalid, long)
• virtual bool moveTo (bool *invalid, long)
• virtual long getCursor ()
• virtual bool isDirty ()
• virtual bool cancel ()
• virtual bool update (bool *done = 0, bool force = false)
• virtual bool insert (bool *done = 0, bool force = false)
• virtual bool append (int todo)
• virtual bool remove ()
• virtual void backup ()
• virtual bool restore ()
• virtual int getNumCols ()
• virtual const char *getColumnName (int col)
• virtual const char *getColumnQualifierName (int col)
• virtual int getColumnType (int col)
• virtual const char *getColumnTypeName (int col)
• virtual long getColumnLength (int col)
• virtual int getColumnPrecision (int col)
• virtual int getColumnScale (int )
• virtual long getColumnDisplaySize (int col)
• virtual int getColumnNullable (int col)
• virtual int getColumnUnsigned (int col)
• virtual int getColumnMoney (int col)
• virtual int getColumnUpdatable (int col)
• virtual int getColumnAutoIncrement (int col)
• virtual long getNumRows ()
• virtual bool setValue (const DBField *field, int column, bool markDirty = true)
• virtual bool setParameter (const DBField *field, int column)
• virtual const DBField *getValue (int pos)
• virtual const DBField *getParameter (int pos)
• static void getErrorInfo (char *info, long errorcode, SQLHENV henv, SQLHDBC hdbc, QString *error)
• static bool connect (char *dsn, SQLHENV *henv, SQLHDBC *hdbc, QString *error)

Protected Members

• SQLHENV henv
• SQLHDBC hdbc
• SQLHSTMT hstmt
• SQLHSTMT hwstmt
• bool paramOk
• bool fieldOk
• QString query
• DBTableDescription *table
• bool dbReadOnly
• SQLSMALLINT numCols
• DBColumnDescription *colDesc
• DBField *orgRecord
• DBField *record
• DBField *backupRecord
• long currentCursor
• long backupCursor
• SQLSMALLINT numParams
• DBColumnDescription *paramDesc
• SQLSMALLINT maxParams
• DBField *param
• QString errorInfo
• DBRecordODBC3 **autoIncQuery
• int numAutoInc
• bool assertWriteHandle ()
• void assertTableDef ()
• void setError (char *info, long errorcode, SQLHSTMT stmt = 0)
• bool initInfo (SQLHSTMT hstmt)
• bool initParams (SQLHSTMT hstmt)
• bool getCharAttr (SQLHSTMT hstmt, int col, int type, char *buffer)
• bool getIntAttr (SQLHSTMT hstmt, int col, int type, int *res)
• bool getLongAttr (SQLHSTMT hstmt, int col, int type, long *res)
• virtual bool doUpdate (DBTableDescription *t, bool *done, bool force)
• virtual bool doInsert (DBTableDescription *t, bool *done, bool force)
• virtual bool doRemove (DBTableDescription *t)
• virtual DBField *getField (int pos)
• virtual DBField *getParam (int pos)
• bool init (bool keepOpen = false)
• virtual bool validate (int todo)
• virtual void invalidate (bool work, bool org)
• virtual bool prepareAutoIncrement (int col)
• virtual bool processAutoIncrement (int col)
• void deleteAutoIncQuery ()
• bool createAutoIncQuery (int col)

virtual bool validate(int todo)

Initializes the working area with valid fields.

Parameters:

todo	SetCopy fetches the values from the database. SetZero init to 0 or "". SetNull init null values SetAutoNull init autoincrement columns for generating a new value

virtual void invalidate(bool work, bool org)

Initializes the working area with invalid values.

Parameters:

org	Initializes the storrage used to cancel setValue().
work	Initializes the storrage used by setValue().