Filemaker Switch ODBC manuals

Filemaker Switch ODBC User Manual (58 pages)

Brand: Filemaker | Category: Software manuals | Size: 1.20 MB |

English

Table of contents

FileMaker

1

Contents

3

Supported standards 27

4

Contents 5

5

Chapter 1

7

Introduction

7

Installing current drivers

9

Chapter 2

11

Installing FileMaker ODBC

11

JDBC client drivers

11

Networking requirements

12

2. Click Next

13

Configuring client drivers

14

Where to go from here

14

Chapter 3

15

Using the ODBC client driver

16

Keyword Value

19

Chapter 4

21

About the JDBC client driver

22

3. Returns error codes

23

Verifying access via JDBC

25

Chapter 5

27

Supported standards

27

SQL clauses

28

FROM clause

29

WHERE clause

29

GROUP BY clause

29

HAVING clause

30

UNION operator

30

ORDER BY clause

30

FOR UPDATE clause

31

DELETE statement

33

INSERT statement

33

UPDATE statement

34

CREATE TABLE statement

35

ALTER TABLE statement

35

SQL aggregate functions

36

SQL expressions

37

1 DATE 'YYYY-MM-DD'

38

1 TIME 'HH:MM:SS'

38

Date operators

39

Relational operators

39

Logical operators

40

Functions

41

Functions that

42

ODBC Catalog functions

43

JDBC Meta Data functions

44

Reserved SQL keywords

44

Reserved keywords

45

Appendix A

47

Appendix B

49

Appendix C

51

ODBC and JDBC error messages

51

JDBC error messages

52

Data source error messages

53

Filemaker devices