It is currently Wed Sep 17, 2014 7:33 am




Post new topic Reply to topic  [ 2 posts ] 
 Table Customizer Not Showing 
Author Message
Sergeant
Sergeant

Joined: Tue Jul 12, 2011 4:36 am
Posts: 59
Location: St. Louis, Missouri USA
Post Table Customizer Not Showing
When I added this SQL statement to the binding of my table, the customizer wont show when I click on it.
Code:
SELECT
   *
FROM
   work_order
JOIN
   proj_state ON work_order.state = proj_state.id


But if I remove the JOIN, the table customizer will show.
I have Ignition 7.5 and Java 7 Update 5

_________________
Jesse Reynolds
Senior Controls Engineer
Jordan Industrial Controls


Thu Jul 12, 2012 9:21 am
Profile
Moderator
Moderator

Joined: Mon Jun 04, 2012 8:53 am
Posts: 440
Post Re: Table Customizer Not Showing
It looks like the tables you're joining have columns with the same name, is that correct? If so, you'll want to use aliasing to give the ambiguous columns distinct names. Here is an example:

table names: table, table2
column names that are the same in each table: item, item1

Code:
select
   t1.item as i, t1.item1 as i1, t2.item as i2, t2.item1 as i3
from
   table as t1
join
   table2 as t2 on t1.id = t2.id


returns table with four columns: i, i1, i2, i3

_________________
James Lorenz
QA/Build Systems Engineer
Inductive Automation


Thu Jul 12, 2012 10:32 am
Profile
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 2 posts ] 


Who is online

Users browsing this forum: Google [Bot], Yahoo [Bot] and 4 guests


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: