Post Reply 
 
Thread Rating:
  • 0 Votes - 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.)
Post: #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 ?
Find all posts by this user
Quote this message in a reply
Post Reply 


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

Forum Jump:


User(s) browsing this thread: 1 Guest(s)