Database
I am testing a concept in my free program called as external program. I am testing PARMS that has two fields defined as 2S 0. I assigned a value for these two fields as 00 and 01 on the time of the call of testing. By debugging, the value of these two variables has changed when searching on the entry list of my program. I tried the call with and without using the CONST keyword. How did it happen?
- 805 views
- 1 answers
- 0 votes
I need experts to please tell me how a two-phase commit mechanism in distributed databases ensures there is data integrity. I am working on an assignment related to database data integrity and this issue seems to be hard. I just need a few pointers on this.
- 901 views
- 2 answers
- 0 votes
There is some research I am carrying out and I am a bit lost. The research is concerning database systems and SQL in specific. I wanted to find out, how can SQL be used to create location transparency in a distributed database?
- 1231 views
- 2 answers
- 0 votes
What is the difference between unique key and primary key?
- 819 views
- 3 answers
- 1 votes
For my university course,i had to install oracle database program both in my laptop and computer. But when i installed the 10g enterprise edition, it was not only installed properly and also i could open it.
But when i tried to write some query for practicing using my desktop, the oracle database program did not execute it which means i can only run the program, but can not execute it.
I need help for this.
- 948 views
- 1 answers
- 0 votes
I want to make tables in InnoDB and non MyISAM. I generally prefer using InnoDB so I don’t have to worry on recovering my tables when it crash or the statements that are partially executed.
I have CMP (Container Managed Persistence) enterprise bean in which my JBoss AS application server can create tables.
I want to know how I can redirect JBoss in creating tables with ENGINE=InnoDB. Can you help me?
- 789 views
- 1 answers
- 0 votes
I am trying to make a statement using SQL but since I am just a beginner in using this, I cannot get my statement correct. The program I am doing is a Visual Basic 6 database. This is regarding my checkbox component SQL string. The problem is, when choosing one of those checkboxes and selects it; the data will be seen in the data list component.
How can I reference the data list on my SQL checkbox statement?
For instance, I have a database table named as category and it has two fields; (ID(key) and category) and another table named as Class 1 which consist of four fields; (category1, category2 *the two will consist of the IDs from the table Category*, group and class.
- 830 views
- 1 answers
- 0 votes
Our professor in Database 2 assigned us to make some small system. We were required to use MS Access as our mode of database storage. Now, after he discussed on what to do, I'm just a little confused between unique constraint and primary key. Is there any differences between these two entity?
- 804 views
- 1 answers
- 0 votes
I have a database for my project that contains list of this is and dissertations.
I am currently using MS Access for my database and I'm using Visual Basic as my programming language.
Using MS Access, can I transport or transfer my MS Access data to MS Excel?
Is there any other way to do this except from copy and pasting it?
- 928 views
- 2 answers
- 0 votes
We are tried to develop the Cisco 2921 router. The router is developing in the branch of our organization. Our branch consist of near about 10 apple and mostly reapplication and remittances of the data and send that facts to the across wans. So my question is that what parameter should we use for the protection of the data and the network named as ASA 5510 which are building in the branches..
Thanks
- 845 views
- 1 answers
- 0 votes