Simple JTable Question


I am writing a prg which take a value from user and check weather its present in table or not....



```
table.getValueAt(i,j).toString().toLowerCase() == searchfield.getText().toLowerCase();
```

Well if yes then make that cell red...



What to write to make cell red?
I just posted an example of this over in a similar thread about JTable [here](/software-development/java/threads/373078/1605358#post1605358). Perhaps it will help.
Check if any of the values in the cells are null.  

If they are you need to modify your code to check for null conditions before using `ToString()`. i would do it like this:

https://www.advanced-excel.com/columns-to-rows.html Yes  

You would need to run the ‘LABEL ON’ SQL Statement.  

Here is a sample of code that changed the column heading for field JOBID from ‘Job ID’ to ‘NEW COLUMN HEADING’  

File is CD053DB In library Charlieb


LABEL ON COLUMN CHARLIEB/CD053DB (JOBID IS ‘NEW COLUMN HEADING’) You want something similar to this :



```
using (var context = new BloggingContext())
{
    var blogs = context.Blogs.SqlQuery("SELECT * FROM dbo.Blogs").ToList();
}

```

You can find tutorial for that here :
<http://msdn.microsoft.com/en-us/data/jj592907.aspx> 1) p(x) = 1/x2 + 1 if x ≤ 3 it is clear that x= 3 is included, so you have to use this function.2) loo k at table d, and compare the given information with the data written inside the table. done. [links to api, release notes, derived formulas, etc](https://community.weatherflow.com/t/links-to-api-release-notes-derived-formulas-etc/2450) .

thanks for the request / suggestion [@vinceskahan](/u/vinceskahan) ! Should be able to do something like this:


UPDATE table\_name  

SET new\_column = (calculated value)  

WHERE new\_column is NULL for this, just use an if function. see https://macmost.com/learn-how-to-use-the-if-function-in-numbers.html so something like this in a2: if(isblank(b2),c2,b2) the condition is to check if b2 is blank. if it is, get the value of c2. if it isn’t blank, then get the value of b2. g = findgroups(yourtable.name);
output = splitapply(@(varargin) {table(varargin{:}, 'variablenames', yourtable.properties.variablenames)}, yourtable, g);
this should give a cell array of tables. [image] nirgrahamuk:

observe({

fv <- req(input$filter\_var)

td <- req(tabledata())

updateselectizeinput(inputid = "filter\_vals",

choices = pull(td,fv))

})

observe({

fv <- as.character(req(input$filter\_var))

td <- req(table…