|
Guys,
I have a VC++/MFC app that connects to a SQL Server database. My application needs to take some action when a particular table in the database is inserted with a new record.
The traditional method would be to continously check the table that I am interested in and pull the record out. Is there any other way by which my app can be notified when a particular table on the database is inserted with a new record.
Thanks a bunch in advance for reading through my issue,
Best,
Mustufa Taj
Software Developer
|
|
|
|
|
Just a thought, can you set up a trigger in the database?
A trigger that fires at an insert-command?
And then make that database trigger to fire an event that you can catch in your program?
If it's possible, it seems to me as the most effecient way to do it.
|
|
|
|
|
kakan wrote: Just a thought, can you set up a trigger in the database...it seems to me as the most effecient way to do it.
I agree.
"One must learn from the bite of the fire to leave it alone." - Native American Proverb
|
|
|
|
|
|
Hello, everyone!
When I run my program in debug mode, (use vc7), the
debugger say : can find xxx.dll, this dll is used in my
program, how can I let the debugger find the dll?
where should i add the dll path?
Please tell me , thank you!
|
|
|
|
|
add the dll file to your solution/project; just like u add cpp/h files.
"Do first things first, and second things not at all."
— Peter Drucker.
|
|
|
|
|
Thank you for your replay.
If I add dll to the path of my project's exe, it is ok.
But I donn't think it's a good way to resolve this problem.
I think perhaps VC7 had some where I can add dll's path,
and when in debug mode, it can find.
But where? do you know?
|
|
|
|
|
chenxiujie wrote:
I think perhaps VC7 had some where I can add dll's path,
and when in debug mode, it can find.
how are you calling the DLL from your project i.e. are you are using LoadLibrary or GetProcAddress combination or provides Project with DLL lib file.
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
Sorry, I donn't know the meaning of yours "provides Project with DLL lib file", can you explain it first? Thank you.
|
|
|
|
|
when you link the dll statically(you don't link it with LoadLibary), then you need this *.lib file to compile.
for your case, seems you link it dynamically,if you want to compile that dll also, I recommond you group that dll project to your project and output files to a same directory, or you have to add the dll file to your output file's directory.
life is just like a box of chocolate,you never know what you r going to get.
|
|
|
|
|
Thank you.
I know your meaning, and now I just put the dll into the
exe path, it can be debug now.
This problem is made by others , what I do is add some functions to it. I feel very strange for one things:
when it compile in release mode, it compile with *.lib,
but when it compile in debug mode , it compile with *.dll
I donn't know why did as thest.
It's a service program, and when it run in debug mode, it always exit at the function: "::StartServiceCtrlDispatcher()"
But in release mode it can run normal,
Do you know the reason , can you help me, thank you!
|
|
|
|
|
Did you only add it to the debug configuration? If so make sure it is in the release configuration as well.
Elaine ![Rose | [Rose]](https://www.codeproject.com/script/Forums/Images/rose.gif)
The tigress is here 
|
|
|
|
|
Thank you.
But in release mode it use *.lib, not *.dll.
So I donn't need to add in release configuration.
|
|
|
|
|
The NULL Developer wrote:
add the dll file to your solution/project; just like u add cpp/h files.
How can you add DLL to a Project ?  ..
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
Project->Add to Porject->Files, in the dialog box, set filetype to "Executable files", choose your dll, it is added to the Project.
~RaGE();
|
|
|
|
|
Rage wrote:
Project->Add to Porject->Files, in the dialog box, set filetype to "Executable files", choose your dll, it is added to the Project.
Now how to use that dll with project?
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
Rage wrote:
Project->Add to Porject->Files, in the dialog box
Then How to use that DLL in your Project?
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
What you say is in vc6, How about in vc7? Perhaps it's the following:
1.select "Project"->"Project Dependencies" ?
But here couldn't "add" only can select modules.
|
|
|
|
|
I am currently debugging a program that stores large amounts of data. Every 15 minutes 1000 pieces of data are calculated and written to a text file. This file is now 250 MB and getting very difficult to deal with. It crashes when opening, things crash when it is loaded, etc. Overall it was not written well.
My job is to fix it, but I am not sure where to start. My coworkers have suggested splitting the file up so that every month a new file is generated, and only the last years worth of files are loaded, unless the user needs more.
Another suggestion was using a binary file instead of text.
Another suggestion was to convert the text file to a database. Someone thought that Access might not be able to handle a record with 1000 pieces of data.
I have a lot of research to do, but I thought that this might help me in the right direction!! Any ideas you have would be greatly appreciated.
Jennifer
|
|
|
|
|
If you choose to use a binary file (recommended, imho) you may want to see this[^] series of articles.
/ravi
My new year's resolution: 2048 x 1536
Home | Music | Articles | Freeware | Trips
ravib(at)ravib(dot)com
|
|
|
|
|
Well, if you dont want to read the whole file, you dont need to load the whole file.
That is, when first loading the file, load text from the file that fills only one page of your textbox, when the user moves the scroll bars of the textbox, you should determine where to go in the text file, load text that lie in that position and display it to the user.
The user does not care whether the whole text file is loaded or not, but when loading the text from the file only-as-needed, you can gain a very good performance instead of loading the whole text file.
You can load a 2GB text file in milliseconds with little memory usage, little cpu processing, and (almost) no disk load.
Regards,
Mohammad Gdeisat
أعلنت إستسلام قلبي لرحيلك..دعه يودع خطوات سيرك..فقط إجعل قلبك يحتضن حروفي ويشعرها بدفئه
فقد مللت كل لحظا تي بدونك....فمابقي لي إلا أن أثني على قسوتك....
فليتك تعلم كم أنهكتني...وكم أحرقتني...وكم جعلت مني وطنا بلا معالم.
فـــدعنــي أبـــكي على شواطئ دفئك...قاتلي
|
|
|
|
|
Mohammad A Gdeisat wrote:
أعلنت إستسلام قلبي لرحيلك..دعه يودع خطوات سيرك..فقط إجعل قلبك يحتضن حروفي ويشعرها بدفئه
فقد مللت كل لحظا تي بدونك....فمابقي لي إلا أن أثني على قسوتك....
فليتك تعلم كم أنهكتني...وكم أحرقتني...وكم جعلت مني وطنا بلا معالم.
فـــدعنــي أبـــكي على شواطئ دفئك...قاتلي
Could you please translate that in english...
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
I am sorry, my signature is in arabic, and it has nothing with the answer, I hope that my answer to the post was submitted correctly, here what I wrote:
Well, if you dont want to read the whole file, you dont need to load the whole file.
That is, when first loading the file, load text from the file that fills only one page of your textbox, when the user moves the scroll bars of the textbox, you should determine where to go in the text file, load text that lie in that position and display it to the user.
The user does not care whether the whole text file is loaded or not, but when loading the text from the file only-as-needed, you can gain a very good performance instead of loading the whole text file.
You can load a 2GB text file in milliseconds with little memory usage, little cpu processing, and (almost) no disk load.
Regards,
Mohammad Gdeisat
|
|
|
|
|
Mohammad A Gdeisat wrote: my signature is in arabic, and it has nothing with the answer
ohh you taking me wrong.. I just want to know what exactly your signature meant.
"Opinions are neither right nor wrong. I cannot change your opinion. I can, however, change what influences your opinion." - David Crow
cheers,
Alok Gupta
VC Forum Q&A :- I/ IV
|
|
|
|
|
This is the translation of the signature:
"My heart has surrendered for your leaving... let it say goodbye for your steps... just let your heart take my words and feel its warmness... because I've bored all my moments without you... there is nothing left except to praise your cruelty.
I wish you know, how much you've to exhausted and burnt me, and how much you made me a building without a basis... so let me cry on the shores of your warmness...my killer"
Its some kind of romantic sayings in arabic, to express feelings of a loving person... maybe my translation did not give the whole meaning, but it gives the idea.
Even programmers can fall in love!
And ever has it been that love knows not its own depth until the hour of separation
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
