Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Last row
Message
 
 
General information
Forum:
Visual FoxPro
Category:
Client/server
Title:
Miscellaneous
Thread ID:
00415642
Message ID:
00420205
Views:
36
>>>Really, a SQL command embedded in an XML string? That sounds very interesting, as we'll be moving to XML for result sets, etc., so we can pass things around COM layers and datasessions.
>>
>>SQL 200 supports this natively. You can POST a query in XML, and get the results in XML all over HTTP.
>
>Sounds really cool, Erik. I just might have to find a box to install that SQL2000 beta on and have a peek.
>
>Is it in a generic syntax or is it specific to SQL2000?

I'm sure it is SQL 2000 ANSI SQL. For example, you couldn't use the following Oracle SQL command:

select table1.*, table2.field2 from table1, table2 where table1.field1 += table2.field1 and table2.field2 = 'myvalue'

I beleive this is an outer join.
Larry Miller
MCSD
LWMiller3@verizon.net

Accumulate learning by study, understand what you learn by questioning. -- Mingjiao
Previous
Reply
Map
View

Click here to load this message in the networking platform