haroldvance

Comments

• I don't need to unencode the files but it would be helpful to have the subject available and maybe the sender. Mainly I want the messages to be available with a double-click via a an edit table on the sales order form. I should be able to program OI…

  in file drag and drop capabilities? Comment by haroldvance June 2016
• Barry, I just ran clientsetup.exe on the workstation where I was getting too few hits with btree.extract. This machine doesn't do much other than run Arev16, so I am pretty sure I had never run clientsetup on it before. There was no reason to do tha…

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• Don, what is the best way to describe the length of a key field? Do I use the Justification Length field? Or do I set the data type? I usually put VARCHAR(10) in pretty much every data type unless I know it is Boolean in which case I use BOOLEAN. Th…

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• Barry, thank you. We will give it a shot to see if we get any difference.

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• I changed the date format to D2- and got same results. I verified the search string contents prior to submission to betree.extract.

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• The OCONV format shows D2-, which is different.

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• Here are the contents of CFG_IDX_SETS: <1> IDX_SETS2 <2> <3> <4> If use of original IDX_SETS is desired, set field 2 to IDX_SETS1; <5> otherwise, leave blank to use most recent version I can't find IDX_SETS2 in SYSENV…

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• On the date range criteria using the BETWEEN operator, I get the same results (zero hits) if the dates are submitted with D2/ format. I had the system display the contents of the search string variable in order to confirm it.

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• Thanks, Don. I will try the OCONV dates. What do I need to look for in the Key ID columns? Do they need to have a specific data type? Our keys tend to be variable length.

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• The screen shot was for a search using a different table, but the code is identical as it was copied throughout that program.

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016
• My bad. The "BETWEEN" operator is used for the date range. We are using the default operator for the two criteria, which I guess is an "AND". SEARCH.STRING = SEARCH.FIELD.NAME: @VM: ENTITY.ID : @FM SEARCH.STRING := "DATE": @VM: BETWEEN.S…

  in btree.extract with multiple criteria using the AND operator Comment by haroldvance March 2016