# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=51 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 52 --- ## [EasyChart and multiple tables](https://forum.inductiveautomation.com/t/easychart-and-multiple-tables/381)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 9\ **Last updated:** [October 9, 2007, 8:21pm UTC](https://forum.inductiveautomation.com/t/easychart-and-multiple-tables/381 "2007-10-09T20:21:05Z")
How can you set pens in the EasyChart to columns that are in different tables? When selecting the pens at design time, I can browse the database (Microsoft SQL Server) and see my multiple tables but when I select column… --- ## [SQLTags Bug](https://forum.inductiveautomation.com/t/sqltags-bug/379)
**Author:** [@KyleChase](https://forum.inductiveautomation.com/u/KyleChase)\ **Replies:** 6\ **Last updated:** [October 7, 2007, 11:00pm UTC](https://forum.inductiveautomation.com/t/sqltags-bug/379 "2007-10-07T23:00:25Z")
Just wondering if any one else is having issues with SQL Tags. My tags just stop querying all together, but when i add a new tag, it works... for a bit. I dont know what the issue is, and want to get it resolved. Its … --- ## [Good Industrial Security Article](https://forum.inductiveautomation.com/t/good-industrial-security-article/380)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [October 7, 2007, 5:16am UTC](https://forum.inductiveautomation.com/t/good-industrial-security-article/380 "2007-10-07T05:16:27Z")
This is a good introduction to layered security that doesn't get too far into the weeds. Defense in Depth is a technique that the military (and corporations) use to buy time by slowing down the determined attacker. It in… --- ## [FactorySQL Performance increase with MySQL 5](https://forum.inductiveautomation.com/t/factorysql-performance-increase-with-mysql-5/157)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 3\ **Last updated:** [October 6, 2007, 3:51pm UTC](https://forum.inductiveautomation.com/t/factorysql-performance-increase-with-mysql-5/157 "2007-10-06T15:51:16Z")
Colby posted this to the Knowledge base. I've had several users ask about it and it's relevant to many of our FSQL users. here's a link. --- ## [Database translator](https://forum.inductiveautomation.com/t/database-translator/377)
**Author:** [@mdowdell](https://forum.inductiveautomation.com/u/mdowdell)\ **Replies:** 4\ **Last updated:** [October 5, 2007, 2:30pm UTC](https://forum.inductiveautomation.com/t/database-translator/377 "2007-10-05T14:30:35Z")
Hello All, Today, I downloaded the FactorySQL package. I will be using it for moving data from my CLogix processors to an Access db. The problem I have is that when I try to start a group I receive the following error … --- ## [Data Source SQL Problem](https://forum.inductiveautomation.com/t/data-source-sql-problem/376)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 1\ **Last updated:** [October 4, 2007, 9:16pm UTC](https://forum.inductiveautomation.com/t/data-source-sql-problem/376 "2007-10-04T21:16:59Z")
I am trying to connect to an Informix database. In the Windows ODBC setup, I have the Informix ODBC driver, and 'Test Connection' works okay. The error I get with FPMI is: FAIL (next test in 8 seconds) Message: (… --- ## [RSSQL = FactorySQL](https://forum.inductiveautomation.com/t/rssql-factorysql/373)
**Author:** [@DaveSP](https://forum.inductiveautomation.com/u/DaveSP)\ **Replies:** 3\ **Last updated:** [October 4, 2007, 7:25pm UTC](https://forum.inductiveautomation.com/t/rssql-factorysql/373 "2007-10-04T19:25:27Z")
I have been trying for days to get RSSQL to READ data out of MSSQL 8.0 with no luck. I am in the process of downloading FactorySQL and am going to try to install this and get this to work. What I have is a entire SCADA… --- ## [Chart Question](https://forum.inductiveautomation.com/t/chart-question/374)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 3\ **Last updated:** [October 4, 2007, 2:13am UTC](https://forum.inductiveautomation.com/t/chart-question/374 "2007-10-04T02:13:00Z")
Is there a way to extract the date/record number/etc from a 'Mark' on an Easy Chart? I need the user to be able to select a range of time on the chart to make another association. Is there any way to add annotations t… --- ## [Import Export Configuration](https://forum.inductiveautomation.com/t/import-export-configuration/333)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 9\ **Last updated:** [September 30, 2007, 11:37pm UTC](https://forum.inductiveautomation.com/t/import-export-configuration/333 "2007-09-30T23:37:53Z")
Let say that I have 8 Identical machines and I build one configuration for one of them can I export the datapoints and transactions or triggers use excel or any other text editor and search and replace and import them an… --- ## [Source Timestamp](https://forum.inductiveautomation.com/t/source-timestamp/362)
**Author:** [@pnendel](https://forum.inductiveautomation.com/u/pnendel)\ **Replies:** 9\ **Last updated:** [September 29, 2007, 7:34pm UTC](https://forum.inductiveautomation.com/t/source-timestamp/362 "2007-09-29T19:34:48Z")
Hello Sorry for my english, I'm french. I use a OPC server, that return timstamped data, Factory SQL don't take the timestamp from the opc server. How i can have it?? Best regard Pierre --- ## [How to Save Report](https://forum.inductiveautomation.com/t/how-to-save-report/370)
**Author:** [@larryjones](https://forum.inductiveautomation.com/u/larryjones)\ **Replies:** 2\ **Last updated:** [September 29, 2007, 6:27pm UTC](https://forum.inductiveautomation.com/t/how-to-save-report/370 "2007-09-29T18:27:04Z")
I'm new to FPMI and I just started experimenting with the FPMI Reporting Plugin. I used the Report Designer to create a report but I don't see where I can save my report. If I just close the Report Designer and then go… --- ## [FPMI gateway with multiple network connection](https://forum.inductiveautomation.com/t/fpmi-gateway-with-multiple-network-connection/369)
**Author:** [@Maithen](https://forum.inductiveautomation.com/u/Maithen)\ **Replies:** 7\ **Last updated:** [September 28, 2007, 6:31pm UTC](https://forum.inductiveautomation.com/t/fpmi-gateway-with-multiple-network-connection/369 "2007-09-28T18:31:10Z")
I have worked a bit with the FPMI gateway and i have finally suceeded in exposing it to the internet. It works fine after setting it up according to an article about this subject (How To: Expose a FactoryPMI Gateway Behi… --- ## [InvokeLater function to run script after all pending events](https://forum.inductiveautomation.com/t/invokelater-function-to-run-script-after-all-pending-events/365)
**Author:** [@lotuseater](https://forum.inductiveautomation.com/u/lotuseater)\ **Replies:** 1\ **Last updated:** [September 26, 2007, 12:19am UTC](https://forum.inductiveautomation.com/t/invokelater-function-to-run-script-after-all-pending-events/365 "2007-09-26T00:19:16Z")
I have Numeric Label "TempSP" with its value bound to: lookup({Root Container.R1P1.Chart.TempSP}, {Root Container.R1P1.Calc\_CurrentStep}, 0, 'StepNumber', 'Temperature') I also have Numberic Label "CurrentStep" with… --- ## [Use Bounds and Numeric Keypad](https://forum.inductiveautomation.com/t/use-bounds-and-numeric-keypad/363)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 2\ **Last updated:** [September 21, 2007, 7:56pm UTC](https://forum.inductiveautomation.com/t/use-bounds-and-numeric-keypad/363 "2007-09-21T19:56:02Z")
If the numeric keypad is used to supply the value to a Numeric Text Field, the Use Bounds on the Numeric Text Field does not function correctly. I’m guessing the bounds is checked when focus is lost on the numeric text… --- ## [Touchscreen Input](https://forum.inductiveautomation.com/t/touchscreen-input/354)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 8\ **Last updated:** [September 19, 2007, 12:53am UTC](https://forum.inductiveautomation.com/t/touchscreen-input/354 "2007-09-19T00:53:13Z")
Can you add position arguments to the showNumericKeyboard and showTouchscreenKeyboard functions? It seems the they open at the bottom of the window, but if the bottom of the window is off screen and the keyboard is off … --- ## [Dynamic Properties shortcut](https://forum.inductiveautomation.com/t/dynamic-properties-shortcut/358)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 2\ **Last updated:** [September 18, 2007, 4:13am UTC](https://forum.inductiveautomation.com/t/dynamic-properties-shortcut/358 "2007-09-18T04:13:17Z")
Can you add the Dynamic Properties keyboard shortcut back in? Thanks --- ## [New Dell PC with Windows XP, issues with JAVA](https://forum.inductiveautomation.com/t/new-dell-pc-with-windows-xp-issues-with-java/361)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [September 17, 2007, 9:35pm UTC](https://forum.inductiveautomation.com/t/new-dell-pc-with-windows-xp-issues-with-java/361 "2007-09-17T21:35:13Z")
Now sure what caused it and it kind of still is happening so I thought I would post it here and see what answers I receive. We recently purchased a new dell PC. On it is Windows XP pro. Our IT staff took the CD they ma… --- ## [Copy and Edit Dataset](https://forum.inductiveautomation.com/t/copy-and-edit-dataset/360)
**Author:** [@lotuseater](https://forum.inductiveautomation.com/u/lotuseater)\ **Replies:** 3\ **Last updated:** [September 17, 2007, 8:47pm UTC](https://forum.inductiveautomation.com/t/copy-and-edit-dataset/360 "2007-09-17T20:47:12Z")
I have a dataset, TempSP, for a chart that is bound to SQL. Its columns are "StepNumber", "Temperature". I need to bind a second dataset, TempSP\_LL, that is "StepNumber", ("Temperature" - 20). The code below is th… --- ## [T\_stamp problem](https://forum.inductiveautomation.com/t/t-stamp-problem/353)
**Author:** [@Enginestart](https://forum.inductiveautomation.com/u/Enginestart)\ **Replies:** 3\ **Last updated:** [September 13, 2007, 8:15am UTC](https://forum.inductiveautomation.com/t/t-stamp-problem/353 "2007-09-13T08:15:43Z")
I was testing with the newest demo to get the data, everything went well and started programming in PHP with the data, but i found some kind of bug.. The timestamps that is given with the data is 2 hours behind servert… --- ## [Selecting Easy Chart pens at runtime](https://forum.inductiveautomation.com/t/selecting-easy-chart-pens-at-runtime/356)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 13\ **Last updated:** [September 6, 2007, 8:25pm UTC](https://forum.inductiveautomation.com/t/selecting-easy-chart-pens-at-runtime/356 "2007-09-06T20:25:38Z")
Is there a built-in method of allowing users to select which pens are to be displayed (not just made visible) in an Easy Chart at runtime? If not, I would like to display 2 lists on the screen: the first will display a… --- ## [How do the Chart and Easy Chart plot data?](https://forum.inductiveautomation.com/t/how-do-the-chart-and-easy-chart-plot-data/357)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 2\ **Last updated:** [September 6, 2007, 2:39pm UTC](https://forum.inductiveautomation.com/t/how-do-the-chart-and-easy-chart-plot-data/357 "2007-09-06T14:39:16Z")
Say for example you have an Easy Chart whose plotting area is 1000 pixels wide. You then ask for a 30 days trend of an input which has been logged every second - potentially over 2.5 million points. Does the Chart req… --- ## [FSQL errors](https://forum.inductiveautomation.com/t/fsql-errors/343)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [August 31, 2007, 2:59pm UTC](https://forum.inductiveautomation.com/t/fsql-errors/343 "2007-08-31T14:59:18Z")
I have been in contact with Travis about this and he told me to increase my scan time from 5mS to 1S on the groups whose scan time was 5mS. I did this and a couple of things happened. First in the service statisics win… --- ## [FactoryPMI and IE: Unable to launch specified application](https://forum.inductiveautomation.com/t/factorypmi-and-ie-unable-to-launch-specified-application/42)
**Author:** [@admin1](https://forum.inductiveautomation.com/u/admin1)\ **Replies:** 12\ **Last updated:** [August 30, 2007, 8:53pm UTC](https://forum.inductiveautomation.com/t/factorypmi-and-ie-unable-to-launch-specified-application/42 "2007-08-30T20:53:57Z")
There is a problem with IE's caching mechanism that causes this symptom: When you click on a Java Web Start link for FactoryPMI, you get the error message: "Unable to launch the specified application" with the details: … --- ## [EasyChart](https://forum.inductiveautomation.com/t/easychart/352)
**Author:** [@jdelgado](https://forum.inductiveautomation.com/u/jdelgado)\ **Replies:** 6\ **Last updated:** [August 30, 2007, 5:05pm UTC](https://forum.inductiveautomation.com/t/easychart/352 "2007-08-30T17:05:36Z")
Hi, I am curios to know if easychart is develop by you guys or do you use a a chart control like gigasoft or chartfx and program around it. If it is a third party control do you mind sharing who makes it. Thanks Jul… --- ## [What objects are affected by Component Security?](https://forum.inductiveautomation.com/t/what-objects-are-affected-by-component-security/351)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [August 30, 2007, 2:22pm UTC](https://forum.inductiveautomation.com/t/what-objects-are-affected-by-component-security/351 "2007-08-30T14:22:52Z")
I've noticed some objects don't seem to be completely affected by Component Security. For example, rather than clutter a window with control buttons, I put a rectangle over an item of equipment on the screen. (The rec… --- ## [FPMI report plug in question](https://forum.inductiveautomation.com/t/fpmi-report-plug-in-question/350)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [August 29, 2007, 12:18am UTC](https://forum.inductiveautomation.com/t/fpmi-report-plug-in-question/350 "2007-08-29T00:18:54Z")
I was wondering how many data sources can you poll from for one report screen? I ask because I may have 2 possibly 3 SQL tables that I would want to pull from to condense the information on one readable screen. --- ## [Text Area Box](https://forum.inductiveautomation.com/t/text-area-box/349)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [August 27, 2007, 3:02pm UTC](https://forum.inductiveautomation.com/t/text-area-box/349 "2007-08-27T15:02:04Z")
I am using a Text Area box that will let the operators leave notes for the next shift. But, it cannot seem to handle an apostrophe within the text. For instance, if they wrote "Screen Bill's parts for a missing clamping … --- ## [Problem with Null pointers in a window](https://forum.inductiveautomation.com/t/problem-with-null-pointers-in-a-window/347)
**Author:** [@BowRiver](https://forum.inductiveautomation.com/u/BowRiver)\ **Replies:** 4\ **Last updated:** [August 24, 2007, 2:00pm UTC](https://forum.inductiveautomation.com/t/problem-with-null-pointers-in-a-window/347 "2007-08-24T14:00:50Z")
I'm experiencing a problem. I have a control dialog box much like your System Control example that is passed a number of parameters when it is opened. Whenever I save in the Designer or run this for the first time as a p… --- ## [Alarm printing](https://forum.inductiveautomation.com/t/alarm-printing/348)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 1\ **Last updated:** [August 24, 2007, 10:38am UTC](https://forum.inductiveautomation.com/t/alarm-printing/348 "2007-08-24T10:38:48Z")
Is there any way to set up a traditional alarm printer on a PMI node? I realise that alarms are logged in a table which enables you to have a nice interface to filter alarms by date etc. and produce one-off reports, but… --- ## [FSQL datalogging question](https://forum.inductiveautomation.com/t/fsql-datalogging-question/346)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [August 23, 2007, 8:09pm UTC](https://forum.inductiveautomation.com/t/fsql-datalogging-question/346 "2007-08-23T20:09:59Z")
I am wondering if it were possible in FSQL to keep a backup of the time stamp. I am hoping I am using the correct terms here. but in the event I am not here is what I would like to accomplish. When an event occurs at t… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=50) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=52)