# Archived Topics

**URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=56

[Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md)

**Page:** 57

---

## [New chart for "digital" graphs](https://forum.inductiveautomation.com/t/new-chart-for-digital-graphs/30)

<div class="topic-metadata">

**Author:** [@jeff\_anderson](https://forum.inductiveautomation.com/u/jeff_anderson)\
**Replies:** 2\
**Last updated:** [February 12, 2007, 1:45am UTC](https://forum.inductiveautomation.com/t/new-chart-for-digital-graphs/30 "2007-02-12T01:45:53Z")

</div>

I need a chart to display digital graphs. Was a fan running or not? Valve open or closed? The line graph looks ok sometimes, but has angled transition lines that look really bad. Is there a better way to do this?

---

## [Passing data between windows](https://forum.inductiveautomation.com/t/passing-data-between-windows/190)

<div class="topic-metadata">

**Author:** [@torulf](https://forum.inductiveautomation.com/u/torulf)\
**Replies:** 15\
**Last updated:** [February 9, 2007, 2:44pm UTC](https://forum.inductiveautomation.com/t/passing-data-between-windows/190 "2007-02-09T14:44:06Z")

</div>

I am still playing with your software. So far I find it fairly functional and friendly but as a beginner I stumble on something every now and then. I have created a window where the user can assemble a dataset by selec…

---

## [Binding Chart mode selection to buttons](https://forum.inductiveautomation.com/t/binding-chart-mode-selection-to-buttons/192)

<div class="topic-metadata">

**Author:** [@torulf](https://forum.inductiveautomation.com/u/torulf)\
**Replies:** 3\
**Last updated:** [February 9, 2007, 2:34pm UTC](https://forum.inductiveautomation.com/t/binding-chart-mode-selection-to-buttons/192 "2007-02-09T14:34:27Z")

</div>

Is there a way to bind the right mouse click menu items to components such as buttons making it easier to select modes and possibly making way for pre-defined combination actions? Regards /T

---

## [Graphics Files](https://forum.inductiveautomation.com/t/graphics-files/185)

<div class="topic-metadata">

**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\
**Replies:** 6\
**Last updated:** [February 6, 2007, 5:18am UTC](https://forum.inductiveautomation.com/t/graphics-files/185 "2007-02-06T05:18:04Z")

</div>

Other formats besides .png would be handy. Animated gif files would be really cool.

---

## [Changing the mouse cursor image](https://forum.inductiveautomation.com/t/changing-the-mouse-cursor-image/189)

<div class="topic-metadata">

**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\
**Replies:** 3\
**Last updated:** [February 2, 2007, 5:29pm UTC](https://forum.inductiveautomation.com/t/changing-the-mouse-cursor-image/189 "2007-02-02T17:29:31Z")

</div>

I know I can change the mouse cursor image based on it rolling over an object. Can I get it to change regardless of the position based upon a dynamic property being set or reset? Here is why. I have 18 identical ai…

---

## [Changing the color of text in a label](https://forum.inductiveautomation.com/t/changing-the-color-of-text-in-a-label/186)

<div class="topic-metadata">

**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\
**Replies:** 2\
**Last updated:** [February 1, 2007, 3:41am UTC](https://forum.inductiveautomation.com/t/changing-the-color-of-text-in-a-label/186 "2007-02-01T03:41:27Z")

</div>

\<html\>Q: I need help. \<br\> \<COLOR\>A: Yes you do. Note. color="red". The board keeps kicking the ="red" out of my post. Doesn't work. Any way to achieve my goal here within one label? I know the html is limited but …

---

## [Command-line options](https://forum.inductiveautomation.com/t/command-line-options/145)

<div class="topic-metadata">

**Author:** [@ChuckP](https://forum.inductiveautomation.com/u/ChuckP)\
**Replies:** 5\
**Last updated:** [January 31, 2007, 8:44pm UTC](https://forum.inductiveautomation.com/t/command-line-options/145 "2007-01-31T20:44:02Z")

</div>

How can I select which window within an application to open on startup. I want one user to start with load and one to start with unload. I then need to password protect going between them. Thanks

---

## [Displaying the logged on username](https://forum.inductiveautomation.com/t/displaying-the-logged-on-username/184)

<div class="topic-metadata">

**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\
**Replies:** 5\
**Last updated:** [January 30, 2007, 10:08pm UTC](https://forum.inductiveautomation.com/t/displaying-the-logged-on-username/184 "2007-01-30T22:08:07Z")

</div>

I figured I would post this in case anybody else out there needed to do this. I selected the window I wanted this to be on and click the little gear icon to bring up the action configuration screen for this window. I…

---

## [Calculating Efficiencies with hourly DB logging](https://forum.inductiveautomation.com/t/calculating-efficiencies-with-hourly-db-logging/176)

<div class="topic-metadata">

**Author:** [@KeithB](https://forum.inductiveautomation.com/u/KeithB)\
**Replies:** 11\
**Last updated:** [January 29, 2007, 8:09pm UTC](https://forum.inductiveautomation.com/t/calculating-efficiencies-with-hourly-db-logging/176 "2007-01-29T20:09:11Z")

</div>

I am trying to calculate the efficiency of our automated machines and log an hourly snapshot of those efficiencies. The equation would be total parts run / (Run Rate \* current run time). I have PLC tags associated wit…

---

## [Advance Button](https://forum.inductiveautomation.com/t/advance-button/183)

<div class="topic-metadata">

**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\
**Replies:** 9\
**Last updated:** [January 29, 2007, 7:05pm UTC](https://forum.inductiveautomation.com/t/advance-button/183 "2007-01-29T19:05:51Z")

</div>

I have a window named Ammonia Air Unit. It displays the information and controls the cooler units in the factory. There are 18 air units. The window is populated with information from a table that I index off of a co…

---

## [Populate a Dropdown List with column labels](https://forum.inductiveautomation.com/t/populate-a-dropdown-list-with-column-labels/182)

<div class="topic-metadata">

**Author:** [@torulf](https://forum.inductiveautomation.com/u/torulf)\
**Replies:** 4\
**Last updated:** [January 29, 2007, 7:12am UTC](https://forum.inductiveautomation.com/t/populate-a-dropdown-list-with-column-labels/182 "2007-01-29T07:12:09Z")

</div>

I have downloaded FactorySQL and FactoryPMI and I am currently evaluating if this is a product for us. Now to my question: I want the users to be able to select what data to populate a table and a couple of chart objec…

---

## [Focus](https://forum.inductiveautomation.com/t/focus/179)

<div class="topic-metadata">

**Author:** [@jet](https://forum.inductiveautomation.com/u/jet)\
**Replies:** 13\
**Last updated:** [January 27, 2007, 11:12pm UTC](https://forum.inductiveautomation.com/t/focus/179 "2007-01-27T23:12:51Z")

</div>

I have set up a container. Within the container I have a slider. When I click on the slider it becomes outlined with a thin border. I am assuming this indicates that object has the focus. My problem is I can't get it …

---

## [Change component attributes based on DB values](https://forum.inductiveautomation.com/t/change-component-attributes-based-on-db-values/180)

<div class="topic-metadata">

**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\
**Replies:** 2\
**Last updated:** [January 26, 2007, 5:59pm UTC](https://forum.inductiveautomation.com/t/change-component-attributes-based-on-db-values/180 "2007-01-26T17:59:41Z")

</div>

I want to change the color, OR, Visability of a component based on a DB value. I want to change the background color of a Rectangle if a DB entry is set at 1 (or perhaps zero) I also want to make an item visable if t…

---

## [ERROR: Unable to connect to OPC Servers](https://forum.inductiveautomation.com/t/error-unable-to-connect-to-opc-servers/174)

<div class="topic-metadata">

**Author:** [@KeithB](https://forum.inductiveautomation.com/u/KeithB)\
**Replies:** 4\
**Last updated:** [January 2, 2007, 10:06pm UTC](https://forum.inductiveautomation.com/t/error-unable-to-connect-to-opc-servers/174 "2007-01-02T22:06:20Z")

</div>

I keep getting this error when I try to start any of my groups. I am running KEPDirect and had this running before. The OPC server seems to be running fine and I cannot find anything that looks different. What could I…

---

## [Make Data Cable Link For PLC Siemens OP Display Series](https://forum.inductiveautomation.com/t/make-data-cable-link-for-plc-siemens-op-display-series/172)

<div class="topic-metadata">

**Author:** [@nuttaphong191](https://forum.inductiveautomation.com/u/nuttaphong191)\
**Replies:** 0\
**Last updated:** [December 29, 2006, 7:00am UTC](https://forum.inductiveautomation.com/t/make-data-cable-link-for-plc-siemens-op-display-series/172 "2006-12-29T07:00:37Z")

</div>

If you need to make data cable link for plc Siemens OP Display Series you can do like this the first one prepare connecter RS-232C female 9Pin 1 set and RS-232C male 15 Pin 1 set ,shielding cable about 2-3 meter http://…

---

## [How to Make Data Cable Link For PLC Mitsubishi SC-02N Or SC-](https://forum.inductiveautomation.com/t/how-to-make-data-cable-link-for-plc-mitsubishi-sc-02n-or-sc/170)

<div class="topic-metadata">

**Author:** [@nuttaphong191](https://forum.inductiveautomation.com/u/nuttaphong191)\
**Replies:** 1\
**Last updated:** [December 26, 2006, 12:25am UTC](https://forum.inductiveautomation.com/t/how-to-make-data-cable-link-for-plc-mitsubishi-sc-02n-or-sc/170 "2006-12-26T00:25:05Z")

</div>

If you need to make data cable link for plc Mitsubishi SC-02N or SC-05 you can do like this the first one prepare connecter RS-232C female 9Pin 1 set and RS-232C male 25 Pin 1 set ,shielding cable about 2-3 meter you can…

---

## [Decoding winmail.dat file sent from MS Outlook](https://forum.inductiveautomation.com/t/decoding-winmail-dat-file-sent-from-ms-outlook/169)

<div class="topic-metadata">

**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Replies:** 0\
**Last updated:** [December 23, 2006, 4:38pm UTC](https://forum.inductiveautomation.com/t/decoding-winmail-dat-file-sent-from-ms-outlook/169 "2006-12-23T16:38:38Z")

</div>

Posting this for my own reference later. When your email client receives a winmail.dat attachment it means that the sender used MS Outlook and your email client can't handle it. Here you can download a program to decod…

---

## [Email, HTML, Table Data](https://forum.inductiveautomation.com/t/email-html-table-data/168)

<div class="topic-metadata">

**Author:** [@dmusser](https://forum.inductiveautomation.com/u/dmusser)\
**Replies:** 4\
**Last updated:** [December 22, 2006, 4:05pm UTC](https://forum.inductiveautomation.com/t/email-html-table-data/168 "2006-12-22T16:05:49Z")

</div>

Can you provide some examples of how I can do the following: The user will click on a push button and automatically send an email out to its recipients (already programmed in). The email will need to be HTML and includ…

---

## [Deploying FactorySQL and Oracle - Small problems](https://forum.inductiveautomation.com/t/deploying-factorysql-and-oracle-small-problems/167)

<div class="topic-metadata">

**Author:** [@Oscar](https://forum.inductiveautomation.com/u/Oscar)\
**Replies:** 1\
**Last updated:** [December 21, 2006, 6:32pm UTC](https://forum.inductiveautomation.com/t/deploying-factorysql-and-oracle-small-problems/167 "2006-12-21T18:32:57Z")

</div>

I've just arrived from our client's factory. Although the system has been left working, I found a few bugs (or are they features? :slight\_smile: ) on the process: I created a tag on KepServer with a name that starte…

---

## [Error HTTP 403 when launching config page](https://forum.inductiveautomation.com/t/error-http-403-when-launching-config-page/166)

<div class="topic-metadata">

**Author:** [@ideas](https://forum.inductiveautomation.com/u/ideas)\
**Replies:** 6\
**Last updated:** [December 20, 2006, 6:59pm UTC](https://forum.inductiveautomation.com/t/error-http-403-when-launching-config-page/166 "2006-12-20T18:59:13Z")

</div>

Hello, I've install FPMI and FSQL on a new laptop with Vista, disabled firewall and so. I can launch designer, gateway status but launching config send me always on a FPMI page : " HTTP Status 403 - type Status repor…

---

## [Demo Software OPC Error](https://forum.inductiveautomation.com/t/demo-software-opc-error/161)

<div class="topic-metadata">

**Author:** [@jmr](https://forum.inductiveautomation.com/u/jmr)\
**Replies:** 6\
**Last updated:** [December 20, 2006, 3:01am UTC](https://forum.inductiveautomation.com/t/demo-software-opc-error/161 "2006-12-20T03:01:10Z")

</div>

I downloaded and installed the FactorySQL software but the OPC server would not load I get an error message saying "Download Failed: Server did not specify content length" What have I done wrong? Do I need to purchase…

---

## [Scheduled group and clearing PLC](https://forum.inductiveautomation.com/t/scheduled-group-and-clearing-plc/142)

<div class="topic-metadata">

**Author:** [@terichem](https://forum.inductiveautomation.com/u/terichem)\
**Replies:** 4\
**Last updated:** [December 20, 2006, 2:54am UTC](https://forum.inductiveautomation.com/t/scheduled-group-and-clearing-plc/142 "2006-12-20T02:54:22Z")

</div>

Hello, We would like to set up FactorySQL following. We need downloaded data from PLC at 6:00, 14:00 and 22:00. In this time we wold like save this value to the database and after this action we would like to set up PL…

---

## [How to create password for protect CPU Omron C200HE](https://forum.inductiveautomation.com/t/how-to-create-password-for-protect-cpu-omron-c200he/164)

<div class="topic-metadata">

**Author:** [@nuttaphong191](https://forum.inductiveautomation.com/u/nuttaphong191)\
**Replies:** 1\
**Last updated:** [December 18, 2006, 11:11pm UTC](https://forum.inductiveautomation.com/t/how-to-create-password-for-protect-cpu-omron-c200he/164 "2006-12-18T23:11:11Z")

</div>

From my experience about create password for protect CPU Omron C200HE tryplc.com/Articles/Password ... 200HE.html

---

## [Oracle 9i and FactorySQL](https://forum.inductiveautomation.com/t/oracle-9i-and-factorysql/162)

<div class="topic-metadata">

**Author:** [@Oscar](https://forum.inductiveautomation.com/u/Oscar)\
**Replies:** 0\
**Last updated:** [December 15, 2006, 10:34am UTC](https://forum.inductiveautomation.com/t/oracle-9i-and-factorysql/162 "2006-12-15T10:34:44Z")

</div>

Hi! I've been trying to get FactorySQL to work with a fresh Oracle 9i installation. Bear in mind while reading this that my Oracle knowledge is very limited. I had the installation already done on the deployment machin…

---

## [Omron Cable Link with Touch Screen Pro-Face](https://forum.inductiveautomation.com/t/omron-cable-link-with-touch-screen-pro-face/160)

<div class="topic-metadata">

**Author:** [@nuttaphong191](https://forum.inductiveautomation.com/u/nuttaphong191)\
**Replies:** 1\
**Last updated:** [December 15, 2006, 12:29am UTC](https://forum.inductiveautomation.com/t/omron-cable-link-with-touch-screen-pro-face/160 "2006-12-15T00:29:36Z")

</div>

I do the cable link of the PLC Omron with Touch Screen (Pro-face) 1 Cable can link all together I hope can usefully for everybody tryplc.com/Articles/Cable%20 ... oface.html why you delete my post before that or thi…

---

## [How do I make FactoryPMI work with the Windows Firewall?](https://forum.inductiveautomation.com/t/how-do-i-make-factorypmi-work-with-the-windows-firewall/159)

<div class="topic-metadata">

**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Replies:** 0\
**Last updated:** [December 13, 2006, 10:08pm UTC](https://forum.inductiveautomation.com/t/how-do-i-make-factorypmi-work-with-the-windows-firewall/159 "2006-12-13T22:08:33Z")

</div>

This post covers it FactoryPMI only needs to be able to communicate over a single, user definable TCP port. To work with any firewall, simply create an exception for the computer to listen over that port. If you want t…

---

## [FactoryPMI no longer works after joining a Windows Domain](https://forum.inductiveautomation.com/t/factorypmi-no-longer-works-after-joining-a-windows-domain/158)

<div class="topic-metadata">

**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\
**Replies:** 0\
**Last updated:** [December 13, 2006, 10:05pm UTC](https://forum.inductiveautomation.com/t/factorypmi-no-longer-works-after-joining-a-windows-domain/158 "2006-12-13T22:05:20Z")

</div>

I just worked with an integrator who lost connectivity to a FactoryPMI server (Windows XP SP2 computer) after joining it to a Windows 2003 domain (Small business server). Here were the symptoms: The machine could run …

---

## [Use text field value in a where clause of a select query](https://forum.inductiveautomation.com/t/use-text-field-value-in-a-where-clause-of-a-select-query/152)

<div class="topic-metadata">

**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\
**Replies:** 6\
**Last updated:** [December 12, 2006, 5:07pm UTC](https://forum.inductiveautomation.com/t/use-text-field-value-in-a-where-clause-of-a-select-query/152 "2006-12-12T17:07:13Z")

</div>

I can get the binding to work, the only problem I have is when I try to change the value of the text field and there is an istance where the value is NUL I get an error. What would be a possible solution?

---

## [FPMI.db help](https://forum.inductiveautomation.com/t/fpmi-db-help/154)

<div class="topic-metadata">

**Author:** [@tsimmons](https://forum.inductiveautomation.com/u/tsimmons)\
**Replies:** 2\
**Last updated:** [December 11, 2006, 4:48pm UTC](https://forum.inductiveautomation.com/t/fpmi-db-help/154 "2006-12-11T16:48:54Z")

</div>

I can't seem to get this to work.....error box reports this - ValueError: SQL Error: Error converting data type varchar to float. ShopOrderNumber = fpmi.db.runScalarQuery("SELECT MAX(ShopOrderNumber) AS ShopOrderNumb…

---

## [Insert date and time in MySQL with a button](https://forum.inductiveautomation.com/t/insert-date-and-time-in-mysql-with-a-button/153)

<div class="topic-metadata">

**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\
**Replies:** 1\
**Last updated:** [December 8, 2006, 9:01pm UTC](https://forum.inductiveautomation.com/t/insert-date-and-time-in-mysql-with-a-button/153 "2006-12-08T21:01:06Z")

</div>

Is there a way to insert the date and time into a MySQL databse by using the action of a button.

[Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=55)

[Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=57)
