git.saurik.com Git - wxWidgets.git/blame_incremental

... / ...

Commit	Line	Data
	1	///////////////////////////////////////////////////////////////////////////////
	2	// Name: listdb.h
	3	// Purpose: wxWindows database demo app
	4	// Author: George Tasker
	5	// Modified by:
	6	// Created: 1996
	7	// RCS-ID: $Id$
	8	// Copyright: (c) 1996 Remstar International, Inc.
	9	// Licence: wxWindows licence
	10	///////////////////////////////////////////////////////////////////////////////
	11
	12	#ifdef __GNUG__
	13	#pragma interface "listdb.h"
	14	#endif
	15
	16	/*
	17	Contains dialog class for creating a data table lookup listbox
	18	*/
	19
	20	#ifndef LISTDB_DOT_H
	21	#define LISTDB_DOT_H
	22
	23
	24	#include <wx/dbtable.h>
	25
	26	const LOOKUP_COL_LEN = 250;
	27
	28	// Global database connection
	29	extern wxDB *READONLY_DB;
	30
	31	// Clookup class
	32	class Clookup : public wxTable
	33	{
	34	public:
	35
	36	char lookupCol[LOOKUP_COL_LEN+1];
	37
	38	Clookup(char tblName, char colName);
	39
	40	}; // Clookup
	41
	42	// Clookup2 class
	43	class Clookup2 : public wxTable
	44	{
	45	public:
	46
	47	char lookupCol1[LOOKUP_COL_LEN+1];
	48	char lookupCol2[LOOKUP_COL_LEN+1];
	49
	50	Clookup2(char tblName, char colName1, char colName2, wxDB pDb);
	51
	52	}; // Clookup2
	53
	54	class ClookUpDlg : public wxDialog
	55	{
	56	private:
	57	bool widgetPtrsSet;
	58	int currentCursor;
	59	Clookup *lookup;
	60	Clookup2 *lookup2;
	61	int noDisplayCols;
	62	int col1Len;
	63
	64	wxListBox *pLookUpSelectList;
	65	wxButton *pLookUpOkBtn;
	66	wxButton *pLookUpCancelBtn;
	67
	68	public:
	69
	70	// This is a generic lookup constructor that will work with any table and any column
	71	ClookUpDlg(wxWindow *parent,
	72	char *windowTitle,
	73	char *tableName,
	74	char *colName,
	75	char *where,
	76	char *orderBy);
	77
	78	//
	79	// This is a generic lookup constructor that will work with any table and any column.
	80	// It extends the capabilites of the lookup dialog in the following ways:
	81	//
	82	// 1) 2 columns rather than one
	83	// 2) The ability to select DISTINCT column values
	84	//
	85	// Only set distinctValues equal to true if necessary. In many cases, the constraints
	86	// of the index(es) will enforce this uniqueness. Selecting DISTINCT does require
	87	// overhead by the database to ensure that all values returned are distinct. Therefore,
	88	// use this ONLY when you need it.
	89	//
	90	// For complicated queries, you can pass in the sql select statement. This would be
	91	// necessary if joins are involved since by default both columns must come from the
	92	// same table.
	93	//
	94	// If you do query by sql statement, you must pass in the maximum length of column1,
	95	// since it cannot be derived when you query using your own sql statement.
	96	//
	97	// The optional database connection can be used if you'd like the lookup class
	98	// to use a database pointer other than the global READONLY_DB. This is necessary if
	99	// records are being saved, but not committed to the db, yet should be included
	100	// in the lookup window.
	101	//
	102	ClookUpDlg(wxWindow *parent,
	103	char *windowTitle,
	104	char *tableName,
	105	char *dispCol1, // Must have at least 1 display column
	106	char *dispCol2, // Optional
	107	char *where,
	108	char *orderBy,
	109	bool distinctValues, // e.g. SELECT DISTINCT ...
	110	char *selectStmt = 0, // If you wish to query by SQLstmt (complicated lookups)
	111	int maxLenCol1 = 0, // Mandatory if querying by SQLstmt
	112	wxDB *pDb = READONLY_DB, // Database connection pointer
	113	bool allowOk = TRUE); // is the OK button enabled
	114
	115	void OnCommand(wxWindow& win, wxCommandEvent& event);
	116	bool OnClose();
	117	void OnActivate(bool) {}; // necessary for hot keys
	118	};
	119
	120	#define LOOKUP_DIALOG 500
	121
	122	#define LOOKUP_DIALOG_SELECT 501
	123	#define LOOKUP_DIALOG_OK 502
	124	#define LOOKUP_DIALOG_CANCEL 503
	125
	126	#endif // LISTDB_DOT_H
	127
	128	// ********************************** listdb.h *******************************