Search Results

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

Page 162/1208 | < Previous Page | 158 159 160 161 162 163 164 165 166 167 168 169  | Next Page >

• Integration Services Throws an Error Reading Access 2007 Table

  - by Eric Flamm

  [Participant Table [1994]] Error: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "I:\My Documents\Flamm Consulting\Migrations.accdb" failed with error code 0xC0209303. There may be error messages posted before this with more information on why the AcquireConnection method call failed. Frankly, I'm confused about how SSIS should connect to Access 2007 - the UI just isn't very friendly - there's no file browser, for example. I'm wondering if there's something wrong with my install - missing drivers, etc.

  Read the article

• More efficient left join of big table

  - by Zeus

  Hello, I have the following (simplified) query select P.peopleID, P.peopleName, ED.DataNumber from peopleTable P left outer join ( select PE.peopleID, PE.DataNumber from formElements FE inner join peopleExtra PE on PE.ElementID = FE.FormElementID where FE.FormComponentID = 42 ) ED on ED.peopleID = P.peopleID Without the sub-query this procedure takes ~7 seconds, but with it, it takes about 3minutes. Given that table peopleExtra is rather large, is there a more efficient way to do that join (short of restructuring the DB) ?

  Read the article

• how to add unique to a table column in ruby on rails

  - by ohana

  hi, I have a table with some columns, now i need to modify one column to make it unique(no duplicate values), how can i do that in ruby on rails?

  Read the article

• How to constrain a table linking two tables in many-to-many relationship

  - by Gromul

  Say I have the following tables and columns: comp: id, model dvd: id, model comp2dvd: id, id_comp, id_dvd A computer can have multiple dvd drives, even of the same model, and a dvd drive can appear in multiple computers. How do I make it so that comp2dvd table can have only existing comp and dvd ids? Thanks

  Read the article

• Truncating table does not make the mysql file smaller

  - by ming yeow

  I truncated several huge tables, but the mysql file and database appears to remain at the same size. Does truncate table delete the data from mysql as well?

  Read the article

• ASP.net looping through controls in a table

  - by c11ada

  hey all, i have a table which contains a bunch of dynamically created radio button lists, im trying to write code which will loop through each one of the radio button list and get the text value of the selected item. i have the following code foreach ( Control ctrl in Table1.Controls) { if (ctrl is RadioButtonList) { //get the text value of the selected radio button } } but i am stuck on how i can get the value of the selected item for that given control.

  Read the article

• How to Enable Full-Text Index on Sql Server 2008 Table

  - by michaeldelorenzo

  Not sure what's happening with this, but here's my question. I have a Sql Server 2008 database that I need to be able to do full-text indexing/searching but when I try to setup my indices on the table, I get the following: I've tried running this stored procedure on my database and it's successful: EXEC sp_fulltext_database @action = 'enable' But I still get the above window and my full-text searches don't return any results when they should. What am I missing?

  Read the article

• Create a new table and import data from csv file into SQL Server 2005

  - by Madhu Kiran

  Hi, I have several files about 15k each of CSV data I need to import into SQL Server 2005. What would be the simplest way to import the csv data into sql server? Ideally, the tool or method would create the table as well, since there are about 180 fields in it, this would simplify things.

  Read the article

• please don't ask me to redesign my table and help me with sql query

  - by saurav

  i have a table as given with name and 10 cities in which he lived during his lifetime. name , c1 , c2 ... ,c10. For a particular name i want to fetch other people who have lived in three or more cities lived by this person.

  Read the article

• Editing a table like iPhone Mail

  - by user217572

  The iPhone Mail application has an edit button in the navigation bar. Tapping that button shows a delete button in the toolbar and shows checkbox controls in the table cells. Tapping one or more checkboxes then tapping the delete button causes the checked messages to be deleted. How can I add similar functionality to my own code? Here's a screenshot of the effect I'm looking for:

  Read the article

• MySql TABLE data type

  - by Neil Aitken

  MS SQL Server has a TABLE data type which can be used in stored procedures, Does anybody know if MySQL has an equivalent data type? I've had a look over the docs but can't seem to find anything, so I presume it doesn't exist, but perhaps somebody has created a workaround

  Read the article

• How to load a table view when coming to back with out selection index

  - by ratnasomu

  Hellow all, I am using navigation controller and have table views inside views. when i select any cell it it will navigate to another view. so,from there if i click back button it come sto previous view.But,it showing the cell which is selected previously. I dnt want this .it should not show which cell we selected previously. Could any one help me how to get this. Thanks.

  Read the article

• Find and replace braced tags within a MySQL table

  - by Cy

  I have about 40000 records in that table that contains plain text and within the plain text, contains that kind of tags which its only characteristic is that they are braced between [ ] [caption id="attachment_2948" align="alignnone" width="480" caption="the caption goes here"] How could I remove those? (replace by nothing) I could also run a PHP program if necessary to do the cleanup.

  Read the article

• fetch fourth maximum record from the table field

  - by chetan

  Following is the command to fetch maximum salary form empsalary table in mysql select max(salary) from empsalary; but I want to fetch employee who got fourth highest from the list of employee. I don't want to use trigger or function because I know there is direct command to fetch.

  Read the article

• Change table cell color in Java

  - by pypmannetjies

  I have read and implemented this http://stackoverflow.com/questions/818287/changing-jtable-cell-color What I'd like to know is how to actually use this code? I just want to change a table cell's colour when I click on it.

  Read the article

• SQL Server: how to export a table

  - by Patrick

  how can I export a SQL Server table to Mysql ? I guess I need to export a .sql file compatible... thanks

  Read the article

• Zend_Pdf table?

  - by Richard Knop

  Is it possible to create a table in Zend_Pdf? If yes, could you give me some code snippet? I've tried searching documentation and devzone but I couldn't find anything about adding tables to pdf.

  Read the article

• Import CSV file data into Postgres table

  - by vardhan

  Hi , Iam new to postgres, i want to write an stored procedure that imports data from a csv file and populates the table . Kindly help.

  Read the article

• Best naming for a column in a SQL Server table

  - by Lance Fisher

  Which of the following three options would you choose for a column name in a SQL Server table, and why? YearToDateWages YTDWages YtdWages Follow up: SSN Ssn SocialSecurityNumber

  Read the article

• mysql search number in table

  - by Sanjay

  hi, i am using php/mysql. i have a product table . in which most product have starting name with number. i want to listout all products start with any number. any one have idea about it....

  Read the article

• free pivot table implementation for qt

  - by Michal Nowotka

  I'm looking for free implementation of pivot table view for Qt. Does someone know where to find such piece of code? Or maybe it's trivial to implement...

  Read the article

• Table with unequal rows in XUL layout

  - by Michael

  Trying to get something similar for Firefox extension using XUL. The most difficult part is the grid with unequal number of rows. I tried <grid> but it didn't work well. Also don't want to use HTML inside of XUL. Any ideas how to build such table?

  Read the article

• use a variable for table name in mysql sproc

  - by Kyle

  I'm trying to pass a table name into my mysql stored procedure to use this sproc to select off of different tables but it's not working... this is what I"m trying: CREATE PROCEDURE `usp_SelectFromTables`( IN TableName varchar(100) ) BEGIN SELECT * FROM @TableName; END I've also tried it w/o the @ sign and that just tells me that TableName doesn't exist...which I know :)

  Read the article

• How do I customize a table view?

  - by Nathan

  Interface Builder Question I know there's a way to change the background color of a table, but is there a way to change the text color? Please Help

  Read the article

• what is an index in a table?

  - by Ramesh

  What is an index in table? Related with realworld entitly like librabry. what are the types of indexes? please related this too also with real world entity.

  Read the article

< Previous Page | 158 159 160 161 162 163 164 165 166 167 168 169  | Next Page >