ODBC Driver for 4D Server

Size: px

Start display at page:

Download "ODBC Driver for 4D Server"

ときなおなか
5 years ago
Views:

1 by ACI

26 Ô ÔÕ

27 SQL_DATE SQL_TIMESTAMP SQL_CHAR SQL_VARCHAR SQL_LONGVARCHAR SELECT CLIENTS.ID CLIENTS.String 1 MyString 2 NULL 3 SELECT CLIENTS.ID FROM CLIENTS WHERE CLIENTS.String IS NULL

29 SELECT INSERT UPDATE DELETE CHAR VARCHAR LONG VARCHAR

30 SELECT SUM MAX MIN AVG COUNT BETWEEN IN DECIMAL SMALLINT INTEGER REAL DOUBLE PRECISION UNION UNION ALL BIT TINYINT DATE TIME TIMESTAMP LONG VARBINARY

31 CONCAT LENGTH RIGHT UCASE LCASE LOCATE RTRIM LEFT LTRIM SUBSTRING MOD DAYOFMONTH MONTH DAYOFWEEK YEAR IF NULL CONVERT

33 SQL_VARCHAR SQL _LONGVARCHAR SQL_DOUBLE SQL_SMALLINT SQL_INTEGER SQL_DATE SQL_TIME SQL_BIT SQL_LONGVARBINARY

34 SQL_VARCHAR SQL_CHAR SQL _LONGVARCHAR SQL_REAL SQL_DOUBLE SQL_DECIMAL SQL_SMALLINT SQL_TINYINT SQL_INTEGER SQL_LONGVARBINARY SQL_DATE SQL_TIMESTAMP SQL_TIME SQL_BIT

35 SELECT SELECT CUSTOMERS.FirstName FROM CUSTOMERS

36 SELECT WHERE SELECT VIDEOS.Title, VIDEOS.RentingPrice FROM VIDEOS WHERE (VIDEOS.RentingPrice>21.1) SELECT BETWEEN SELECT VIDEOS.Title, VIDEOS.RentingPrice FROM VIDEOS WHERE (VIDEOS.RentingPrice BETWEEN 21.1 And 24.5)

37 SELECT VIDEOS.Title, VIDEOS.RentingPrice FROM VIDEOS WHERE (VIDEOS.Title Like 'M%') SELECT SELECT VIDEOS.Title, VIDEOS.RentingPrice FROM VIDEOS WHERE (VIDEOS.RentingPrice<21.1) ORDER BY VIDEOS.Title Blaze of Glory 18.8 Chip & Jeff's Excellent Adventure 19.5 Night of the Living Noni s 15.5 Prédateurs (Les) 15.5 Return of Cujo 13.5 SELECT SELECT left(ucase(videos.title),10) FROM VIDEOS WHERE (VIDEOS.RentingPrice>21.1)

38 SELECT VIDEOS.Title, locate('a',videos.title) FROM VIDEOS Demoiselles de Rochefort (Les) 0 Prédateurs (Les) 5 Missing in Action I 0 Chip & Jeff's Excellent Adventure 0 Jane Fonda s 10min Workout 2 Return of Cujo 0 Slippery When Wet 0 Blaze of Glory 3 Night of the Living Noni s 0 Boyz in New Jersey 0 Runaway 4 Living on a Prayer 11 Wyle Traps the Road Runner! 8 SELECT SELECT Avg(VIDEOS.RentingPrice) FROM VIDEOS

39 SELECT min(videos.rentingprice) FROM VIDEOS SELECT max(videos.rentingprice) FROM VIDEOS SELECT GROUP BY Count GROUP BY SELECT Count(*), VIDEOS.Category FROM VIDEOS GROUP BY VIDEOS.Category

40 SELECT SELECT CUSTOMERS.FirstName, CUSTOMERS.LastName, TRACKING.BorrowDate, VIDEOS.Title, VIDEOS.Category FROM CUSTOMERS, TRACKING, VIDEOS WHERE TRACKING.Video_ID = VIDEOS.Video_ID AND CUSTOMERS.Customer_ID = TRACKING.Client_ID ORDER BY CLIENTS.LastName Jon Bon Jovi Demoiselles de Rochefort Comedy (Les) Jeff Davis Prédateurs (Les) Fantastic Perry Fitch Missing in Action I War Fred Forire Chip & Jeff's Excellent Comedy Adventure Cary Grant Demoiselles de Rochefort Comedy (Les) Gus Guilbert Jane Fonda's 10min Health Workout John Huston Prédateurs (Les) Fantastic Dave Popielarz Return of Cujo Martial Arts SELECT UNION UNION UNION

41 SELECT VIDEOS.Category FROM VIDEOS UNION SELECT CUSTOMERS.FirstName FROM CUSTOMERS

42 SELECT IN SELECT VIDEOS.Title FROM VIDEOS WHERE VIDEOS.Video_ID IN ( SELECT TRACKING.Video_ID FROM TRACKING WHERE (TRACKING. Days Late >0) ) Demoiselles de Rochefort (Les) Prédateurs (Les) Chip & Jeff's Excellent Adventure Jane Fonda's 10min Workout Living on a Prayer Return of Cujo SELECT TRACKING. Days Late FROM TRACKING

43 SQL_API_SQLALLOCCONNECT SQL_API_SQLALLOCENV SQL_API_SQLALLOCSTMT SQL_API_SQLBINDCOL SQL_API_SQLCANCEL SQL_API_SQLCOLATTRIBUTES SQL_API_SQLCONNECT SQL_API_SQLDESCRIBECOL SQL_API_SQLDISCONNECT SQL_API_SQLERROR SQL_API_SQLEXECDIRECT SQL_API_SQLEXECUTE SQL_API_SQLFETCH SQL_API_SQLFREECONNECT SQL_API_SQLFREEENV SQL_API_SQLFREESTMT SQL_API_SQLGETCURSORNAME SQL_API_SQLNUMRESULTCOLS SQL_API_SQLPREPARE SQL_API_SQLROWCOUNT SQL_API_SQLSETCURSORNAME SQL_API_SQLSETPARAM SQL_API_SQLTRANSACT

44 SQL_API_SQLCOLUMNS SQL_API_SQLDRIVERCONNECT SQL_API_SQLGETCONNECTOPTION SQL_API_SQLGETDATA SQL_API_SQLGETFUNCTIONS SQL_API_SQLGETINFO SQL_API_SQLGETSTMTOPTION SQL_API_SQLGETTYPEINFO SQL_API_SQLPARAMDATA SQL_API_SQLPUTDATA SQL_API_SQLSETCONNECTOPTION SQL_API_SQLSETSTMTOPTION SQL_API_SQLSPECIALCOLUMNS SQL_API_SQLSTATISTICS SQL_API_SQLTABLES SQL_API_SQLBROWSECONNECT SQL_API_SQLCOLUMNPRIVILEGES SQL_API_SQLDATASOURCES SQL_API_SQLDESCRIBEPARAM SQL_API_SQLEXTENDEDFETCH SQL_API_SQLFOREIGNKEYS SQL_API_SQLMORERESULTS SQL_API_SQLNATIVESQL SQL_API_SQLNUMPARAMS SQL_API_SQLPARAMOPTIONS SQL_API_SQLPRIMARYKEYS SQL_API_SQLPROCEDURECOLUMNS SQL_API_SQLPROCEDURES SQL_API_SQLSETPOS SQL_API_SQLSETSCROLLOPTIONS SQL_API_SQLTABLEPRIVILEGES SQL_API_SQLDRIVERS SQL_API_SQLBINDPARAMETER

45 SQLSetStmtOption / SQLGetStmtOption SQLSetConnectOption / SQLGetConnectOption SQLMoreResults SQL_NO_DATA_FOUND

橡j_Oracle_whitepaper.PDF

橡j_Oracle_whitepaper.PDF Pervasive-Oracle 1 1 Pervasive Software Pervasive-Oracle / Pervasive Oracle Pervasive-Oracle ISV Pervasive-Oracle Pervasive.SQL Oracle 2 Pervasive-Oracle Pervasive-Oracle Pervasive.SQL Oracle Open Database