Wow, I'm having a bit of a headache with Access 2007. I have two tables, main_table and ref_table. when I store an int id in main_table corresponding to some record in ref_table, I get the looked up value of the record that I'm storing and not the int id. This isn't what I expected and I'd like access to behave like every other databa...
Hello, I have a question. I hope someone can help me out on this one. I'm setting up a sharepoint-site for a client of ours. There's a document library ("Customers"), in which every Customer has one folder (=customername) with 4 sub-folders. The subfolders are always the same ("Technical Information", "Documents", "Security information...
I ran an update statement on a large PostgreSQL table through the phpPgAdmin interface. This timed out as it ran for too long. I can now update some rows from that table but not all. Trying to update some rows will hang. Are the rows locked? How can I allow these rows to be updated? ...
I need to check whether a given date is in the preceding month for a monthly query. I can get CURRENT DATE - 1 MONTH to compare the selected date with, but I can't assume the current date will be the first day of each month exactly. Is there a built in way to get the first day of the month without extracting the year and month and glu...
i am updating/inserting/deleting values on more than 1 database and want to implement a transaction. currently its done like try{ db[1].begintransaction(); db[1].ExecuteNonQuery(); db[2].begintransaction(); db[2].ExecuteNonQuery(); ... db[N].begintransaction(); db[N].ExecuteNonQuery(); // will execute only if no exception raised du...
I am developing an Erlang application which requires a LOT of DB writes. My schema has, in addition to the primary key, another attribute with a unique constraint enforced. Say I have an ID, an unique_constraint_field, and some other fields. I need to now update a row in the DB corresponding to the unique ID, given that no other row sh...
I have a C# program that uses System.Data.OracleClient to access an oracle database. The code uses OracleCommand, OracleDataReader objects. And it uses the TNS names to refer to specific oracle servers (as defined in the tnsnames.ora file). It runs fine on my computer. And then I copied the binary to another computer, and upon running ...
My company has me working on finishing a back end for Oracle for a Python ORM. I'm amazed at how much differently RDBMSes do things even for the simple stuff. I've learned a lot about the differences between Oracle and other RDBMSes. Just out of sheer curiosity, I'd like to learn more. What are some common "gotchas" in terms of portin...
This problem has bugged me so many times and i have now decided to try and find the proper solution for it, instead of my long-winded/dirty/horrible way I always revert to (copying the sql statement) The table has a date column with a default value of NULL Now what i need to do is pass a value (-1,0,1) to an sql statement which determi...
I am creating a SQL Server database programmatically during a conversion. If the conversion code fails I want to delete/drop the database. If I use the shortcut menu for the database in SQL Server Management Studio 2005 the "delete" option is disabled. DROP DATABASE command also fails with message "Cannot drop database "XYZ" because it i...
For my school project I am buiding a time registration program. It is my first in ruby on rails, so even the simplest things are hard . ;) The situation: Users can work on a project, and I want to display in a chart how many hours each user worked on a project, let's say, each month. The chart plugin works like this: first_serie = O...
I am currently working on an application that has different permissions/users for the local development environment and test. I want to be able to ignore the users and permissions when deploying to either environment. Under the .sqldeployment file, there seems to only be options for ignoring permissions (IgnorePermissions) and role mem...
Table1 has a list of items. Table2 has a list of groups the items can be associated with. Table3 is a cross-reference between 1 and 2. The groups in table 2 are set up in hierarchical fashion. Key ParentKey Name 1 NULL TopGroup1 2 NULL TopGroup2 3 1 MiddleGroup1 4 2 Middle...
What's the best way to store EXIF data from photos in a Database (MySQL in my case). This is for a photo sharing site. What are the most important Tags, and what are discardable? ...
Are JOIN queries faster than several queries? (You run your main query, and then you run many other SELECTs based on the results from your main query) I'm asking because JOINing them would complicate A LOT the design of my application If they are faster, can anyone approximate very roughly by how much? If it's 1.5x I don't care, but if...
Unfortunately Sun Microsystems behaving badly by removing the link to the article on how to create custom storage engine for MySQL. By any chance you have that article, or can point to another resources on the web that talks about how to create custom engine? This is 'dead' link ...
Hi, A client of mine have a progress 7.3 database. The company that made the system is out of business, and he wants to export the data to text files. However, the company did not give him the admin password. The question is: how can we reset/recover the password of a Progress database? Thanks ...
Say I have a query like this: select ((amount1 - amount2)/ amount1) as chg from t1 where ((amount1 - amount2)/ amount1) > 1 OR ((amount1 - amount2)/ amount1) < 0.3 Is there a way I can perform the arithmetic calculation only once instead of doing it thrice as in the above query ? EDIT: I am not sure if the datab...
Once I created a form builder where user could select any number of fields for a web form. The tool then produced a code snippet which user could copy in the JSP. The submitted form data was stored as a key-value pairs in the DB, so basically just two columns were required for the form specific data. If I remember right, the processing ...
Hello, I m working on a single user swing application that access an hsqldb database. How can i Automatically run the DB server when a user run the application.? for example, after i finish development i will put the application into an exe file. If the exe file is distributed to multiple users. How can the DB server run and the DB b...