# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=47 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 48 --- ## [Data Overwrite Issue with FSQL running on KEPWare OPC Server](https://forum.inductiveautomation.com/t/data-overwrite-issue-with-fsql-running-on-kepware-opc-server/527)
**Author:** [@dmcglynn](https://forum.inductiveautomation.com/u/dmcglynn)\ **Replies:** 5\ **Last updated:** [February 5, 2008, 10:26pm UTC](https://forum.inductiveautomation.com/t/data-overwrite-issue-with-fsql-running-on-kepware-opc-server/527 "2008-02-05T22:26:44Z")
I encountered a rather scary problem yesterday with a FactorySQL configuration that I'm moving from RSLinx OPC Server to KEPWare OPC Server. When my project was running on RSLinx, someone had set up a bi-directional gr… --- ## [What is the return type of getTagValue for DateTime tags?](https://forum.inductiveautomation.com/t/what-is-the-return-type-of-gettagvalue-for-datetime-tags/528)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 4\ **Last updated:** [February 5, 2008, 4:20pm UTC](https://forum.inductiveautomation.com/t/what-is-the-return-type-of-gettagvalue-for-datetime-tags/528 "2008-02-05T16:20:34Z")
This is a Global Event Script b = java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").parse(fpmi.tag.getTagValue("\[\]ExpectedTransferTime")).getTime() Says the return value of fpmi.tag.getTagValue can't be coerced to a… --- ## [Windows Networking](https://forum.inductiveautomation.com/t/windows-networking/523)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 6\ **Last updated:** [February 4, 2008, 11:07pm UTC](https://forum.inductiveautomation.com/t/windows-networking/523 "2008-02-04T23:07:49Z")
After doing some research I found that the PLC units we have do not support Windows File Sharing. So that leads to a series of quesions: What would you recommend to take 2 small files and globally send them to each an… --- ## [How to make many SQL tags](https://forum.inductiveautomation.com/t/how-to-make-many-sql-tags/520)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [January 31, 2008, 11:25pm UTC](https://forum.inductiveautomation.com/t/how-to-make-many-sql-tags/520 "2008-01-31T23:25:17Z")
This message is mainly aimed at Colby. A short while back while doing a meeting you showed how to do a cut and paste kind of thing using Jython script. I do not recall exactly how you done it but thought this would make … --- ## [Timer reset?](https://forum.inductiveautomation.com/t/timer-reset/522)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 1\ **Last updated:** [January 31, 2008, 9:24pm UTC](https://forum.inductiveautomation.com/t/timer-reset/522 "2008-01-31T21:24:54Z")
I have a timer on a window. The timer only counts up when the Door\_Open tag is true. I would also like the timer to reset when the Door\_Open tag is false but I can't figure that part out. Is there any way to do this? I… --- ## [Multiple menus within a project](https://forum.inductiveautomation.com/t/multiple-menus-within-a-project/518)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 9\ **Last updated:** [January 31, 2008, 8:36pm UTC](https://forum.inductiveautomation.com/t/multiple-menus-within-a-project/518 "2008-01-31T20:36:20Z")
It appears that each project has one and only one menu structure. Is there a way to alter that menu structure depending on some parameter (i.e. which window is active, which user is active, etc.)? Also, related but s… --- ## [Designer - styles customizer image path browser](https://forum.inductiveautomation.com/t/designer-styles-customizer-image-path-browser/519)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 1\ **Last updated:** [January 31, 2008, 4:31pm UTC](https://forum.inductiveautomation.com/t/designer-styles-customizer-image-path-browser/519 "2008-01-31T16:31:35Z")
Using images in the style customizer would be much easier if there was a small "browse" (folder) icon that allowed you to browse image paths instead of having to type a string. --- ## [Easychart Axis Change](https://forum.inductiveautomation.com/t/easychart-axis-change/507)
**Author:** [@jvandeve](https://forum.inductiveautomation.com/u/jvandeve)\ **Replies:** 9\ **Last updated:** [January 29, 2008, 10:15pm UTC](https://forum.inductiveautomation.com/t/easychart-axis-change/507 "2008-01-29T22:15:51Z")
I am trying to programatically change the axis used for the easychart in a window. Depending on the product chosen the y-axis needs to have different minimum and maximum values, all the rest stays the same. Can that be… --- ## [PMI adding SQL tags](https://forum.inductiveautomation.com/t/pmi-adding-sql-tags/517)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [January 29, 2008, 12:06am UTC](https://forum.inductiveautomation.com/t/pmi-adding-sql-tags/517 "2008-01-29T00:06:14Z")
I was wondering if anyone else had a problem with PMI tags? What seems to be happening is that I will get tags that I did not put in. I used the numbers 1 - 99 and sometimes it will mysteriously add higher numbers usuall… --- ## [Configuring FactorySQL on a new machine](https://forum.inductiveautomation.com/t/configuring-factorysql-on-a-new-machine/516)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [January 28, 2008, 8:12pm UTC](https://forum.inductiveautomation.com/t/configuring-factorysql-on-a-new-machine/516 "2008-01-28T20:12:21Z")
I have just installed FactorySQL on a customer's machine and came across a potential problem. It would appear that the FactorySQL Settings (Data Connection, Redundancy, SQLTags etc.) are held separately from the saved P… --- ## [Connection/statistics](https://forum.inductiveautomation.com/t/connection-statistics/509)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 18\ **Last updated:** [January 26, 2008, 6:25pm UTC](https://forum.inductiveautomation.com/t/connection-statistics/509 "2008-01-26T18:25:15Z")
First off I dont recall the exact menu option. I know it is under the connections tab and it has to do with statistics. It is a window pane that show avg. exection time and thing such as this. What I am wondering is: H… --- ## [SQLTags Data Connection](https://forum.inductiveautomation.com/t/sqltags-data-connection/514)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 2\ **Last updated:** [January 25, 2008, 10:16pm UTC](https://forum.inductiveautomation.com/t/sqltags-data-connection/514 "2008-01-25T22:16:04Z")
I'm a little confused re conffiguration of SQLTags Settings in FSQL. I imagine that if I have separate databases for separate projects, then I might want to keep each project's SQLTags in its own database. However, … --- ## [What does this mean?](https://forum.inductiveautomation.com/t/what-does-this-mean/512)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [January 24, 2008, 11:11pm UTC](https://forum.inductiveautomation.com/t/what-does-this-mean/512 "2008-01-24T23:11:32Z")
I recently upgraded from 3.1.2 to 3.1.3. After I done this I check out my project and for some reason I get the following error message when I go to print. Can you tell me what the error message means and how to fix? T… --- ## [MySQL Could not find File when opening Administrator Fix](https://forum.inductiveautomation.com/t/mysql-could-not-find-file-when-opening-administrator-fix/511)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 2\ **Last updated:** [January 24, 2008, 9:04pm UTC](https://forum.inductiveautomation.com/t/mysql-could-not-find-file-when-opening-administrator-fix/511 "2008-01-24T21:04:06Z")
I had a problem where if i opened MySQL Administrator, it would give me an error "Could not find file", and I couldnt get access to all the settings. Well the fix is as follows" When i was getting the error, my MySQL … --- ## [Using string in Where clause errors](https://forum.inductiveautomation.com/t/using-string-in-where-clause-errors/510)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 4\ **Last updated:** [January 24, 2008, 7:41pm UTC](https://forum.inductiveautomation.com/t/using-string-in-where-clause-errors/510 "2008-01-24T19:41:56Z")
I am trying to use a string from the PLC in a where clause to update a table, but receive this error: 'Conversion from string "GLOBAL" to type 'Integer' is not valid.' I have the column named STATION and is the text/… --- ## [FactoryPMI Gateway Problems](https://forum.inductiveautomation.com/t/factorypmi-gateway-problems/503)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 19\ **Last updated:** [January 24, 2008, 5:57pm UTC](https://forum.inductiveautomation.com/t/factorypmi-gateway-problems/503 "2008-01-24T17:57:14Z")
I'm having a problem on my dev machine. I just upgraded with the offline upgrade exe, and now FactoryPMI will not start at all. If I look at the FactoryPMI Gateway Control window, I see this info: Status: Faulted Clust… --- ## [Problem logging small floating point values](https://forum.inductiveautomation.com/t/problem-logging-small-floating-point-values/508)
**Author:** [@kurt](https://forum.inductiveautomation.com/u/kurt)\ **Replies:** 1\ **Last updated:** [January 23, 2008, 7:54pm UTC](https://forum.inductiveautomation.com/t/problem-logging-small-floating-point-values/508 "2008-01-23T19:54:58Z")
I am attempting to use FactorySQL to log some Float (4) values to a MySQL database. They show up correctly in the FactorySQL front-end but not in the MySQL database. As the number decreases the value in MySQL looses prec… --- ## [Translation table using SQLTags](https://forum.inductiveautomation.com/t/translation-table-using-sqltags/505)
**Author:** [@AlThePal](https://forum.inductiveautomation.com/u/AlThePal)\ **Replies:** 3\ **Last updated:** [January 23, 2008, 4:48pm UTC](https://forum.inductiveautomation.com/t/translation-table-using-sqltags/505 "2008-01-23T16:48:53Z")
I have an input that can be one of a range of integer values. I need to translate this value into a corrected value as shown in the following table: Raw Corrected 1 1 2 2 3 3 4 … --- ## [Bar Chart](https://forum.inductiveautomation.com/t/bar-chart/506)
**Author:** [@matth](https://forum.inductiveautomation.com/u/matth)\ **Replies:** 1\ **Last updated:** [January 23, 2008, 4:00pm UTC](https://forum.inductiveautomation.com/t/bar-chart/506 "2008-01-23T16:00:10Z")
Hello, I am trying to create a bar chart in the report viewer. The data is in dollars, so it's floating point and it needs to have a $ on the front. Is there any way to modify the vertical axis to show this? I notic… --- ## [Multiple network adapters and FactoryPMI 2.0](https://forum.inductiveautomation.com/t/multiple-network-adapters-and-factorypmi-2-0/242)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 2\ **Last updated:** [January 23, 2008, 3:37pm UTC](https://forum.inductiveautomation.com/t/multiple-network-adapters-and-factorypmi-2-0/242 "2008-01-23T15:37:59Z")
If you have multiple network adapters with static IP addresses (or multiple IP addresses bound to a single adapter, not counting loopback), I would recommend that you manually specify which one FactoryPMI uses. This is a… --- ## [SQL tags in a loop](https://forum.inductiveautomation.com/t/sql-tags-in-a-loop/501)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 11\ **Last updated:** [January 22, 2008, 7:45pm UTC](https://forum.inductiveautomation.com/t/sql-tags-in-a-loop/501 "2008-01-22T19:45:32Z")
I was wondering what would be the best approach to do the following. When I click on a button I want a certain page to load. On this page will be shown 99 checkmark boxes along with a numeric label and a button at the … --- ## [Alerting not working](https://forum.inductiveautomation.com/t/alerting-not-working/467)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 4\ **Last updated:** [January 21, 2008, 3:38pm UTC](https://forum.inductiveautomation.com/t/alerting-not-working/467 "2008-01-21T15:38:16Z")
i cant seem to figure this out, but my alerting used to work, but stopped on December 19th. I think i did an update on this day, but is there any issues known with the alerting --- ## [Unable to convert between java.util.Date and TIMESTAMP](https://forum.inductiveautomation.com/t/unable-to-convert-between-java-util-date-and-timestamp/500)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 4\ **Last updated:** [January 18, 2008, 11:57pm UTC](https://forum.inductiveautomation.com/t/unable-to-convert-between-java-util-date-and-timestamp/500 "2008-01-18T23:57:18Z")
When creating a DB SQLTag with a datetime datatype, I get an exception: Timestamp is not the correct datatype to use in SQL Server anyway. So I don't know why it says this. The correct datatype should be datetime fo… --- ## [Learning FactorySQL](https://forum.inductiveautomation.com/t/learning-factorysql/493)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 6\ **Last updated:** [January 18, 2008, 6:09pm UTC](https://forum.inductiveautomation.com/t/learning-factorysql/493 "2008-01-18T18:09:34Z")
I'm trying to get FactorySQL to work so I can learn how to make it do something. I made a couple of DB SQLTags in Designer, and a Group in the FactorySQL frontend, and trying to make an Action Item or two to write someth… --- ## [Global tags in FSQL?](https://forum.inductiveautomation.com/t/global-tags-in-fsql/498)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 17, 2008, 11:14am UTC](https://forum.inductiveautomation.com/t/global-tags-in-fsql/498 "2008-01-17T11:14:26Z")
I will attempt to describe what I would like then you can tell me if there is such an item in FSQL. I want to have a folder called timeset. In that folder there will be a group that gets the current time and date infor… --- ## [FSQL Remote running](https://forum.inductiveautomation.com/t/fsql-remote-running/497)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [January 16, 2008, 6:57pm UTC](https://forum.inductiveautomation.com/t/fsql-remote-running/497 "2008-01-16T18:57:36Z")
I was wondering, if you have a server running FSQL, besides the fact of doing a remote desktop to the server, are there other ways to run the application, alter the application, or view the data from the application from… --- ## [Number formatting - trailing zeros](https://forum.inductiveautomation.com/t/number-formatting-trailing-zeros/496)
**Author:** [@deryk](https://forum.inductiveautomation.com/u/deryk)\ **Replies:** 1\ **Last updated:** [January 15, 2008, 6:56pm UTC](https://forum.inductiveautomation.com/t/number-formatting-trailing-zeros/496 "2008-01-15T18:56:44Z")
Is there a way to for trailing zeros to be displayed in a label? I'm using the round function to produce a value with 3 decimal places. I'd like , for example, 26.3 to display as 26.300. TIA --- ## [dBaseIII anyone?](https://forum.inductiveautomation.com/t/dbaseiii-anyone/495)
**Author:** [@porksmash](https://forum.inductiveautomation.com/u/porksmash)\ **Replies:** 2\ **Last updated:** [January 14, 2008, 11:04pm UTC](https://forum.inductiveautomation.com/t/dbaseiii-anyone/495 "2008-01-14T23:04:15Z")
I'm wondering if it is possible to use FactorySQL with dBase III files. We are looking at using FSQL for another piece of the same project, but then we need to deal with some dBase things from the customer as well. I can… --- ## [SQL log issues](https://forum.inductiveautomation.com/t/sql-log-issues/492)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 0\ **Last updated:** [January 14, 2008, 7:04pm UTC](https://forum.inductiveautomation.com/t/sql-log-issues/492 "2008-01-14T19:04:21Z")
I was wondering our IT staff found an error 902 on SQL, which mean there is a difference between the log and the actual data. This was probably due to the deletion of the said log file. By the way this is Microsoft SQL t… --- ## [FactoryPMI doesn't see SQLTags tables in MSSQL](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 3\ **Last updated:** [January 14, 2008, 3:26pm UTC](https://forum.inductiveautomation.com/t/factorypmi-doesnt-see-sqltags-tables-in-mssql/491 "2008-01-14T15:26:07Z")
I'm trying to use Microsoft SQL Server and didn't install MySQL. I created a data connection called MSSQL in FactorySQL. When I go into FactoryPMI Gateway Status in the SQLTags tab, it says SQLTags tables not created. Ru… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=46) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=48)