Changes between Version 3 and Version 4 of Ticket #28274


Ignore:
Timestamp:
Jun 6, 2017, 5:36:18 AM (8 years ago)
Author:
Adama Camara
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #28274 – Description

    v3 v4  
    2222
    2323When looking at the SQL statements and trying to find the "?" symbol it does not appear:
    24 WHERE
     24
     25
     26{{{
     27PRE_INV_Q = """\
     28        SELECT cust.id, cust.name, inv.currency_id, SUM(inv.total)
     29        FROM
     30          v3_customer as cust
     31          JOIN v3_customerproxy ON cust.id = v3_customerproxy.original_id
     32          JOIN v3_invoice as inv ON v3_customerproxy.id = inv.customer_id
     33        WHERE
    2534          cust.id IN %s
    2635          and inv.type = 'i'
    27           and inv.invoice_date < %s  ---->  "comment: It is here the "?" should have appeared"
     36          and inv.invoice_date < %s
    2837        GROUP BY cust.id, inv.currency_id
    29         ORDER BY cust.id, inv.currency_id
     38        ORDER BY cust.id, inv.currency_id"""
     39}}}
     40
    3041
    3142 Could there be some incompatibilities between Postgre and SQLite?
Back to Top