# Archived Topics **URL:** https://forum.inductiveautomation.com/c/archived-topics/9.md?page=48 [Latest](https://forum.inductiveautomation.com/latest.md) · [Categories](https://forum.inductiveautomation.com/categories.md) · [Tags](https://forum.inductiveautomation.com/tags.md) **Page:** 49 --- ## [Locations and names of files](https://forum.inductiveautomation.com/t/locations-and-names-of-files/489)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [January 14, 2008, 1:07pm UTC](https://forum.inductiveautomation.com/t/locations-and-names-of-files/489 "2008-01-14T13:07:15Z")
I was wondering. We recently had our SQL server crumble. Or at least the databases we were working with on your software. What happened was that the log file became so large and took up the drive where SQL was on that S… --- ## [Default table horizontal spacing for columns](https://forum.inductiveautomation.com/t/default-table-horizontal-spacing-for-columns/488)
**Author:** [@carlm](https://forum.inductiveautomation.com/u/carlm)\ **Replies:** 1\ **Last updated:** [January 11, 2008, 8:49pm UTC](https://forum.inductiveautomation.com/t/default-table-horizontal-spacing-for-columns/488 "2008-01-11T20:49:42Z")
Is there a way to set the horizontal spacing of table columns to some DEFAULT value other than "Auto" ?? That is, to have the spacing set to say, "center" by default so i don't have to go into the table customerizer a… --- ## [Screenshots](https://forum.inductiveautomation.com/t/screenshots/487)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 7\ **Last updated:** [January 11, 2008, 8:38pm UTC](https://forum.inductiveautomation.com/t/screenshots/487 "2008-01-11T20:38:12Z")
It would be nice to have an integrated function that let an operator take a screenshot when he sees a problem. This is far better than having them try to put the problem into words. I have seen this feature on several ot… --- ## [Easy Chart binding to globalWhereClause](https://forum.inductiveautomation.com/t/easy-chart-binding-to-globalwhereclause/486)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 10, 2008, 4:13pm UTC](https://forum.inductiveautomation.com/t/easy-chart-binding-to-globalwhereclause/486 "2008-01-10T16:13:55Z")
In the easy chart there is a Where condition. It is a string reported to have the name globalWhereClause. When I type my condition into this box, such as machine=55, it works quite well. But I am trying to get a more dyn… --- ## [T\_STAMP Question](https://forum.inductiveautomation.com/t/t-stamp-question/485)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 10, 2008, 4:11pm UTC](https://forum.inductiveautomation.com/t/t-stamp-question/485 "2008-01-10T16:11:42Z")
I was wondering, the manual does not clearly state this out. The T\_STAMP which is written to the database when FSQL writes a value to a table. Which server does this data come from? Does it come from the Server running… --- ## [Open html in browser window, replacing FPMI](https://forum.inductiveautomation.com/t/open-html-in-browser-window-replacing-fpmi/482)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 2\ **Last updated:** [January 9, 2008, 12:46am UTC](https://forum.inductiveautomation.com/t/open-html-in-browser-window-replacing-fpmi/482 "2008-01-09T00:46:18Z")
Related to, but not the same as, topic "Open a web page within FPMI application". I want to open an html page in the same browser window/tab as FPMI is in, replacing the FPMI page with my html page. openURL opens th… --- ## [myISAM tables automatic recovery](https://forum.inductiveautomation.com/t/myisam-tables-automatic-recovery/480)
**Author:** [@bds](https://forum.inductiveautomation.com/u/bds)\ **Replies:** 4\ **Last updated:** [January 8, 2008, 11:45am UTC](https://forum.inductiveautomation.com/t/myisam-tables-automatic-recovery/480 "2008-01-08T11:45:11Z")
Speaking today with Carl, he mentioned that myISAM tables are very fast, but can be corrupted if power is lost. He also said that there is an modification to my.ini to enable automatic recovery on restart. Can someone … --- ## [FSQL ASYNC Update question](https://forum.inductiveautomation.com/t/fsql-async-update-question/478)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 7, 2008, 8:10pm UTC](https://forum.inductiveautomation.com/t/fsql-async-update-question/478 "2008-01-07T20:10:31Z")
I was wondering, I think I fixed the problem using this checkmark setting but I wanted to run it up you ideas and see if indeed this is the best approach. Before I checked this setting for one of my groups. I had the s… --- ## [Printing and Global changing](https://forum.inductiveautomation.com/t/printing-and-global-changing/477)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [January 7, 2008, 12:40pm UTC](https://forum.inductiveautomation.com/t/printing-and-global-changing/477 "2008-01-07T12:40:01Z")
I was wondering if these would be prudent request for your FSQL product. A way to print the information in your project. In my case, and I am not saying I done it correctly. But I have 99 folders and in each folder I … --- ## [SQL tags](https://forum.inductiveautomation.com/t/sql-tags/479)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [January 6, 2008, 5:32am UTC](https://forum.inductiveautomation.com/t/sql-tags/479 "2008-01-06T05:32:03Z")
I am just begining to look at SQL tags for some of my design. In one case there will be about 99 SQLTags now granted each one will have a similar name but the address will be different. Ex: Kepware.KepServerEX.Chan\_1.n… --- ## [Images/Buttons](https://forum.inductiveautomation.com/t/images-buttons/475)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 7\ **Last updated:** [January 5, 2008, 10:39am UTC](https://forum.inductiveautomation.com/t/images-buttons/475 "2008-01-05T10:39:56Z")
Can you suggest a way to give images a sort of "3d effect" when they are used as buttons? It wouldn't have to be too fancy- just some indicator to the operator that he actually clicked the image. I've played around wit… --- ## [Changing the default web page](https://forum.inductiveautomation.com/t/changing-the-default-web-page/284)
**Author:** [@clark](https://forum.inductiveautomation.com/u/clark)\ **Replies:** 8\ **Last updated:** [January 4, 2008, 9:29am UTC](https://forum.inductiveautomation.com/t/changing-the-default-web-page/284 "2008-01-04T09:29:12Z")
Can I change the default FactoryPMI Launch web page? I want to make it start one of my projects. Is this possible? --- ## [SQL command assist req](https://forum.inductiveautomation.com/t/sql-command-assist-req/470)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 9\ **Last updated:** [January 3, 2008, 7:14am UTC](https://forum.inductiveautomation.com/t/sql-command-assist-req/470 "2008-01-03T07:14:26Z")
I have two table in SQL2005. We will call them table-1 and table-2. Even though they have a different number of columns they do have 5 columns with the same names. What I would like to do is copy these 5 columns from tab… --- ## [Printing](https://forum.inductiveautomation.com/t/printing/147)
**Author:** [@dmusser](https://forum.inductiveautomation.com/u/dmusser)\ **Replies:** 4\ **Last updated:** [January 2, 2008, 6:25pm UTC](https://forum.inductiveautomation.com/t/printing/147 "2008-01-02T18:25:11Z")
How can I print, or get a print preview? --- ## [Graphics Programs](https://forum.inductiveautomation.com/t/graphics-programs/474)
**Author:** [@Step7](https://forum.inductiveautomation.com/u/Step7)\ **Replies:** 3\ **Last updated:** [January 2, 2008, 4:42pm UTC](https://forum.inductiveautomation.com/t/graphics-programs/474 "2008-01-02T16:42:17Z")
What are other people using to create the graphics objects for your GUIs? I have used Serif DrawPlus for most of my objects (similar to InkScape), but some of my objects are pretty tedious to draw this way, plus they a… --- ## [View Vs Table](https://forum.inductiveautomation.com/t/view-vs-table/472)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 2, 2008, 1:46pm UTC](https://forum.inductiveautomation.com/t/view-vs-table/472 "2008-01-02T13:46:14Z")
I was wondering if someone could clarify something for me. What is the difference between a view and an actual table? Does your software work with views? Do you need any special or additional commands when using vie… --- ## [Hisotrical data storage](https://forum.inductiveautomation.com/t/hisotrical-data-storage/473)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 1\ **Last updated:** [January 2, 2008, 11:16am UTC](https://forum.inductiveautomation.com/t/hisotrical-data-storage/473 "2008-01-02T11:16:16Z")
I know the following will probably need some amount of scripting I am just curious of ease and implimentation. In FSQL I recently made a group for what I will refer to as hourly counts. Every hour on the hour it sends… --- ## [Locking pen chart](https://forum.inductiveautomation.com/t/locking-pen-chart/471)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 4\ **Last updated:** [December 31, 2007, 4:49pm UTC](https://forum.inductiveautomation.com/t/locking-pen-chart/471 "2007-12-31T16:49:13Z")
I am unsure But is there a way to lock the y values of a pen chart? I thought I had them locked but when we started running the project some tags came back with faulty information and it caused havoc with the pen chart. --- ## [Need help activating FPMI report Designer](https://forum.inductiveautomation.com/t/need-help-activating-fpmi-report-designer/466)
**Author:** [@Kyle\_Chase](https://forum.inductiveautomation.com/u/Kyle_Chase)\ **Replies:** 1\ **Last updated:** [December 30, 2007, 5:11am UTC](https://forum.inductiveautomation.com/t/need-help-activating-fpmi-report-designer/466 "2007-12-30T05:11:33Z")
I uninstalled 1.1.5, because the online installer wouldnt update to 1.1.6, then i installed 1.1.6, and i cant activate. Can someone give me a call ASAP to activate this please? --- ## [Refreshing a table from a popup window](https://forum.inductiveautomation.com/t/refreshing-a-table-from-a-popup-window/465)
**Author:** [@nathan](https://forum.inductiveautomation.com/u/nathan)\ **Replies:** 0\ **Last updated:** [December 28, 2007, 6:55pm UTC](https://forum.inductiveautomation.com/t/refreshing-a-table-from-a-popup-window/465 "2007-12-28T18:55:27Z")
I recently helped a customer set up a table's popup window editor to refresh the table on a change. At the end of your editing code, add the following: #Update table's dataSet in other window try: window = fpmi.gui.g… --- ## [Rectangles](https://forum.inductiveautomation.com/t/rectangles/454)
**Author:** [@Pat](https://forum.inductiveautomation.com/u/Pat)\ **Replies:** 2\ **Last updated:** [December 27, 2007, 8:37pm UTC](https://forum.inductiveautomation.com/t/rectangles/454 "2007-12-27T20:37:39Z")
It would be nice if we could round the edges of rectangles. Also to be able to set how much of the edge gets rounded. --- ## [PMI data connections](https://forum.inductiveautomation.com/t/pmi-data-connections/464)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 2\ **Last updated:** [December 27, 2007, 4:16pm UTC](https://forum.inductiveautomation.com/t/pmi-data-connections/464 "2007-12-27T16:16:02Z")
I was wondering, I thought I had all the settings correct in PMI but I must be missing one thing. What recently happened, and I am glad it has during our testing and debugging stages, is the IT dept had taken the SQL ser… --- ## [Multi-state "key-pad"](https://forum.inductiveautomation.com/t/multi-state-key-pad/463)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 5\ **Last updated:** [December 26, 2007, 11:50pm UTC](https://forum.inductiveautomation.com/t/multi-state-key-pad/463 "2007-12-26T23:50:00Z")
Hey all. I’m loving the new HOA “multi-state” button. I would love it if this was able to combine buttons into a keypad. I have several applications that could use this. Right now, I’m just creating multiple rows to … --- ## [Backup Restore options tab](https://forum.inductiveautomation.com/t/backup-restore-options-tab/462)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 3\ **Last updated:** [December 26, 2007, 4:05pm UTC](https://forum.inductiveautomation.com/t/backup-restore-options-tab/462 "2007-12-26T16:05:56Z")
First I wanted to ask about the Backup/Restore option in FSQL. I have tried this twice and both times on seperate machines, running the same version, which I think is 4.1.2 it does the same thing. If you click on the bac… --- ## [Indirect SQLTags](https://forum.inductiveautomation.com/t/indirect-sqltags/461)
**Author:** [@heyjeff](https://forum.inductiveautomation.com/u/heyjeff)\ **Replies:** 1\ **Last updated:** [December 22, 2007, 12:46am UTC](https://forum.inductiveautomation.com/t/indirect-sqltags/461 "2007-12-22T00:46:09Z")
When clicking on the "indirect Tag" radio button in the property binding window, It would be nice if the current Tag info would carry over to the "Indirect Tag Path" box. That way, I can drag the SQLTag to a container (… --- ## [Numeric field update failure](https://forum.inductiveautomation.com/t/numeric-field-update-failure/457)
**Author:** [@mdowdell](https://forum.inductiveautomation.com/u/mdowdell)\ **Replies:** 9\ **Last updated:** [December 21, 2007, 6:22pm UTC](https://forum.inductiveautomation.com/t/numeric-field-update-failure/457 "2007-12-21T18:22:33Z")
I am using a pop-up window for data entry. When I edit a value in a numeric field and then change to another field the new value reverts to its old value. What do I need to do? I am using MSSQLServer and the permissio… --- ## [PMI remote access settings](https://forum.inductiveautomation.com/t/pmi-remote-access-settings/459)
**Author:** [@mrtweaver](https://forum.inductiveautomation.com/u/mrtweaver)\ **Replies:** 5\ **Last updated:** [December 21, 2007, 5:46pm UTC](https://forum.inductiveautomation.com/t/pmi-remote-access-settings/459 "2007-12-21T17:46:15Z")
I know this was covered in here before but I can not seem to locate that topic section. So my basic question is, I know that you have to enable it somewhere in the local running session of PMI but how do you make it so y… --- ## [Locked out my navigation buttons](https://forum.inductiveautomation.com/t/locked-out-my-navigation-buttons/458)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 3\ **Last updated:** [December 21, 2007, 5:23pm UTC](https://forum.inductiveautomation.com/t/locked-out-my-navigation-buttons/458 "2007-12-21T17:23:04Z")
When I was working in the designer I went to my navigation screen and all the buttons were whited out. I accidently saved and know I am unable to link to the screens. I can not remember the sequence to fix this. --- ## [Authentication broken in 3.1.2](https://forum.inductiveautomation.com/t/authentication-broken-in-3-1-2/456)
**Author:** [@timf](https://forum.inductiveautomation.com/u/timf)\ **Replies:** 7\ **Last updated:** [December 20, 2007, 11:22pm UTC](https://forum.inductiveautomation.com/t/authentication-broken-in-3-1-2/456 "2007-12-20T23:22:06Z")
We have a server with 3.1.1 that works and a server with 3.1.2 that doesn't work. When we use IE across the network to try to open Configuration and any Settings option, it asks for authentication again but doesn't open … --- ## [Have 2 dates in the same table for MySQL](https://forum.inductiveautomation.com/t/have-2-dates-in-the-same-table-for-mysql/455)
**Author:** [@DB2](https://forum.inductiveautomation.com/u/DB2)\ **Replies:** 1\ **Last updated:** [December 20, 2007, 5:29pm UTC](https://forum.inductiveautomation.com/t/have-2-dates-in-the-same-table-for-mysql/455 "2007-12-20T17:29:13Z")
I have a table that stores 2 seperate dates in there own columns, one is called date opened and the other is called date closed in the MySQL table. I use PMI to insert records into the table, when I insert the record I… [Previous page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=47) [Next page](https://forum.inductiveautomation.com/c/archived-topics/9.md?page=49)