This is an archive of CompuServe forum messages from 1985 to 1995, as saved in transcripts by John Foust.
Search Results (22 messages)
Jan, I think it will start in a month or so. -Ronald-
Israel, When I double checked the info before posting it to you, I also came across CanTransact in CRecordset and I wondered about what made that one special as well. So… I looked at the source and found that CRecordset::CanTransact is essentially implemented as return m_pDatabasem_bTransactions So I really wonder…
Israel, There isn't a function per-se. If yoi want to avoid going crazy waiting, your best bet is to use CDatabase::ExecuteSQL("delete from Mytable") which will get rid of all your records in the table. An even faster option for very large tables is to drop the table and then recreate…
Israel, What probably happened is that you did not select all the coulumns (fields) that make up a specific row. Even if you need only a few fields from the select, you still need to include all the fields making up a unique index. The cursor library will turn a…
Israel, As always with SQL, this is determined internally. One of the purposes of SQL is to shield you from explicitely specifying the access path. In most production databases however, you can influence the optimiser. Usually either by the order in which you specify the tables or by giving 'hints'…
CJ, No, they don't work with the Access Driver. -Ronald-
Jan, No, I don't have any solid info at all at the moment. It does seem that the beta will be reasonably wide, so you might want to take your chances and apply. My only guess as to why the new drivers will be much better is that MS made…
#30194-
MS Certified Prof.
Message #30403
Stuart, Curtis, Actually getting certified is not that expensive. While the courses maybe more that you want to pay, following them is not a requirement for certification. The only requirement is passing the 6 required exams at about $100 a piece. If you know your stuff and read the material…
Chris, Requery DOES NOT work when you change the filter or sort clauses, this is stated wrong in the docs. It will only work with parametrised recordsets. So what happens is that close/open, does a new SQLPrepare and then a SQLExecute while Requery only does the SQLExecute. This may be…
#30169-
#transactions
Message #30401
Israel, You probably didn't find the functions because you were looking in the wrong place. the functions "BeginTrans", "CommitTrans" and "Rollback" are members of CDatabase. This makes sense because transactions work across recordsets, i.e. if you commit a transaction, work performed in all recordsets will be committed. -Ronald-
#30001-
Filtering CRecordSet
Message #30400
Simon, Requery does not work for changed filters, the docs are wrong, it only work for parametrised recordsets. You should look at the knowledgebase (GO MSKB) for a list of articles about the problems with requery. Try searching for "MFC" and "requery". -Ronald-
#29994-
changing Index using SQL
Message #30399
Pat, Use Access. I have found it essential to have a copy of Access when working with Access files. Some things like creating counter fields are only possible (as far as I know) using Access itself or maybe using VB. -Ronald-
#30154-
#ODBC Tales
Message #30398
David, If you only have the SQL server driver, you have nothing at all. This driver's only purpose in life is to act as a liaison between your app and a running copy of SQL Server. So this is not really a good choice for a standalone app. As I…
J N, While I try to help others with problems they have in various CIS forums, there are times when I can't deveote any time to CIS for several days, there are even times when I am on holiday. So posting a new message directly to me, or mailing it…
#29630-
Access & over 64K data
Message #30251
Pierre, There is a _tiny_ bug in the CLongBinary transfer mechanism: it doesn't work for > 64 K. Whoever wrote it forgot 2 things, one of the 2 was to split up the transfer in 64K pieces. There should be a KB article on this in MSKB either now or…
#29811-
ID_RECORD_FIRST
Message #30250
Dan, >> Note: The SQL Server ODBC driver allows only >> one open recordset per database connection. The cursor library (odbccurs.dll) works around this limitation. In fact the way the MFC database classes are written they would not work at all with the SQL Server driver without the cursor lib.…
#29959-
Can not update record
Message #30249
Kyle, The only Access driver that is available is the one from MS. Since MS does not release the interface specs, no third party can produce a competing driver at the moment. Watcom does support Dynasets. -Ronald-
#29976-
CRecordset Query ?
Message #30248
Ted, Sorry for coming in this late, but I don't quite understand your exact question: If you have no "order by" cluase, the question is meaningless, because then there is no order in which you will get the records, so "scroll forward from the selected record on" is quite meaningless.…
#29785-
ODBC RFXText failure
Message #30247
Joseph, I have always found that posting a question here gives the best results. I don't bother with phone support at all anymore. -Ronald-
#29709-
Best C++ DB API?
Message #30246
Will, WINEXT Section 10, message # 109679. -Ronald-
Robert, You will need to write your app as a service. See the services overview in the NT SDK docs. If you have any programming problems with NT, ask in MSWIN32 (and pray for an answer). -Ronald- Read action !
Julie, Do you mean by this that even the non-GUI code in MFC won't be multi-thread safe. Things like the collection classes? If we have to serialise access to the collections ourself we either have to alter the source code or live with strongly reduced parallellism in the collections. -Ronald-…