Hi i need a simple interface for visually building SQL queries with access database (supporting inner joins) every comments and helps appreciated :) PS. in a simple reporting system for end-user if fields from main tables are selected for output and the other tables are hidden to user (we dont like to show him the structure), i am going to traverse relations and build the appropriate inner join clause for query :doh:

Hi I suggest u to use another Thread for database retrival while ur main msg loop handle user and system msgs. also if u make a single QUERY for 6 table if it is possible it make ur jobs faster. Bye:)

Hi You can find it ksMedia.h header file Cheers :cool:

MFC: double dblValue = sqrt(2); CString csText; csText.Format("%f",dblValue); C: char Buffer[256]; double dblValue = sqrt(2); sprintf(Buffer,"%f",dblValue); :~

change these lines 1. CArray <CRealPoint,CRealPoint&> m_arrPo; . . . 6 CRealPoint &newPoint = m_arr.ElementAt(0); // ElementAt return ref to ob or 6 CRealPoint newPoint = m_arr.GetAt(0); // GetAt return ob and need copy constructor that ur class have it. BTW. CRealPoint newPoint = m_arr.ElementAt(0); is also correct :)

this is my beta code use it if it's useable for u (up to DXF14) //////////////////////////////////////////////////////////////// _READ.h: interface for the CDXF_READ class. // ////////////////////////////////////////////////////////////////////// #if !defined(AFX_DXF_READ_H__0C34F7F9_A3E2_11D2_B76C_CAED36AA095C__INCLUDED_) #define AFX_DXF_READ_H__0C34F7F9_A3E2_11D2_B76C_CAED36AA095C__INCLUDED_ #if _MSC_VER > 1000 #pragma once #endif // _MSC_VER > 1000 /////////warnnigs < 1000 #define ER_NOTABLEHEADER -993 #define ER_VOIDBLOCKS -994 #define ER_VOIDHEADER -995 #define ER_VOIDTABLES -996 #define ER_FILECORRUPT -997 #define ER_NOENDSEC -998 #define ER_MISSEDENDOFFILE -999 ////////////////// #define ER_WARNNIG -1000 /////////errors > 1000 #define ER_INVALIDFILENAME -1001 #define ER_NOSUCHFILE -1002 #define ER_BADVALUE -1003 #define ER_VOIDENTITY -1004 #define ER_BADTABLES -1005 #include "..\drw_dxf.h" class CDXF_FILE { CStdioFile m_file; CString m_str; public : int Open(LPCSTR); void Close(); CDXF_FILE (); virtual ~CDXF_FILE (); double ReadDouble(); float ReadFloat(); __int8 ReadInt8(); __int16 ReadInt16(); __int32 ReadInt32(); BOOL EndOfFile(); BOOL ReadString(CString&); private: BOOL m_fileColse; }; class CDXF_READ { public: BOOL ProcessSystemMsg(); struct DXF_RECORD { int what; __int8 m_int8; __int16 m_int16; __int32 m_int32; double m_double; float m_float; CString m_string; } Rec; int Read_DXF_Line(); CDXF_READ(); CDXF_READ(LPCSTR dxf_file); virtual ~CDXF_READ(); int Process_Free_DXF(LPCSTR dxf_file=NULL); int Process_DXF(LPCSTR dxf_file=NULL); private: BOOL GroupCircle; BOOL EndOfFileReached; BOOL NOT_READ_BEFOR; CDXF_FILE fileDXF; int Process_EndOfFile(); int Process_Entites(BOOL READ_SECTION = TRUE); int Process_Tables(BOOL READ_SECTION = TRUE); int Process_Blocks(BOOL READ_SECTION = TRUE); int Process_Header(BOOL READ_SECTION = TRUE); int Open_DXF_File(); ////////////tables section int Parse_LayerInfo(); int Parse_TableItemInfo(); ////////////entities section int Parse_LineInfo(); int Parse_PolyLineInfo(); int Parse_LWPolyLineInfo(); int Parse_CircleInfo(); int Parse_ArcInfo(); int Parse_TextInfo(); int Parse_MTextInfo(); int Parse_SolidInfo(); int Parse_PointInfo(); int Parse_InsertInfo(); int Parse_SeqendInfo(); int Parse_