Hi, Dear, this is the problem...my two tables are not related to each other. Actually one table has the header of the company which i am displaying on the top and the other table has all the details which has to be displayed, edited and add on the window. Both the tables have no relation at all with one another. In such a case what to do. And also if the tables have realtion as Primary Key- forign Key then as you said to update each table separately, in that case alsoboth the table firlds are being displayed on the window, and after a execute the AddNew (), it shows the error that the "Database is read only"... Please look into it. Thanks, Pankaj

Hi, Can you please let me know how to perform this task. Or please let me know that how to use two or more tables in a SDI application so that at any place or time any table can be updated. Please do help meout !!!! Pankaj

Hi friends.... I am working on a SDI application with database support. I require two tables for my application. While configuring the application wizard i specified both the tables in the Data Source when asked. Everything went fine. The application is running well. But if i want to add a new record in a table then it does not allow and states that "Database is Read Only". I went again making the same appliaction with a single table, and when i tried to add a new record it did successfully. Why is it happening that when using two tables the database is openeing as Read Only. I am not using Open function at all, since the application wizard itself opens it up. It happens fine when i use one table. It should do with two tables too. Please solve this problem of mine. Thanks. Pankaj

Thanks....this is one method that did not strike me....this can be done and i am sure it will work. But usually what happens is that in the class wizard we get a combo box in which all the member variables are stored by default, we just have to choose for which resource which field variable we have to assign. In this case no coding is required. But as you said i think by coding in this manner, the work will be done. Anyways, Thanks a lot !!! Regards, Pankaj

My Friend... I have done what all you said. I made my own class which had the base class as CRecordSet. It asked for the details of the database and everything else. It created the class in which all the field members of the database were accesed by a global variable m_pSet, for eg. m_pSet -> Name where Name is a field of the database. Now i have, say a edit box on my dialog resource, and i want to display the Name field in it. I will go to the class Wizard and Member Variable Tab. there i will have to assign the variable of this edit box, say IDC_NAME = m_pSet -> Name Now since there is no CRecordView class, so this cannot happen, which in the normal cases of SDI or MDI which have CRecordView as the base class give the option to assign these variables. My problem lies here that how to assign any resource variable to the field variable as i said above. Please do let me know how this can happen.... Pankaj

Tha is okay....but when it comes to attaching the member variables with the fields of the database, then the CRecordView class is required. I stuck up here when i have to attach the member variables. Please help in this matter then i suppose it will work successfully !!! Do reply.... Pankaj

Hi.... I wanted to know whether we can create a dialog based Appliocation having document/view support, indirectly saying to have databse support in a dialog base application. After entering the application wizard, in the second step it asks for the type of application to be built. if we go for SDI or MDI we can choose the document/view option and then canchoose our data source. But if we choose the dialog based application, then the option for choosing the data source is no more available. Now how to give this dialog based application the database connectivity ??????? And further more if we are calling further more dialogs from the first dialog window then the connectivity should be there for all the windows. Anyone..... Pankaj

I am not exactly sure whether it can be done or not, but even it can be done or not, what will you do by inserting a record in a recordset if you do not want to insert it in the database. As far as my knowledge goes, the recordset is used as an interface between the user and the actual database, and once the connection is closed with the databse the recordset will not exist !!! Pankaj

The same problem i also have, but instead of Oracle database i am using MS Access as the database. Can Anybode let me know how to get the same thing using MS Access as the database. I know how to connect to MS Acces database, but what i want to know is how to use Crystal Report to view data and print. Regards, Pankaj

The idea of having office or word and then making the print outs was one way for the solution to the problem. What you have said is very true, and shouldbe thought over. Well, as far as i am concerned, i am not aware of it at all. If you can help me out regarding it then please let me know. Regards, Pankaj

Hi, Thanks for your reply... I had the same thing in my mind, but do not know how to do this thing programatically. can you please help me out how to code this word automation. All what is to be done will be that some values have to be exported to the word document where our format of the printout will be ready. And from there we will have to fire the print out somehow. I know the procedure, but how to code all this is not known by me. Please help me out. Thanks, Pankaj

Thanks a lot for replying so soon to my problem. Since i am new i was wondering what will happen to my problem. As you asked... 1. I will be printing on a dot matrix printer. 2. regarding the format, so i am unable to tell since i am not getting what you exactly mean by it ? Please do specify so that i can clear the picture. Thanks...

Hi...I am new to this forum..this being my first message. I am working on a project in which i want to do billing. I have seen in various stores that the window in which they enter the values, it is not the same when the printout comes out, it is having some other format. Can i Know how to print our own customised views while entering some data in a window ?? Pankaj