Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Contract - Retrieval Issue
12-23-2017, 04:20 AM, (This post was last modified: 12-23-2017, 04:37 AM by TurboPT.)
#7
RE: Contract - Retrieval Issue
I have not yet committed the file, as I was investigating more around that area.

The suggested fix DOES appear to fix the case when there is an actual quotation and order number combination, but then using the Outstanding Sales Orders/Quotations link with the order number, and 'Orders_Only' can generate the similar date error as shown below: [the date error message is generated by function: ConvertSQLDateTime()]

[Image: sl20dy.png]

The query does return 1 row, though ALL fields are NULL: (as also shown in the debug textarea above)

[Image: bex948.png]

...and running the explain on that query gives:

[Image: xkpw77.png]

Any ideas on why we would not get 0 rows instead of 1 row that has all fields NULL to avoid this issue? As it's not just the dates, but the output table (below the error messages) appears to be pointless with null information, but output because 1 row was found.

I am using Server version: 10.1.21-MariaDB ... does anyone see different behavior on MySQL ?
Reply


Messages In This Thread
Contract - Retrieval Issue - by VortecCPI - 12-20-2017, 12:12 PM
RE: Contract - Retrieval Issue - by TurboPT - 12-21-2017, 04:25 AM
RE: Contract - Retrieval Issue - by VortecCPI - 12-21-2017, 06:42 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-21-2017, 06:47 AM
RE: Contract - Retrieval Issue - by VortecCPI - 12-21-2017, 07:16 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-21-2017, 07:31 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-23-2017, 04:20 AM
RE: Contract - Retrieval Issue - by TurboPT - 12-28-2017, 03:09 PM
RE: Contract - Retrieval Issue - by TimSchofield - 01-02-2018, 07:26 PM
RE: Contract - Retrieval Issue - by VortecCPI - 01-03-2018, 12:17 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-03-2018, 03:16 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-03-2018, 03:28 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-03-2018, 05:26 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-03-2018, 11:11 PM
RE: Contract - Retrieval Issue - by TurboPT - 01-04-2018, 01:38 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-04-2018, 03:15 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-04-2018, 05:15 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-04-2018, 05:44 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-04-2018, 05:58 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-04-2018, 06:03 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-04-2018, 06:05 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-06-2018, 06:41 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-06-2018, 06:48 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-06-2018, 07:08 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-06-2018, 07:55 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-06-2018, 10:57 PM
RE: Contract - Retrieval Issue - by TimSchofield - 01-06-2018, 11:49 PM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 12:33 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-07-2018, 12:42 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-07-2018, 01:25 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 01:46 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-07-2018, 02:03 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 02:13 AM
RE: Contract - Retrieval Issue - by VortecCPI - 01-07-2018, 04:24 AM
RE: Contract - Retrieval Issue - by TimSchofield - 01-07-2018, 05:00 AM
RE: Contract - Retrieval Issue - by TurboPT - 01-07-2018, 12:28 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)