I am using visual basic as the coding language. conSQL.Open() Dim cmd As New SqlCommand("update Phd_Student set student_name = '" + studentnameTextBox.Text + "' where student_id = '" + studentidno.Text + "'", conSQL) cmd.ExecuteNonQuery() conSQL.Close() This does not change the value of the record. I created a brea...
I have to make a decision of which database server to use for my next project, but the simple decision to use MySQL like almost all the projects I did is harder now, because I expect very much records. The database will store a user list, some other irrelevant tables, and the last one, some user-collected data. Let's say, if I have 6000...
We have an application that uses Hibernate's 2nd level caching to avoid database hits. I was wondering if there is some easy way to invalidate the Java application's Hibernate 2nd level cache when an outside process such as a MySQL administrator directly connected to modify the database (update/insert/delete). We are using EHCache as...
I know there are many database design tool, database modeling tool. Example, ER-win , db desginer and etc. But, they are not supported for Ruby on Rails. What is the best way or tool to design database for Ruby on Rails? Appended: I know the rails development phases are growing step by step. But, When starting of project, I think da...
Hey all, I'm having a difficult time wording this properly which is why im having trouble finding an answer online, so the best I can do is give an example. I have the following database table: ACTORNAME SERIESNAME ------------------------------ ------------ baldwin found baldwin ...
how to add multimedia files(such as images) in a database(SQL SERVER or ORACLE) ...
There are couples of questions around asking for difference / explanation on identifying and non-identifying relationship in relationship database. My question is, can you think of a simpler term for these jargons? I understand that technical terms have to be specific and unambiguous though. But having an 'alternative name' might help ...
I have no experience with access. How to do update/insert/delete/select statement with and without $rs = new com("ADODB.RecordSet"); ? ...
I need a database tool where i can easily add information to it. Example: I have 2 tables, customers and invoices. The database tool must show me input fields of the customer and invoices. invoice has a foreign key to customer. The input fields of invoices must have a dropdown where i can select the customer so i won't have to copy pas...
I'm trying to write a sql query to get all the fields in a given item in Sitecore. To say I am stuck is putting it mildly. I'm guessing I have to do some self joining on the fields table, but I'm getting myself in knots. Anyone have any ideas? ...
Should I be scared of upgrading the database to SQL Server 2008? Is it a simple auto-upgrade and everything works? Is it worth it? ...
I would like to provide database for my program that uses elixir for ORM. Right now the database file (I am using SQLite) must be hardcoded in metadata, but I would like to be able to pass this in argv. Is there any way to do this nice? The only thing I thought of is to: from sys import argv metadata.bind = argv[1] Can I set this in...
Hi I'm looking to refine my workflow around NHibernate and a relatively frequently changing schema, and how best to deal with this - I would like the same solution to apply to production systems, so I think I need a migration engine rather than just Schema Update. What I want to know is how i can refine the workflow as far as possible s...
Hi, I guess this is strange situation. I have a results table which contain 100k records, basically this table consists of transactions with particular ID's ( not PK). I am displaying the results limiting the records to 3000. I am using Javascript tool box to display a filter on top of table heading so that users can select / filter...
I am developing Delphi 7 application, which is operating with Access Database (MDB format). It works fine on my PC, and some other PCs as well. But on some machines application gives error when trying to access database sometimes, saying something like "Unkown database format (mdb)". Additionally I noticed one thing: When you open that d...
We have an application we would like to port to the BlackBerry platform that reads its data from a SQLite database that, for the purposes of this port, will be around 4 MB. This database isn't particularly complicated (few relationships, two interesting tables to index/search and the resultant data) and is only used for reading. What's...
I have to develop a web application in Java, a pretty big one with loads of data to store and manipulate. I am also planning to use Hibernate and Spring. There are many databases available now like MSSQL Server, MySQL Server, Oracle, db2, etc.. Which do you recommend? Features I look for would be Java - database connection should be ...
I'm thinking of designing a database schema similar to the following: Person ( PersonID int primary key, PrimaryAddressID int not null, ... ) Address ( AddressID int primary key, PersonID int not null, ... ) Person.PrimaryAddressID and Address.PersonID would be foreign keys to the corresponding tables. The obvious proble...
I am coding in Visual Basic. I am using a checkbox control. Now depending on its checked property I need to set/unset a bit column in a SQL Server database. Here's the code: Try conSQL.Open() Dim cmd As New SqlCommand("update Student set send_mail = " + _ sendemailCheckBox.Checked.ToString + " where stud...
It came up again today how to handle allowing users to add custom fields to the standard entity schemas delivered in your product's database. I favour actually providing a function that gives the user limited DDL functions, so they can actually add a new, custom field to a table. Another approach is to have a separate table for custom ...