Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote view and outer join
Message
From
29/03/2005 01:53:26
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
 
 
To
28/03/2005 15:15:38
Cristian Tenea
Aquila Part Prod Com
Ploiesti, Romania
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00999522
Message ID:
00999608
Views:
21
Ok, I got it. The {oj is escape sequence for outer join. But why if it is generated by designer can't load anymore again in designer.

Other problem : isnull() from SQL server is equivalent to NVL() in Fox but when i use this in a remote view to SQL server (isnull() to filter null values from SQL server) again test are ok save and at load get the error 'Too many parameters'. Seems the Fox forget the select phraze is for SQL server not for Fox!
Previous
Reply
Map
View

Click here to load this message in the networking platform