It is currently Mon Sep 01, 2014 5:43 am




Post new topic Reply to topic  [ 2 posts ] 
 Insert new column into the table 
Author Message
Trooper
Trooper

Joined: Wed Oct 12, 2011 11:58 am
Posts: 18
Post Insert new column into the table
Insert new column into the table
In the transaction group, the Run-Always Expression Items & Triggered Expression Items have up/down arrow to move item to where I want, but the basic OPC Group items do not have up/down arrow. When I added a new Item ( new column) it ended up being the last column in the table.
TIA.


Wed Aug 22, 2012 6:26 am
Profile
Moderator
Moderator

Joined: Sun Apr 02, 2006 3:43 pm
Posts: 2495
Post Re: Insert new column into the table
The up/down arrows are used to specify execution order, when can be important when the items do things like run sql queries. When defining new columns on an existing table, it would take a lot of work to make ordering possible in a way that works with all databases. Also, I'm not aware of any real benefit for this, as it doesn't affect db performance, and you can simply order the columns as you want in the SELECT statement.

Regards,

_________________
Colby Clegg
Inductive Automation
Software Development


Thu Aug 23, 2012 9:40 am
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: