Hi All, I'm working on a LOT of VBA code that generates reports from Excel. I reckon it's a really stupid idea to use Excel and VBA to run "queries" on an worksheet so I'd like to do it in a database environment. I successfully ported the required table and data into OpenOffice base. The problem now is that I need to run a report tha...
Say I have these tables and Oldbookings is an archive table containing rows from Bookings made a year ago. Also, assuming that such constraints were already defined in Bookings: FOREIGN KEY (cusNo) REFERENCES Customers(cusNo) FOREIGN KEY (flightNo) REFERENCES Flights(flightNo) Would it make sense to define these contraints (foreign ke...
Is there any command that I can locate a certain table from all databases? Since I forgot where the table is. Thanks. ...
Table entity column is unique, and I'm trying to add items. Items amount is fairly big, so i'm trying to avoid connecting to a database many times. What is the best way to ignore duplicates? Example: code Edit: Problem was word1 was of type nchar(50), so after changing it to nvarchar(50) everything worked. ...
There is a column in options that hold an integer. I want to select the row only if that value % 2 = 1. I know this can be done in 2 queries but is it possible to do it in 1? ...
What should be best Database topic to start with for a fresher ? ...
what will be minimum no of table will be mapped from this entity relationship model. here M1 IS PRIMARY KEY. P1 IS PRIMARY KEY, N1 IS DESCRIMINATOR OF WEAK ENTITY SET E3. AND R1 IS A RELATION SHIP (MANY TO ONE)(FROM E1 TO E2) R2 IS A RELATION SHIP (MANY TO ONE )(FROM E3 TO E2) E1 HAS TOTAL PARTICIPATION IN R1 AND E3 HAS ALSO TOTAL P...
Hi I want to upload data through CSV files in my contact management application. The CSV file structure is like this: Name, Phone, City John Doe, 555-555-5555, New York While the table structure in the db is like this: name, phone, city_id In the database, the city name is stored in another table and the foreign key is referenced ...
Hi, What is the best way to design a view for a Java/Hibernate Application for the following scenario: There is Entity A that has one to many relation with Entity B, Entity C and Entity D. There is a need to show all the relations of Entity A in a single Table in the UI. Does it make sense to create a database view and map that with ...
All, Please share any ideas and please help me. i've got a exsiting database (mysql) my Boss need to evaluting with this database and he need to know the step by step to evaluate (He don't need in deep technical). please suggest how i do? thanks for any ideas.. ...
We have a Joomla website which we want to copy over to another host website. So far everything has been copied except for the database. The problem we're experiencing is as follows: After exporting the database information from our old website into an .sql file and trying to import it into an empty database on our new host, it seems tex...
Hi All, Thanks in Advance.. I want to put a question to solve my problem, the question is that how is the way to use database (Trigger, Sps, and other elements) in VSS same like using source code in VSS and access in Microsoft Visual Studio. like doing check in and out of database elements in VSS or other tool for making database in c...
Background: School counselors will login and make comments about their meetings with students. Issues: PHP 4 server Flat File or CSV Suppose I have HTML form with the following text fields user id date comments How can I create an effective record keeping to be able to display the comments that have been made and next to them ...
Good morning, Can the ads.ini file be located in other directory ? C:\%SystemRoot% C:\Users\%UserProfile%\WINDOWS C:\Users\%UserProfile%\AppData\Local\VirtualStore\Windows I checked all of them and when I start Data Architect, I see my db aliases but the specified path is not the good one ?! I changed it using the interface and the ...
hi all , i'm looking for a DB software that can run on mac server and serve multiple clients , all users can update the DB. the DB will hold thousands of contacts with loads of different fields (same as mac contacts , personal, freelancers, clients, others), i want to be able to categorize contacts(entries) under Clients, Personal, Staf...
Table A consists of (id, fieldA, fieldB, fieldC, fieldD) Table B consists of (id, tableA-id, fieldE, fieldF, fieldG) My queries looks like this:- 1. select * from tableB b, tableA a where a.fieldA=? and a.fieldB=? and a.fieldC=? and a.fieldD=? and (b.fieldF >= '09/01/10' and b.fieldF <= '09/30/10'); 2. select * from tableB b, ...
I know that this isn't exactly normalised, but bringing all of the localised data throughout my application into just a few tables will help me out a lot. I have to be able to link some generic table to a LocalisedContent table which will contain different rows for each of the localised key-value pairs of the generic table joined to it....
Hello all, i would like to update my sql lite database with the native update-method of the SQLiteDatabase class of android. ContentValues dataToInsert = new ContentValues(); dataToInsert.put("name", "flo"); dataToInsert.put("location", "flotown"); String where = "id" + "=" + id; try{ db.update(DATABAS...
If a user wishes to run Primavera on SE database instead of EE, what are the pros and cons he is looking at ? ...
I have a table like this: UserID Customer ID status 1 1 1 1 2 1 1 3 1 1 4 2 1 5 1 1 6 3 1 7 2 2 8 1 2 9 2 ........ ...