|
How do I use CDatabase and CRecordset to return a list of tables in a given database. I am connecting sucessfully to a MySQL server on a unix machine. I know this because I can pass a SELECT * FROM query and get a populated recordset in return.....however when I try "SHOW TABLES FROM db_name" I get an assertion error.
Thanks.
|
|
|
|
|
|
JKallen wrote: ...when I try "SHOW TABLES FROM db_name" I get an assertion error.
What line of what file is asserting?
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Class CSDITest1Doc creates a new instance of a dialog class. Works OK. Example below:
CTestDlg* aDlg = new CTestDlg(); //code is in CSDITest1Doc
From class CSDITest1Doc I can execute functions of the new CTestDlg. For example, LoadMessage() is a function of CTestDlg. Works OK. Example below:
aDlg->LoadMessage(); //this code is in CSDITest1Doc
Sometimes I want to alert CSDITest1Doc of something that happens in CTestDlg. Sometimes I want CTestDlg to ask for data from CSDITest1Doc. Suppose XYZ() is a function of CSDITest1Doc. How do I execute a XYZ()of CSDITest1Doc from CTestDlg?
|
|
|
|
|
Oliver123 wrote: How do I execute a XYZ()of CSDITest1Doc from CTestDlg?
One way is to pass a CSDITest1Doc pointer to the CTestDlg instance.
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
I tried this, but found I didn't really know what to load into the pointer. In CSDITest1Doc I entered the following code. I figured if I could get the pointer aDoc loaded with the address of the instance of CSDITest1Doc, I could call a function from CTestDlg, and use that to pass the pointer to CTestDlg.
CSDITest1Doc* aDoc;<br />
aDoc = ???????
Is this a correct approach?
Thanks
|
|
|
|
|
Oliver123 wrote: Is this a correct approach?
No. Try:
CTestDlg* aDlg = new CTestDlg(this); Remember to create an appropriate CTestDlg constructor.
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Re: Entering Negative values in MSVS 6.0 Edit dialogs.
Has anyone found a solution or work around for the problem with entering a “negative” value in an Edit-Control Dialog box?
When a ‘int type’ is specified and validation is used or not, the same “Enter a Number Error” dialog is displayed when the first entry is the “ - “ key! 
I am aware of one work around first enter the number, then use HOME key, and then enter the – key, but this is very clumsy and many users would not know to use this.
Ralph_L
|
|
|
|
|
Ralph_L wrote: in MSVS 6.0 Edit dialogs.
What is an "MSVS 6.0 Edit dialog"? You mean like where you enter the number of spaces to use for a Tab? Why would you put a negative number in there?
|
|
|
|
|
MSVS 6.0 is Microsoft Visual Studio ver 6.0 for C++/MFC.
The Edit box is a Dialog Edit box where one can enter value into.
Ralph_L
|
|
|
|
|
Ralph_L wrote: When a ‘int type’ is specified and validation is used or not, the same “Enter a Number Error” dialog is displayed when the first entry is the “ - “ key!
Because "-" is not a numeric character. Use a masked edit control.
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Hey! I was fishing in here and had not bagged my limit .... yet! 
|
|
|
|
|
Thank for the reply David,
Would you please explain 'masked edit control' and provide sample perhaps? 
This is an Edit box in a Dialog base application, and made via the Resource Editor.
Ralph_L
|
|
|
|
|
Ralph_L wrote: Would you please explain 'masked edit control' and provide sample perhaps?
See here.
"Normal is getting dressed in clothes that you buy for work and driving through traffic in a car that you are still paying for, in order to get to the job you need to pay for the clothes and the car and the house you leave vacant all day so you can afford to live in it." - Ellen Goodman
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
|
|
|
|
|
Create a class derived from CEdit, let us call it CIntEdit, and handle WM_CHAR message:
void CIntEdit::OnChar(UINT nChar, UINT nRepCnt, UINT nFlags)
{
//Allowed characters
CString numeric = "-0123456789.";
if (numeric.Find(nChar) != -1)
CEdit::OnChar(nChar, nRepCnt, nFlags);
}
This will only accept integer values.
Pierre.
|
|
|
|
|
Thanks Pierre, I will give this a try.
Ralph_L
|
|
|
|
|
Lets see if I can describe this clearly without writing a book. I have a DAO process in place that is updating one or more records for a given table. During this process when a certain value change or event occurs I make a call to a stored procedure to update a value (in a different table) thru ADO. When all the editing is done and the user exits the dialog, I get the following DAOexception message; The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data...
1) Is there a way I can let DAO know that my ADO call is okay to run?
2) What is happening under the hood? Are the DAO changes queued up and made at the end? If so, may these be accessed so the ADO call may be performed after DAO is happy(changes commited)?
Thank you.
|
|
|
|
|
I'm just guessing here.... your using MS Access? You are using two different drivers (Jet vs. ADO[OLE DB... ODBC... whatever]) so access sees two different users. Access is not reliable as a multi-user database.
Suggestion: switch to the SQL Desktop database product, I don't know what the name is this hour, and only use a single driver to access it.
|
|
|
|
|
Its a very complicated system, and it uses ACCESS linked thru to MS SQL Server. My understanding is that we are planning a switch to SQL Desktop, but getting there will be a lengthy process (and outside of my control/responsibilities).
Is there a way to call a stored proc (passing parameters) using DAO? And can it be performed while the other DAO process is active?
-- modified at 16:11 Friday 2nd November, 2007
|
|
|
|
|
littleGreenDude wrote: Its a very complicated brittle system
littleGreenDude wrote: Is there a way to call a stored proc (passing parameters) using DAO?
I don't know, I haven't used DAO for like 6 or 7 years now, it's just a bad idea. My memory is that DAO is for JET. JET does not have stored procedures it has "Queries". My memory is that the queries can have parameters and you can call them from DAO. But it's still a bad idea here's why:
If it works, do it
-----------------
If it works, do it it works
-----------------
seems to probably
^ ^
If it ^ works, do it it ^ works
-----------------
seems to probably
^ ^
If it ^ works, do it it ^ works
^
^
(and it might work again )
(although, admitedly, that is an assumption )
|
|
|
|
|
I'm looking for someone to help teach me C++, C# and VB and answer questions via phone. I just installed Visual Studio 2008 Beta 2 and I haven't touched Visual Studio since 6.0, so I am a bit out of date. Also, I'm entirely self-taught, so I would like someone who can show me how to start from scratch and set things up 'correctly'. My focus is on creating a simple C++ form app using CLR specifically for Vista. I need to know the correct method for reading/writing files, and I would like to learn how to use RegisterPowerSettingNotification to catch the WM_POWERBROADCAST message in C++, C# and VB. If you can control a serial port, that would be great too.
Currently I am creating an application to control my home projector, but this is really just to help me come up to speed again. I can pay $25-30/hr via paypal. The calls can be done in off-hours late nights and weekends.
My email address is ima_computer@yahoo.com, thanks!
- Ed
|
|
|
|
|
Ed, don't cross post. Use the Jobs board for this announcement. There's a link to it in the left column on the home page.
|
|
|
|
|
Did you work with c++ previous or do you know c++? or C#
|
|
|
|
|
If you have a disabled/grayed item in a tree control, should it be possible to drag it to another location? Should it be possible to drop another item on it?
|
|
|
|
|
Do you have any knowledge of Drag and Drop, with anything? With a tree control?
You will receive the messages at the Tree Control level not the item level. You have to do the item level work from the control level message.
Does that answer your question?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
