|
You are doing it the hard way, aren't you? 
Why don't you use DAO or ADO? These will allow you to create your database, update it in the much more efficient way? And you do not need to have Access installed...
Good luck!
|
|
|
|
|
thanks for your suggestion however I forgot to mention that the people I'm doing want to have Access displayed so they can see graphs being updated during the simulation run of my software.
|
|
|
|
|
Hello,
If you develop application VC++ 6.0 you can use MS-Access 98 version. (or VB 6.0 Ad-Ins->Visual Data Manager) otherwise, displays the 'Select Database' dialog. I think you use in MS Access 2000.
With Regards,
R.Selvam
|
|
|
|
|
Dear All:
I now use CGridCtrl by Chris Maunder, and I add all the source files manually not by ClassWisard, that is to say I only use the command "Add Files to Folder..." to add all the files.
The question is I can't find all the classed by Chris Maunder listed in ClassWisard, also can't find all the message by Chris Maunder in the ClassWisard,what should I do?
BTW: I can't add the a grid like what Maunder said in the introduce?
Hoping...
|
|
|
|
|
You need to 'rebuild' your classwizzard file. To do this, rename (or delete but it's more dangerous) the .clw file from your project. Then open ClassWizzard and it will ask you if you want to rebuild it from your sources files. Say yes and select all the files (don't forget to select all the class from the control). That's it.
|
|
|
|
|
Sucessfully, what should I say... Thank you very much!
Another question: In Chris Maunder's introduce, he generate a dialog and insert a grid with a ID:IDC_GRID, but I inserted a grid manually without an ID, what should I do if I also want to have a grid's ID???
|
|
|
|
|
Hello,
I received some files (probably issued from a DBase 4 database and having a .dbf extension) and I would like to access it from a VC++ application to pick up some figures in it.
How can I do that and retrieve the right column/row ?
Any suggestion is welcome ...
Regards,
DD
|
|
|
|
|
You can use ODBC. Define a DSN onto your database with a dBase driver.
|
|
|
|
|
I don't know the structure of dBase, I juste have the copy of a .dbf file (containing the field that interressed me) taken in the middle of dozen others .dbf files.
With ODBC, is it possible to work on a single .dbf file, just to read some infos in it (no update to be done) without the whole dBase context or do I have to read the file in another way, like I would do it for a text file ? But, in this case, how to access the correct column/row, skip the kind of header at the beginning of the file, move from a record to another, etc ...
Regards,
DD
|
|
|
|
|
Qadddd wrote:
I don't know the structure of dBase
That's the beauty of ODBC... you have a common way of accessing all databases. Simply read (or write). You can select which field you want to appear, etc...
|
|
|
|
|
yes, I agree that ODBC is not too bad for this reason and also for code compatibility with other databases.
But, I would like to be sure that it allows me to access a single .dbf file without having the whole dBase context installed on my PC. By context, I mean the right access management, the DB manager itself and all these things that turn around the .dbf files...
So, a .dbf file can really be read out of its dBase context via ODBC.
Is the description of the table (and other needed infos) stored in the famous "header" stored at the beginning of the .dbf file and that's why ODBC can understand the content of the file ? Some other applications (i.e. Microsoft Excel) can also open these .dbf files, do they use the file header, do they use ODBC or an kind of internal interface to do the translation ?
Thanks again for you answers
DD
|
|
|
|
|
Hello,
I use the ODBC driver "dBase Files" installed by microsoft.
hereunder is the code I wrote to access the C:\Documents and Settings\dd\Mes documents\GSTAT.DBF file :
#define DBName "DSN=dBASE Files;UID=;PWD:"
...
CDatabase gDB;
CRecordset rs(&gDB);
CString res;
CString ErrMsg;
CString CASHT;
CString NETROOM;
CString DATUM;
int NbRecord;
CString Path = "C:\\Documents and Settings\\dd\\Mes documents\\" ;
CString File = "GSTAT.DBF" ;
ErrMsg = "";
res = "SELECT DATUM,CASHT,NETROOM from ["+File+"]";
// res = "SELECT DATUM,CASHT,NETROOM from ["+File+"] WHERE (DATUM = 20010208)";
// res = "SELECT DATUM,CASHT,NETROOM from ["+File+"] WHERE (DATUM = '20010208')";
// gDB.OpenEx(DBName,CDatabase::noOdbcDialog);
gDB.OpenEx(DBName,CDatabase::forceOdbcDialog );
TRY
{
rs.Open( CRecordset::forwardOnly, res );
NbRecord = rs.GetRecordCount();
}
CATCH(CDBException, e)
{
ErrMsg ="**ERR: "+e->m_strError.Left(70);
}
END_CATCH
if (ErrMsg == "") {
while(!rs.IsEOF()) {
rs.GetFieldValue( "DATUM", DATUM);
rs.GetFieldValue( "CASHT", CASHT);
rs.GetFieldValue( "NETROOM", NETROOM);
rs.MoveNext();
}
}
rs.Close();
gDB.Close();
Used like this, it works but I have some problems :
1) I am obliged go thru the ODBC display to give the name of the file, I can't set it by program ... why ? How can I do this and use the noOdbcDialog option (When I try to use it, ODBC tells me that it can't find GSTAT.DBF)?
Furthermore, ODBC dialog is based on program directory, not on the path. If I add the Path to the name in File variable, ODBC tells me that it can't find C:\Documents and Settings\dd\Mes documents\GSTAT.DBF ...
2) If I add the clause "WHERE" to my request, no record is returned ... why ? Can't I use it ? Am I obliged to read all records and test the DATUM field by program ?
3) what is the format of the date in the file ? Excel says 08/02/2001, Word says 20010208 and DATUM = 2001-02-06 when debugging my code ... When I use a date in format yyyy-mm-dd or dd/mm/yyyy ODBC tells me that my format is not compatible
Thanks in advance
DD
|
|
|
|
|
I think you are almost there!
1) the database problem
When you create your system DSN, you will give it a name (ex dsnMyDatabase). This name will indicate the DBF file name and the driever you are using.
Then you will redefine
#define DBName "DSN=dsnMyDatabase;UID=WD;"
It should do the trick
2)and 3) The Where should work it is probably a problem due to the way dates are defined
try this WHERE DATNUM = #mm/dd/yyyy#
Good luck
|
|
|
|
|
hello,
sorry to bug you again with this stuff, but I need some extra-infos (in fact, I don't use PC database stuff very much (except MySql on which I crated a little application also using ODBC and I am quite a newbie in VC++ )
1) #define DBName "DSN=dsnMyDatabase;UID=WD;"
Ok I was looking for the pannel where I set the access to the database (path, file) during the ODBC configuration and did not find it ... but looking at it a second time, there is a "Use Current directory" set, and if I deselect it, I can precise the path/file ...
So the way id to Create 1 DSN per file in ODBC and done the "gDB.OpenEx(DBName,CDatabase::noOdbcDialog);" with the correct one.
But, in ODBC, should I just give the path and then precise the file in "OpenValue" in the "rs.Open( CRecordset::forwardOnly, OpenValue );" command, or should I give the path and the file name, in this case should I repeat the file name ine the "OpenValue" or not ?
2) Yes, it should work. ok, I will try the WHERE format you proposed me.
Thanks again
DD
|
|
|
|
|
Salut (did not realise you were French too),
Ok when you create your DSN.
1) You go into System DSN
2) Click Add
3) Select dBase, click Finish
4) Enter the Data Source Name (dsnMyDatabase)
And select your database (after having unclicked use current directory)
Then in ODBC, you do not need to repeat the path of your file, simply the name of the DSN. Do I make sense?
Bonne chance!
|
|
|
|
|
re hello !
BadJerry wrote:
did not realise you were French too
my perfect english probably ... ))
BadJerry wrote:
Then in ODBC, you do not need to repeat the path of your file, simply the name of the DSN?
I aggree !
but I for step 4 :
A) the DSN should be set to the directory containing the file.dbf and the I specify the name of the file.dbf in the rs.Open( CRecordset::forwardOnly, SQLCmd )(what I suppose) or
B) the DSN should be set to the directory+file.dbf and then, I have no clue on what SQLCmd has to be in the rs.Open( CRecordset::forwardOnly, SQLCmd) ?
DD
Et merci pour le Bonne chance, je n'ai pas fini de souffrir avec ce que que je suis en train de faire ...
|
|
|
|
|
What you need to do is find the name of your recordset and the name of your fields as they are defined in your DSN.
The easiest way would be to start MS Access and try to import the data from your DSN (Fichier/Donnees externes in an existing mdb).
This way you will get the name of your table and then you can have something like
"Select * from MyTable"
BTW I suspect the table name is the name of the dbf file...
If this works and its for a one off, leave as it is. If you plan to make this a released application, consider using ADO though... There is a good set of classes on CP for ADO.
Une fois que tu auras fait ca une fois, tu verras, ca n'a rien de sorcier!
A+!
|
|
|
|
|
BadJerry wrote:
"Select * from MyTable"
BTW I suspect the table name is the name of the dbf file...
ok, this pleases me !!!
BadJerry wrote:
consider using ADO though...
I am using these files just to pick some basic informations in, no delete, no update, no complicated SQL stuff. The dBase application producing these files will soon desappear to be replaced by something using Oracle ... So I will keep it like that.
But just for my info : what is the advantage of CDaoDatabase compared to CDatabase class ?
The example I looked before was using CDaoDatabase, I took the code and didn't see a lot of benefits using this class. Further more I need to import a lot of code to make it even compile, the CDaoDatabase isn't known while you just add #include "afxdb.h" for Cdatabase ...
BadJerry wrote:
Une fois que tu auras fait ca une fois, tu verras, ca n'a rien de sorcier!
oui, c'est la premiere fois que ca fait mal ...
A la prochaine
DD
|
|
|
|
|
DAO is really for Access databases really... and it is obsolete. I still use it when I need to play with an Access database because it is blinding fast.
ODBC was the MS first attempt at having a universal way to access databases.
ADO is like ODBC but meant to be much faster (it actually is)
So in your case, do not bother with CDaoDatabase or CDaoRecordset
Qadddd wrote:
oui, c'est la premiere fois que ca fait mal ...
Tiens j'ai deja entendu ca mais c'etait pas sur le meme type de forum 
|
|
|
|
|
Hello,
my code seems to work correctly, but I have some problems :
1) SELECT in the files returns me no record but an error message: "Impossible de trouver le fichier memo xBase Demande", in english it can be traduced by "impossible to find the requested xBase memo file" ....
If I open the file with Excel and launch my appli accessing the file, all records are correctly selected and returned ... Strange I know, but true. Simple, to test my appli and until I have a better solution, I just open all accessed files with Excel at the same time ...
Any idea on the cause of this problem and its solution?
2) I thought I had a too old version of my ODBC drivers, so I wanted to upgrade them ...
With microsoft, it is never easy to find anything, so what should I upgrade to upgrade my ODBC drivers ? Seems to be MSJet engine ... So I downloaded the lastest MSJet4.0 sp8, but when I want to install it, it refuses to do it and tells me that I should already have at least the sp3 installed to install this sp8 ... The problem is that, when I verify manually the version of the dll, the version corresponds to a sp5 ... So I don't know what to do to perform my installation ...
3) ODBC and MDAC ... are both linked ? if I upgrade ODBC, should I also upgrade MDAC ? and if yes, which version of MDAC should I install (I have the MDAC 2.5 sp2 installed at the moment)?
4) in one of my dbf table, I have to make a selection on an ID to retrieve a record. This ID seems to be numeric but must not be declared as a standard numeric or even text value (I am thinking to an auto incremented value or style like that) because, in my clause WHERE, when I don't use the quotes, ODBC send me a error message saying that my format is not correct, and when I use the quotes, I don't receive the error, but no record is returned (even if my file is opened with Excel ...) is the any other way to write my request ?
Sorry to bug you again with this but I am a little bit stuck
Regards
DD
|
|
|
|
|
I'm currently in the middle of redesigned a larger application.
Previously the application was divided in [too] large chunks (I will use the term chunk to distinguish it from files/modules). Each chunk had a lot of source (mainly .c) files, but only one header (.h) file that had to be included by the routines of that chunk and by other routines that wanted to use that chunk.
Up to now we used precompiled header files to speed up compilation (all files of a chunk had to include their own header file as first file).
Now I want to divide all these chunks in smaller C++ classes. Each class will have its own header (.h) file and source (.cpp) file. My hope is to end up with less includes, less dependencies and thus a faster compilation.
However, what I notice is just the opposite. We try to make a lot of use of STL and Boost templates, but these seem to slow down compilation seriously. On the other hand, we cannot use precompiled headers anymore because each class has its own header file.
In the fantastic book 'Debugging Applications for .Net and Windows', the author, John Robbins, suggests to use one main header file (e.g. ALL.H) that is included (first) by all of our source files. All includes that aren't changed in the last 3 months should be put in that header file (including STL and Windows includes). In our case we would typically include STL and Boost header files in that ALL.H file, but the template constructions even seem to slow down compilations if precompiled header files are used.
How do you organize your header files? How do you use precompiled headers? And what should be the correct way to use them?
(maybe this could be a question for a poll, but it is probably too C++ oriented for that).
Thanks for your help, fellow CPians.
Enjoy life, this is not a rehearsal !!!
|
|
|
|
|
hi all..
i m new to VC++ and i want to know,where i can get info related to accessing databases using DAO,ODBC in VC++.Any books,preferably.
Thanks in advance
|
|
|
|
|
MSDN Library is your friend. If you don't have it yet, go to it's home page and order a subscription license for yourself. This library contains just about every official thing related to Windows programming world.
MSDN Library is also available via the Net for free reading, and I just happened to have a link to the site handling database and data connectivity issues.
MSDN homepage can be found from here[^].
An introduction to database programming with MFC can be found from here[^].
Happy reading !
-Antti Keskinen
----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.
|
|
|
|
|
Hi...
I'm trying to create a patch. I read the msdn online help but couldnt quite get the steps to create a small update patch.
Can anybody give me a clue or other sites that i can refer to on how to get this done?
Thank you
|
|
|
|
|
This depends solely on what type of a patch you are planning to create.
Naturally, the most easiest way to patch a program is to replace it's binary executable or library files. This just means that you create an installer which searches or asks for the correct directory, and then dumps it's contents there, overwriting old files as fit.
If you have a gaming application that contains a huge file for resources such as scripts, models, sounds etc then dumping a new file is not really an option (Nobody wants to download a patch of 200 Mb in size). In this case, your best bet is to originally design the resource files to be patchable, that is, you use an encoding or encryption algorithm to which you have the appropriate decoding mechanism. Then you just read the client's file, decode it, make necessary changes, and re-encode the file.
-Antti Keskinen
----------------------------------------------
The definition of impossible is strictly dependant
on what we think is possible.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
