sql.txt

delphi实现的sql解析器

select * from parts  where (parts.OnOrder > parts.OnHand) 
select max(ItemNo)  from Items   where OrderNo = :OrderNo
select Customer.CustNo, Customer.Company, Customer.LastInvoiceDate, Customer.Phone from customer   where      (customer.LastInvoiceDate >= :FromDate) and     (customer.LastInvoiceDate <= :ToDate)
select * from customer order by LastInvoiceDate descending
select * from orders where      (SaleDate >= :FromDate) and     (SaleDate <= :ToDate) order by    SaleDate