riley.dewiley's articles:

Items(13) /2 Next >> Last >|

Where to define a const string? 12 21 (8/26/2005 7:34:53 PM) comp.lang.c++ I am looking for a graceful way to declare a string const that is to be visible across many files. If I do this: //----hdr.h const char * sFoo = "foo"; //file.cpp #include strcpy(string, sFoo); //anoth... Riley

UPDATE query results not written to database 3 40 (8/20/2005 10:55:39 PM) comp.databases.ms-access Using OLEDB, Jet 4.0, C++, Windows. I have been baffled by UPDATE queries that return S_OK but do not change the data in the database. It seems that UPDATEs do not update until the CDataSource object goes ou... Riley

UPDATE query not happy with date fields 1 34 (8/19/2005 10:41:38 PM) comp.databases.ms-access I have an UPDATE query that is always setting 0 records. When I cut and paste the SQL into Access and use it, it fails in the same way unless I coerce the date fields to be '=now()', in which case it works. I... Riley

Performance with combined key in junction table 1 29 (8/6/2005 3:14:42 AM) comp.databases.ms-access I have an application with two tables, A and B. Each has an autonumber unique ID field, plus other data. I have a junction table, AB, containing fields AID, BID, and Count (a number). AB has a combined uniq... Riley

How to interrogate through OLEDB for space to be freed by compaction? 1 25 (7/28/2005 7:16:09 PM) comp.databases.ms-access There is a way to ask a data source how much space would be freed if compaction were to be done. I saw the reference, but now cannot find it. Anyone know where that web page was? Even Google has not helped. ... Riley

Further adventures in Jet database compaction 4 34 (7/24/2005 2:26:59 AM) comp.databases.ms-access I am using Jet 4.0 through OLEDB and C++. My travails with compaction are well known to regular readers of this NG. Many of my problems were solved by disabling record locking. I am now confronted with two r... Riley

Failure to compact/repair: why? 1 22 (7/4/2005 12:29:36 AM) comp.databases.ms-access I have a C++/OleDB project that is compacting an access db on-the-fly. I close all my sessions, and close the DB. When I call IJetCompact::Compact(), I get back E_FAIL. The same file, when pulled in to Access... Riley

File bloating/compression problem in Jet 9 34 (6/28/2005 12:57:46 AM) comp.databases.ms-access I have a project that is using a Jet backend and having trouble with Jet's tendency to bloat it's MDB file. I can compact it but it is a hassle. I am considering switching to a Fox backend but have not used o... Riley

Exception handling and heap corruption 2 27 (6/25/2005 4:26:44 AM) comp.lang.c++ I have a program which must call into third party code that might do a wild write (I have been getting ASSERTs and access violations in debug code when I am freeing pointers after a call into that code). Ass... Riley

How to clean up this simple query? 7 28 (11/29/2004 6:14:30 AM) comp.databases.ms-access I am continually amazed by SQL's ability to humble me .... I have a toy query into a toy database that looks just like this: SELECT [f].[f] FROM f, fw, w WHERE f.id = fw.fid and fw.wid = w.id and w.id in ((((... Riley

riley.dewiley's replies:

Items(8) /1

File bloating/compression problem in Jet 9 34 (6/28/2005 12:57:46 AM) comp.databases.ms-access I have a project that is using a Jet backend and having trouble with Jet's tendency to bloat it's MDB file. I can compact it but it is a hassle. I am considering switching to a Fox backend but have not used o... riley.dewiley (26)

Failure to compact/repair: why? 1 22 (7/4/2005 12:29:36 AM) comp.databases.ms-access I have a C++/OleDB project that is compacting an access db on-the-fly. I close all my sessions, and close the DB. When I call IJetCompact::Compact(), I get back E_FAIL. The same file, when pulled in to Access... riley.dewiley (26)

Further adventures in Jet database compaction 4 34 (7/24/2005 2:26:59 AM) comp.databases.ms-access I am using Jet 4.0 through OLEDB and C++. My travails with compaction are well known to regular readers of this NG. Many of my problems were solved by disabling record locking. I am now confronted with two r... riley.dewiley (26)

UPDATE query not happy with date fields 1 34 (8/19/2005 10:41:38 PM) comp.databases.ms-access I have an UPDATE query that is always setting 0 records. When I cut and paste the SQL into Access and use it, it fails in the same way unless I coerce the date fields to be '=now()', in which case it works. I... riley.dewiley (26)

Non-Jet OLEDB backends? 13 25 (11/1/2004 10:13:08 AM) comp.databases.ms-access I am developing in c++, OLEDB, and targeting the Jet backend. I have realized late in the project that the Jet backend is too slow, and I need to retarget. I do not want to rewrite my source code. I do not want... riley.dewiley (26)

Question involving OLE DB, recursion, and filtered views 10 35 (11/22/2004 5:11:15 AM) comp.databases.ms-access I have a programming problem in OLEDB and C++ that seems to be pointing me toward using layered views and hierarchical rowsets. However, I am uncertain of the precise implementation and need guidance from some... riley.dewiley (26)

How to clean up this simple query? 7 28 (11/29/2004 6:14:30 AM) comp.databases.ms-access I am continually amazed by SQL's ability to humble me .... I have a toy query into a toy database that looks just like this: SELECT [f].[f] FROM f, fw, w WHERE f.id = fw.fid and fw.wid = w.id and w.id in ((((... riley.dewiley (26)

How do I compress/repair access database from code? 5 30 (10/23/2004 9:46:18 PM) comp.databases.ms-access Subject says it all. I am writing in C++/OLEDB and want to compress + repair from my program, what do I have to do? Thanks, RDeW ... riley.dewiley (26)