Search Results

Search found 16978 results on 680 pages for '80 column'.

Page 39/680 | < Previous Page | 35 36 37 38 39 40 41 42 43 44 45 46  | Next Page >

• VB.Net: Resizing ListBoxView Column When Form Resizes

  - by Ben

  How can I have a single column resize with the form so that the ListBoxView columns continue to fill the whole form?

  Read the article

• Search for multiple values in an xml column

  - by Yuriy Gettya

  Environment: SQL Server 2012. Primary and secondary (value) index is built on xml column. Say I have a table Message with xml column WordIndex. I also have a table Word which has WordId and WordText. Xml for Message.WordIndex has the following schema: <xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" …

  Read the article

• Update Column of NCLOB Issue

  - by Mahesh

  Hi, I am using Oracle10g. One of my tables contain column of type NCLOB. I want to change the column's data by query or by the use of the SQL Developer. But i don't know, it is not allowing me to update the value. 1)Can anyone please help me why this is happening? 2)Or should i use some other datatypes in place of the NCLOB. (i want…

  Read the article

• InnoDB "Column count doesn't match value count at row 1"

  - by Webnet

  I'm having issues with a table. I'm using the following to create my insert query... $validatedData = array(); foreach ($post as $key => $value) { if ($key != 'submit' && $key != 'dz_tos' && $key != 'dz_billShip') { $validatedData[$key] = filter_var($value, FILTER_SANITIZE_STRING); } } …

  Read the article

• mySQL - Separate Lastname,Firstname and CompanyName entries from a single column

  - by Decalmo

  I've got a column in a database which contains company names, and customer names all in one field... what I'd like to do is keep the CompanyName column completely intact, but wherever there is a comma in the CompanyName I'd like to take that information and populate it into a FirstName and LastName field. So that…

  Read the article

• How to prevent column b containing the same value as any column a in Oracle?

  - by Janek Bogucki

  What is a good way to prevent a table with 2 columns, a and b, from having any record where column b is equal to any value in column a? This would be used for a table of corrections like this, MR -> Mr Prf. -> Prof. MRs -> Mrs I can see how it could be done with a trigger and a subquery assuming no…

  Read the article

• SQLite Modify Column

  - by Nathan

  I need to modify a column in a SQLite database but I have to do it programatically due to the database already being in production. From my research I have found that in order to do this I must do the following. Create a new table with new schema Copy data from old table to new table Drop old table Rename new…

  Read the article

• Unable to reverse seemingly simple rails migration - getting "altered_table.column may not be NULL"

  - by brad

  I have a table 'invoices' in my development database (sqlite3) populated with a small amount of test data. I wanted to add a column 'invoice_number' to it and set up a migration like so: class AddInvoiceNumberColumnToInvoices < ActiveRecord::Migration def self.up add_column :invoices, :invoice_number,…

  Read the article

• horizontally scrollable table column

  - by Alexandru Cucu

  Hello, I would need to build a html table that has a horizontally scrolable column. The scroll should be placed in the column's header. My question first question is: do you know any jquery plug-in that is able to do this? My second question: is this possible using a single table. I've heard that in order to…

  Read the article

• Ruby fixtures error with password column

  - by user347998

  I am trying to load a fixture for my tests which has a password column (binary datatype). The tool i am using uses EzCrypto gem for encrypting and decrypting passwords before they are stored/retrieved. Now if my column is binary i thought rails would automatically store the password as encrypted - but all i…

  Read the article

• how to get column type of datagridview columns in vb.net

  - by meenakshi

  How do I show textbox column of datagridview in multiline format using vb.net?

  Read the article

• Transact SQL IDENTITY like column types

  - by Lucas

  Is there an IDENTITY column type that generates alphanumeric values? Like 023904F?

  Read the article

• asp.net free webcontrol to display crosstab or pivot reports with column and row grouping, subtotals

  - by dev-cu

  Hello, I want to develop some crosstab also know as pivot reports in Asp.net with x-axis and y-axis being dynamics, allowing grouping by row and column, for example: have products in y-axis and date in x-axis having in body number of sells of a given product in a given date, if date in x-axis are years, i…

  Read the article

• How to take the value of a DynEdit column of a TMS AdvWegGrid

  - by ahmed

  How to take the value of a DynEdit column of a TMS AdvWegGrid and insert or update in SQL ?

  Read the article

• SQL Overlapping and Multi-Column Indexes

  - by durilai

  I am attempting to tune some stored procedures and have a question on indexes. I have used the tuning advisor and they recommended two indexes, both for the same table. The issue is one index is for one column and the other is for multiple columns, of which it includes the same column from the first. My…

  Read the article

• problem with null column

  - by Iulian

  One column in my database (of type double) has some null values. I am executing a sored procedure to get the data in my app wipDBTableAdapters.XLSFacturiTableAdapter TAFacturi = new wipDBTableAdapters.XLSFacturiTableAdapter(); var dtfacturi = TAFacturi.GetData(CodProiect); Then i try…

  Read the article

• Creating SQL Server index on a nvarchar column

  - by Jahan

  When I run this SQL statement: CREATE UNIQUE INDEX WordsIndex ON Words (Word ASC); I get the following exception message: The CREATE UNIQUE INDEX statement terminated because a duplicate key was found for the object name 'dbo.Words' and the index name 'WordsIndex'. The duplicate key value is…

  Read the article

• HyperTreeList Fix Width Column

  - by MA1

  How to make a fixed width column in HyperTreeList? So, that user can't resize it.

  Read the article

• mvc 2.0 updatemodel and my ID Column

  - by femi

  Hello, I have created a create view within my MVC 2.0 Application and by default it included a field for the integer ID Column. This is definitely a field i do not need. If i remove the field and use updatemodel when trying to create the object in code, will something break because it doesnt see my…

  Read the article

• ExtJS Data Grid Column renderer to have multiple values

  - by Podlsk

  Hi, I am wondering if it is possible in ExtJS to have several values of the data source available to the renderer of the column. For example with the "Actions" column, the id is passed to the renderer. However I require both the user_id and id passed to the render. How may I do this? table_cols =…

  Read the article

• Inserting a table column with jQuery

  - by fudgey

  I have a table of data that I need to dynamically add a column to. Lets say I have this basic table to start with: <table> <tr><td>cell 1</td><td>cell 2</td><td>cell 3</td></tr> <tr><td>cell 1</td><td>cell…

  Read the article

• Stored Procedure for Multi-Table Insert Error: Cannot Insert the Value Null into Column

  - by SidC

  Good Evening All, I've created the following stored procedure: CREATE PROCEDURE AddQuote -- Add the parameters for the stored procedure here AS BEGIN -- SET NOCOUNT ON added to prevent extra result sets from -- interfering with SELECT statements. SET NOCOUNT ON; Declare @CompanyName…

  Read the article

• Returning the value of an identity column during/after SQL INSERT command

  - by Adam Kane

  Using VS 2010, with ASP.NET, and .NET 3.0, and C#... When I use a System.Web.UI.WebControls.SqlDataSource and call its Insert() method to insert a new row, and that table has an identity column, I'd like my method to return the value of that column. For example, in my SQL 2005 table,…

  Read the article

• Table and column naming conventions when plural and singular forms are odd or the same

  - by Superstringcheese

  In my search I found mostly arguments for whether to use plurality in database naming conventions, and ways to handle it in either case. I have decided I prefer plural table names, so I don't want to argue that. I need to represent an animal's species and genus and so on in a…

  Read the article

• SQL IDENTITY COLUMN

  - by andreas

  Hey guys i am have an sql table which is basically a statement. Now lest say the records i have in my table have a date and an identity column which is autonumbered and defines the order which the transactions are displayed in the front end to the client. The issue is during…

  Read the article

< Previous Page | 35 36 37 38 39 40 41 42 43 44 45 46  | Next Page >