C:/GCC/docs/DocSqlite/wxSqlite/wx_SQLite.h

#ifndef WX_SQLITE_H_INCLUDED
#define WX_SQLITE_H_INCLUDED

#include <vector>
#include <wx/wxSqlite/wxsqlite3.h>

 using namespace std;

//------------------------
// procedure acces DDS
//------------------------
enum Type_Zone {
     xInt    = 1,
     xDbl    = 2,
     xText   = 3,
     xDate   = 4,
     xBlod   = 5
     };


class wx_SQL
{
private:
     wxString  Merr ;
     bool      Berr  ;
     wxString Xsql ;

 // 1= entier  2 = num  3 = text  4 = Date  5 = blod(pas trt)
struct DDS
{
   DDS(int f, wxString n,wxString v, int t, int l,   int e, int p ,bool k , int o )
   : field(f), Name(n), wxVal(v), Type(t) , Lng(l),  Ent(e), Prs(p) , Key(k), Ord(o){}

   int field;
   wxString Name;
   wxString wxVal;
   int    Type;
   int    Lng;
   int    Ent ;
   int    Prs;
   bool   Key;
   int    Ord; // N°index key
};
// Key index -> DDS
struct KID
{
   KID(int f, wxString n ,wxString v, int d , int s)
   : field(f), Name(n), wxVal(v), Desc(d), Sel(s) {}

   int field;
   wxString Name;
   wxString wxVal;
   int Desc;    // descandant key = 1
   int Sel;     // selection  = 1  >= 0
};

struct KLF
{
   KLF(int f, wxString n ,wxString v, int d, int s)
   : field(f), Name(n), wxVal(v), Desc(d), Sel(s) {}

   int field;
   wxString Name;
   wxString wxVal;
   int Desc;     // descandant key = 1
   int Sel;      // selection  = 1  >= 0
};


//     const int KEY = 00 ; // position enum (swicht = 00 )
 public:

struct  F_FILE{
 wxSQLite3Database  db;
 wxSQLite3ResultSet qry;
 wxSQLite3Statement stm;
 wxSQLite3Table     tbl;

 std::vector<DDS>   ds ;  // Déf Data Structure
 std::vector<KID>   ki ;  // Key Index
 std::vector<KLF>   lg ;  // Key Index Logique
 int  slg[10];             // N° ordre de zone for Logique  where
 int  klg[10];             // N° ordre de zone for Logique  Key ASC
 wxString BD ;
 bool     OpnBD;
 } DDS_FILE;


 public:
   wx_SQL() ;
   virtual ~wx_SQL();
// erreur
bool  wx_SQL::F_Berr(){return Berr;};
const wxString wx_SQL::F_Merr(){return Merr;};

// initialisation des definitions Fields
void wx_SQL::F_Field(int nField, wxString nameField,wxString valeurField,
int typeField, int lenField,   int entierField =0,
 int precisionField =0,bool keyField = false , int ordrefield = 0);
// Initialisation Index
void wx_SQL::F_Index(int nField, wxString nameField,
wxString valeurField,bool keyField , int ordrefield);
// Initialisation Index pour lecture Logique
void wx_SQL::L_Index(int nField, wxString nameField,
wxString valeurField,bool keyField , int ordrefield);

// initialisation des Logiques
void wx_SQL::L_ValLGF( int i ,const wxString V_field = wxT(""));

// lecture des fields pour wxString
const wxString  wx_SQL:: F_GetDDS( int i );
// initialisation des fields pour wxString
void  wx_SQL::F_SetDDS( int i ,const wxString V_field );
// Open file .db3
void  wx_SQL::F_OpnDDS(wxString Fpath);
// fonction de creation Sqlite File  field
wxString wx_SQL::F_CrtDDS(wxString Fname);
// fonction de creation Sqlite File  Index
const wxString  wx_SQL::F_IdxDDS(wxString Fname);
// initialisation  de la base de données
bool wx_SQL::F_CrtTable(wxString Fname, bool index = false);
//  INSERT BD
bool wx_SQL::F_WrtDDS(wxString Fname);
//  UPDATE DB
bool wx_SQL::F_UpdDDS(wxString Fname);
//  UPDATE BD ( 1 Field)
bool wx_SQL::F_UpdDDSx(wxString Fname,unsigned int x);
//DELETE DB
bool wx_SQL::F_DltDDS(wxString Fname);
// Stell Index Unique
bool wx_SQL::F_ChainDDS(wxString Fname);

//*********************************************************
//*********************************************************
// Gestion Lecture sur logique
//*********************************************************
//*********************************************************

// Setll  read *all
bool L_RallDDS(wxString Fname);
// Setll  read *GE
bool L_ReadGeDDS(wxString Fname);
// Setll  readp *LE
bool L_ReadpLeDDS(wxString Fname);
};
#endif // WX_SQLITE_H_INCLUDED

---