Filemaker Switch ODBC Uživatelský manuál

Procházejte online nebo si stáhněte Uživatelský manuál pro Softwarové příručky Filemaker Switch ODBC. FileMaker Switch ODBC User's Manual Uživatelská příručka

  • Stažení
  • Přidat do mých příruček
  • Tisk

Shrnutí obsahu

Strany 1 - FileMaker

FileMaker® 9ODBC and JDBC Guide

Strany 2

10 FileMaker ODBC and JDBC Guide

Strany 3 - Contents

Chapter 2Installing FileMaker ODBC and JDBC client driversThese instructions help you install the drivers needed to access a FileMaker data source fro

Strany 4 - Supported standards 27

12 FileMaker ODBC and JDBC GuideJDBC client driver requirementsTo find which version of Java you’re running, open a command window (Windows) or Te

Strany 5 - Contents 5

Chapter 2 | Installing FileMaker ODBC and JDBC client drivers 13ODBC client driver installation (Mac OS)If you have previously installed the ODB

Strany 6

14 FileMaker ODBC and JDBC Guide6. Click Next.7. Confirm your installation selections, then click Install.8. When the installation is complete,

Strany 7 - Introduction

Chapter 3Using ODBC to share FileMaker dataUse the ODBC client driver to connect to a FileMaker data source from another application. The application

Strany 8

16 FileMaker ODBC and JDBC GuideUsing the ODBC client driverYou can use the ODBC client driver with any ODBC-compliant application. Sharing your F

Strany 9 - Installing current drivers

Chapter 3 | Using ODBC to share FileMaker data 17Accessing a FileMaker database file from a Windows applicationSpecifying ODBC client driver pro

Strany 10

18 FileMaker ODBC and JDBC Guide10. If you’ve enabled sharing via ODBC/JDBC in the host application, click the button to the right of Server Data

Strany 11 - JDBC client drivers

Chapter 3 | Using ODBC to share FileMaker data 19Accessing a FileMaker database file from a Mac OS applicationIf you build custom applications,

Strany 12 - Networking requirements

© 2004-2007 FileMaker, Inc. All Rights Reserved. FileMaker, Inc. 5201 Patrick Henry Drive Santa Clara, California 95054FileMaker is a trademark of Fi

Strany 13 - 2. Click Next

20 FileMaker ODBC and JDBC Guide

Strany 14 - Where to go from here

Chapter 4Using JDBC to share FileMaker dataIf you’re a Java programmer, you can use the JDBC client driver with any Rapid Application Development (RAD

Strany 15 - Chapter 3

22 FileMaker ODBC and JDBC GuideAbout the JDBC client driverThe JDBC client driver provides partial support for the JDBC 3.0 specification. The fo

Strany 16 - Using the ODBC client driver

Chapter 4 | Using JDBC to share FileMaker data 23Registering the JDBC client driver and connecting to a FileMaker data source (an example)Here i

Strany 17

24 FileMaker ODBC and JDBC GuideSpecifying driver properties in the URL subnameSpecify the user and password driver properties in the subname of t

Strany 18

Chapter 4 | Using JDBC to share FileMaker data 25JDBC URL connection with the database name, user name, and password specified in the URLFormat

Strany 19 - Keyword Value

26 FileMaker ODBC and JDBC Guide

Strany 20

Chapter 5Supported standardsThis chapter describes the SQL statements and constructs supported by the FileMaker ODBC and JDBC client drivers. Use the

Strany 21 - Chapter 4

28 FileMaker ODBC and JDBC GuideThe SELECT statement can use a variety of clauses:SELECT [DISTINCT] {* | column_expression [[AS] column_alias],...

Strany 22 - About the JDBC client driver

Chapter 5 | Supported standards 29FROM clauseThe FROM clause indicates the tables that are used in the SELECT statement. The format is:FROM tabl

Strany 23 - 3. Returns error codes

ContentsChapter 1 Introduction 7About this guide 7Using a FileMaker database as a data source 7Accessing a hosted FileMaker Pro database 8L

Strany 24

30 FileMaker ODBC and JDBC GuideHAVING clauseThe HAVING clause enables you to specify conditions for groups of records (for example, display only

Strany 25 - Verifying access via JDBC

Chapter 5 | Supported standards 31FOR UPDATE clauseThe FOR UPDATE clause performs Positioned Updates or Positioned Deletes via SQL cursors. The

Strany 26

32 FileMaker ODBC and JDBC GuideRetrieving the contents of a container field: CAST() function and GetAs() functionYou can retrieve binary data, fi

Strany 27 - Supported standards

Chapter 5 | Supported standards 33DELETE statementUse the DELETE statement to delete records from a database table. The format of the DELETE sta

Strany 28 - SQL clauses

34 FileMaker ODBC and JDBC GuideThe SELECT statement is a query that returns values for each column_name value specified in the column name list.

Strany 29 - GROUP BY clause

Chapter 5 | Supported standards 35CREATE TABLE statementUse the CREATE TABLE statement to create a table in a database file. The format of the C

Strany 30 - ORDER BY clause

36 FileMaker ODBC and JDBC GuideCREATE INDEX statementUse the CREATE INDEX statement to speed searches in your database file. The format of the CR

Strany 31 - FOR UPDATE clause

Chapter 5 | Supported standards 37ExamplesSELECT SUM (Sales_Data.Amount) AS agg FROM Sales_DataSELECT AVG (Sales_Data.Amount) AS agg FROM Sales_

Strany 32

38 FileMaker ODBC and JDBC GuideYou must enclose date, time, and timestamp constants in braces ({}), for example, {D '2005-06-05'}, {14:

Strany 33 - INSERT statement

Chapter 5 | Supported standards 39Date operatorsYou can modify dates.ExamplesIn the following examples, hire_date is {01/30/2004}.Additional exa

Strany 34 - UPDATE statement

4 FileMaker ODBC and JDBC GuideChapter 4 Using JDBC to share FileMaker data 21About JDBC 21Using the JDBC client driver 21About the JDBC c

Strany 35 - ALTER TABLE statement

40 FileMaker ODBC and JDBC GuideSELECT Sales_Data.Time_Sold FROM Sales_Data WHERE Sales_Data.Time_Sold < '12:00:00'SELECT Sales_Data.

Strany 36 - SQL aggregate functions

Chapter 5 | Supported standards 41FunctionsThe ODBC and JDBC client drivers support many functions you can use in expressions. Some of the funct

Strany 37 - SQL expressions

42 FileMaker ODBC and JDBC GuideSELECT SPACE(2) + Salespeople.Salesperson_ID AS Salesperson_ID FROM SalespeopleSELECT STRVAL('60506') AS

Strany 38 - 1 TIME 'HH:MM:SS'

Chapter 5 | Supported standards 43Operator precedenceAs expressions become more complex, the order in which the expressions are evaluated become

Strany 39 - Relational operators

44 FileMaker ODBC and JDBC GuideJDBC Meta Data functionsThe JDBC client driver supports the following Meta Data functions:1 getColumns1 getColumnP

Strany 40 - Logical operators

45 FileMaker ODBC and JDBC GuideReserved keywordsIFIFNULLIGNOREIMMEDIATEININDEXINDICATORINITIALLYINNERINPUTINSENSITIVEINSERTINTINTEGERINTERSECTINT

Strany 41 - Functions

46 FileMaker ODBC and JDBC Guide

Strany 42 - Functions that

Appendix AMapping FileMaker fields to ODBC data typesThis table illustrates how FileMaker field types map to the standard ODBC data types. String leng

Strany 43 - ODBC Catalog functions

48 FileMaker ODBC and JDBC Guide

Strany 44 - Reserved SQL keywords

Appendix BMapping FileMaker fields to JDBC data typesThe JDBC client driver uses the following mappings when converting FileMaker data types to JDBC S

Strany 45 - Reserved keywords

| Contents 5Appendix A Mapping FileMaker fields to ODBC data types 47Appendix B Mapping FileMaker fields to JDBC data types 49Appendix C OD

Strany 46

50 FileMaker ODBC and JDBC Guide

Strany 47 - Appendix A

Appendix CODBC and JDBC error messagesHere are the basic formats of error messages you receive when working with FileMaker and ODBC/JDBC. For a listin

Strany 48

52 FileMaker ODBC and JDBC GuideSequeLink Server error messagesAn error reported by the SequeLink Server has the following format:[DataDirect] [OD

Strany 49 - Appendix B

Appendix C | ODBC and JDBC error messages 53Data source error messages An error that occurs in the data source includes the data source name, in

Strany 50

54 FileMaker ODBC and JDBC Guide

Strany 51 - ODBC and JDBC error messages

IndexAAccess via ODBC/JDBC extended privilege 16Access, Microsoft. See Microsoft Accessaccounts and privileges 16aggregate functions in SQL 36al

Strany 52 - JDBC error messages

56 FileMaker ODBC and JDBC Guidedriversinstalling FileMaker JDBC 13installing FileMaker ODBC 12uninstalling old 9DROP INDEX (SQL statement)

Strany 53 - Data source error messages

| Index 57MMac OScreating a DSN 19installing JDBC client driver 13installing ODBC client driver 13JDBC client driver requirements 12ODB

Strany 54

58 FileMaker ODBC and JDBC GuideSPACE function 41space in database name 19, 24SQL aggregate functions 36SQL expressions 37character operat

Strany 55

6 FileMaker ODBC and JDBC Guide

Strany 56

Chapter 1IntroductionThis guide explains concepts and details to help you share FileMaker® data with other applications using ODBC (Open Database Conn

Strany 57

8 FileMaker ODBC and JDBC GuideSQL is passed through the ODBC and JDBC interfaces to the FileMaker host of the data source, performing queries suc

Strany 58

Chapter 1 | Introduction 9Updating files from previous versionsIf you used LDAC (Local Data Access Companion) or RDAC (Remote Data Access Compan

Komentáře k této Příručce

Žádné komentáře