# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=58 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 59 --- ## [Modified history graph](https://forum.inductiveautomation.com/t/modified-history-graph/114)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 5\ **Last updated:** [September 28, 2006, 5:16pm UTC](https://forum.inductiveautomation.com/t/modified-history-graph/114 "2006-09-28T17:16:03Z")
Hi All: I am trying to modify the history graph you've made. Mostly it is a simplified version following your original plan. I have a container cntDatasets with 7 checkboxes, each label representing a different se… --- ## [Referring to values in code](https://forum.inductiveautomation.com/t/referring-to-values-in-code/113)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 2\ **Last updated:** [September 27, 2006, 10:21pm UTC](https://forum.inductiveautomation.com/t/referring-to-values-in-code/113 "2006-09-27T22:21:37Z")
Hi Carl: I am attempting to modify the history graph goodie. Can you see why the following first line of code works, but not the next? As a background, I have a container cntDatasets on the root container, on whic… --- ## [Referring to label values in code](https://forum.inductiveautomation.com/t/referring-to-label-values-in-code/112)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 2\ **Last updated:** [September 26, 2006, 10:10pm UTC](https://forum.inductiveautomation.com/t/referring-to-label-values-in-code/112 "2006-09-26T22:10:16Z")
Hi all: I have a screen that has 14 tanks. Depending on the contents of a dropdown list, the screen shows the contents of one of several cellars; the different cellars have differing numbers of tanks, and the visible p… --- ## [Calculating averages of multiple non-contiguous row of table](https://forum.inductiveautomation.com/t/calculating-averages-of-multiple-non-contiguous-row-of-table/109)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 9\ **Last updated:** [September 25, 2006, 10:16pm UTC](https://forum.inductiveautomation.com/t/calculating-averages-of-multiple-non-contiguous-row-of-table/109 "2006-09-25T22:16:25Z")
Hi Guys: I have a table where the user can select multiple non-contig. rows. I placed a button on the window and a numeric label. The code for the button on the actionPerformed action is: table = event.source.paren… --- ## [Best practice to install FSQL](https://forum.inductiveautomation.com/t/best-practice-to-install-fsql/110)
**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\ **Replies:** 1\ **Last updated:** [September 25, 2006, 8:15pm UTC](https://forum.inductiveautomation.com/t/best-practice-to-install-fsql/110 "2006-09-25T20:15:37Z")
I am installing FSQL on the manufacturing network and have two choices of where to install it. I can install it on the machine that is running RSVIEW32, ADS and all of the OPC servers (including RSLINX and Kepware) OR on… --- ## [Testing a menu bar](https://forum.inductiveautomation.com/t/testing-a-menu-bar/108)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [September 22, 2006, 11:36pm UTC](https://forum.inductiveautomation.com/t/testing-a-menu-bar/108 "2006-09-22T23:36:00Z")
I used the menu editor to create some site navigation, but I don't see any way to test it from within the designer. Do I need to deploy it to the web as a 'finished' product in order to see the menubar? TIA D. Lewis --- ## [Passing parameters to sql server stored procedures](https://forum.inductiveautomation.com/t/passing-parameters-to-sql-server-stored-procedures/106)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 4\ **Last updated:** [September 21, 2006, 9:51pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-to-sql-server-stored-procedures/106 "2006-09-21T21:51:32Z")
I have a sproc that accepts one parameter (varchar). Example parameters are 200, Cellar, Pilot, or 80a. All these will run with the exception of 80a. I have run into this in other instances with factory pmi, where it … --- ## [Two bugs and one compability issue](https://forum.inductiveautomation.com/t/two-bugs-and-one-compability-issue/105)
**Author:** [@JonasLarsson](https://forum.inductiveautomation.com/u/JonasLarsson)\ **Replies:** 2\ **Last updated:** [September 20, 2006, 12:31am UTC](https://forum.inductiveautomation.com/t/two-bugs-and-one-compability-issue/105 "2006-09-20T00:31:09Z")
Hi, I downloaded the demo version (2.2.6) of FactorySQL to evaluate it, and ran into serious problems. After some troubleshooting I think that I have found the source of my problem. It has to do with localized number for… --- ## [Passing parameters from a table row to a chart window](https://forum.inductiveautomation.com/t/passing-parameters-from-a-table-row-to-a-chart-window/101)
**Author:** [@gjohnson](https://forum.inductiveautomation.com/u/gjohnson)\ **Replies:** 15\ **Last updated:** [September 15, 2006, 6:19pm UTC](https://forum.inductiveautomation.com/t/passing-parameters-from-a-table-row-to-a-chart-window/101 "2006-09-15T18:19:11Z")
I read the color change posting and I understand most of the concept. But what I need to do is click on a row in a History table, have a chart window open and draw a graph according to the data in the table row, the sta… --- ## [Creating Relational Tables](https://forum.inductiveautomation.com/t/creating-relational-tables/102)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 2\ **Last updated:** [September 8, 2006, 10:31pm UTC](https://forum.inductiveautomation.com/t/creating-relational-tables/102 "2006-09-08T22:31:49Z")
How can you create related tables or assign foreign keys between different schema's? --- ## [Programmatically changing cell background color in table](https://forum.inductiveautomation.com/t/programmatically-changing-cell-background-color-in-table/99)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 4\ **Last updated:** [August 30, 2006, 8:42pm UTC](https://forum.inductiveautomation.com/t/programmatically-changing-cell-background-color-in-table/99 "2006-08-30T20:42:12Z")
Hi All: I would like to vary the background color of individual cells of a table (not entire rows or columns), based on values in other cells. Is this possible? Here are some sample data: Type Vessel Value A … --- ## [Update a PMI table with a button](https://forum.inductiveautomation.com/t/update-a-pmi-table-with-a-button/96)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 4\ **Last updated:** [August 30, 2006, 8:09pm UTC](https://forum.inductiveautomation.com/t/update-a-pmi-table-with-a-button/96 "2006-08-30T20:09:07Z")
What would be the best way to update a PMI table "run a fpmi.db.runQuery()" using a button? --- ## [Current Date and Time for Default Value](https://forum.inductiveautomation.com/t/current-date-and-time-for-default-value/97)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 4\ **Last updated:** [August 30, 2006, 7:52pm UTC](https://forum.inductiveautomation.com/t/current-date-and-time-for-default-value/97 "2006-08-30T19:52:33Z")
How do you make the current time and date a default value in MySQL? Also, what is the default syntax or mask for a DateTime field? --- ## [Importing/Exporting between MySQL and MS Access](https://forum.inductiveautomation.com/t/importing-exporting-between-mysql-and-ms-access/64)
**Author:** [@gjohnson](https://forum.inductiveautomation.com/u/gjohnson)\ **Replies:** 4\ **Last updated:** [August 29, 2006, 10:07pm UTC](https://forum.inductiveautomation.com/t/importing-exporting-between-mysql-and-ms-access/64 "2006-08-29T22:07:12Z")
I was recently asked to see if I could devise an easy way to export from a MySQL table to an Access table. I found that if you set both databases up on ODBC, then use the Access menus File/Get External Data, you can ha… --- ## [Grid control](https://forum.inductiveautomation.com/t/grid-control/98)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 3\ **Last updated:** [August 29, 2006, 8:57pm UTC](https://forum.inductiveautomation.com/t/grid-control/98 "2006-08-29T20:57:36Z")
Is there a way to easily show a 'grid' of data, like an excel worksheet? It would need to be dynamically sized (according to the number of rows returned), and hopefully scrollable, perhaps sortable by column, etc. TI… --- ## [Binding to boolean values](https://forum.inductiveautomation.com/t/binding-to-boolean-values/95)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 4\ **Last updated:** [August 29, 2006, 8:26pm UTC](https://forum.inductiveautomation.com/t/binding-to-boolean-values/95 "2006-08-29T20:26:56Z")
Is there a way to display the words "True or False" or "Yes and No" in a chart when you bind the data to a boolean value in MySQL? --- ## [Scroll forward and backward on a graph](https://forum.inductiveautomation.com/t/scroll-forward-and-backward-on-a-graph/93)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 2\ **Last updated:** [August 15, 2006, 10:42pm UTC](https://forum.inductiveautomation.com/t/scroll-forward-and-backward-on-a-graph/93 "2006-08-15T22:42:18Z")
I have a graph that shows the last 7 days of data for a process. I would like to add a scroll bar or buttons or whatever to allow the user to scroll back and forth to show data from different periods. Alternatively the… --- ## [One graph for many tanks](https://forum.inductiveautomation.com/t/one-graph-for-many-tanks/92)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [August 15, 2006, 9:10pm UTC](https://forum.inductiveautomation.com/t/one-graph-for-many-tanks/92 "2006-08-15T21:10:34Z")
I have four tanks for which I would like to graph a few attributes (level, temperature, pressure, etc.). Rather than making four graphs, I would like to have a drop down list or radio button array or something where the… --- ## [Switch expression for label text](https://forum.inductiveautomation.com/t/switch-expression-for-label-text/91)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 7\ **Last updated:** [August 10, 2006, 10:42pm UTC](https://forum.inductiveautomation.com/t/switch-expression-for-label-text/91 "2006-08-10T22:42:48Z")
I am trying to use a switch expression to dynamically change the text in a label. The value of ({cntBottling.dsTankData}\["BBTW2"\]) is 5, but the expression is returning "BBT: N/A" rather than "BBT: 5W". Can anyone spot… --- ## [Binding a color to a column in a dataset](https://forum.inductiveautomation.com/t/binding-a-color-to-a-column-in-a-dataset/90)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [August 10, 2006, 10:09pm UTC](https://forum.inductiveautomation.com/t/binding-a-color-to-a-column-in-a-dataset/90 "2006-08-10T22:09:55Z")
I have a pipe segment that I would like to display in different colors depending upon what is currently happening. One of the datasets in the project has a column that reflects what is happening (0=nothing, 1=product tr… --- ## [Carriage return/line feed in labels](https://forum.inductiveautomation.com/t/carriage-return-line-feed-in-labels/89)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [August 10, 2006, 9:58pm UTC](https://forum.inductiveautomation.com/t/carriage-return-line-feed-in-labels/89 "2006-08-10T21:58:22Z")
I have an expression in a label as below: ({cntBottling.dsTankFlowData}\["FlowSet1"\])+" / " +({cntBottling.dsTankFlowData}\["Transfer1Flow"\]) which is displayed as 2.3/2.2 I would like it to display as: 2.3/ 2.2 H… --- ## [Using an expression to populate a label](https://forum.inductiveautomation.com/t/using-an-expression-to-populate-a-label/88)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [August 9, 2006, 11:57pm UTC](https://forum.inductiveautomation.com/t/using-an-expression-to-populate-a-label/88 "2006-08-09T23:57:40Z")
I have a label that I would like to show a setpoint and actual value, thusly: 10/9.9 I tried building an expression in stages. The first step was {cntBottling.dsTankFlowData}\["FlowSet1"\]+' / ' which worked fine. Whe… --- ## [Use an action of a button to insert a record into a table](https://forum.inductiveautomation.com/t/use-an-action-of-a-button-to-insert-a-record-into-a-table/87)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [August 9, 2006, 11:51pm UTC](https://forum.inductiveautomation.com/t/use-an-action-of-a-button-to-insert-a-record-into-a-table/87 "2006-08-09T23:51:12Z")
Is there a procedure, when using an "Select Event -\> action -\> actionPerformed" to insert new records into a table instead of updating existing records in the table? --- ## [Using a dataset to supply values, not separate queries](https://forum.inductiveautomation.com/t/using-a-dataset-to-supply-values-not-separate-queries/86)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [August 8, 2006, 8:50pm UTC](https://forum.inductiveautomation.com/t/using-a-dataset-to-supply-values-not-separate-queries/86 "2006-08-08T20:50:57Z")
I have a screen with dozens of controls. Rather than using sql queries to bind each individual control (and have dozens of db calls), I would like to bring all the values over in one or two datasets, then assign the va… --- ## [.net Componet, and or Connector something?](https://forum.inductiveautomation.com/t/net-componet-and-or-connector-something/85)
**Author:** [@lawrencek](https://forum.inductiveautomation.com/u/lawrencek)\ **Replies:** 3\ **Last updated:** [August 1, 2006, 6:51pm UTC](https://forum.inductiveautomation.com/t/net-componet-and-or-connector-something/85 "2006-08-01T18:51:33Z")
What I would like to be able to do is to run the FactorySQL engine inside a .net app and receive/respond to events or something with my custom business objects that would be responsible for loading the DB. I could wo… --- ## [Problem with Applicom OPC server](https://forum.inductiveautomation.com/t/problem-with-applicom-opc-server/84)
**Author:** [@Armando\_Di\_Francesco](https://forum.inductiveautomation.com/u/Armando_Di_Francesco)\ **Replies:** 2\ **Last updated:** [July 18, 2006, 6:55pm UTC](https://forum.inductiveautomation.com/t/problem-with-applicom-opc-server/84 "2006-07-18T18:55:16Z")
Hi, I have a problem with the FactorySQL and the applicom OPC Server always it says that is UNABLE TO CONNECT TO OPC SERVER also I wasn't able to browse the OPC server from FactorySQL. I can browse and connect to that … --- ## [Bad values with Kepware or Top OPC server](https://forum.inductiveautomation.com/t/bad-values-with-kepware-or-top-opc-server/49)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 4\ **Last updated:** [June 29, 2006, 5:03pm UTC](https://forum.inductiveautomation.com/t/bad-values-with-kepware-or-top-opc-server/49 "2006-06-29T17:03:36Z")
If you have encountered BAD DATA in FactorySQL when trying to log items from Kepware's OPC server then here are the steps required to solve this problem: 1) Click Start -\> Run 2) Type dcomcnfg 3) Expand Component Servi… --- ## [Second counter needed](https://forum.inductiveautomation.com/t/second-counter-needed/82)
**Author:** [@amfonline](https://forum.inductiveautomation.com/u/amfonline)\ **Replies:** 3\ **Last updated:** [May 16, 2006, 6:10pm UTC](https://forum.inductiveautomation.com/t/second-counter-needed/82 "2006-05-16T18:10:43Z")
I would like to set up an item that starts counting seconds when a PLC timer goes to 0 and ends when the same PLC timer goes to 1. This information would then be graphed as machine cycle time in Factory PMI. The data w… --- ## [Alarm Summary](https://forum.inductiveautomation.com/t/alarm-summary/81)
**Author:** [@bhastie](https://forum.inductiveautomation.com/u/bhastie)\ **Replies:** 2\ **Last updated:** [April 25, 2006, 5:03pm UTC](https://forum.inductiveautomation.com/t/alarm-summary/81 "2006-04-25T17:03:01Z")
How can I set up an alarm summary object. I have the query down, just can't seem to get the data to display. --- ## [Access FactoryPMI by name instead of IP, eg MyHMI.com](https://forum.inductiveautomation.com/t/access-factorypmi-by-name-instead-of-ip-eg-myhmi-com/79)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 2\ **Last updated:** [April 18, 2006, 1:02am UTC](https://forum.inductiveautomation.com/t/access-factorypmi-by-name-instead-of-ip-eg-myhmi-com/79 "2006-04-18T01:02:36Z")
How do I access my FactoryPMI project by name instead of IP address? I'd rather use 192.168.1.50 I know this is possible. Any ideas on how to do it? [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=57) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=59)