1. how do i make app field (product) of multiple fields on diff tables - embedded db forums.netbeans.org |
2. Can we add a Field(column) in a table dynamically? coderanch.comHello, I have uptil now updated table by adding rows dynamically.I would like to add a field name(ie new column)dynamically. The scenario is like this. I have a administrator account who should be able to edit the table by adding new column.We have no. of premises and each premise has its own database.We wish to transfer database from one premises to ... |
3. How to get field size of a column in a data base table coderanch.comI'm not sure what you are getting at, but rsmd.getColumnDisplaySize() the normal maximum number of characters allowed as the width of the designated column. Example for the first column in a database that is Varchar (20) field, rsmd.getColumnDisplaySize(1) should return 20. If it was a Varchar (5) column rsmd.getColumnDisplaySize(1) would return 5. This method will return to you (no matter which ... |
4. tables and fields coderanch.com |
5. id of the new field in my table coderanch.com |
6. search database of all tables for one field in table coderanch.com |
7. get fields and types for tables coderanch.comMy goal is to write a utility like i use in my ASP database work. given a table name in a database it auto generates a class wrapper for the table that knows how to insert/update/delete from the table. before i go and re-invent the wheel, is there one out there that i can customize to my needs. If not, is ... |
8. How many fields in one Table coderanch.com |
9. Usage of Reserved words for Database Table fields coderanch.comI have one more problem... Im doing a Database Migration from HSQL to DERBy.. Some of the tables in my Source Database(HSQL) have reserved words like "USER", "CLOSE", "OPEN"...etc When I migrate the database to DERBY which is my destination DB Im getting trouble with these reserved words... the table which have these reserved words raises exception..and the table is never ... |
10. How can we know the Data Table fields changed for every 5mints coderanch.comIf this is a web app, then a trigger is probably not the way to go. Web apps are request driven, so even if the data changes there is no way to push that change out a client. From a web app, your only real route would be to poll the table to watch for changes. You could do this in ... |
11. how I can swap content of two fields in one table? coderanch.com |
12. about null fields in a table coderanch.comi have a table for example, Address userId | homeAddress | currentAddress normally a table will look like this, and im worried when my users will vastly increase, some will not fill out the home address or the current address, so there will be a field that is null in the table if that will be the structure. so I re ... |
13. Copy field in the same table coderanch.comHi. I want to copy one field in the same table. Expect we have some "productDescriptions" for companyID = 249. How can we copy the "productDescriptions" to companyID = 248? The code I tried which doesn' t work: UPDATE product SET productDescription = ( SELECT productDescription FROM product WHERE companyID = 249 ) WHERE companyID = 248 The error in mySQL ... |
14. how to maintain a table field's value from second table'value coderanch.comNasty data modelling. Are you stuck with this? If not, I would review it. You are making your life harder than it needs to be. If you can't, triggers, as Muhammad suggests, are the way to go. Java code is not the place to do it because you are making your data model rely on one specific database client. |
15. Multivalued field in a table. java-forums.org |
16. How to get database, table's name, field's name and field's type? forums.oracle.comGreetings, I'm a student in a computer high school, and I'm completely new to java. What I know are OOP theory, java applet and thread. I was a delphi programmer, and I want to migrate to java. There's several things I want to do in java. I want to make a program that accept an "url connection string" , "driver" etc. ... |