# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=28 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 29 --- ## [Barcode help](https://forum.inductiveautomation.com/t/barcode-help/1176)
**Author:** [@hazey](https://forum.inductiveautomation.com/u/hazey)\ **Replies:** 6\ **Last updated:** [June 12, 2009, 11:07pm UTC](https://forum.inductiveautomation.com/t/barcode-help/1176 "2009-06-12T23:07:36Z")
Hi guys I am after some design help with a barcode project. I have a MS SQL server 2008 with a database that has a table with hundreds of EAN128 barcodes for products. I have connected Sick scanner and have succesfully s… --- ## [JAR certificate problem](https://forum.inductiveautomation.com/t/jar-certificate-problem/1177)
**Author:** [@robertkjonesjr](https://forum.inductiveautomation.com/u/robertkjonesjr)\ **Replies:** 3\ **Last updated:** [June 12, 2009, 9:07pm UTC](https://forum.inductiveautomation.com/t/jar-certificate-problem/1177 "2009-06-12T21:07:23Z")
I get an error on one particular computer where the JAR resources are not signed by same certificate (same as this thread: http://www.inductiveautomation.com/forum/viewtopic.php?f=26&t=2685). I went through those solut… --- ## [Button RGBA](https://forum.inductiveautomation.com/t/button-rgba/540)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 8\ **Last updated:** [June 8, 2009, 10:52pm UTC](https://forum.inductiveautomation.com/t/button-rgba/540 "2009-06-08T22:52:17Z")
I am unable to set the Alpha (transparency) for the background color of a button. Is this by design? I would very much like to be able to do that. I want that in order to put a frame around an existing feature on an … --- ## [Using the enter key when editing table](https://forum.inductiveautomation.com/t/using-the-enter-key-when-editing-table/1151)
**Author:** [@Jonathan](https://forum.inductiveautomation.com/u/Jonathan)\ **Replies:** 6\ **Last updated:** [June 8, 2009, 5:38pm UTC](https://forum.inductiveautomation.com/t/using-the-enter-key-when-editing-table/1151 "2009-06-08T17:38:05Z")
When you edit a cell in a table then press the enter key the selection box disappears. Then when you press the enter key again the selected row jumps to the first row in the table. If you use tab instead of enter the … --- ## [CTG Col\_Name Has To Match PointID](https://forum.inductiveautomation.com/t/ctg-col-name-has-to-match-pointid/1174)
**Author:** [@rhoag](https://forum.inductiveautomation.com/u/rhoag)\ **Replies:** 2\ **Last updated:** [June 8, 2009, 5:00pm UTC](https://forum.inductiveautomation.com/t/ctg-col-name-has-to-match-pointid/1174 "2009-06-08T17:00:55Z")
Is there a way to make the CTG work so the Col\_Name doesn't have to match the PointID? The project I'm working on has 20 sites with the same equipment at each site. The database tables are named by site and each site h… --- ## [Collecting events off many different triggers](https://forum.inductiveautomation.com/t/collecting-events-off-many-different-triggers/1175)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 3\ **Last updated:** [June 8, 2009, 3:13pm UTC](https://forum.inductiveautomation.com/t/collecting-events-off-many-different-triggers/1175 "2009-06-08T15:13:07Z")
Hello: Currently I am working on a request to collect event data from a mixing system here on site. I have an overall mixing cycle and ~60 some odd separate possible events in that cycle. The request is to collect eac… --- ## [Tree View?](https://forum.inductiveautomation.com/t/tree-view/274)
**Author:** [@troyt](https://forum.inductiveautomation.com/u/troyt)\ **Replies:** 13\ **Last updated:** [June 6, 2009, 7:00pm UTC](https://forum.inductiveautomation.com/t/tree-view/274 "2009-06-06T19:00:16Z")
I am brand new to ID FactoryPMI. It is fairly straightforward to generate graphics and other things, but I really need a tree view for my site. So far, I have been unable to find anything whatsoever. Given that the D… --- ## [FactoryPMI Designer Crashing](https://forum.inductiveautomation.com/t/factorypmi-designer-crashing/1173)
**Author:** [@karnick](https://forum.inductiveautomation.com/u/karnick)\ **Replies:** 3\ **Last updated:** [June 3, 2009, 8:33pm UTC](https://forum.inductiveautomation.com/t/factorypmi-designer-crashing/1173 "2009-06-03T20:33:12Z")
I'm having a problem where the FactoryPMI designer keeps locking up on me. This happens after about 3 minutes of having it open. The error is a java out of memory error, and I get it regardless of what computer I'm openi… --- ## [SQLTags Write Error when After SQL DB is restarted](https://forum.inductiveautomation.com/t/sqltags-write-error-when-after-sql-db-is-restarted/1169)
**Author:** [@robertkjonesjr](https://forum.inductiveautomation.com/u/robertkjonesjr)\ **Replies:** 9\ **Last updated:** [June 3, 2009, 8:20pm UTC](https://forum.inductiveautomation.com/t/sqltags-write-error-when-after-sql-db-is-restarted/1169 "2009-06-03T20:20:52Z")
While trying to test robustness of system, we took down MySQL for a moment then brought it back up. This is with a Kepware -\> FSQL -\> FPMI implementation. We wanted to see what would happen to the system. After retur… --- ## [OPC E-Fail and FSQL Triggers](https://forum.inductiveautomation.com/t/opc-e-fail-and-fsql-triggers/1168)
**Author:** [@robertkjonesjr](https://forum.inductiveautomation.com/u/robertkjonesjr)\ **Replies:** 6\ **Last updated:** [June 1, 2009, 9:43pm UTC](https://forum.inductiveautomation.com/t/opc-e-fail-and-fsql-triggers/1168 "2009-06-01T21:43:02Z")
We noticed some behaviour today with FSQL and triggers. We have a bit in a PLC that is latched; when it goes from low-\>high, trigger the FSQL group, and it is set to execute once. This works. While testing the system… --- ## [FactoryPMI Plugin Creation](https://forum.inductiveautomation.com/t/factorypmi-plugin-creation/1165)
**Author:** [@famador](https://forum.inductiveautomation.com/u/famador)\ **Replies:** 2\ **Last updated:** [June 1, 2009, 4:41pm UTC](https://forum.inductiveautomation.com/t/factorypmi-plugin-creation/1165 "2009-06-01T16:41:03Z")
I have a java application that I would like to import as a plugin for FactoryPMI. Much like FPMI it lets me create java code to compile and run at runtime. I'm hoping this java code can be linked to FPMI object propert… --- ## [FactorySQL will not connect to KepserverEX (intermiten)](https://forum.inductiveautomation.com/t/factorysql-will-not-connect-to-kepserverex-intermiten/1166)
**Author:** [@mryoung](https://forum.inductiveautomation.com/u/mryoung)\ **Replies:** 6\ **Last updated:** [May 30, 2009, 2:43am UTC](https://forum.inductiveautomation.com/t/factorysql-will-not-connect-to-kepserverex-intermiten/1166 "2009-05-30T02:43:36Z")
FactorySQL will not connect to the local service sometimes(KEPserver EX) Error is that Queue or buffer is full 127.0.0.1:5505 also when server is restarted active tag population of the Kepserver Ex which is called upon b… --- ## [Handling SQL exceptions](https://forum.inductiveautomation.com/t/handling-sql-exceptions/1163)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 4\ **Last updated:** [May 28, 2009, 6:05pm UTC](https://forum.inductiveautomation.com/t/handling-sql-exceptions/1163 "2009-05-28T18:05:30Z")
Hi all, I was wondering if there was a way we can catch SQL exceptions before the message box is shown. I've tried putting the SQL calls in a try/catch and expected the open catch: to get the SQL exception, but the mess… --- ## [Editable Table, cannot insert new row](https://forum.inductiveautomation.com/t/editable-table-cannot-insert-new-row/1164)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 2\ **Last updated:** [May 27, 2009, 3:30am UTC](https://forum.inductiveautomation.com/t/editable-table-cannot-insert-new-row/1164 "2009-05-27T03:30:40Z")
I am experimenting with the editable table goodie and I get an error when trying to insert a row. I am using MSSQL. I was doing some reading and from what I understand this issue is from the differences between MySQ… --- ## [Changing the name of the items?](https://forum.inductiveautomation.com/t/changing-the-name-of-the-items/1097)
**Author:** [@kjoari](https://forum.inductiveautomation.com/u/kjoari)\ **Replies:** 5\ **Last updated:** [May 26, 2009, 4:49pm UTC](https://forum.inductiveautomation.com/t/changing-the-name-of-the-items/1097 "2009-05-26T16:49:55Z")
We already have a system configured (MSSQL) where the tags are named; opcserver.opcgroup.opcitem. Where is the mapping-file / table for the name of the "tags" in FactorySQL (column-name) and the name of the OPC-item? Whe… --- ## [Issues after upgrading to 4.2.10](https://forum.inductiveautomation.com/t/issues-after-upgrading-to-4-2-10/1155)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 7\ **Last updated:** [May 26, 2009, 1:07pm UTC](https://forum.inductiveautomation.com/t/issues-after-upgrading-to-4-2-10/1155 "2009-05-26T13:07:19Z")
I upgraded to 4.2.10 over the weekend. This morning I went to check to make sure things are working correctly, and they're not. I figured the differences I was seeing over the weekend were due to using polled reads on c… --- ## [Need some design ideas](https://forum.inductiveautomation.com/t/need-some-design-ideas/1154)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 4\ **Last updated:** [May 22, 2009, 5:18pm UTC](https://forum.inductiveautomation.com/t/need-some-design-ideas/1154 "2009-05-22T17:18:10Z")
I know some of you guys must be working in plants that handle enormous amounts of data. I'm looking for some suggestions on what you do to make the data more presentable for a user without causing sensory overload. For… --- ## [Power Loss Database Corruption](https://forum.inductiveautomation.com/t/power-loss-database-corruption/1159)
**Author:** [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Replies:** 8\ **Last updated:** [May 21, 2009, 11:43pm UTC](https://forum.inductiveautomation.com/t/power-loss-database-corruption/1159 "2009-05-21T23:43:20Z")
Are there any tips to keeping a MySQL database intact after a power loss, other than the obvious (a big UPS)? I've had two separate events where the server PC lost power, and Travis helped me get MySQL database tables … --- ## [Number-to-Color translation](https://forum.inductiveautomation.com/t/number-to-color-translation/1161)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [May 21, 2009, 6:03pm UTC](https://forum.inductiveautomation.com/t/number-to-color-translation/1161 "2009-05-21T18:03:14Z")
I'm trying to change the colour of an object based on a value, but what I'm trying to achieve doesn't seem possible with the standard Number-to-Color Translation feature. I'm trying to achieve the following: Value=0,… --- ## [Property bindings for current component](https://forum.inductiveautomation.com/t/property-bindings-for-current-component/1158)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 4\ **Last updated:** [May 20, 2009, 11:42pm UTC](https://forum.inductiveautomation.com/t/property-bindings-for-current-component/1158 "2009-05-20T23:42:11Z")
Hi all, I'm looking for a way to access the current component's properties without tunneling down (ie not using Root Container.Path.To.Component.) Specifically, I want to bind the mouseover text for a bunch of component… --- ## [Multiple monitor support](https://forum.inductiveautomation.com/t/multiple-monitor-support/1129)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [May 20, 2009, 8:07pm UTC](https://forum.inductiveautomation.com/t/multiple-monitor-support/1129 "2009-05-20T20:07:54Z")
I'm not quite sure if this should go here or in the Feature Request area. I would like to run 2 clients on one dual-screen PC, with each client maximised to a different screen. Is this possible? Al --- ## [Simple map window and scaling issues](https://forum.inductiveautomation.com/t/simple-map-window-and-scaling-issues/1157)
**Author:** [@chache](https://forum.inductiveautomation.com/u/chache)\ **Replies:** 2\ **Last updated:** [May 20, 2009, 5:12pm UTC](https://forum.inductiveautomation.com/t/simple-map-window-and-scaling-issues/1157 "2009-05-20T17:12:12Z")
Hi all, Based on the draggable component code that was posted on this forum, I’ve created a simple map window. Basically I followed the idea from someone on this forum for a large draggable map (was Step7 in this threa… --- ## [Integrating Google Maps in Factory PMI](https://forum.inductiveautomation.com/t/integrating-google-maps-in-factory-pmi/688)
**Author:** [@smd](https://forum.inductiveautomation.com/u/smd)\ **Replies:** 10\ **Last updated:** [May 20, 2009, 4:57pm UTC](https://forum.inductiveautomation.com/t/integrating-google-maps-in-factory-pmi/688 "2009-05-20T16:57:11Z")
Has anyone yet integrated Google Maps into a Factory PMI page? What would be the best way to go about that? --- ## [Cannot connect to OPC Server for Browse with RSLinx OPC](https://forum.inductiveautomation.com/t/cannot-connect-to-opc-server-for-browse-with-rslinx-opc/1153)
**Author:** [@alexr](https://forum.inductiveautomation.com/u/alexr)\ **Replies:** 2\ **Last updated:** [May 19, 2009, 8:33pm UTC](https://forum.inductiveautomation.com/t/cannot-connect-to-opc-server-for-browse-with-rslinx-opc/1153 "2009-05-19T20:33:12Z")
When I try to open the RSLinx OPC Server from FSQL show me the next error: An error ocurred during browsing: Cannot connect the OPC Server for browse. In the Log Viewer is genereted that is attachet in the topic Any i… --- ## [Zeros written to SQL while FactorySQL PC is being used](https://forum.inductiveautomation.com/t/zeros-written-to-sql-while-factorysql-pc-is-being-used/1152)
**Author:** [@rollie715](https://forum.inductiveautomation.com/u/rollie715)\ **Replies:** 5\ **Last updated:** [May 19, 2009, 7:05pm UTC](https://forum.inductiveautomation.com/t/zeros-written-to-sql-while-factorysql-pc-is-being-used/1152 "2009-05-19T19:05:16Z")
I have FactorySQL 4.2.10.0 running on an XPPro box along with other applications. The applications include RSLogix and RSViewME. The SQL database being written to is on a separate box. The problem seems to be while I am … --- ## [Routing between subnets](https://forum.inductiveautomation.com/t/routing-between-subnets/412)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 7\ **Last updated:** [May 19, 2009, 3:15am UTC](https://forum.inductiveautomation.com/t/routing-between-subnets/412 "2009-05-19T03:15:15Z")
I am installing an Ethernet/IP network with a ControlLogix processor, 16 Point I/O racks and a Red Lion G308 HMI, all connected via 17 Ethernet switches on a fibre ring. We have now been told that we will have to pass … --- ## [Swapping out Header Windows](https://forum.inductiveautomation.com/t/swapping-out-header-windows/1142)
**Author:** [@KeithB](https://forum.inductiveautomation.com/u/KeithB)\ **Replies:** 9\ **Last updated:** [May 18, 2009, 10:27am UTC](https://forum.inductiveautomation.com/t/swapping-out-header-windows/1142 "2009-05-18T10:27:27Z")
I am using the basic 2 window setup that was presented during a demo we watched. I have a Header window and then a Body window. The Body windows change without issue. What I would like to do is also Swap out my Heade… --- ## [FactorySQL killing PLC processor](https://forum.inductiveautomation.com/t/factorysql-killing-plc-processor/1116)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 16\ **Last updated:** [May 16, 2009, 11:04am UTC](https://forum.inductiveautomation.com/t/factorysql-killing-plc-processor/1116 "2009-05-16T11:04:57Z")
I have yet to hear a good answer to this question so I'll ask it again and give more examples. I'm an RsSQL convert. There were so many things wrong with that program, when I found FSQL I made the switch very quickly. Bu… --- ## [Data Poll on unreliable OPC server](https://forum.inductiveautomation.com/t/data-poll-on-unreliable-opc-server/1132)
**Author:** [@neville](https://forum.inductiveautomation.com/u/neville)\ **Replies:** 9\ **Last updated:** [May 15, 2009, 11:28pm UTC](https://forum.inductiveautomation.com/t/data-poll-on-unreliable-opc-server/1132 "2009-05-15T23:28:41Z")
Hi; my first post to the forum after purchasing and starting to use FSQL. I've got most of what I want to do running. For one set of data, it is coming from a rather unreliable OPC server. When I say unreliable it is… --- ## [FactorySQL video request?](https://forum.inductiveautomation.com/t/factorysql-video-request/1124)
**Author:** [@SonicClang](https://forum.inductiveautomation.com/u/SonicClang)\ **Replies:** 1\ **Last updated:** [May 15, 2009, 6:31pm UTC](https://forum.inductiveautomation.com/t/factorysql-video-request/1124 "2009-05-15T18:31:16Z")
This isn't a feature request, but a request for another video. I'm extremely interested in the alerting features in FactorySQL, and I'd love to know a little more about it. The videos were so helpful and I think one on t… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=27) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=29)