Remote view sql designer being too clever

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi
I have a remote view that requires a valid sql substring join which
works very well.

FROM {oj dbo.ORDER_DETAILS Order_details ;
INNER JOIN dbo.ORDER_MSTR Order_mstr ;
ON substring(Order_details.log_rec_num,1,10) = Order_mstr.LOG_NUM ;
LEFT OUTER JOIN dbo.PRODUCT_NO_MSTR Product_no_mstr ;
ON Order_details.PROD_NO = Product_no_mstr.PROD_NO};

however if I try and modify fields with the remote view designer under
VFP9 it reports back that it contains invalid content and wants to
always regenerate the sql into

FROM ;
{oj dbo.ORDER_DETAILS Order_details ;
INNER JOIN dbo.ORDER_MSTR Order_mstr ;
ON Order_details.LOG_REC_NUM = Order_mstr.LOG_NUM ;
LEFT OUTER JOIN dbo.PRODUCT_NO_MSTR Product_no_mstr ;
ON Order_details.PROD_NO = Product_no_mstr.PROD_NO};

So I have to always create new views and then edit the sql 'offline'
with my join. The other programs can call it and i can browse without
any issues, but as i'm still designing it is getting painful to keep
creating the same structures.

Does anybody perhaps know of a way to tell foxpro not to error check at
this depth?

Thanks in advance
Colin

.

Relevant Pages

  • Re: SQl Data Provider Performance Issues
    ... selects with a single inner join perforn OK. ... When I run the query from SQL ... Analyzer, SQL Profiler shows a duration of 30. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQl Data Provider Performance Issues
    ... selects with a single inner join perforn OK. ... When I run the query from SQL Query ... Analyzer, SQL Profiler shows a duration of 30. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: SQl Data Provider Performance Issues
    ... Can you provide a complete sample app ... selects with a single inner join perforn OK. ... When I run the query from SQL ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: sysindexes
    ... collation, but you should be able to use it for your column change as well. ... SQL Server MVP ... DECLARE @sql VARCHAR ... INNER JOIN information_schema.table_constraints tc ...
    (microsoft.public.sqlserver.server)
  • Re: SQl Data Provider Performance Issues
    ... selects with a single inner join perforn OK. ... When I run the query from SQL Query ... Analyzer, SQL Profiler shows a duration of 30. ...
    (microsoft.public.dotnet.languages.csharp)