# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=38 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 39 --- ## [PMI query assistance](https://forum.inductiveautomation.com/t/pmi-query-assistance/850)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [October 16, 2008, 9:37pm UTC](https://forum.inductiveautomation.com/t/pmi-query-assistance/850 "2008-10-16T21:37:47Z")
On a page I am designing I have three items. One is a numeric entry box, one is a calendar and the other is a report. The query I have in mind uses the t\_stamp column and the calendar component. Here is somewhat what I h… --- ## [Implementing SQL transactions](https://forum.inductiveautomation.com/t/implementing-sql-transactions/847)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [October 16, 2008, 3:48am UTC](https://forum.inductiveautomation.com/t/implementing-sql-transactions/847 "2008-10-16T03:48:37Z")
I have always used MySQL's MyISAM database engine in my projects so far, but I am looking at another project which will have to update several related tables simultaneously when the user presses a button. It seems obvi… --- ## [Global variable question](https://forum.inductiveautomation.com/t/global-variable-question/848)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [October 15, 2008, 4:37pm UTC](https://forum.inductiveautomation.com/t/global-variable-question/848 "2008-10-15T16:37:44Z")
Running version 3.2.3 of FPMI. Have a global timer defined with a time duration of 15 seconds. There is a value which is being calculated in this timer. What is the best and most efficient way to have a dynamic proper … --- ## [Initializing easy chart dates at startup](https://forum.inductiveautomation.com/t/initializing-easy-chart-dates-at-startup/776)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 8\ **Last updated:** [October 14, 2008, 8:23am UTC](https://forum.inductiveautomation.com/t/initializing-easy-chart-dates-at-startup/776 "2008-10-14T08:23:18Z")
I am using the easy chart and want to be able to set the start and end dates. I have tried several methods but keep getting errors. I obviously do not understand how dates are being used or whether it is a java date or … --- ## [Script Performance](https://forum.inductiveautomation.com/t/script-performance/844)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 2\ **Last updated:** [October 12, 2008, 11:01pm UTC](https://forum.inductiveautomation.com/t/script-performance/844 "2008-10-12T23:01:30Z")
I had a couple of mostly theoretical questions about the python scripting, but maybe it will help me write better code as well. Is there any performance hit at all for passing properties of various components to local… --- ## [Designer component paletes load error](https://forum.inductiveautomation.com/t/designer-component-paletes-load-error/843)
**Author:** [@ZahSerg](https://forum.inductiveautomation.com/u/ZahSerg)\ **Replies:** 1\ **Last updated:** [October 10, 2008, 11:26pm UTC](https://forum.inductiveautomation.com/t/designer-component-paletes-load-error/843 "2008-10-10T23:26:28Z")
Hello. When designer started it gives an error of component paletes loading. And shows only report palette. Uninstallation and reistallation gives no effect. Attempt to load paletes manually also impossible (no .fpal f… --- ## [FSQL Alert Screen](https://forum.inductiveautomation.com/t/fsql-alert-screen/841)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 2\ **Last updated:** [October 8, 2008, 5:04pm UTC](https://forum.inductiveautomation.com/t/fsql-alert-screen/841 "2008-10-08T17:04:27Z")
Maybe my screen is not happy. I have an OPC item, in the Alert Configuration. When I use ‘digital,’ the custom message box is visible. When I try ‘analog,’ I can no longer see the ‘Custom Message’ box and the Standard… --- ## [Industrial Automation Services Mumbai](https://forum.inductiveautomation.com/t/industrial-automation-services-mumbai/840)
**Author:** [@paryana1](https://forum.inductiveautomation.com/u/paryana1)\ **Replies:** 1\ **Last updated:** [October 8, 2008, 12:24pm UTC](https://forum.inductiveautomation.com/t/industrial-automation-services-mumbai/840 "2008-10-08T12:24:50Z")
InParyana Automation formely known as Labdhi Automation and Controls are committed to the art and science of automation. Our automation and integration solutions - whether through project implementation, best-in-class pr… --- ## [X Axis Margin on Easy Chart and other concerns](https://forum.inductiveautomation.com/t/x-axis-margin-on-easy-chart-and-other-concerns/839)
**Author:** [@ian.eccles](https://forum.inductiveautomation.com/u/ian.eccles)\ **Replies:** 4\ **Last updated:** [October 7, 2008, 8:36pm UTC](https://forum.inductiveautomation.com/t/x-axis-margin-on-easy-chart-and-other-concerns/839 "2008-10-07T20:36:39Z")
Hello, While we want to make use of all of the great features of the Easy Chart operating in Real Time mode, one thing we require is a margin on the upper-bound of the X-Axis, I know this property can be specified in t… --- ## [Easy Chart Zoom Data Change](https://forum.inductiveautomation.com/t/easy-chart-zoom-data-change/834)
**Author:** [@dmusser](https://forum.inductiveautomation.com/u/dmusser)\ **Replies:** 10\ **Last updated:** [October 7, 2008, 6:24pm UTC](https://forum.inductiveautomation.com/t/easy-chart-zoom-data-change/834 "2008-10-07T18:24:56Z")
Is it possible to change data in a data set by using the zoom command (Rectangular Selection) on an easy chart? --- ## [Newbie Question: Kind of urgent](https://forum.inductiveautomation.com/t/newbie-question-kind-of-urgent/838)
**Author:** [@jimwinchell](https://forum.inductiveautomation.com/u/jimwinchell)\ **Replies:** 7\ **Last updated:** [October 7, 2008, 5:25pm UTC](https://forum.inductiveautomation.com/t/newbie-question-kind-of-urgent/838 "2008-10-07T17:25:59Z")
We are currently evaluating FSQL and I need some design assistance for what I am trying to accomplish. We have a VB.net application that we are using in conjuction with FSQL and a PLC for production line control. We h… --- ## [Browse OPC Server](https://forum.inductiveautomation.com/t/browse-opc-server/837)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 3\ **Last updated:** [October 7, 2008, 4:15pm UTC](https://forum.inductiveautomation.com/t/browse-opc-server/837 "2008-10-07T16:15:46Z")
I want to add another OPC tag. I tried to browse from my development machine, from the server running FPMI and from the server running FSQL/Kepware. All returned the error. I wonder if this is a DCOM problem, but ever… --- ## [Scripting when/when not to email alerts, possible?](https://forum.inductiveautomation.com/t/scripting-when-when-not-to-email-alerts-possible/835)
**Author:** [@Dravik](https://forum.inductiveautomation.com/u/Dravik)\ **Replies:** 2\ **Last updated:** [October 7, 2008, 3:47pm UTC](https://forum.inductiveautomation.com/t/scripting-when-when-not-to-email-alerts-possible/835 "2008-10-07T15:47:24Z")
Several of the datapoints we log and display in our existing SCADA systems are tied to Enviromental Compliance events. I'd like to be able to turn on email alerting for only a subset of the configured alerts and possibly… --- ## [FactoryPMI Designer ease of use enhancements](https://forum.inductiveautomation.com/t/factorypmi-designer-ease-of-use-enhancements/760)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 6\ **Last updated:** [October 6, 2008, 7:42pm UTC](https://forum.inductiveautomation.com/t/factorypmi-designer-ease-of-use-enhancements/760 "2008-10-06T19:42:02Z")
There are a few user interface changes which I think would make a big improvement to the ease of use of the FactoryPMI Designer: When you click on an object in a window, if you do not click and release at exactly the … --- ## [WOW - The need for (query) speed](https://forum.inductiveautomation.com/t/wow-the-need-for-query-speed/831)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 1\ **Last updated:** [October 1, 2008, 8:25pm UTC](https://forum.inductiveautomation.com/t/wow-the-need-for-query-speed/831 "2008-10-01T20:25:19Z")
"t\_stamp" - I know this was covered in previous postings, BUT I just wanted I just wanted to share this significant success story, and how such a small thing has such a significant impact on performance: I basically "… --- ## [Group related questions](https://forum.inductiveautomation.com/t/group-related-questions/828)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [September 30, 2008, 3:29pm UTC](https://forum.inductiveautomation.com/t/group-related-questions/828 "2008-09-30T15:29:50Z")
In FSQL I have a block group. In this block groups I am writing plenty of information to various PLC on the production floor. I have been getting some error messages from the block group and want some clarification so I … --- ## [2D Drawing](https://forum.inductiveautomation.com/t/2d-drawing/826)
**Author:** [@MadMax](https://forum.inductiveautomation.com/u/MadMax)\ **Replies:** 1\ **Last updated:** [September 25, 2008, 4:02pm UTC](https://forum.inductiveautomation.com/t/2d-drawing/826 "2008-09-25T16:02:05Z")
I know you've scheduled a 2D drawing package for a future release. I just want to lobby for vector graphic support to avoid screen resolution hassles. BTW- Wonderware now supports it in ArchestrA. Thanks for your excelle… --- ## [Group error from action item](https://forum.inductiveautomation.com/t/group-error-from-action-item/825)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 1\ **Last updated:** [September 24, 2008, 11:37pm UTC](https://forum.inductiveautomation.com/t/group-error-from-action-item/825 "2008-09-24T23:37:39Z")
Here is the error: I have a group that has 26 opc items in it that writes based on a trigger. This works fine. I then added an action item with an expression that returns "Test". Result data type is string. Store resul… --- ## [Barcode scanner project requirements](https://forum.inductiveautomation.com/t/barcode-scanner-project-requirements/814)
**Author:** [@norml](https://forum.inductiveautomation.com/u/norml)\ **Replies:** 5\ **Last updated:** [September 23, 2008, 4:56pm UTC](https://forum.inductiveautomation.com/t/barcode-scanner-project-requirements/814 "2008-09-23T16:56:46Z")
I'm currently planning to implement our first barcode scanner project. In short, I need to have our final inspector scan 3 separate barcodes that were attached to the product during the manufacturing process. This will… --- ## [PDF Viewer closing Designer](https://forum.inductiveautomation.com/t/pdf-viewer-closing-designer/821)
**Author:** [@jenicabecklund](https://forum.inductiveautomation.com/u/jenicabecklund)\ **Replies:** 2\ **Last updated:** [September 22, 2008, 5:16pm UTC](https://forum.inductiveautomation.com/t/pdf-viewer-closing-designer/821 "2008-09-22T17:16:17Z")
I am trying to use the pdf viewer in a window, it seems to work fine for one page docs, but my three pager completely closes my designer down. Has anyone had this problem before?? --- ## [Translation map](https://forum.inductiveautomation.com/t/translation-map/820)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 1\ **Last updated:** [September 19, 2008, 8:17pm UTC](https://forum.inductiveautomation.com/t/translation-map/820 "2008-09-19T20:17:51Z")
Is there a way to use a variable within the translation map of a table? Right now, I am doing something like this for the translation: Part 1 But I would like to be able to assign the color dynamically: Part 1 I … --- ## [All/Standard Properties](https://forum.inductiveautomation.com/t/all-standard-properties/819)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 1\ **Last updated:** [September 18, 2008, 6:24pm UTC](https://forum.inductiveautomation.com/t/all-standard-properties/819 "2008-09-18T18:24:25Z")
Would it be possible to have a selection in the project properties (or somewhere else, it doesn't matter) to have "All" of the properties show up right away instead of just the "Standard" properties? Or maybe there's alr… --- ## [New idea need help getting started if available](https://forum.inductiveautomation.com/t/new-idea-need-help-getting-started-if-available/817)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [September 18, 2008, 6:23pm UTC](https://forum.inductiveautomation.com/t/new-idea-need-help-getting-started-if-available/817 "2008-09-18T18:23:23Z")
An idea was presented in a recent meeting and I am not sure where to begin with it so i thought I would post it here and see what kind of responce I obtain. Out on the production floor we have the production monitoring … --- ## [Oops, I typed myself into a hole](https://forum.inductiveautomation.com/t/oops-i-typed-myself-into-a-hole/818)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 1\ **Last updated:** [September 18, 2008, 4:34pm UTC](https://forum.inductiveautomation.com/t/oops-i-typed-myself-into-a-hole/818 "2008-09-18T16:34:32Z")
Something that can be fixed on my end by being more careful, but in the mean time... When a group is running, obviously the 'OK' button is not selectable. However, it is still possible to edit text, say, the code in an… --- ## [T\_stamp Differences between group type](https://forum.inductiveautomation.com/t/t-stamp-differences-between-group-type/815)
**Author:** [@TimE](https://forum.inductiveautomation.com/u/TimE)\ **Replies:** 5\ **Last updated:** [September 16, 2008, 7:48pm UTC](https://forum.inductiveautomation.com/t/t-stamp-differences-between-group-type/815 "2008-09-16T19:48:08Z")
This is a very strange problem and since you guys are great at solving them, here goes ... I am logging to MSSQL on a different server. I have several groups. So far I have only been querying data from "Historical Grou… --- ## [Dynamic location of an object](https://forum.inductiveautomation.com/t/dynamic-location-of-an-object/816)
**Author:** [@donadams](https://forum.inductiveautomation.com/u/donadams)\ **Replies:** 1\ **Last updated:** [September 16, 2008, 7:27pm UTC](https://forum.inductiveautomation.com/t/dynamic-location-of-an-object/816 "2008-09-16T19:27:01Z")
How do I move a line object via a tag value? --- ## [Easy Chart - I think?](https://forum.inductiveautomation.com/t/easy-chart-i-think/806)
**Author:** [@hirzel](https://forum.inductiveautomation.com/u/hirzel)\ **Replies:** 5\ **Last updated:** [September 16, 2008, 6:11pm UTC](https://forum.inductiveautomation.com/t/easy-chart-i-think/806 "2008-09-16T18:11:30Z")
I want to chart my daily temperatures (0700 - 2300). I can get the chart to start 0700 each day, BUT, I don't like the way it presents itself. I want the chart to show 0700 - 2300, regardless of the current time. I… --- ## [E\_FAIL and Watchdog](https://forum.inductiveautomation.com/t/e-fail-and-watchdog/813)
**Author:** [@f\_adamg](https://forum.inductiveautomation.com/u/f_adamg)\ **Replies:** 1\ **Last updated:** [September 15, 2008, 8:44pm UTC](https://forum.inductiveautomation.com/t/e-fail-and-watchdog/813 "2008-09-15T20:44:14Z")
We are having some issues with communications between two buildings (about 1.5 miles apart). We would like to email when communications are bad (not the problem). To do this, there is a bit in Kepware called Error which … --- ## [Data Source connection fails](https://forum.inductiveautomation.com/t/data-source-connection-fails/812)
**Author:** [@jenicabecklund](https://forum.inductiveautomation.com/u/jenicabecklund)\ **Replies:** 1\ **Last updated:** [September 14, 2008, 2:05pm UTC](https://forum.inductiveautomation.com/t/data-source-connection-fails/812 "2008-09-14T14:05:24Z")
My IADemo and another that I created will not connect. I do have one working data source. I am getting an error about my usernames, but I only have two root and jbecklund and neither will work. Everything seems to be the… --- ## [Difference in dataset datetime fields between locations](https://forum.inductiveautomation.com/t/difference-in-dataset-datetime-fields-between-locations/810)
**Author:** [@Ron](https://forum.inductiveautomation.com/u/Ron)\ **Replies:** 4\ **Last updated:** [September 12, 2008, 11:20pm UTC](https://forum.inductiveautomation.com/t/difference-in-dataset-datetime-fields-between-locations/810 "2008-09-12T23:20:49Z")
I have an FPMI application that runs a query and then loads screen components with that data. What I am getting is a descrepency in the date fields returned to the dataset. When I look at the dataset on my PC I get thi… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=37) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=39)