# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=31 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 32 --- ## [Query color change](https://forum.inductiveautomation.com/t/query-color-change/1071)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [April 7, 2009, 10:52pm UTC](https://forum.inductiveautomation.com/t/query-color-change/1071 "2009-04-07T22:52:11Z")
I have a two part question. I beleive part two has already been covered here before. Part one - Have a report that is running a query, the data from the query is populating the chart. In the query there is a section th… --- ## [Ignore trigger when group is first turned on?](https://forum.inductiveautomation.com/t/ignore-trigger-when-group-is-first-turned-on/1070)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 2\ **Last updated:** [April 7, 2009, 7:19pm UTC](https://forum.inductiveautomation.com/t/ignore-trigger-when-group-is-first-turned-on/1070 "2009-04-07T19:19:15Z")
Is there a way to have FSQL ignore the group trigger when the group is first turned on? I don't want to write to the table just because I turned the group on. EDIT: For instance, I have a group for each machine that wr… --- ## [Vista and MSSQL 2008](https://forum.inductiveautomation.com/t/vista-and-mssql-2008/1068)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 6\ **Last updated:** [April 7, 2009, 9:16am UTC](https://forum.inductiveautomation.com/t/vista-and-mssql-2008/1068 "2009-04-07T09:16:02Z")
I just put together a new server to run some tests, and am having a problem setting up the server connection. I've gone through everything I can think of, but still get the following error: FAIL (next test in 8 seco… --- ## [Event logger](https://forum.inductiveautomation.com/t/event-logger/1069)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [April 6, 2009, 10:31pm UTC](https://forum.inductiveautomation.com/t/event-logger/1069 "2009-04-06T22:31:20Z")
I don't know if the following is possible with FactorySQL or whether it qualifies as a feature request. An old DOS (!) SCADA package I used many years ago had both time-based logging and event logging. You defined a tr… --- ## [OPC Browser with a remote RSLinx server?](https://forum.inductiveautomation.com/t/opc-browser-with-a-remote-rslinx-server/476)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 6\ **Last updated:** [April 6, 2009, 7:04pm UTC](https://forum.inductiveautomation.com/t/opc-browser-with-a-remote-rslinx-server/476 "2009-04-06T19:04:48Z")
In my OPC Browser in FactoryPMI Designer, I have one OPC server, KEPware.DEPServerEx.V4. Is it possible to add other OPC servers into this OPC Browser window? I have a separate server with RSLinx OPC server running. I'd … --- ## [Special Escape characters](https://forum.inductiveautomation.com/t/special-escape-characters/1064)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 7\ **Last updated:** [April 3, 2009, 6:18pm UTC](https://forum.inductiveautomation.com/t/special-escape-characters/1064 "2009-04-03T18:18:40Z")
I am sure my problem has to do with special escape char. But would like clarification. On a screen I have an editable table. Then I have a button that converts this table to HTML and sends it to the required recipients… --- ## [Text Box Problems](https://forum.inductiveautomation.com/t/text-box-problems/1066)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [April 3, 2009, 5:39pm UTC](https://forum.inductiveautomation.com/t/text-box-problems/1066 "2009-04-03T17:39:45Z")
Maybe this has been fixed in 3.3.1 but in 3.3.0 I found this issue. I have a screen with 3 text boxes , 2 drop downs and a table on it. In the focus lost of one of the text boxes I have the fpmi.db.refresh command. I… --- ## [Error when adding dataset to chart](https://forum.inductiveautomation.com/t/error-when-adding-dataset-to-chart/1065)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 4\ **Last updated:** [April 3, 2009, 4:16pm UTC](https://forum.inductiveautomation.com/t/error-when-adding-dataset-to-chart/1065 "2009-04-03T16:16:08Z")
When I add an addition dataset to a chart I receive this message. Any ideas why? --- ## [A few requests](https://forum.inductiveautomation.com/t/a-few-requests/326)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 10\ **Last updated:** [April 3, 2009, 1:16am UTC](https://forum.inductiveautomation.com/t/a-few-requests/326 "2009-04-03T01:16:41Z")
Quick Preferences settings – It would be nice if Designer would remember my Quick Preference settings or if I could change the default settings. I use Anchored Layout and sometimes forget to change the layout when I fir… --- ## [MySQL Tips and Tricks](https://forum.inductiveautomation.com/t/mysql-tips-and-tricks/1063)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 2\ **Last updated:** [April 2, 2009, 10:05pm UTC](https://forum.inductiveautomation.com/t/mysql-tips-and-tricks/1063 "2009-04-02T22:05:53Z")
Since most of us are not DBAs, I figured we could share some tips and tricks relevant to the databases we are using. 1.Indexes You need to index your columns which may appear inside a where clause. However, having ind… --- ## [Alerts](https://forum.inductiveautomation.com/t/alerts/1062)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 0\ **Last updated:** [April 2, 2009, 5:43pm UTC](https://forum.inductiveautomation.com/t/alerts/1062 "2009-04-02T17:43:17Z")
Hi, I will be nice to have the following options: 1) Have a couple of custom optional fields that we can bind to OPC items to stored process data with the alarm rec. Like we will like to stored batch id, Step Number… --- ## [Dictionary printed missing elements](https://forum.inductiveautomation.com/t/dictionary-printed-missing-elements/1060)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [April 2, 2009, 12:36am UTC](https://forum.inductiveautomation.com/t/dictionary-printed-missing-elements/1060 "2009-04-02T00:36:10Z")
I have a dictionary that is filled with string from text boxes. When I try printing the dictionary only has 11 elements, but I assigned 13. here is the code. stringHarvestYear = event.source.parent.getComponent('textf… --- ## [Considering a change to FPMI. Any advice?](https://forum.inductiveautomation.com/t/considering-a-change-to-fpmi-any-advice/1059)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 5\ **Last updated:** [April 1, 2009, 1:42pm UTC](https://forum.inductiveautomation.com/t/considering-a-change-to-fpmi-any-advice/1059 "2009-04-01T13:42:17Z")
My company has been using RsView for 9 years. We designed our control screens when we initially started using it and we've never re-examined the design since then. When we'd build a new machine we'd pretty much copy and … --- ## [Modify Row Selector filters in script](https://forum.inductiveautomation.com/t/modify-row-selector-filters-in-script/1058)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [March 31, 2009, 6:34pm UTC](https://forum.inductiveautomation.com/t/modify-row-selector-filters-in-script/1058 "2009-03-31T18:34:22Z")
I have been playing around with the row selector that comes with the reporting plugin and I was wondering if it is possible to modify the filters at runtime? I did not find any scripting options in the manual so here is … --- ## [Custom email subject](https://forum.inductiveautomation.com/t/custom-email-subject/1057)
**Author:** [@JordanCClark](https://forum.inductiveautomation.com/u/JordanCClark)\ **Replies:** 4\ **Last updated:** [March 31, 2009, 5:26pm UTC](https://forum.inductiveautomation.com/t/custom-email-subject/1057 "2009-03-31T17:26:09Z")
Is there any way to edit the subject line of an alert e-mail? Rather like a fpmi.net.sendEmail, but for FSQL? Regards, --- ## [SQL Tags and Stale Data](https://forum.inductiveautomation.com/t/sql-tags-and-stale-data/1019)
**Author:** [@chris\_d\_sanders](https://forum.inductiveautomation.com/u/chris_d_sanders)\ **Replies:** 5\ **Last updated:** [March 31, 2009, 4:54pm UTC](https://forum.inductiveautomation.com/t/sql-tags-and-stale-data/1019 "2009-03-31T16:54:30Z")
Came into work this morning and the MySQL DB was faulted, or so my FPMI told me it was. I couldn't get MySQL to shut down and restart, so I restarted the computer. Once restarted, all of my SQL tags showed "STALE". I tri… --- ## [Brainstorming a standby backup system](https://forum.inductiveautomation.com/t/brainstorming-a-standby-backup-system/1056)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 7\ **Last updated:** [March 31, 2009, 3:38pm UTC](https://forum.inductiveautomation.com/t/brainstorming-a-standby-backup-system/1056 "2009-03-31T15:38:44Z")
Hi Guys, I want to run a configuration by you to see what you think. We have event data that we need to log to SQL, event because it is trigger by the PLC. Customer will like to have a backup system in case of a fai… --- ## [Table Inner Join](https://forum.inductiveautomation.com/t/table-inner-join/830)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 10\ **Last updated:** [March 30, 2009, 4:49pm UTC](https://forum.inductiveautomation.com/t/table-inner-join/830 "2009-03-30T16:49:59Z")
I am having a problem with building a sql query to populate a table. You guys will probably come up with a solution in under 60 seconds. Suppose we have three tables: Table1, Table2, Table3. In Table1, the columns a… --- ## [Animating the position of an object](https://forum.inductiveautomation.com/t/animating-the-position-of-an-object/1050)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [March 27, 2009, 3:55pm UTC](https://forum.inductiveautomation.com/t/animating-the-position-of-an-object/1050 "2009-03-27T15:55:16Z")
I'm building a demo for a customer and am trying to animate the position of an object on the screen (it can be in one of 2 places). There appears to be no way to bind to an object's coordinates, so I got it working usin… --- ## [Allowed IP address being ignored?](https://forum.inductiveautomation.com/t/allowed-ip-address-being-ignored/1054)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 4\ **Last updated:** [March 26, 2009, 8:28pm UTC](https://forum.inductiveautomation.com/t/allowed-ip-address-being-ignored/1054 "2009-03-26T20:28:59Z")
This is something I noticed while giving a remote demonstration of a system to a customer. I added their public IP address to our firewall to let it through, then also added it to the Gateway: Allowed Addresses field in… --- ## [SQL Tags connection issue](https://forum.inductiveautomation.com/t/sql-tags-connection-issue/1052)
**Author:** [@adamabelew](https://forum.inductiveautomation.com/u/adamabelew)\ **Replies:** 5\ **Last updated:** [March 26, 2009, 7:12pm UTC](https://forum.inductiveautomation.com/t/sql-tags-connection-issue/1052 "2009-03-26T19:12:45Z")
Hello, I am having problems with SQL Tags and MSSQL Express2005. I installed MSSQLexpress as per the video and then created a project to use that database. The project seemed to work alright, so I wanted to change t… --- ## [Dynamically changing the renderer style](https://forum.inductiveautomation.com/t/dynamically-changing-the-renderer-style/1055)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [March 26, 2009, 7:06pm UTC](https://forum.inductiveautomation.com/t/dynamically-changing-the-renderer-style/1055 "2009-03-26T19:06:10Z")
I have been using the standard chart for displaying a calulated series of points. This has been working great so far. The data is a delimmited string of numbers that I have to calculate and store to a dataset and represe… --- ## [Set a bit high if any OPC item in group changes value](https://forum.inductiveautomation.com/t/set-a-bit-high-if-any-opc-item-in-group-changes-value/1053)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 2\ **Last updated:** [March 26, 2009, 4:52pm UTC](https://forum.inductiveautomation.com/t/set-a-bit-high-if-any-opc-item-in-group-changes-value/1053 "2009-03-26T16:52:53Z")
I'm not sure if I'm correct in thinking I could use FSQL for this. I'd like to monitor all the set points on a machine and if any one of them changes, set a bit high. I made a standard group with all the set points, a… --- ## [Programmably sort table](https://forum.inductiveautomation.com/t/programmably-sort-table/1049)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [March 25, 2009, 7:16pm UTC](https://forum.inductiveautomation.com/t/programmably-sort-table/1049 "2009-03-25T19:16:31Z")
is there a way to programmably sort a table? --- ## [Get column headers](https://forum.inductiveautomation.com/t/get-column-headers/1048)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 3\ **Last updated:** [March 23, 2009, 9:27pm UTC](https://forum.inductiveautomation.com/t/get-column-headers/1048 "2009-03-23T21:27:00Z")
is there a way in the python scripting language to get the names of the headings on a table? In order to change a python dataset to a component dataset i need the headers. instead of hard coding the headers into a list… --- ## [Question about group refresh rate](https://forum.inductiveautomation.com/t/question-about-group-refresh-rate/1047)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 2\ **Last updated:** [March 20, 2009, 6:49pm UTC](https://forum.inductiveautomation.com/t/question-about-group-refresh-rate/1047 "2009-03-20T18:49:36Z")
If a group's refresh rate is set to 30 seconds, does it start timing when you start the group, or when it sees the group trigger go high? I'd like to have a group log data points every 30 seconds when a bit is high. I'… --- ## [Logging Machine Changes](https://forum.inductiveautomation.com/t/logging-machine-changes/995)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [March 20, 2009, 6:29pm UTC](https://forum.inductiveautomation.com/t/logging-machine-changes/995 "2009-03-20T18:29:17Z")
On one of our lines we have about 60+ setpoints that make up the process. I want to create a logging table that contains a record of when a value changes. I already have a group that contains these tags and set the grou… --- ## [Right/Left functions in action item expression?](https://forum.inductiveautomation.com/t/right-left-functions-in-action-item-expression/1046)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 3\ **Last updated:** [March 20, 2009, 5:24pm UTC](https://forum.inductiveautomation.com/t/right-left-functions-in-action-item-expression/1046 "2009-03-20T17:24:01Z")
Is there a way to do a right/left function (much like the way you can in SQL) on an OPC item in an expression? I've got a 14 character OPC string I'd like to compare to an 11 character string on the SQL server. It would … --- ## [Table data related question](https://forum.inductiveautomation.com/t/table-data-related-question/1040)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 8\ **Last updated:** [March 20, 2009, 5:07pm UTC](https://forum.inductiveautomation.com/t/table-data-related-question/1040 "2009-03-20T17:07:09Z")
I have a table and a button on a screen. When I press the button it takes and uses the HTML and sends the data to my email address. It works well except, if you are editing a cell and instead of pressing TAB or ENTER you… --- ## [Frontend Question from a Newbie](https://forum.inductiveautomation.com/t/frontend-question-from-a-newbie/1044)
**Author:** [@jjt\_mo](https://forum.inductiveautomation.com/u/jjt_mo)\ **Replies:** 5\ **Last updated:** [March 20, 2009, 5:07pm UTC](https://forum.inductiveautomation.com/t/frontend-question-from-a-newbie/1044 "2009-03-20T17:07:07Z")
I've installed the complete trial package and am having problems with the frontend. In the OPC Server area, I have only 'Remote Servers' showing up. KEPServer is in fact running, I was able to configure a topic to view… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=30) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=32)