Hi, I am currently writing a VB .NET application where I am trying to open 1 database, create a select statement and then post the results into another database file using Microsoft Access database 2003. The code seems to stop executing at the statement cmdJetDB.ExecuteNonQuery() I am using the following code: Dim conn1 As OleDbConne...
My company recently opened an office in Singapore. I work on the web application we use internally to manage the company, using a SQL Server 2005 back-end. Because of slow access over the net from Singapore, we're shipping them a server that will host a local copy of the web app and database and we want to keep their local version of t...
I am not very familiar with databases and what they offer outside of the CRUD operations. My research has led me to triggers. Basically it looks like triggers offer this type of functionality: (from Wikipedia) There are typically three triggering events that cause triggers to 'fire': INSERT event (as a new record is being inserted...
I want to implement NHibernate on my domain objects in my project, but I'm not sure how I should go about generating the mapping file, and the database. I've found some questions that kind of touch on this here and here, but I'm starting with my classes already defined, and would like to start from them and work my way down, not the oth...
[ edit ] For the record, here's the problem portion of the query, which is now working: SELECT m.groupNum, t.ea, ( t.ea - ( t.ea * m.margin )) AS estCost, (( t.ea - ( t.ea * m.margin )) * t.quantity ) AS salesSub, ((( t.ea - ( t.ea * m.margin )) * t.quantity ) / ( SELECT SUM(( t2.ea - ( t2.ea * m.margin )) * t2.quantity ...
I'm working on a viewer program that formats the contents of a database. So far it's all been read-only, and I have a Refresh button that re-queries the database if I want to make sure to use current data. Now I'm looking at changing the viewer to an editor (read-write) which involves writing back to the database, and am realizing there...
I know what a key is, I know what opaque is in other contexts - but what is an opaque key in a database context? ...
I've only really used phpMyAdmin and SQL calls from PHP to use a database before, and I want to use that same functionality in C++, but I'm not sure how to go about doing that. What is a good database system to use? Is there a good open source one available? What headers/functions do I need in order to connect to/use the database in C++?...
Hi, We use mysql server as a centralized logging system and I want to have a job to delete\clean the table entries that are more than 3 months old regularly. What is the best way to do this? Thanks in advance. -hinling ...
Is there a way to implement a CHECK constraint that checks a value against another value in a different column in the same table? Specifically, I want to ensure that a "checkout" date value to be inserted is greater than the "checkin" date value in the table before inserting the row. I may be missing some details, so please let me know ...
Anyone now what is a draft design of a database??? Is it the design process and steps like: Determine the purpose of your database Find and organize the information required Divide the information into tables Turn information items into columns Specify primary keys Set up the table relationships Refine your design Apply ...
I'm developing software using the google app engine. I have some considerations about the optimal design regarding the following issue: I need to create and save snapshots of some entities at regular intervals. in the conventional relational db world, I would create db jobs which would insert new summary records. for example, a job w...
In the context of a web application, my old boss always said put a reference to an image in the database, not the image itself. I tend to agree that storing an url vs. the image itself in the DB is a good idea, but where I work now, we store a lot of images in the database. The only reason I can think of is perhaps it's more secure? You...
I have an application where the database back-end has around 15 lookup tables. For instance there is a table for Counties like this: CountyID(PK) County 49001 Beaver 49005 Cache 49007 Carbon 49009 Daggett 49011 Davis 49015 Emery 49029 Morgan 49031 Piute 49033 Rich 49035 Salt Lake 49037 San ...
I am aware that MySQL and PostgreSQL[1] do not have that concept, so I am interested in finding out of there is an open-source SQL database that does have the concept. [1] It was later pointed out that PostgreSQL does have the rowid pseudo-column. ...
I'm working on the project with relatively big DB table(700K rows). Mistake, I've made while designing DB schema. When rows were increasing, I had to increase ID's column type bigint(x). Now it is bigint(44). I afraid of setting high x value because I thought that it can significantly slows down performance. Maybe I'm wrong.. Please h...
Hi, I'm working with open esb on a glassfish server. We have a connection pool that works with an as400 Database. Every couple of days we get this error: Error in allocating a connection. Cause: In-use connections equal max- pool-size and expired max-wait-time. Cannot allocate more connections The best way to relief the cp is to resta...
I'm trying to call a row update from php to an mysql database. It fails out but when i try to call an insert new row formated just the same it works. $result = mysql_query("INSERT INTO auth (username, password, studycode, description, server) VALUES ('$username', '$password', '$studycode', '$description', '$server')"); but this code f...
Actually wat I need is: I have submitted some data in database from a html form. Then I have to load one column of that data in select tag of another form. I have done this but problem is that how will I increase the number of options as the number of records are increased. Code is as follows <%@ page import="java.util.*"%> <%@ page ...
I'm working on a MVC based web app on LAMP that needs some records to be modified only under the approval of a "superior" user. (The normal user can submit changes but they get applied only after this approval) There are is only a table in which this would have to take place, say "events": EVENTS - id - name VARCHAR - start_date DAT...