General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Hi Michael,
In addition to what they have suggested, you might want to look at the last 2 '))' at the end of the where statement. Does not look like they belong to anyone.
HTH
Beth
>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
Previous
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