# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=46 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 47 --- ## [Update a row in Db by selecting a row in a PMI Table](https://forum.inductiveautomation.com/t/update-a-row-in-db-by-selecting-a-row-in-a-pmi-table/155)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 4\ **Last updated:** [February 22, 2008, 11:27pm UTC](https://forum.inductiveautomation.com/t/update-a-row-in-db-by-selecting-a-row-in-a-pmi-table/155 "2008-02-22T23:27:27Z")
Is it possible to select a row from a PMI Table and use a value from the selected row in the where clause to run an update query on a database table. Example: I have a PMI table with 10 rows that list unique part num… --- ## [Expression language DateDiff()](https://forum.inductiveautomation.com/t/expression-language-datediff/568)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 1\ **Last updated:** [February 22, 2008, 9:43pm UTC](https://forum.inductiveautomation.com/t/expression-language-datediff/568 "2008-02-22T21:43:35Z")
Returns the difference in months, days, hours, minutes, seconds or milliseconds between two date tags! Currently can only be done with a Jython call or Sql statement. --- ## [Multiple select in tree view](https://forum.inductiveautomation.com/t/multiple-select-in-tree-view/559)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 1\ **Last updated:** [February 21, 2008, 8:21pm UTC](https://forum.inductiveautomation.com/t/multiple-select-in-tree-view/559 "2008-02-21T20:21:11Z")
Selection of multiple groups works for the other two views, but not in tree view. This feature would be a nice addition. --- ## [How to set component values from datatable values](https://forum.inductiveautomation.com/t/how-to-set-component-values-from-datatable-values/565)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 3\ **Last updated:** [February 20, 2008, 11:04pm UTC](https://forum.inductiveautomation.com/t/how-to-set-component-values-from-datatable-values/565 "2008-02-20T23:04:01Z")
Currently, I am creating a tank farm, that has about 100 tanks in it. I have a table that contains the values, tank number, product, fill dates and expected fill dates in it. There are about 100 tanks that I would like… --- ## [Older Unified Installer and FPMI, what's the deal?](https://forum.inductiveautomation.com/t/older-unified-installer-and-fpmi-whats-the-deal/556)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 2\ **Last updated:** [February 19, 2008, 8:11pm UTC](https://forum.inductiveautomation.com/t/older-unified-installer-and-fpmi-whats-the-deal/556 "2008-02-19T20:11:49Z")
My most recent version of the online unified installer (2.1.3.1, downloaded on January 30th 2008, maybe...) detects FactoryPMI 3.1.4 as the latest version. I think another copy I have of 2.1.4 has the same problem. I d… --- ## [Using a button to clear data from a table](https://forum.inductiveautomation.com/t/using-a-button-to-clear-data-from-a-table/562)
**Author:** [@KeithB](https://forum.inductiveautomation.com/u/KeithB)\ **Replies:** 3\ **Last updated:** [February 19, 2008, 5:39pm UTC](https://forum.inductiveautomation.com/t/using-a-button-to-clear-data-from-a-table/562 "2008-02-19T17:39:29Z")
I am creating a logging table that will show real time data for selected values from a table. I have a 2 State Toggle button that is used as a trigger to start the data logging. The data does not need to be stored to r… --- ## [Error when importing SQL tags](https://forum.inductiveautomation.com/t/error-when-importing-sql-tags/560)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [February 18, 2008, 10:13pm UTC](https://forum.inductiveautomation.com/t/error-when-importing-sql-tags/560 "2008-02-18T22:13:55Z")
Recently, our server crashed that we had the Inductive Automation software on. So during the resurection period we upgraded to 4.1.5. While doing the reinstall a few things came up that I wanted to question you on. … --- ## [Ping, FTP and other](https://forum.inductiveautomation.com/t/ping-ftp-and-other/483)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [February 17, 2008, 12:59am UTC](https://forum.inductiveautomation.com/t/ping-ftp-and-other/483 "2008-02-17T00:59:43Z")
I was wondering. I recently saw a post where there was a ping add in for PMI. Now I do not know a lot about TCP/IP, PING, and FTP. I can tell you what they mean but dont necessarily understand the underlying things that … --- ## [Activation problem](https://forum.inductiveautomation.com/t/activation-problem/555)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [February 17, 2008, 12:47am UTC](https://forum.inductiveautomation.com/t/activation-problem/555 "2008-02-17T00:47:39Z")
I came in to do an upgrade this weekend at the customer site, and wanted to move the license to my laptop to test the upgrades there. My server doesn't have an internet connection, so I selected the "deactivate by phone"… --- ## [What recommedations for the following](https://forum.inductiveautomation.com/t/what-recommedations-for-the-following/547)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 13\ **Last updated:** [February 15, 2008, 1:19pm UTC](https://forum.inductiveautomation.com/t/what-recommedations-for-the-following/547 "2008-02-15T13:19:05Z")
In my Historical data which is being written to an SQL table from FSQL there is a column that I want to populate called 'SHIFT'. This is the shift number that that employee is currently assigned. The owner wants this inf… --- ## [Can a string be used in an SQL statement](https://forum.inductiveautomation.com/t/can-a-string-be-used-in-an-sql-statement/553)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [February 15, 2008, 5:29am UTC](https://forum.inductiveautomation.com/t/can-a-string-be-used-in-an-sql-statement/553 "2008-02-15T05:29:52Z")
I was thinking of doing the following and was wondering if it was possible. Here is the script I was thinking of: If checkbox=1: queryclause = " shift = {root container.shift} and " else: queryclause = "an… --- ## [Query Assistance Please](https://forum.inductiveautomation.com/t/query-assistance-please/551)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 8\ **Last updated:** [February 15, 2008, 2:09am UTC](https://forum.inductiveautomation.com/t/query-assistance-please/551 "2008-02-15T02:09:56Z")
Here is a query that I am attempting to run. This query takes the asigned shift out of one table and copies it into another table. However when I run this query the proper row is updated but all the other fields in that … --- ## [Data transfer timing](https://forum.inductiveautomation.com/t/data-transfer-timing/515)
**Author:** [@Colby.Clegg](https://forum.inductiveautomation.com/u/Colby.Clegg)\ **Replies:** 15\ **Last updated:** [February 13, 2008, 8:41pm UTC](https://forum.inductiveautomation.com/t/data-transfer-timing/515 "2008-02-13T20:41:35Z")
From mrtweaver: I have some questions that I am hoping someone might be able to answer. Is there a way to determine wire time? (I hope I have this term correct, what I want to know is how long it takes for my data t… --- ## [Enabling New Groups or Folders in a Running Config](https://forum.inductiveautomation.com/t/enabling-new-groups-or-folders-in-a-running-config/548)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 2\ **Last updated:** [February 13, 2008, 6:32pm UTC](https://forum.inductiveautomation.com/t/enabling-new-groups-or-folders-in-a-running-config/548 "2008-02-13T18:32:57Z")
Hi, I have a questions about enabling new groups or folders to a running config or if edit groups or folders will the running configuration will be affected when I submit the changes. Ex I have Folder with multiple gr… --- ## [Wind Direction Meter](https://forum.inductiveautomation.com/t/wind-direction-meter/544)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 10\ **Last updated:** [February 12, 2008, 4:50pm UTC](https://forum.inductiveautomation.com/t/wind-direction-meter/544 "2008-02-12T16:50:27Z")
I need a wind direction indicator. I can't figure out a way to use the existing meter component. Any suggestions? --- ## [Inhibit Group or Item](https://forum.inductiveautomation.com/t/inhibit-group-or-item/526)
**Author:** [@dmcglynn](https://forum.inductiveautomation.com/u/dmcglynn)\ **Replies:** 5\ **Last updated:** [February 11, 2008, 4:31pm UTC](https://forum.inductiveautomation.com/t/inhibit-group-or-item/526 "2008-02-11T16:31:33Z")
Maybe there's already a way to do this that I'm not seeing, but it would be nice to be able to inhibit or deactivate a group so that on startup, it would not be started automatically. Along the same lines of thinking, … --- ## [Function to Write CSV File](https://forum.inductiveautomation.com/t/function-to-write-csv-file/502)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 4\ **Last updated:** [February 10, 2008, 3:49am UTC](https://forum.inductiveautomation.com/t/function-to-write-csv-file/502 "2008-02-10T03:49:38Z")
I've developed a function to write a CSV file given a dataset. Just thought I would share with the community. Forgive me if this has already been done. def writeCSVFile(dataSet, filename=""): import fpmi if len(file… --- ## [Building an action item through an expression](https://forum.inductiveautomation.com/t/building-an-action-item-through-an-expression/545)
**Author:** [@raw1312](https://forum.inductiveautomation.com/u/raw1312)\ **Replies:** 1\ **Last updated:** [February 10, 2008, 3:29am UTC](https://forum.inductiveautomation.com/t/building-an-action-item-through-an-expression/545 "2008-02-10T03:29:10Z")
How would you write or can you write this expression. These are all opc tags. Where can I find info on writing expressions. If value1 \> Value2 then Bit1=1 else Bit1=0 --- ## ["Trigger On Item" problem](https://forum.inductiveautomation.com/t/trigger-on-item-problem/542)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [February 8, 2008, 11:43pm UTC](https://forum.inductiveautomation.com/t/trigger-on-item-problem/542 "2008-02-08T23:43:24Z")
I think I may have found a bug, or maybe I'm doing something you aren't supposed to do. In FactorySQL, I have a folder with five groups. Each group represents different parts of the plant, and each group is set to exec… --- ## [Enable/disable buttons](https://forum.inductiveautomation.com/t/enable-disable-buttons/541)
**Author:** [@Jcam](https://forum.inductiveautomation.com/u/Jcam)\ **Replies:** 1\ **Last updated:** [February 8, 2008, 10:28pm UTC](https://forum.inductiveautomation.com/t/enable-disable-buttons/541 "2008-02-08T22:28:15Z")
This is probably simple to do...I am fairly new at this. What I need to know is, how do I set a button to be disabled on one window if something is not entered in a field from another window? For example: On one wi… --- ## [Enhancements to bar chart tool](https://forum.inductiveautomation.com/t/enhancements-to-bar-chart-tool/536)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 8\ **Last updated:** [February 8, 2008, 9:17pm UTC](https://forum.inductiveautomation.com/t/enhancements-to-bar-chart-tool/536 "2008-02-08T21:17:19Z")
Hi all: A lot of functionality of the standard chart tool has been stripped from the bar chart, as far as I can tell. Because the bar chart is often categorical, the x-axis labels can sometimes be big. I haven't found… --- ## [Calculation in SQLTag](https://forum.inductiveautomation.com/t/calculation-in-sqltag/539)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 3\ **Last updated:** [February 8, 2008, 8:05pm UTC](https://forum.inductiveautomation.com/t/calculation-in-sqltag/539 "2008-02-08T20:05:29Z")
The following equation extracts a bit value (bit 0 in this case) from an word. (floor({\[.\]WordValue}/2^0))%2 I have been using it successfully for a while to drive a dynamic property, which in turn controls a display… --- ## [Where do I find the upgrades?](https://forum.inductiveautomation.com/t/where-do-i-find-the-upgrades/537)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 4\ **Last updated:** [February 8, 2008, 5:56pm UTC](https://forum.inductiveautomation.com/t/where-do-i-find-the-upgrades/537 "2008-02-08T17:56:02Z")
Hi all: I've been cruising around your site trying to find where the upgrades are available for download. All I've found is the full trial version on the download page. If I want to upgrade from 3.1.3 to 3.1.4 do I do… --- ## [Pareto chart (sorry for the cross post)](https://forum.inductiveautomation.com/t/pareto-chart-sorry-for-the-cross-post/534)
**Author:** [@David](https://forum.inductiveautomation.com/u/David)\ **Replies:** 1\ **Last updated:** [February 7, 2008, 7:12pm UTC](https://forum.inductiveautomation.com/t/pareto-chart-sorry-for-the-cross-post/534 "2008-02-07T19:12:10Z")
Hi Carl: Quick question (I hope): I have a data set I'm going to plot as an histogram, and I would like to superimpose on that a cumulative line. So, imagine a chart with 12 bars, then a line on top of that whose firs… --- ## [Project size](https://forum.inductiveautomation.com/t/project-size/524)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 13\ **Last updated:** [February 7, 2008, 5:27pm UTC](https://forum.inductiveautomation.com/t/project-size/524 "2008-02-07T17:27:12Z")
Is there any practical limit to the size of a project? e.g. Is performance better of worse as project size heads toward infinity? I can see issues re managing a large number of screens in the designer, but are there … --- ## [Controlling the order in which components update](https://forum.inductiveautomation.com/t/controlling-the-order-in-which-components-update/533)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 2\ **Last updated:** [February 7, 2008, 2:34am UTC](https://forum.inductiveautomation.com/t/controlling-the-order-in-which-components-update/533 "2008-02-07T02:34:12Z")
I have a dynamic property which queries for a controller\_type definition. Elsewhere on the same page, I have a container with a bunch of identical components, reading the status of bits in a database word and retrievi… --- ## [Type casting question](https://forum.inductiveautomation.com/t/type-casting-question/531)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 6\ **Last updated:** [February 7, 2008, 1:13am UTC](https://forum.inductiveautomation.com/t/type-casting-question/531 "2008-02-07T01:13:54Z")
Does this make sense? I have the following code in an action script (mouse clicked) in a list box. If I use it as is, I see the correct string in SQLTag TempTag2. However, if I use "index1" rather than "index2" in t… --- ## [FSQL suddenly unable to see local OPC servers](https://forum.inductiveautomation.com/t/fsql-suddenly-unable-to-see-local-opc-servers/532)
**Author:** [@apurdom](https://forum.inductiveautomation.com/u/apurdom)\ **Replies:** 1\ **Last updated:** [February 6, 2008, 11:12pm UTC](https://forum.inductiveautomation.com/t/fsql-suddenly-unable-to-see-local-opc-servers/532 "2008-02-06T23:12:59Z")
While working with a new OPC server, suddenly FSQL is now unable to view the locally running OPC servers at all. All my existing groups are running fine but I would not be able to browse the servers to create anything ne… --- ## [Navigation plan](https://forum.inductiveautomation.com/t/navigation-plan/530)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 1\ **Last updated:** [February 6, 2008, 6:30pm UTC](https://forum.inductiveautomation.com/t/navigation-plan/530 "2008-02-06T18:30:40Z")
I have the following plan for navigation, which still has a couple of holes in it. I am submitting this post requesting any feedback re my proposed method. My navigation will drill down through levels of detail, e.g. … --- ## [Writing information to a CSV file](https://forum.inductiveautomation.com/t/writing-information-to-a-csv-file/521)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 7\ **Last updated:** [February 6, 2008, 3:06am UTC](https://forum.inductiveautomation.com/t/writing-information-to-a-csv-file/521 "2008-02-06T03:06:51Z")
I recently started working with the writeFile routine. I call up data out of the employee database based on a set of criteria. Now I can see my dataset just fine but am having difficulty having the system write it to the… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=45) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=47)