|
Martin Ziacek wrote:
Switch to MS SQL Server.
Why would one out of free will pay quite a lot of money for something that is also available freely?
If you need an SQL server, maybe Firebird could be something to have a look at.
|
|
|
|
|
Mike Nordell wrote:
maybe Firebird could be something
Well, maybe, at least it has got well documented bugs like ORDER BY has no effect. But, frankly, I am not interested in discussion about better or worse products. If you dislike MS SQL Server, do not use it and recommend something else, and obviously you have to know why you do that. I suggested MS SQL Server, because e.g. it supports import of the MS Access database. Is there the same feature in Firebird? I guess there is no such a thing. And what would be the cost of the development and maintenance of the database with Firebird? You have to understand that there are more requirements than just price of a piece of software.
|
|
|
|
|
What OS ? Windows 95/98 have a 2 gig file limit AFAIK.
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
Jamie,
The OS is both Win 98 and Win 2000. I need to find the optimal database application that does not reside on a server and is independat like Access. Do you know of any out there?
|
|
|
|
|
|
Have a look at MSDE, Microsoft's cut down version of SQL Server 2000. I'm not sure on it's maximum specs but it is a lot cheaper than investing in the full version SQL Server.
You'll find details about it on the Microsoft web-site.
Michael
Look, try and use your intelligence, man, even if you are a politician. - The Doctor
|
|
|
|
|
MSDE is limited to 2GB too. clickety
Is mysql an option?
bibamus, edamus, cras moriemur [eat, drink, for tomorrow we die]
|
|
|
|
|
As far as stand-alone databases MS Access is probably you're best bet. Unfortunantely, there is a 2gb limit.
One idea: split the DB into multiple MDB files and LINK the tables into a master database. Basically with this configuration you can still have a single view of the DB but have the data from the various tables spread out. This will not work, though, if you have 1 table that exceeds your 2gb limit.
Another idea: most access databases are not designed well (I'm not saying yours is poorly designed, just that this is what i've seen.) You should look at the size of the columns in your tables and see if they can be shrunk. Many DB's I've seen use the default size for text columns which is 50 characters. Often this leaves alot of unused space. Also, look for redundant data and consider normalizing the database a little. (Normalizing has the unfortunante side effect of causing you to modify your code, though.)
|
|
|
|
|
In Platform SDK of MSDN, about PeekMessage function: it says we can use PM_QS_PAINT or some other values to specify that only certain message should be processed. But when I use this value, I got complie error:'PM_QS_PAINT' : undeclared identifier. I'm sure I include Windows.h.
The other problem I got is I can use SetForegroundWindow()function, but not AllowSetForegroundWindow()function in the same file. I got compile warning:'AllowSetForegroundWindow' undefined.
Anyone knows how to fix those. Thx.
mIchAel Liu
|
|
|
|
|
Michael Liu wrote:
PM_QS_PAINT or some other values to specify that only certain message should be processed.
Never heard of it. Are you sure it's not an example of a user defined message ?
Michael Liu wrote:
I got compile warning:'AllowSetForegroundWindow' undefined
I have never heard of this either. MSDN says it's defined for Windows ME and 2000 only ( I presume XP has it as well ). This means that any code that uses it will not run on W95/98/98SE/NT and also means you'll need to download the platform SDK ( about 500 MB, also available on CD ) in order to use it.
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
PM_QS_PAINT :
MSDN give us four values to specify that only certain message should be processed. Do you know how to specify those values?
1. PM_QS_INPUT Windows 98/Me, Windows 2000/XP: Process mouse and keyboard messages.
2. PM_QS_PAINT Windows 98/Me, Windows 2000/XP: Process paint messages.
3. PM_QS_POSTMESSAGE Windows 98/Me, Windows 2000/XP: Process all posted messages, including timers and hotkeys.
4. PM_QS_SENDMESSAGE Windows 98/Me, Windows 2000/XP: Process all sent messages.
AllowSetForegroundWindow():
But I can use SetForegroundWindow(). This function needs the same requirements as AllowSetForegroundWindow().
Thx.
mIchAel Liu
|
|
|
|
|
Michael Liu wrote:
PM_QS_PAINT
Ah.. I did not know about it because I've never used it. Apart from GDI+ and transparent windows, I don't think I've ever used anything that requires the SDK. Look at the requirements you just posted and you'll realise I've answered your question. You need the SDK.
Michael Liu wrote:
But I can use SetForegroundWindow(). This function needs the same requirements as AllowSetForegroundWindow().
Not true. "Minimum operating systems Included in Windows 95, Windows NT 3. "
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
|
I've installed the latest SDK. How can I use the latest SDK with VC6? Thx.
mIchAel Liu
|
|
|
|
|
Wow - you must have an MSDN subscription. The SDK should set up it's paths so that it is automatically integrated with VC.
Christian
I am completely intolerant of stupidity. Stupidity is, of course, anything that doesn't conform to my way of thinking. - Jamie Hale - 29/05/2002
|
|
|
|
|
Michael Liu wrote:
AllowSetForegroundWindow():
But I can use SetForegroundWindow(). This function needs the same requirements as AllowSetForegroundWindow().
It looks like AllowSetForegroundWindow is a newer function. Have you got the latest platform SDK or are you still using the headers that came with VC6?
Michael
Look, try and use your intelligence, man, even if you are a politician. - The Doctor
|
|
|
|
|
I'm using the headers that comes with VC6(sp5). I have MSDN(Jan. 2002). Is the SDK in that CD? Thx.
mIchAel Liu
|
|
|
|
|
If you have an MSDN subscription other than the Library, you should have a CD with the platform SDK. If you only have a library subscription you'll need to obtain the platform SDK from the MSDN site.
Michael
Look, try and use your intelligence, man, even if you are a politician. - The Doctor
|
|
|
|
|
|
I've installed the latest SDK, how can I updated the vc6 include file? Just copy those files? Thx.
mIchAel Liu
|
|
|
|
|
I feel like I'm missing something - I just try to load a text file into an Multiline EDIT, modify it, and save it again as text file. (should match notepad's behavior of hard line breaks)
Issue: just taking the file size and loading does not work because of the \n <--> \r\n conversion. For saving, it seems to double the line breaks, so it's bad again.
All I came up was either reading line-by-line, or reading as binary and do the replacements on my own. Which sounds a bit awkward.
Any suggestions?
TIA
Peter
We are ugly but we have the music Leonhard Cohen [sighist]
|
|
|
|
|
1) I tried putting the following:
CNewDialog cDlgNoOk;
cDlgNoOk.m_edit1.SetFocus();
Got a debug assert when it ran.
2) Then I tried putting it in the constructor- still asserts:
CNewDialog::CNewDialog(CWnd* pParent /*=NULL*/)
: CDialog(CNewDialog::IDD, pParent)
{
//{{AFX_DATA_INIT(CNewDialog)
none = NULL; // NOTE: the ClassWizard will add member initialization here
//}}AFX_DATA_INIT
m_edit1.SetFocus();
}
3)Finally I put it in :
BOOL CNewDialog::OnInitDialog()
{
CDialog::OnInitDialog();
// TODO: Add extra initialization here
m_edit1.SetFocus();
return TRUE; // return TRUE unless you set the focus to a control
// EXCEPTION: OCX Property Pages should return FALSE
}
It ran without asserting but the editbox didnt get the focus.....
Any suggestion on how to set the focus?
Thanks,
ns
|
|
|
|
|
please read:
>>
m_edit1.SetFocus();
return TRUE; // return TRUE unless you set the focus to a control
<<
We are ugly but we have the music Leonhard Cohen [sighist]
|
|
|
|
|
I'm going to start reading the comments from now on! THanks so much for pointing me to it...
ns
|
|
|
|
|
Hi all.
Since we have written our own web server, our setup has to detect if there is already a application listening on port 80, so we can notify the user about the conflict. How can I get this information?
Regards
Thomas
Sonork id: 100.10453 Thömmi
Disclaimer: Because of heavy processing requirements, we are currently using some of your unused brain capacity for backup processing. Please ignore any hallucinations, voices or unusual dreams you may experience. Please avoid concentration-intensive tasks until further notice. Thank you.
|
|
|
|