Click here to Skip to main content
16,016,613 members
Home / Discussions / C / C++ / MFC
   

C / C++ / MFC

 
AnswerRe: How can save COLORREF value in access database ? Pin
CPallini16-Nov-08 21:38
mveCPallini16-Nov-08 21:38 
Questionset monitor frequency Pin
ani_ikram16-Nov-08 19:33
ani_ikram16-Nov-08 19:33 
AnswerRe: set monitor frequency Pin
Hamid_RT16-Nov-08 20:41
Hamid_RT16-Nov-08 20:41 
QuestionCreating a setup for installtion of MFC Application Pin
Dhiraj kumar Saini16-Nov-08 19:30
Dhiraj kumar Saini16-Nov-08 19:30 
AnswerRe: Creating a setup for installtion of MFC Application Pin
santhoshv8416-Nov-08 19:41
santhoshv8416-Nov-08 19:41 
AnswerRe: Creating a setup for installtion of MFC Application Pin
ani_ikram16-Nov-08 19:48
ani_ikram16-Nov-08 19:48 
AnswerRe: Creating a setup for installtion of MFC Application Pin
Hamid_RT16-Nov-08 20:37
Hamid_RT16-Nov-08 20:37 
QuestionAccessing column data from multiple tables in oracle 10g to a single form of SDI Application Pin
Divya Lalwani16-Nov-08 19:22
Divya Lalwani16-Nov-08 19:22 
I can access all data from a single table.But If I want to access selected data from multiple tables then I get an error after executing.

ERROR: ORA-00903: invalid table name
DSN Name: om_ebridge.
Oracle User Name: SCOTT
Table Names: Transaction_Master,Transporter_Master,Supplier_Master,Product_Master.

CString CMyebridgeSet::GetDefaultConnect()
{
return _T("ODBC;DSN=om_ebridge");
}

CString CMyebridgeSet::GetDefaultSQL()
{
//return _T("[SCOTT].[TRANSACTION_MASTER]");(works to access data from single table.)

(But ERROR occurs if the below mentioned INNER JOIN is used to access selected data from multiple tables .Can you please help me access data).

return _T("SELECT TRANSACTION_MASTER.TRANSACTION_CODE,TRANSACTION_MASTER.VEHICLE_NO,TRANSACTION_MASTER.OPERATING_MODE,")
_T("TRANSPORTER_MASTER.transporter_name,SUPPLIER_MASTER.SUPPLIER_NAME,")
_T("PRODUCT_MASTER.PRODUCT_NAME,TRANSACTION_MASTER.unit,TRANSACTION_MASTER.Gross_Wt,TRANSACTION_MASTER.Gross_WtTime,")
_T("TRANSACTION_MASTER.Tare_Wt,TRANSACTION_MASTER.Tare_WtTime,TRANSACTION_MASTER.CONTAINER1_TAREWT,")
_T("TRANSACTION_MASTER.CONTAINER2_TAREWT ,TRANSACTION_MASTER.net_Wt,TRANSACTION_MASTER.Challan_no,TRANSACTION_MASTER.Challan_Wt,")
_T("TRANSACTION_MASTER.No_Of_Units,TRANSACTION_MASTER.Calculated_Wt,TRANSACTION_MASTER.Formula1,")
_T("TRANSACTION_MASTER.Formula2,TRANSACTION_MASTER.Formula3,TRANSACTION_MASTER.Formula4,")
_T(" TRANSACTION_MASTER.location_code,TRANSACTION_MASTER.field1,TRANSACTION_MASTER.field2,TRANSACTION_MASTER.field3 ")

_T("from PRODUCT_MASTER INNER JOIN SUPPLIER_MASTER INNER JOIN TRANSACTION_MASTER")
_T("ON SUPPLIER_MASTER.SUPPLIER_CODE =TRANSACTION_MASTER.SUPPLIER_CODE")
_T("ON PRODUCT_MASTER.PRODUCT_CODE=TRANSACTION_MASTER.PRODUCT_CODE")
_T("INNER JOIN TRANSPORTER_MASTER ON TRANSPORTER_MASTER.TRANSPORTER_CODE=TRANSACTION_MASTER.TRANSPORTER_CODE ");
}
QuestionExecuting program error. Pin
Nikesh Jagtap16-Nov-08 18:47
Nikesh Jagtap16-Nov-08 18:47 
QuestionRe: Executing program error. Pin
David Crow17-Nov-08 3:27
David Crow17-Nov-08 3:27 
QuestionWrite data n PDF and Excel Pin
MsmVc16-Nov-08 17:18
MsmVc16-Nov-08 17:18 
AnswerRe: Write data n PDF and Excel Pin
Hamid_RT16-Nov-08 17:56
Hamid_RT16-Nov-08 17:56 
QuestionIncorrect binary path set during Win32 Service installation Pin
Member 569752116-Nov-08 16:00
Member 569752116-Nov-08 16:00 
Questionminimum spanning tree Pin
Sadaiyappan16-Nov-08 9:54
Sadaiyappan16-Nov-08 9:54 
AnswerRe: minimum spanning tree Pin
Sarath C16-Nov-08 19:11
Sarath C16-Nov-08 19:11 
Questionhey plz fix this code it got errors urgent Pin
jazikhan00116-Nov-08 8:46
jazikhan00116-Nov-08 8:46 
AnswerRe: hey plz fix this code it got errors urgent Pin
Peter Weyzen16-Nov-08 9:46
Peter Weyzen16-Nov-08 9:46 
GeneralRe: hey plz fix this code it got errors urgent Pin
jazikhan00116-Nov-08 9:50
jazikhan00116-Nov-08 9:50 
AnswerRe: hey plz fix this code it got errors urgent Pin
22491717-Nov-08 12:42
22491717-Nov-08 12:42 
AnswerRe: hey plz fix this code it got errors urgent Pin
Iain Clarke, Warrior Programmer18-Nov-08 2:40
Iain Clarke, Warrior Programmer18-Nov-08 2:40 
QuestionA beginner question about winforms in VC++ Pin
Pedram Behroozi16-Nov-08 4:42
Pedram Behroozi16-Nov-08 4:42 
AnswerRe: A beginner question about winforms in VC++ Pin
Mark Salsbery16-Nov-08 6:14
Mark Salsbery16-Nov-08 6:14 
GeneralRe: A beginner question about winforms in VC++ Pin
Pedram Behroozi16-Nov-08 7:42
Pedram Behroozi16-Nov-08 7:42 
AnswerRe: A beginner question about winforms in VC++ Pin
Jijo.Raj16-Nov-08 7:07
Jijo.Raj16-Nov-08 7:07 
GeneralRe: A beginner question about winforms in VC++ Pin
Pedram Behroozi16-Nov-08 7:47
Pedram Behroozi16-Nov-08 7:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.