# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=29 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 30 --- ## [SQL Tags, MS SQL, Deadlocks](https://forum.inductiveautomation.com/t/sql-tags-ms-sql-deadlocks/1150)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [May 13, 2009, 11:00pm UTC](https://forum.inductiveautomation.com/t/sql-tags-ms-sql-deadlocks/1150 "2009-05-13T23:00:57Z")
First off I want to say sorry for writing so much but with the recent issues that have come to be I felt it best to obtain expert opinions. Next I dont know how to do it on this forum but I would like if other integrat… --- ## [Manipulating DataSets and PyDataSets](https://forum.inductiveautomation.com/t/manipulating-datasets-and-pydatasets/1149)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 3\ **Last updated:** [May 13, 2009, 5:23pm UTC](https://forum.inductiveautomation.com/t/manipulating-datasets-and-pydatasets/1149 "2009-05-13T17:23:18Z")
Hi all, My goal is to execute a select query, and then for each row assign "ASDF" to column 2. Sounds simple enough, but I'm still having trouble :neutral\_face:. This is the code I have: penList = fpmi.db.runQuery(… --- ## [Indentation on code under button when doing a runQuery](https://forum.inductiveautomation.com/t/indentation-on-code-under-button-when-doing-a-runquery/1143)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 8\ **Last updated:** [May 13, 2009, 2:29am UTC](https://forum.inductiveautomation.com/t/indentation-on-code-under-button-when-doing-a-runquery/1143 "2009-05-13T02:29:11Z")
I have been going thru the manual and most likely not looking in the correct location, or maybe its not even possible being as I have not seen it listed in anyones code. I think the correct terminology is called indentat… --- ## [Source Control](https://forum.inductiveautomation.com/t/source-control/1147)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 3\ **Last updated:** [May 12, 2009, 11:11pm UTC](https://forum.inductiveautomation.com/t/source-control/1147 "2009-05-12T23:11:43Z")
Hi all, I'm wondering if there is a way to use a source tracking solution (eg SVN, CVS) for maintaining FPMI projects. Basically we'd like to keep tabs on the scripts/action code over its lifespan. What do you guys do … --- ## [Gateway Status screen](https://forum.inductiveautomation.com/t/gateway-status-screen/1145)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [May 12, 2009, 10:47pm UTC](https://forum.inductiveautomation.com/t/gateway-status-screen/1145 "2009-05-12T22:47:05Z")
This might just be that the one network side is running where the IP's are assigned but the IT dept asked me to ask for clarity. If you type in the address of the server:8080 and you click on GATEWAY STATUS then click … --- ## [Hiding Text in Text Field](https://forum.inductiveautomation.com/t/hiding-text-in-text-field/1144)
**Author:** [@jvandeve62](https://forum.inductiveautomation.com/u/jvandeve62)\ **Replies:** 4\ **Last updated:** [May 12, 2009, 10:41pm UTC](https://forum.inductiveautomation.com/t/hiding-text-in-text-field/1144 "2009-05-12T22:41:59Z")
I know you can use the password box for this, but I need to hide text an operator enters into a Text Field that exists on a window. Can I do this? --- ## [Error during browse](https://forum.inductiveautomation.com/t/error-during-browse/1140)
**Author:** [@conor](https://forum.inductiveautomation.com/u/conor)\ **Replies:** 3\ **Last updated:** [May 12, 2009, 3:50pm UTC](https://forum.inductiveautomation.com/t/error-during-browse/1140 "2009-05-12T15:50:04Z")
Hi, My first post. I am just starting to evaluate FactorySQL and am trying to connect to my PLC's. I am running RSLinx on my PC, but when I try and browse it for a PLC I am getting an error "Error during browse". When I… --- ## [Enter keyCode not showing up when editing table](https://forum.inductiveautomation.com/t/enter-keycode-not-showing-up-when-editing-table/1141)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [May 8, 2009, 9:53pm UTC](https://forum.inductiveautomation.com/t/enter-keycode-not-showing-up-when-editing-table/1141 "2009-05-08T21:53:16Z")
I have this code on the event keyPressed of a table: print "keyCode="+str(event.keyCode) if(event.keyCode == 10): print "selectedColumn"+str(event.source.selectedColumn) if(event.source.selectedColumn == 4): … --- ## [SQL or FPMI error message](https://forum.inductiveautomation.com/t/sql-or-fpmi-error-message/1139)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [May 7, 2009, 3:28pm UTC](https://forum.inductiveautomation.com/t/sql-or-fpmi-error-message/1139 "2009-05-07T15:28:42Z")
Have just started getting this error message and am unsure why or what it means. Can anyone shed some light on it and let me know. THanks and have a great day. --- ## [Error message when group starts](https://forum.inductiveautomation.com/t/error-message-when-group-starts/1138)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 1\ **Last updated:** [May 6, 2009, 7:25pm UTC](https://forum.inductiveautomation.com/t/error-message-when-group-starts/1138 "2009-05-06T19:25:31Z")
When I start a group I get this error message about 20 times, then after that it works without any problems. Group Execution Error Error executing item NextTestOutNumber: Object reference not set to an instance of an o… --- ## [Container questions and how to truncate data](https://forum.inductiveautomation.com/t/container-questions-and-how-to-truncate-data/1137)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [May 6, 2009, 4:08pm UTC](https://forum.inductiveautomation.com/t/container-questions-and-how-to-truncate-data/1137 "2009-05-06T16:08:01Z")
This is a two part question and both are related. First question: If I place a container on the screen, and inside this container I place some check boxes, When I change the value of any of the check boxes should that … --- ## ["Use polled reads instead of subscriptions"](https://forum.inductiveautomation.com/t/use-polled-reads-instead-of-subscriptions/1131)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 3\ **Last updated:** [May 5, 2009, 1:55am UTC](https://forum.inductiveautomation.com/t/use-polled-reads-instead-of-subscriptions/1131 "2009-05-05T01:55:48Z")
Hi, I have used this option "Use polled reads instead of subscriptions" prior to version 4.2.10 with no issues on CompactLogix but this weekend we are working with some SLC 5/05 and the group failed when writing the Hand… --- ## [URL to Builtin Images](https://forum.inductiveautomation.com/t/url-to-builtin-images/1136)
**Author:** [@MickeyBob](https://forum.inductiveautomation.com/u/MickeyBob)\ **Replies:** 2\ **Last updated:** [May 4, 2009, 11:30pm UTC](https://forum.inductiveautomation.com/t/url-to-builtin-images/1136 "2009-05-04T23:30:08Z")
Is there a way to reference a built-in icon via a URL, for example "http://factorypmi:8080/images/builtin/icons/16/edit.png"? --- ## [Merge 2 reports](https://forum.inductiveautomation.com/t/merge-2-reports/1134)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [May 4, 2009, 11:00pm UTC](https://forum.inductiveautomation.com/t/merge-2-reports/1134 "2009-05-04T23:00:37Z")
Have a screen with 2 report viewers. Also have the underlying code as such: cover=event.source.parent.getComponent("tab1") turnover=event.source.partent.getComponent("tab2") cover.print() turnover.print() However I wan… --- ## [Race Condition between SQL code and SQL tag](https://forum.inductiveautomation.com/t/race-condition-between-sql-code-and-sql-tag/1127)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [May 4, 2009, 9:07pm UTC](https://forum.inductiveautomation.com/t/race-condition-between-sql-code-and-sql-tag/1127 "2009-05-04T21:07:23Z")
I am pretty sure this is a race condition and would like to know what is the best way to fix it. If you look in the General section of this forum there is a posting called FPMI Project Screen Shots. Under there you wil… --- ## ['browser' is undefined error](https://forum.inductiveautomation.com/t/browser-is-undefined-error/1133)
**Author:** [@rollie715](https://forum.inductiveautomation.com/u/rollie715)\ **Replies:** 2\ **Last updated:** [May 4, 2009, 5:33pm UTC](https://forum.inductiveautomation.com/t/browser-is-undefined-error/1133 "2009-05-04T17:33:28Z")
When attempting to launch a project as an Applet, I get an error within IE that says: \[color=#FF0000\]'Problems with this Web page might prevent it from being displayed properly or functioning properly.' Details: Line 7 … --- ## [Progress Bar](https://forum.inductiveautomation.com/t/progress-bar/1130)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [May 3, 2009, 9:45pm UTC](https://forum.inductiveautomation.com/t/progress-bar/1130 "2009-05-03T21:45:34Z")
I would like to use a progress bar to show the user that something is happening. I'm opening up and reading a slew of files, and this takes about five seconds. As I rip through the files, I would like to update the progr… --- ## [FSQL getvariable function](https://forum.inductiveautomation.com/t/fsql-getvariable-function/1126)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [May 1, 2009, 4:19pm UTC](https://forum.inductiveautomation.com/t/fsql-getvariable-function/1126 "2009-05-01T16:19:33Z")
I was wondering while at home this evening I thought up something that might work. But wanted the experts opinion on it. It has to do with the getvariable in FSQL. Here is the code I was thinking of but like I said being… --- ## [Problems with chart axis](https://forum.inductiveautomation.com/t/problems-with-chart-axis/1123)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 1\ **Last updated:** [April 30, 2009, 5:13pm UTC](https://forum.inductiveautomation.com/t/problems-with-chart-axis/1123 "2009-04-30T17:13:50Z")
I have a chart with the following dataset. when it tries to graph I receive these two errors. so i then change my x axis to a number axis and i receive this error. java.lang.IllegalArgumentException: Illegal… --- ## [HTML Document Viewer](https://forum.inductiveautomation.com/t/html-document-viewer/1110)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 12\ **Last updated:** [April 30, 2009, 3:23pm UTC](https://forum.inductiveautomation.com/t/html-document-viewer/1110 "2009-04-30T15:23:43Z")
I'm trying to do a couple of things with the doc viewer. I have scripted hyperlink events, and those work great. But, one thing I'm not sure of how to do is jumping to a specific place on the page. For instance, let's… --- ## [Time Stamps from Different Time Zones](https://forum.inductiveautomation.com/t/time-stamps-from-different-time-zones/1118)
**Author:** [@rollie715](https://forum.inductiveautomation.com/u/rollie715)\ **Replies:** 5\ **Last updated:** [April 29, 2009, 9:00pm UTC](https://forum.inductiveautomation.com/t/time-stamps-from-different-time-zones/1118 "2009-04-29T21:00:41Z")
I have FactorySQL running on a PC in Georgia. The FactorySQL PC clock is set to Eastern Time or GMT-5. The SQL Database where the data is sent to is in Washington State Pacific Time or GMT-8. When I view the data in Fact… --- ## [Error writing action item result to OPC item: E\_Fail](https://forum.inductiveautomation.com/t/error-writing-action-item-result-to-opc-item-e-fail/1117)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 3\ **Last updated:** [April 29, 2009, 6:13pm UTC](https://forum.inductiveautomation.com/t/error-writing-action-item-result-to-opc-item-e-fail/1117 "2009-04-29T18:13:31Z")
What does this mean? "Error writing action item result to OPC item: Error code returned: E\_Fail". It doesn't even tell me which action or OPC item is causing the problem. It only happens when I first turn the group on,… --- ## [Trigger group on high or low transition?](https://forum.inductiveautomation.com/t/trigger-group-on-high-or-low-transition/1122)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 3\ **Last updated:** [April 29, 2009, 5:47pm UTC](https://forum.inductiveautomation.com/t/trigger-group-on-high-or-low-transition/1122 "2009-04-29T17:47:13Z")
Am I not understanding the group trigger options? Is there an option to trigger a group on a high or low transition? I'd like to trigger a group when a bit goes from 1 to 0, but not trigger when it goes 0 to 1. I'm ju… --- ## [Use 'enumerate' function in script](https://forum.inductiveautomation.com/t/use-enumerate-function-in-script/1121)
**Author:** [@robertkjonesjr](https://forum.inductiveautomation.com/u/robertkjonesjr)\ **Replies:** 1\ **Last updated:** [April 29, 2009, 3:37pm UTC](https://forum.inductiveautomation.com/t/use-enumerate-function-in-script/1121 "2009-04-29T15:37:38Z")
I am trying to use the enumerate function in a script, but I get a name error. for index, item in enumerate(dspy): print index, item Where dspy is a py dataset. Do I need to import a module to use this function? --- ## [Option for no DB connection and/or no table name](https://forum.inductiveautomation.com/t/option-for-no-db-connection-and-or-no-table-name/1119)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 3\ **Last updated:** [April 29, 2009, 3:27pm UTC](https://forum.inductiveautomation.com/t/option-for-no-db-connection-and-or-no-table-name/1119 "2009-04-29T15:27:45Z")
There are times when I'd like to use FactorySQL to monitor a tag or tags in a PLC and then take an action when certain criteria are met. I'm not going from OPC to DB or DB to OPC. Couldn't there be an option for "No DB c… --- ## [Exclude tag from asynch update monitoring](https://forum.inductiveautomation.com/t/exclude-tag-from-asynch-update-monitoring/1120)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 1\ **Last updated:** [April 28, 2009, 8:41pm UTC](https://forum.inductiveautomation.com/t/exclude-tag-from-asynch-update-monitoring/1120 "2009-04-28T20:41:24Z")
It would be nice if I could tell FSQL to ignore a tag in a group that is being monitored for changes. In a group monitoring the set points of a machine, I'd like to be able to write a 1 to a bit if any of the set points … --- ## [Group Comment](https://forum.inductiveautomation.com/t/group-comment/566)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 4\ **Last updated:** [April 28, 2009, 7:54pm UTC](https://forum.inductiveautomation.com/t/group-comment/566 "2009-04-28T19:54:13Z")
It would be nice if there was a place to add some comments or documentation to a Group, so that I can add some information as to what the Group does or why the Group was created. --- ## [Error message on Query, but why?](https://forum.inductiveautomation.com/t/error-message-on-query-but-why/1114)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [April 28, 2009, 12:34am UTC](https://forum.inductiveautomation.com/t/error-message-on-query-but-why/1114 "2009-04-28T00:34:54Z")
Ok I have the following query: SELECT machine,start,shift,a.ProdEmpFirstName + ' ' + a.ProdEmpLastName as mech1,mech2,verb1 as status FROM DJT\_MECH\_REPORT as i left outer join ProdEmployee AS a ON a.ProdEmployeeID = i… --- ## [SQL Tags between clients](https://forum.inductiveautomation.com/t/sql-tags-between-clients/1111)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [April 27, 2009, 11:28am UTC](https://forum.inductiveautomation.com/t/sql-tags-between-clients/1111 "2009-04-27T11:28:15Z")
First, if my undersanding of SQL tags is correct, if I change a SQL tag which is set as DB, on one client, then all clients will see that same tag change to the new value. Is this correct? Second if I have a table on a… --- ## [Error message on startup script](https://forum.inductiveautomation.com/t/error-message-on-startup-script/1107)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [April 24, 2009, 8:22pm UTC](https://forum.inductiveautomation.com/t/error-message-on-startup-script/1107 "2009-04-24T20:22:30Z")
Here is an error message I am receiving from my startup script. The thing is this does not occur every time. If I start the project in runtime say 10 times at least 3 will have this error message where the other 7 will b… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=28) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=30)