Search found 3 matches

by guy
Tue Jul 01, 2008 3:44 pm
Forum: Label Design & Printing
Topic: Need to do an OUTER JOIN
Replies: 7
Views: 4834

I don't believe this is a troubleshooting issue. I am asking how to do an 'OUTER JOIN'. Something like SELECT table1.field1,table2.field2 FROM table1 LEFT OUTER JOIN table2 ON table1.field3 = table2.field3 This will return all records in table1 and populate the field2 output with any matching record...
by guy
Thu Jun 19, 2008 5:47 pm
Forum: Label Design & Printing
Topic: Waiting for an external program to finish.
Replies: 1
Views: 2291

Waiting for an external program to finish.

I have been trying to use the 'Open document/program' action in NiceForm to run an external program to retrive some data. The program runs fine when I click the button. The problem is that NiceForm continues with the next action without waiting for the external program to finish. Is there a way to c...
by guy
Thu Jun 19, 2008 2:34 pm
Forum: Label Design & Printing
Topic: Need to do an OUTER JOIN
Replies: 7
Views: 4834

Need to do an OUTER JOIN

Hi I have a label that pulls data from 5 tables. One of the tables contains related data for only some of the labels to be printed. I would like to have the data print when it is available but leave the area blank when there is no related records in the table. I would normally do this with an OUTER ...