queries, Tracefields?

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • queries, Tracefields?

    Still new at datapage and PCDMIS. So please forgive me if my question dose not come out right. my boss wants to know if you can sort the data by vendor, not just part number? I think you would creat a Query by using the vendors name? I'm guessing I need a comand in PCDMiS where you would place the vendors name? So when you want to creat a chart or report in datapage you would use the Query. Thank you for any help you can give. THANK U. I use 4.1 pcdmis.

  • #2
    Originally posted by tinabeth View Post
    Still new at datapage and PCDMIS. So please forgive me if my question dose not come out right. my boss wants to know if you can sort the data by vendor, not just part number? I think you would creat a Query by using the vendors name? I'm guessing I need a comand in PCDMiS where you would place the vendors name? So when you want to creat a chart or report in datapage you would use the Query. Thank you for any help you can give. THANK U. I use 4.1 pcdmis.
    Well, to sort by vendors, and not by part number, then the part number must be the same no matter what vendor it comes from, meaning you get the same part from multiple sources since the PART number is what the data is saved to Datapage under. I hope you don't mean sample number when you say part number.

    Anyway, you sort parts in a "part" in Datapage, you set up a tracefield in the program, and it must be after the stats/on command. Then in Datapage, you set up the query, it will walk you though it, it is quite simple, it is 'coding' in the strictest sense, BUT, it is a can't-screw-up form that you do the scripting in. Tracefield (math operation) value and you then select teh query when making the reports in Datapage. Queries are set up in the DPEditor
    sigpic
    Originally posted by AndersI
    I've got one from September 2006 (bug ticket) which has finally been fixed in 2013.

    Comment


    • #3
      Just remember TRACE entries are strings even though people can type numbers into them.

      Comment

      Related Topics

      Collapse

      Working...
      X