General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can someone look at this sql code for a view def'n
The error generated by the cpode below is
Command contains unrecognized phrase/keyword
CREATE SQL VIEW "ORDERID" AS ;
SELECT Ordhead.orderid, Ordhead.customerid, Ordhead.location, ; Ordhead.entered, Ordsize.PRODUCT, Ordsize.ordered, Sizetype.DESCRIPTION, ;
Ordsize.sizetypeid,PRODUCT.CODE ;
FROM frantisi!Sizetype, frantisi!Ordprod, frantisi!Ordsize, frantisi!Ordhead, frantisi!PRODUCT ;
WHERE Ordsize.PRODUCT = PRODUCT.productid ;
AND Ordhead.orderid = Ordprod.orderid ;
AND Ordprod.orderprodid = Ordsize.orderprodid ;
AND Ordsize.sizetypeid = Sizetype.sizetypeid ;
AND (Ordsize.location = ?THISFORM.LocationCombo.VALUE OR EMPTY(?THISFORM.LocationCombo.VALUE)) ;
AND (PRODUCT.supplier = ?THISFORM.SupplierCombo.VALUE OR EMPTY(?THISFORM.SupplierCombo.VALUE)) ;
AND (Ordhead.customerid = ?THISFORM.CustomerCombo.VALUE ;
OR EMPTY(?THISFORM.CustomerCombo.VALUE)) ;
AND Ordsize.ordered > 0))
This usually means a typo... and I am not seeing it.
Maybe fresh eyes can help?
TIA,
Mike
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only