C / C++ / MFC

FirstPrevNext

Re: method FIND Carlos Antollini26-Jul-01 5:08 Carlos Antollini 26-Jul-01 5:08  it's Impossible. You need to inform the name of the field. Carlos Antollini. Readonly recordset Jimmy Ehrnström26-Jul-01 3:59 Jimmy Ehrnström 26-Jul-01 3:59  What can cause a CRecordset object to be readonly? My CDatabase object is tested to be open and updatable so that's not the problem. I can use the recordset to fetch records from the database table and I've verified that my recordset contains a record. I also make sure to position the cursor at the first record. But still CanUpdate() returns false. I've tried opening the recordset as both dynaset or snapshot, but neither works. I don't use the CRecordset::readOnly paramter either. I'm also quite sure there's no permission restraints in my table, since updates using ExecuteSQL works fine. Does anyone recognize this problem and could tell me what to try? Or maybe give me a pointer to a good faq about MFC and databases? My database table contains fields of the following types: int, datetime, smallint and numeric. It has an auto-generated primary key of type int. Any advice will be much appreciated. Thanks, Jimmy Ehrnström Re: Readonly recordset Carlos Antollini26-Jul-01 4:42 Carlos Antollini 26-Jul-01 4:42  The class CRecordset don't work fine. A lot of people have the same problem. You can make two things. If you want to be a good database programer, never Update a Table usign the metodo AddNew or Update, is better to use SQL Sentences. Like INSERT or UPDATE using ExecuteSQL. If you are using a SQL Server or Oracle or like some this, Please use Stored Procedures, for update, insert, and delete records, Is better, Quickly and more secure for the programer and for the DBA, because you don't need permits over the table you only need permit of execute in the stored, Also is easy for Admin, because if you add a field into a table, sometimes you only need to modify the store and not the VC++ Code. Best Regards. Carlos Antollini. Re: Readonly recordset Jimmy Ehrnström26-Jul-01 4:54 Jimmy Ehrnström 26-Jul-01 4:54  With all the problems I've had with my recordsets I can only believe that your right. It's strange though that I haven't found any warnings about recordsets, just small examples where they mostly use recordsets to fetch data. You could think that MFC classes should work fine together with SQL server, but obviously that's not very true. I'll guess I have to switch to stored procedures, like you suggested. Hopefully the redesigning will be minimal and maybe I'll save time in the long run. Thanks a lot for your 2 cents. Re: Readonly recordset Carlos Antollini26-Jul-01 5:12 Carlos Antollini 26-Jul-01 5:12  Try with my class CADODatabase and CADORecordset, These are in CodeProject, But I will send you a new version by email. A lot of people said me that replaced the class CDatabase and CRecordset for my classes, and with a minimal change in the code. Cheers!!! Carlos Antollini. Re: Readonly recordset Jimmy Ehrnström26-Jul-01 22:05 Jimmy Ehrnström 26-Jul-01 22:05  Finally I found the problem with my non updatable/appendable recordset class: The table the recordset was supposed to operate on had no primary key, and this led to the recordset not being updatable/appendable. I've spent way too many hours looking for the solution, and now I feel stupid that I didn't notice the lack of primary key earlier. Thanks to everyone that has tried to help me. Hopefully this experience could be of some help to others too. Re: Readonly recordset 4-Sep-01 1:33 4-Sep-01 1:33  A table must have a primary key for the CRecordset object to be able to add records to it. If no primary key is defined then I think it is marked as readOnly. Localization in arabic Hussam Ahmad26-Jul-01 3:39 Hussam Ahmad 26-Jul-01 3:39  I hope somebody knows how to do this Well my problem is that I am tring to implement arabic (Right to left) application. Mirroring controls and menus functions well ( in spite of the bugs in VC) but the language of the texts is wrong the whole way apart from those that are to be written in editboxes. Does anyone have an idea about how to force the CMenu and CStatic to write in arabic instead of "something strange"? Environements I am using: - Win 2000 english / Win98 norwegian / win98 arabic - VC++ 6 the application is MFC app and should run on arabic win 98 All help is appreciated Hussam Re: Localization in arabic Michael Dunn26-Jul-01 8:53 Michael Dunn 26-Jul-01 8:53  First thing I'd suggest is to check the FONT lines in your dialog resources. They should be "MS Shell Dlg" not "MS Sans Serif" which is the default. (MFC automagically changes the dialog font itself in East Asian languages at the time the dialog is created, so I'd think it would do the same for other DBCS languages, but maybe not. Give it a shot.) --Mike-- http://home.inreach.com/mdunn/ "Make sure that if you are using a blow torch that you don't set anything on fire."   -- Chris Maunder Re: Localization in arabic Carlos Antollini26-Jul-01 9:12 Carlos Antollini 26-Jul-01 9:12  I did That, I made a System for Citibank in Hebrew. Ask me to carlos.antollini@nixorcorp.com I will try to help!!! Carlos Antollini. Problems loading DLL 26-Jul-01 2:43 26-Jul-01 2:43  Hi, I'm having problems to load a dll using the LoadLibrary API function. It works in the debug version, but returns ERROR_INVALID_ORDINAL in the release. Any help is appreciated. Cheers, xico ---------------------------- xicoloko@hotmail.com www.devbrasil.com Re: Problems loading DLL Tomasz Sowinski26-Jul-01 2:55 Tomasz Sowinski 26-Jul-01 2:55  Your DLL depends on some other library (it's importing a function by ordinal), and this library has no function with required number. Tomasz Sowinski -- http://www.shooltz.com Re: Problems loading DLL 26-Jul-01 4:12 26-Jul-01 4:12  Tomasz, First of all thanks for your reply!! My dll doesn't use any other dll (apart from the system ones). But even if I had this problem why would the debug version work? cheers ---------------------------- xicoloko xicoloko@hotmail.com www.devbrasil.com Re: Problems loading DLL Tomasz Sowinski26-Jul-01 4:14 Tomasz Sowinski 26-Jul-01 4:14  But even if I had this problem why would the debug version work? Maybe some functions are compiled only when DEBUG is #defined. You should use depends.exe to check what exactly is missing. Tomasz Sowinski -- http://www.shooltz.com Buttom order 26-Jul-01 2:36 26-Jul-01 2:36  Hello how can i add a buttom border to the CToolBar that was created at run time? 10x Re: Buttom order Tomasz Sowinski26-Jul-01 2:47 Tomasz Sowinski 26-Jul-01 2:47  What's 'buttom order'? Tomasz Sowinski -- http://www.shooltz.com i ment: buttom border 26-Jul-01 3:51 26-Jul-01 3:51  how can i make a buttom border for a CToolBar? Re: i ment: buttom border Tomasz Sowinski26-Jul-01 4:12 Tomasz Sowinski 26-Jul-01 4:12  My English is a little bit weak, so please be more specific: you want 'button border' or 'bottom border'? Tomasz Sowinski -- http://www.shooltz.com RichEdit 26-Jul-01 2:17 26-Jul-01 2:17  How do i insert text to the CRichEditCtrl progromaticaly? Re: RichEdit Tomasz Sowinski26-Jul-01 2:55 Tomasz Sowinski 26-Jul-01 2:55  Check SetWindowText and ReplaceSel. Tomasz Sowinski -- http://www.shooltz.com Re: RichEdit 26-Jul-01 2:56 26-Jul-01 2:56  You need a callback function, something like: DWORD CALLBACK readText(DWORD dwFilehandle, LPBYTE lpBuffer, LONG lBytesToRead,LONG FAR* lpBytesRead) { if(!ReadFile((HANDLE)dwFilhandle,lpBuffer, lBytesToRead, (unsigned long*)lpBytesRead, NULL)){ AfxMessageBox(_T("Couldn't read from file!")); return 1; } return 0; } and then use StreamIn. /Per How to read parameter from stored procedure ? Bartek26-Jul-01 2:09 Bartek 26-Jul-01 2:09  Hi, I am using ADO tecnology to execute stored procedure. Does anyone know how to read out a parameter from sp into VC++ variable I need to get @file_id (which is set at the bottom of sp) thank you, bartek My stored procedure: CREATE PROCEDURE [sp_StandardFileNew] @receive_date varchar(20), @pj_id int, @pj_type varchar(20), @file_group varchar(200), @name varchar(255), @ext varchar(10), @total_words int, @dtp_pages int, @notes varchar(500) AS DECLARE @file_id int, @receive_date2 smalldatetime, @project_id int, @job_id int, @group_id int -- Check if obligatory text parameters are null if @name is null OR @ext is null OR @pj_id is null OR @pj_type is null OR @receive_date is null begin return 1 end -- Set @project_id or @job_id depending on the @pj_type [ "job" | "project" ] if @pj_type="job" begin set @project_id=null set @job_id=@pj_id end else if @pj_type="project" begin set @project_id=@pj_id set @job_id=null end else begin return 2 end -- Check group_txt if it exists retrieve its id or create new group if it does not exist if @file_group is not null begin exec sp_NewFileGroup @file_group, null, @project_id, @job_id, @group_id OUTPUT if @group_id is null begin return 3 end end else begin set @group_id = null end -- Convert date-string format to datetime / smalldatetime exec sp_DateConvert @receive_date, @receive_date2 OUTPUT -- insert new row to the Files table and convert text arguments to integer values insert into files(name, ext, receive_date, group_id, job_id, project_id, total_words, dtp_pages, file_type_id, deleted, works_count, notes) values(@name, @ext, @receive_date2, @group_id, @job_id, @project_id, @total_words, @dtp_pages, 0, 0, 0, @notes) set @file_id = @@identity if @file_id is null begin return 4 end return 0 GO WANTED: Clever Ideas Derek Lakin26-Jul-01 1:59 Derek Lakin 26-Jul-01 1:59  I have three menu buttons on a dialog (thanks to Norm Almond for the code) each of which requires the same menu items on them in terms of the strings they present and whether or not any items are disabled. However, the first and third buttons need to show check marks, but independently of each other. The second button mustn't show any check marks at all. Does anyone have any clever ideas on how best to implement this or do I need a separate menu and corresponding handlers for each? Is there a way to use the ON_UPDATE_COMMAN_UI macro? If so how? Derek. Re: WANTED: Clever Ideas Tomasz Sowinski26-Jul-01 3:01 Tomasz Sowinski 26-Jul-01 3:01  ON_UPDATE_COMMAND_UI should work - do you have any problems with that? Tomasz Sowinski -- http://www.shooltz.com Re: ON_UPDATE_COMMAND_UI Derek Lakin26-Jul-01 5:20 Derek Lakin 26-Jul-01 5:20  I thought this macro was only applicable to menus and toolbars that existed in a CFrameWnd-derived class. If I can use it then presumably all I need to do is process which button was pressed and then update the checkmarks (if any) accordingly. With the LButtonDown/Up already overridden in the class to provide the menu buttons, how can I determine which button was pressed from the dialog?

Last Visit: 31-Dec-99 18:00     Last Update: 24-May-24 11:25 Refresh ᐊ Prev1...18142181431814418145181461814718148181491815018151 Next ᐅ

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.