General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Try moving LocationCombo.Value and SupplierCombo.Value and CustomerCombo.Value into variables and use the variables in the view's where clause instead of 'THISFORM.xxx.value'
>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