How to read Triggers of a Database
-
Hey Friends I wish to create a database viewer which can a) list down records of tables b) list down fields of tables c) list down triggers of tables. I am stuck when i am tryint to list down triggers of tables. I am aware of CRecordset & CDatabae classes
-
Hey Friends I wish to create a database viewer which can a) list down records of tables b) list down fields of tables c) list down triggers of tables. I am stuck when i am tryint to list down triggers of tables. I am aware of CRecordset & CDatabae classes
Hey Friends I got it SELECT * FROM user_objects WHERE object_type='TRIGGER' Now the problem is that how we can read the trigger details i found using Desc statment but how to run DESC using MFC ? Thanks :-)
-
Hey Friends I got it SELECT * FROM user_objects WHERE object_type='TRIGGER' Now the problem is that how we can read the trigger details i found using Desc statment but how to run DESC using MFC ? Thanks :-)
What u meant by DESC statement ? You can run this statement using ADODB. use _RecordsetPtr->Open to execute the sql. cheers...mil10.
-
What u meant by DESC statement ? You can run this statement using ADODB. use _RecordsetPtr->Open to execute the sql. cheers...mil10.
Hey Thanks buddy By saying DESC i meant the Trigger Details I found a query for the same which i can run using CRecordSet & get the value :-) SELECT Table_name , Trigger_Name , Trigger_type , description, TRIGGER_BODY FROM ALL_TRIGGERS Regards
-
Hey Thanks buddy By saying DESC i meant the Trigger Details I found a query for the same which i can run using CRecordSet & get the value :-) SELECT Table_name , Trigger_Name , Trigger_type , description, TRIGGER_BODY FROM ALL_TRIGGERS Regards
If you want to develop a database program, i suggest u use VB - it is very easy to learn and very powerful for databse issues. If you want to learn database in VC, i suggest u throw CRecordSet and all its related classes (i.e. CDatabase) away - they are very ugly. the best classes in VC are Cdatabase etc (d is lowercase) - they are very flexable and powerful, VB uses them at background. once u know Cdatabase etc, you are a master. u are a slave for forever if using CDatabase etc.
A special image tool for Windows C++ programmers, don't miss it! The world unique Software Label Maker is waiting for you and me ... A nice hyper tool for optimizing your Microsoft html-help contents.
-
If you want to develop a database program, i suggest u use VB - it is very easy to learn and very powerful for databse issues. If you want to learn database in VC, i suggest u throw CRecordSet and all its related classes (i.e. CDatabase) away - they are very ugly. the best classes in VC are Cdatabase etc (d is lowercase) - they are very flexable and powerful, VB uses them at background. once u know Cdatabase etc, you are a master. u are a slave for forever if using CDatabase etc.
A special image tool for Windows C++ programmers, don't miss it! The world unique Software Label Maker is waiting for you and me ... A nice hyper tool for optimizing your Microsoft html-help contents.
hi, Sorry for the intereption. My little experience in database suggest that you should not use the MFC Database classes if you want to develop a database. Instead use the "xxado.dll" to develop your app. In the stdafx.h file write these lines include include #import "path\\xxado.dll" namespace "EOF, adoEOF" Then use ur desired objects as follows: CoInitialze(NULL); IConnectionPtr pCon; IRecordsetPtr pRes; pCon.Open(connectionstring); pRecordset.open(query,pCon ,etc); ... CoUninitialize();