Search Results

Search found 30190 results on 1208 pages for 'table row'.

Page 254/1208 | < Previous Page | 250 251 252 253 254 255 256 257 258 259 260 261  | Next Page >

• How do you load data into a Table View when there's both a Tab Bar and a Nav Bar?

  - by editor

  I think I'm way overthinking the issue of having a Tab Bar project type and adding Nav Bar controls. I've followed some basic directions and have a demo app running fine with two tabs, each with a Table View and nav bars. But how do I load data into them? I know I need to hook up delegate and dataSource, but where?

  Read the article

• Why does compacting a Access 2000 db changes the order of records in a table?

  - by razvan

  As the question says. The table has no primary key defined. Other tables in the database do not change after compacting, and have as well no primary key defined.

  Read the article

• How do I modify an attribute across all rows in a table?

  - by prgmatic

  Hi folks, My apologies for asking such a novice question but, I need help building a script using either PHP or directly in MySQL that can do the following: Take the values of a column in a table (text) Change them into capitalized words (from "this is a title" to "This Is A Title") Replace the old values (uncapitalized) with the new values (capitalized). Thanks for the help and support.

  Read the article

• Is it possible to alter the table in admin interface with SQL?

  - by Eric

  In our projects table we have every version of a project. Is it possible to show only those projects where max(version_id) in the admin interface? Thanks! :) Eric

  Read the article

• IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes?

  - by Matt

  IN MSSQL 2008 is there a way to generate a report as to how much space on disk each table takes? I can do it one by one by checking the storage properties, but I was wondering if there was a way, maybe even a query to generate such a report.

  Read the article

• How can I INSERT rows into a new table and update the primary key of the transported items?

  - by ggg

  The new table has an auto-increment that I want to use for the data that I'm transferring. Here is the query I want to run. INSERT INTO `xyz_1mydata` SELECT * FROM `xyz_1production` WHERE `xyz_1production.Id` > '12000'; I don't want to replace the existing items in #_1mydata.

  Read the article

• Inability to delete table cells after a certain point.

  - by Sahil Lavingia

  I have built an app which has the ability to delete cells from a table, but only if there are more than two cells. If there are two or less cells, it only lets me select them. Any ideas? Here's a video to visualize it: http://slavingia.com/etc/helpme.mov

  Read the article

• How can I detect if an iPhone is rotating while being face up in a table?

  - by OscarMk

  Hello, Is there a way to detect if an iphone lying down in a table face up is rotating?. I do realize that this kind of movement is not reported by the accelerometer and neither is it reported to the - (BOOL)shouldAutorotateToInterfaceOrientation:(UIInterfaceOrientation)interfaceOrientation method. Is there a way to detect angle variations for the phone rotating this way?. Thank you.

  Read the article

• loading data from a flat file to table using informatica, having both english and foreign language c

  - by Manish

  I am loading data from a flat file to table using informatica, the file has both english and foreign language characters like chinese, and others. The foreign language characters are not getting displayed properly after loading. How can this problem be solved ? I could solve it by using code page UTF - 16 Encoding of Unicode Platform Endian, earlier i was using different code page UTF-8.

  Read the article

• How do I replicate a table to all nodes in a DB2 DPF instance?

  - by brianegge

  I have a dpf instance with a few large tables, which are partitioned, and a number of small tables which are not. I'd like the small table to fully exist on each node of the partition for performance reasons. How do I make db2 fully replicate these small tables to each node?

  Read the article

• How do map 1-to-1 relationship in grails to just 1 table under the covers?

  - by egervari

  Let's say I have a UserAccount domain class that has a UserPreferences domain class. I do this to separate the fields for organization purposes. Is there a way to tell grails/gorm that I really want it to map these domain classes to just the user_account table under the covers? Thanks!

  Read the article

• How to create a database table in an installation file for a Drupal Module?

  - by Koning WWWWWWWWWWWWWWWWWWWWWWW

  I am creating a module for Drupal 7.x, and I want to create a database table when the module is installed (enabled for the first time). How can I do this? Thanks.

  Read the article

• How to bind DataGrid to display only 25 records of a table having more than 1000 records ..??

  - by Devashri

  I have a datagrid control which is bound to a table which containing more than 1000 records. And i want to show only 25 records once a time. I have used paging in datagrid. But each time the next page index is set, query is fired again. This takes lots of time. So what is the easiest way to bound data in this case to improve performance..??

  Read the article

• Cocoa: how to nest a button inside a Table View cell?

  - by underthetable

  Take a look at the top pane of the Xcode window. There's a table list, with checkboxes in one of the columns. That's the interface I want to do. So how do you nest a button in an NSTableView cell?

  Read the article

• how to insert an integer value from a Grid to Sql table?

  - by z-chaos

  Hi, I have a AdvWebGrid where the 7th coloumn is DynEdit where user will enter the value.Now I have to take the enetered value and insert into the Sql tablel. For example i have 7 records in the grid the user will enter some comments for the first three record and save.Now i have to insert/update the first three comments in the table.

  Read the article

• how to run Make table query that i have in access in C# code ?

  - by Gold

  hi i have query (DO2) in access that makes a table and inserting any data. how to run this query in C# code ? i try this: SQL = "Select * from DO2"; Cmd = new OleDbCommand(SQL, Conn); Cmd.ExecuteNonQuery(); Cmd.Dispose(); but i get error

  Read the article

• How to SUM() from an offset through the end of the table?

  - by keithjgrant

  If SELECT SUM(amount) FROM transactions ORDER BY order LIMIT 0, 50 sums the amount field for the first 50 records in a table, how do a sum all records after the first 50? In other words, I'd like to do something like SELECT SUM(amount) from transactions ORDER BY order LIMIT 50, *, but that doesn't work.

  Read the article

• Zend Framework: How to subtract amount from database table field ?

  - by NAVEED

  I want to subtract a amount from a table's field in Zend Framework. I can run it with SQL using following query: UPDATE `Person` SET credit=credit-50 where id=1 But how to write above SQL query in Zend Framework?

  Read the article

• C# SQL: What is the best way to implement a dynamic table?

  - by SirMoreno

  I want to allow the user to add columns to a table in the UI. The UI: Columns Name:__ Columns Type: Number/String/Date My Question is how to build the SQL tables and C# objects so the implementation will be efficient and scalable. My thought is to build two SQL tables: TBL 1 - ColumnsDefinition: ColId, ColName, ColType[Text] TBL 2 - ColumnsValues: RowId, ColId, Value [Text] I want the solution to be efficient in DB space, and I want to allow the user to sort the dynamic columns. I work on .NET 3.5 MSSQL 2008. Thanks.

  Read the article

• How to dump temporary MySQL table into a file?

  - by Alex N.

  Is there a way to create a dump/export/save a temporary MySQL table into a file on disk(.sql file that is, similar to one that is created by mysqldump)?

  Read the article

• What is the cleanest way to sort "describe table" query results ?

  - by Youssef AZARI

  Hello everyone, I'm working on "describe table" output to show a list of fields and their types, i want my primary keys to be at top of the list.. I think there's no way to sort describe's results using SQL (something like 'order by') rather than sorting it in PHP. what do you think guys ? thanks

  Read the article

• How to use PHP Load Data Infile to replace the current copy of the table with the new one?

  - by NJTechGuy

  We get a new copy of data in a pipe-delimited text file from time to time. I have to refresh the table or in other words, replace the existing copy with that of the newly generated copy (output.txt). Any ideas are highly appreciated. Thank you..

  Read the article

• SQL Server: Is it possible to get procedure or table creation and last alter date?

  - by Woland

  SQL Server: is it possible to get procedure or table creation and last alter date? If it is then how do to it? SQL Server 2005

  Read the article

• Need a good way to store data in a DB from a table on a webpage that can have N columns.

  - by Abe Miessler

  Users need to be able to add a specific type of column to an otherwise static table on my web page and then save the information they enter in there to the database. I've been told that in reality they will almost never go over 5 columns but I would rather support N. The columns will all be of the same datatype. My first thought was to have an XML column with the values from all added columns in there but I was curious if anyone else had come up with a better solution. Suggestions?

  Read the article

• How to recover data from a table, and store that into list?

  - by Wilhelm

  How can I get ALL the data from a table of my DB (mySQL) using hibernate, and store the output into List of Objects? I'll use this List, to populate a JTable.

  Read the article

< Previous Page | 250 251 252 253 254 255 256 257 258 259 260 261  | Next Page >