[Adrian Dyck]

Thanks for the response Pietro. However I am still having a lot of trouble with this as pulling a field that does not directly link with the WO_OPERATION table, and not on the data tree. So I have to link the WORK_CENTER field to the WO_TASK via the WWC_AUTO_KEY, and then reference the link between the WO_OPERATION and WO_TASK TABLES via the WOO_AUTO_KEY to pull that value into SQL. I am trying to do this on the calc tab, under the DBtext2 field that I have applied. When discussing this internally, I have been told that if a data point is not in the data tree, then I cannot bring it in. Is this the case then?

[Adrian Dyck]

Hi – initially on the skills side, I found that they are ordered by the estimated labor hours when I played around with it (sorts highest to lowest). So if I want them to be “in order” then I have to sequence through labor hours (1,2,3) when putting them in. Then once they are in – I have to go back and edit the estimated labor hours to what it should be…then it keeps the order.(??!!) So there is a work around, but becomes a problem as we want this in a template so we have repeatable task cards. Very interesting that it does this.

[Adrian Dyck]

Thanks Warren – this view has a “due date” in there, so I guess that past due field in quantum is just logic then.

[Adrian Dyck]

Thanks Mike and Nadim – the issue with Stock_Ti table is that there is no cost of the item that was issued. A very key component… We can get what part was issued, to what BOM, on what date from the WO_BOM table… and even the unit price…but not the cost. So trying to pull the cost of the actual stock line that was issued to the job. Is there a better table that we should be linking it too?

[Adrian Dyck]

Thanks Mike – Quantum is less-unhappy with that – the forms designer calc tab is now green and seems to accept what has been put in. However, when saved and try to apply this template, there is an error – ORA-00920: invalid relational operator.

Here is the latest of where I am at:

var

q: TOracleDataset;

begin

q := TOracleDataset.Create(nil);

q.SetSession;

q.Sql.Text := ‘SELECT wwc.work_center ‘ +

‘FROM wo_task wot, wo_work_center wwc ‘ +

‘WHERE woo.woo’ +

‘AND woo.woo_auto_key = wot.woo_auto_key’ +

‘AND wot.wwc_auto_key = wwc.wwc_auto_key’;

q.Open;

Text := q.FieldByName[‘WORK_CENTER’].AsString;

q.Free;

end;