|
You can execute SQL commands...like this
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF", "EndOfFile")
_bstr_t strConn("DRIVER={Microsoft Access Driver (*.mdb)};DBQ=yourdatabase.mdb");
_ConnectionPtr pCn("ADODB.Connection");
kl.Format("INSERT INTO ...);
pCn->Open(strConn, "", "", adConnectUnspecified);
pCn->Execute((_bstr_t)kl ,NULL, adCmdText);
pCn->Close();
i hope this helps
|
|
|
|
|
any idea how I could run a sybase stored procedure from there? for example. I have an array for names. names[]. I want to pass the array into a sybase stored procedure within my database called storenames. any idea on how I could do that?
ICXC
NIKA
|
|
|
|
|
You could always use ODBC. There are many simple wrapper classes that make it very painless to do. I have been using a set of ODBC wrappers for many years now and have had no problems with sybase, oracle, MSSQL, Access, etc. Additionally, if you are just executing statements/sprocs and using fwd only result set fetching, odbc is a little faster than using ATL/OLEDB. If you need wrapper classes, send me an email and I can set you up.
|
|
|
|
|
I am trying to use a property page inside of a few different dialogs.. but i can't get it to show up.. if i take my property page and use it with CSAPrefsDialog (a netscape style options dialog on CP) it shows up.. but in my dialog all i see is the black frame of the static control.. heres what i have:
BOOL MyDialog::OnInitDialog()
{
CDialog::OnInitDialog();
m_boundingFrame.GetWindowRect(m_frameRect);
ScreenToClient(m_frameRect);
CMyChooser Chooser;
if (!::IsWindow(Chooser.m_hWnd))
Chooser.Create(IDD_MYCHOOSER, this);
if (::IsWindow(Chooser.m_hWnd))
{
Chooser.MoveWindow(m_frameRect.left, m_frameRect.top, m_frameRect.Width(), m_frameRect.Height());
Chooser.ShowWindow(SW_SHOW);
Chooser.SetFocus();
Invalidate();
RedrawWindow();
}
return TRUE;
} I've tried returning FALSE, and I've traced through, everything gets called, but nothing shows up.. my static frame has everything set to false except 'Visible' (which ive tried false as well), and has Type set to 'Frame'.
basicly i just want to be able to place this property sheet(MyChooser) into several different dialogs.. but i cant get it to show up anywhere.. anyone know why?
thanks!
-dz
|
|
|
|
|
CMyChooser is being declared locally on the atck. It goes out of scope at the end of the procedure, which probably destroys all the windows you have created. Make is a member variable of the MyDialog class as a 1st step.
Roger Allen
Sonork 100.10016
If I had a quote, it would be a very good one.
|
|
|
|
|
thanks a ton!
ya.. im still learning..
-dz
|
|
|
|
|
I have placed CPropertyPage(s) on a CPropertSheet (using the CPropertySheet member function AddPage() and then called the DoModal() member function of the CPropertySheet to do this sort of thing.
I have some notes on my method... if you haven't solved this one yet let me know.
|
|
|
|
|
Please give me an example hoe to use dbsetlsecure.
|
|
|
|
|
And the Lord came down from the heavens and spaketh, "thou shalt not helpth thy ACs."
Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311
"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses
|
|
|
|
|
Sounds like Shakespeare
modified 12-Sep-18 21:01pm.
|
|
|
|
|
Thou hath brought forth Shakespearian commentary to thine plate of conversion! And so I say unto you that speaketh, beith of good manner and cheer. And, Forgeteth not that ACs cascadeth from within thine realm of thy unworthy.
Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311
"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses
|
|
|
|
|
But doeseth thy have a answer for the original question?
Roger Allen
Sonork 100.10016
If I had a quote, it would be a very good one.
|
|
|
|
|
Doth thou fancieth an answer? If thou would have thine desire of thy AC I shall provideth info. I shan't directly doeth such for ACs.
Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311
"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses
|
|
|
|
|
you probably forget when you were a student...
|
|
|
|
|
I remember quite well actually, because I never stop learning I still am a student as far as I am concerned. I also remember never being afraid to ask a question. It's how we learn. And, just because I'm not asking a question at the moment on this board, doesn't mean I still don't ask 'em.
Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311
"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses
|
|
|
|
|
Jeremy Falcon wrote:
And, just because I'm not asking a question at the moment on this board, doesn't mean I still don't ask 'em
Prove it! Ask a stupid question! I dare ya.....na na na na naaaaa!
Roger Allen
Sonork 100.10016
If I had a quote, it would be a very good one.
|
|
|
|
|
Roger Allen wrote:
I dare ya
Look up!
Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311
"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses
|
|
|
|
|
damn. I answered that will full sincerity there (or did you really not know the answer to that?)
--
Help me! I'm turning into a grapefruit!
|
|
|
|
|
LOL
Roger Allen
Sonork 100.10016
If I had a quote, it would be a very good one.
|
|
|
|
|
benjymous wrote:
or did you really not know the answer to that?
I knew that one already - sorry!
Jeremy L. Falcon<nobr>
Homepage : Sonork = 100.16311
"But everybody darlin' sometimes bites the hand that feeds."
"Remember in this game we call life that no one said it's fair."
"Just because you're winnin' don't mean you're the lucky ones."
Song: Breakdown - Album: Use Your Illusion II - Artist: Guns N' Roses
|
|
|
|
|
|
So my helpfulness wasn't totally wasted then
--
Help me! I'm turning into a grapefruit!
|
|
|
|
|
Ok, kid, since the hot air is getting thick...
PLOGINREC pLoginRec = dblogin();
if (pLoginRec)
{
DBSETLSECURE(pLoginRec);
// now, you do not have to set user/login
// with DBSTLUSER and DBSETLPWD since it
// will use the NT User to authenticate (or not)
PDBPROCESS pDBConnection = dbopen(pLoginRec, "MYSQLSERVER");
dbfreelogin (pLoginRec); // free it right away
if (pDBConnection)
{
// exec sql statements....
dbclose(pDBConnection);
}
}
|
|
|
|
|
Basementman, Thank you.
|
|
|
|
|
Anyone knows how to deal with ghost windows in XP? How to get rid of the ghost windows in windows XP system with Platform SDK? Thanks.
Windows XP: If a top-level window stops responding to messages for more than several seconds, the system considers the window to be hung and replaces it with a ghost window that has the same Z order, location, size, and visual attributes. This allows the user to move it, resize it, or even close the application. However, these are the only actions available because the application is actually hung. When in the debugger mode, the system does not generate a ghost window.
reference from MSDN.
|
|
|
|