column

Java Swing - Can i make a JTable column without borders ?

I have created a column with cells that contain a JTextArea + A JButton inside it, as you can see in the image below in Column 3 : But i have faced lots of problems with my CellRenderer and CellEditor when updating the cells values in that column, as my code is a bit complicated. So instead i want to replace that column with 2 columns...

TSQL Average Column By Distinct Entries In Another Column

I start with a table looking like this... +-------------------------+ | procName | TimeEnded | +-------------------------+ | A | 04:00:00.000 | | B | 04:01:00.000 | | C | 04:03:00.000 | | A | 04:06:00.000 | | B | 04:10:00.000 | | ... | ... | Run a query to generate a RunTime column,...

hide column (header and rows) post jqGrid render

Is it possible to hide a specific column in jqGrid after it has been setup, while ensuring all alignments are correct (table width and header/data alignment) for IE/FF. The data can't be removed at back-end w/o major refactoring. I am reiterating through a specific column and checking if it is all empty, and if so, I tried .remove() on...

Inserting columns into a Table

Hello, I have a table with 3 columns. Now I want to insert another column, but I want to insert the new column after the first one. Now I'm wondering how this can be done. If I'm not wrong, the Table.Columns property isn't really representing columns, it's more representing their layout but has nothing to do with the values of the colum...

How can I evenly distribute columns in a DataGrid in Flex?

I have 16 columns in a DataGrid in my Flex app. The first 15 look fine, with the column, simply containing the text, but the last one has a lot of extra space. Essentially, the columns are just big enough to fit the first 15 and all that extra space is tacked onto the 16th column. How can I evenly distribute the space over each column? ...

Xslt how to style conditional odd/even rows

I've an html table written using xslt transformation that looks like this <table> <xsl:for-each select="someNode"> <xsl:if test="testThis"> <tr> <!-- <xsl:call-template name="conditionalRowStyle"/> --> <td>something</td> </tr> </xsl:if> <tr> ...

Oracle read nth column using a cursor

hi, can i read column data in a cursor giving the index of the column? thanks... From the questioner's comments : "I need to create a generic procedure which will read a table or view (name of the view or table is the argument of the proc) and encrypt the data in the column and then will write the encrypted data to a OS file. " ...

Adding new columns to a column database having billions of rows.

I want to add a new column to a table which already consists billions of rows. The new columns are derived from existing columns. For example, new_col1 = old_col1 + old_col2 new_col2 = old_col1 / old_col2 I am trying to do this in following way - Add new columns ALTER TABLE table_name ADD ( column_1 column-definition, colum...

WPF ListView column selection

I have a ListView. When I select a row I want that only one cell was selected not the whole row. How can I get this? Here is my styles and templates. <ListView x:Name="List" ItemsSource="{Binding }" ItemContainerStyle="{DynamicResource ListItemStyle}"> <ListView.View> ...

Get Column names with Delphi (Dbexpress)

Hi , I'm using this sql command to get column names : select COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS where TABLE_NAME = 'MyTableName' but i don't know how can i using the executed SQL command results ! for example , this way doesn't work to extract the column names as a string value and i got this error = Operation Not Supporte...

Excel: Find value in column(s)

I've got an Excel spreadsheet with multiple columns of different lengths, each filled with unsorted numbers. Each column has a header. Is there a way to determine which column(s) contain that number? For instance, I'd love to be able to do =WHICHCOLS( 123, A, Z ) and have Excel tell me columns [B, C, and K] contain cells with a value ...

Access: Text , Memo or VarChar ? Which one to use ?

Hi, What's the difference between VarChar, Text and Memo in Microsoft Access ? Regards, MadSeb ...

column _id does not exist

Hi, the error in my logcat is such Logcat 08-29 08:20:57.961: ERROR/AndroidRuntime(1766): java.lang.RuntimeException: Unable to start activity ComponentInfo{one.two/one.two.Booking}: java.lang.IllegalArgumentException: column '_id' does not exist 08-29 08:20:57.961: ERROR/AndroidRuntime(1766): at android.app.ActivityThread.performL...

SQL : The influence of research speed with empty clolumns?

Hi, I'd like to know if some empty columns (with the field 'null' for example) can decrease the speed to make a query "SELECT" on a indexed column or a normal column. Thanks, Ba ...

How to set a controlparameter to the value of gridtemplatecolumn dropdownlist??

Hi, I have a radgrid in which there are 5 columns. one of the column is gridtemplatecolumn in which the itemtemplate is a label and edititemtemplate is dropdownlist. Code is as given below: <telerik:GridTemplateColumn DataField="GameId" HeaderText="Game Id" SortExpression="GameId" UniqueName="GameId"> ...

DataSet column can be NULL but not converted to string ?

I have a string which can be empty if its not empty it is containing a xml document. The problem is null values are allowed in this dataset column of DataType System.String. Error Message:this.MetaData' threw an exception of type 'System.Data.StrongTypingException' base {System.SystemException} = {"The value for column 'MyData' in tabl...

indexes needed for table inheritance in postgres?

this is a fairly simple question, but it's one i can't find a firm answer on. i have a parent table in postgres, and then several child tables which have been defined. a trigger has been established, and the children tables only have data inserted if a field, say field x, meets a certain criteria. when i query the parent table with ...

SQL/ASP - Invalid column name 'Email'.

hey all, i am having trouble adding stuff into the Email column. I can add stuff into the Username column but for some reason i get the following error: Microsoft OLE DB Provider for SQL Server error '80040e14' Invalid column name 'Email'. When I use this code: Set rstSimple = cnnSimple.Execute("insert into SALT (Email, Username, Fi...

What SQLite column name can be/cannot be?

Is there any rule for the SQLite's column name? Can it have characters like '/'? Can it be UTF-8? ...

Android TableLayout: preserve column widths between different tables

I have two TableLayouts, one above the other, in my View. I want them to act as a single table for the purpose of calculating column widths, but appear separately with a gap between them (and the main View background showing through) for aesthetic reasons. Each table has 3 columns, and I want the column widths sized automatically depend...