|
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?
|
|
|
|
|
led mike wrote: Does that answer your question?
No. I am not asking for coding details. I am asking about policy - should it be possible with a disabled item?
|
|
|
|
|
I guess that depends on what a grayed.disabled tree-view item means in the
context of the application.
My first thought is "no, it shouldn't be allowed" but a grayed item could mean anything
we choose it to.
I'm pretty sure that answered NONE of your question 
Mark
Mark Salsbery
Microsoft MVP - Visual C++
![Java | [Coffee]](https://www.codeproject.com/script/Forums/Images/coffee.gif)
|
|
|
|
|
get out of my thread you fish-napper!
|
|
|
|
|
 Busted!
Mark Salsbery
Microsoft MVP - Visual C++
|
|
|
|
|
Hans Dietrich wrote: I am asking about policy
 Obviously I didn't get that from your OP.
Generally no, but there would certainly be exceptions based on your specific application. I mean it's a usability issue so if it makes sense from a usability stand point then, yes, do it.
Does that help?
|
|
|
|
|
Yes, you and Mark have confirmed my suspicion that there was no clear answer - unfortunately. 
Both of you have pointed out that there is no way of knowing why items are disabled, and therefore there can be no general policy regarding dragging them.
So I guess I have an answer. Thanks!
|
|
|
|
|
Hans Dietrich wrote: Thanks!
Your Welcome. The bottom line is your user. If it will help the user do it. If it's going to be confusing for the user don't. If you can't determine that, which is very likely, then do some usability testing and find out.
|
|
|
|
|
Hi
I'm facing some problem in standard MFC application. In my application, I'm able to run only 3 insatnces of my application simultaneously.That is, i'm able to open only three login screens at the same time, but I dont want this limitaton. I'm currently working in Windows XP. However, when I ran my application in Windows NT, only 4 instances can ber run at a time. When I tried to open it fourth time in Windows XP, it gets crashed at the following line of code.
//winfrm.cpp
BOOL CFrameWnd::Create(LPCTSTR lpszClassName,
LPCTSTR lpszWindowName,
DWORD dwStyle,
const RECT& rect,
CWnd* pParentWnd,
LPCTSTR lpszMenuName,
DWORD dwExStyle,
CCreateContext* pContext)
{
HMENU hMenu = NULL;
if (lpszMenuName != NULL)
{
// load in a menu that will get destroyed when window gets destroyed
HINSTANCE hInst = AfxFindResourceHandle(lpszMenuName, RT_MENU);
if ((hMenu = ::LoadMenu(hInst, lpszMenuName)) == NULL)
{
TRACE(traceAppMsg, 0, "Warning: failed to load menu for CFrameWnd.\n");
PostNcDestroy(); // perhaps delete the C++ object
return FALSE;
}
}
m_strTitle = lpszWindowName; // save title for later
if (!CreateEx(dwExStyle, lpszClassName, lpszWindowName, dwStyle,
rect.left, rect.top, rect.right - rect.left, rect.bottom - rect.top,
pParentWnd->GetSafeHwnd(), hMenu, (LPVOID)pContext))
{
TRACE(traceAppMsg, 0, "Warning: failed to create CFrameWnd.\n");
if (hMenu != NULL)
DestroyMenu(hMenu);
return FALSE;
}
return TRUE;
}
Can anybody please advise on this?
Chirag Kalra
|
|
|
|
|
Chirag_kalra wrote: Hi
I'm facing some problem in standard MFC application. In my application, I'm able to run only 3 insatnces of my application simultaneously.That is, i'm able to open only three login screens at the same time, but I dont want this limitaton. I'm currently working in Windows XP. However, when I ran my application in Windows NT, only 4 instances can ber run at a time. When I tried to open it fourth time in Windows XP, it gets crashed at the following line of code.
It looks like a lack of memory situation (or some other resource. Try running them while task manager is up and displaying resource usage.
Nathan
|
|
|
|
|
i want to write an exe program file,it can run stand alone,and also i want to make it possible that other programs can call functions exposed by the exe,just like call functions exposed by a dll file.
is that possible?
thanks for any reply.
|
|
|
|
|
Yes[^], just make sure to export the desired functions, just as you would do with a dll.
|
|
|
|
|
I have been checking the website to look for articles that explains how to make an instalator of an application coded. I didn't find many info. In one article I found one comment, where two third party programms are named. The "Inno Setup" and the "NSIS2". I would like to know what is your opinion about them (if you know them).
Any other information (like a link to an article that I didn't see, any other tutorial...) that can help me to know about how to do a "MyAppInstall.exe" will be wellcome.
Thank you for your answers.
Greetings.
--------
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
|
|
|
|
|
See this article http://www.codeproject.com/useritems/NSIS.asp[^]
Why is common sense not common?
Never argue with an idiot. They will drag you down to their level where they are an expert.
Sometimes it takes a lot of work to be lazy
Individuality is fine, as long as we do it together - F. Burns
|
|
|
|
|
My opinion about installers, in general, is that they can be a great waste of your development time. If you have a complex project to install and significant time to invest in creating an installer -- go for NSIS.
I hold the Nullsoft installer in high regard.
But, if you don't have the time and you don't need a fancy installer -- consider something simpler -- there's free commercial stuff out there. I use something called "Advanced Installer" (www.caphyon.com).
They have a free version!
I'd rather spend my limited time coding and debugging than futzing with the installer. And though installer seems like a small thing, trust me you will be investing some time in it.
Like all things in software, once you make a choice, you often have to live with it for a very long time. Choose wisely -- consider what works now and what will work later...
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~<br />
Peter Weyzen<br />
Staff Engineer<br />
<A HREF="http://www.soonr.com">SoonR Inc -- PC Power delivered to your phone</A>
|
|
|
|
|
hai all,
i want to know, if it is possible to lock a file, such that, nobody can delete it.
why i want this is, for my application, iam using file as the database, where all the user data and other data is available.
i remember that, long back, i used to lock a file from dosmode using ren command. but now iam unable to recall it. can any body remind that logic to me and also if this could be applied to solve my problem?
thanks.
|
|
|
|
|
The C runtime provides a _lock_file[^] function. You might just want to use permissions to deny your users delete authority on the file though. Probably a safer solution.
Nothing is exactly what it seems but everything with seems can be unpicked.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
