资源描述：
《VFP+SQL SERVER实例讲解10》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、VFP+SQLSERVER实例讲解10[日期：2007-06-21]来源： 作者：[字体：大中小]MPLOYEEID)"csql=csql+" INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERID=CUSTOMERS.CUSTOMERID)"csql=csql+" INNER JOIN SHipPERS ON ORDERS.SHIPVIA=SHIPPERS.SHIPPERID)"csql=csql+" INNER JOIN [ORDER DETAILS] ON ORDERS
2、.ORDERID=[ORDER DETAILS].ORDERID)"csql=csql+" INNER JOIN PRODUCTS ON [ORDER DETAILS].PRODUCTID=PRODUCTS.PRODUCTID"&&传送,得到的光标名称为默认的SqlResultSQLEXEC(hconn,csql)解释：由于语句很长，我花费了多条赋值语句才完成配置这个字符串。大家注意到了我选用双引号作为字符串分隔符，这里面是有大学问的。在SQL Server中有待空格的表名如：Order Details
3、，当它用于SQL语句时，就必须要用方括号标示，所以如果在Visual foxpro中如果用方括号分割字符串的话，就会有冲突！；单引号是SQL Server中分隔字符串、日期值的符号，在Visual FoxPro中如果使用单引号分隔字符串的话，也会造成冲突，当然在以上语句中我们没有看到单引号的身影，不过我们做一个变动，大家就会感到问题的存在了！local csq&&配置待传送的语句csql=csql+"SELECT ORDERS.SHIPNAME,ORDERS.SHIPADDRESS,ORDERS.SHI
4、PCITY,ORDERS.SHIPREGION,"csql=csql+"ORDERS.SHIPPOSTALCODE,ORDERS.SHIPCOUNTRY,ORDERS.CUSTOMERID,"csql=csql+"CUSTOMERS.COMPANYNAME AS CUSTOMERNAM,"csql=csql+"EMPLOYEES.FIRSTNAME+' '+EMPLOYEES.LASTNAME AS SALESPERSON,ORDERS.ORDERID,ORDERS.ORDERDATE,"csql=cs
5、ql+"ORDERS.REQUIREDDATE,ORDERS.SHIPPEDDATE,SHIPPERS.COMPANYNAME AS SHIPPERNAME,"csql=csql+"[ORDER DETAILS].PRODUCTID,PRODUCTS.PRODUCTNAME,[ORDER DETAILS].UNITPRICE,"csql=csql+"[ORDER DETAILS].QUANTITY,[ORDER DETAILS].DISCOUNT,"csql=csql+"[ORDER DETAILS].
6、UNITPRICE*[ORDER DETAILS].QUANTITY*(1-[ORDER DETAILS].DISCOUNT) AS EXTENDEDPRICE,"csql=csql+" ORDERS.FREIGHT"csql=csql+" FROM ((((EMPLOYEES INNER JOIN ORDERS ON EMPLOYEES.EMPLOYEEID=ORDERS.EMPLOYEEID)"csql=csql+" INNER JOIN CUSTOMERS ON ORDERS.CUSTOMERID
7、=CUSTOMERS.CUSTOMERID)"csql=csql+" INNER JOIN SHIPPERS ON ORDERS.SHIPVIA=SHIPPERS.SHIPPERID)"csql=csql+" INNER JOIN [ORDER DETAILS] ON ORDERS.ORDERID=[ORDER DETAILS].ORDERID)"csql=csql+" INNER JOIN PRODUCTS ON [ORDER DETAILS].PRODUCTID=PRODUCTS.PRODUCTID
8、"csql=csql+" WHERE ORDERS.ORDERDATE BETWEEN '1996-10-01' AND '1997-09-30'"csql=csql+" AND ORDERS.CUSTOMERID LIKE '%C%'"csql=csql+" AND [ORDER DETAILS].QUANTITY>50"&&传送,得到的光标名称为默认的SqlResultSQLEXEC(hconn,csql)传递变量上面一个例子充分证明了
