- Home
- File Maker Tutorial
- What Is ODBC? - File Maker
What Is ODBC? - File Maker
Interview Questions
Practice Test
Pragnyameter Exam
All Tutorials
Job SearchODBC stands for Open Database Connectivity. It was originally developed by the SQL Access Group and first released in 1992. It’s basically a widely accepted way (an application programming interface or API) for database systems to communicate with each other, though they may use many different proprietary native languages. It’s the Babel fish (a la The Hitchhiker’s Guide to the Galaxy) or Rosetta stone, if you will, of database systems, allowing one system to communicate with another.
All you need to know is how to set up your ODBC drivers and some basic SQL (Structured Query Language) commands that compatible database systems will recognize. You’ll use these SQL commands to select and modify data. And you can be up and running using ODBC with FileMaker Pro in almost no time at all.
|
|
File Maker Related Tutorials |
|
|---|---|
| Management Information systems Tutorial | Software Engineering Tutorial |
| Excel Data Analysis Tutorial | Unix makefile Tutorial |
File Maker Related Interview Questions |
|
|---|---|
| Management Information systems Interview Questions | Software Engineering Interview Questions |
| File net Interview Questions | Data analyst Interview Questions |
| Hadoop Distributed File System (HDFS) Interview Questions | Linux File Systems Interview Questions |
| Excel Data Analysis Interview Questions | Asp Dot Net Database Interview Questions |
File Maker Related Practice Tests |
|
|---|---|
| Management Information systems Practice Tests | Software Engineering Practice Tests |
| File net Practice Tests |
File Maker Tutorial
- What Is A Database?
- A Matter Of Definitions
- More Basic Database Elements
- What Is Filemaker Pro?
- Exploring Filemaker Pro
- The Filemaker Pro Environment
- Setting Preferences
- Document Preferences
- The Window And Help Menus
- Case Study: Chris’s Corner Computer Shop
- Create Your First Database
- Defining Fields
- Text Fields
- Validation Options
- Create The Rest Of Company.fp5’s Text Fields
- Number Fields
- Auto-enter Options
- Storage Options
- Repeating Fields
- Date Fields
- Time Fields
- Container Fields
- Calculation Fields
- Global Fields
- Summary Fields
- Define Fields Features
- Your First Layout
- Scriptmaker
- Save A Copy Of Your Database
- Harnessing The Power Of Complex Calculations Conclusion
- What Is A Layout ?
- Create Your First Layout: A Detail View
- Create Your Own Themes
- Layout Parts
- Part Definition Dialog
- Create A List View
- Mailing Labels
- Envelopes
- Table View
- Summary Reports
- Layout Objects
- Your Layout Tools
- Replicating Objects
- Fields
- Value Lists
- Lines (not Visible In Figure Above)
- Rectangles, Rounded Rectangles, And Ovals
- Pictures
- Portals
- Buttons
- Ole Objects — Windows Only
- Sliding And Printing
- Layout Menu
- View Menu
- The Arrange Menu
- Building Layouts The Last Word
- Exploring Browse Mode
- Working With Records
- Creating, Duplicating, And Deleting Related Records In A Portal
- Working With Fields
- Formatting Text Data
- Entering Graphics, Sounds, Quicktime/movies, Or Ole Objects
Into Container Fields - Replacing Data
- Finding And Replacing Data
- Relookup Data
- Finding Data
- Sorting Data
- Spell-checking Data
- Importing And Exporting Data
- Previewing And Printing Data
- A Database Of Your Friends
- The Relationship Between Databases
- Invoice Database Systems
- Relationship Setup
- Portal Setup Basics
- Lookups Vs. Related Data
- Setting Up Lookups
- From The Field: Advanced Portal Techniques
- Stacking Portal Fields
- Duping A Record With All Its Related Portal Records Intact
- Sorting A Portal At The Click Of A Mouse – Without A Million Layouts
- The Hidden Portal Technique
- A List View That’s Actually A Portal
- Highlighting Current Record In A List View Portal
- Use A Multikey Portal To Quickly Add Items To A Related Database
- Select A Portal Row To Data-enter A Line Item
- Rotating A Portal
- Other Cool Portal Tricks
- Planning A Relational Database System
- What Are Calculations?
- The Calculation Dialog Box
- Calculations Explained
- File Maker Constants
- Field References
- Some Simple Calculations
- Functions Of File Maker
- Text Functions
- Number Functions
- Date Functions
- Time Functions
- Summary Functions
- Repeating Functions
- Financial Functions
- Trigonometric Functions
- Logical Functions
- Status Functions
- Design Functions
- External Functions
- Store The Calculation Results
- Debugging Calculations
- From The Field: Create An Audit Trail, Track Changes To Your Data, Hold Users Accountable
- From The Field: Using Calculations To Create Boilerplate Quote
text That’s Plural Intelligent - Records And Data Conclusion
- The Scripts Menu And Define Scripts Dialog
- Naming And Organizing Scripts
- The Script Definition Dialog
- Building Scripts
- Performing Scripts
- Script Writing Best Practices
- Debugging Scripts
- Script Analysis Tools
- Miscellaneous Notes
- Complete Script Step Reference
- How Much Security Do You Need?
- Your Security Plan
- Filemaker Pro’s Security Features
- From The Field: Darn Good Security System
- Case Study: Matter, Inc
- Other Security Measures You Can Take
- Other Security Software Tools And Add-ons
- Recovering Damaged Filemaker Pro Databases
- Hacking A Filemaker Database
- Your First Database Conclusion
- Why Share Databases?
- Database Sharing With Filemaker Pro
- Introducing Filemaker Server
- Installation And Optimization
- Configuring Filemaker Server
- Starting Filemaker Server
- Scheduling Automatic Filemaker Server Tasks
- From The Field: Sharing Filemaker Databases With Remote Users
- Introducing Filemaker Mobile
- Setting Up Filemaker Mobile
- Syncing Up
- From The Field: Synchronizing Multi-user Databases
- Other Ways To Sync Data With A Handheld
- Deploying Distributed Databases On Laptops
- Determining Your Data-sharing Requirements
- The Hidden Complexities Of Distributed Systems
- What Is ODBC?
- What’s So Great About Odbc?
- Filemaker Versus Other Database Software Terminology
- Odbc Drivers
- Filemaker Pro As Odbc Data Source
- Importing Data Into Filemaker Pro Via Odbc
- Common Problems
- Execute Sql Script Step
- Other Odbc/sql Solutions And Tools
- Filemaker-based Accounting Solutions
- Integrating Filemaker With Commercial Accounting Software
- Filemaker Pro As Document Manager
- Email Applications/plug-ins
- Faxing Applications/plug-ins
- Calendar/scheduling Software
- Charts And Graphs
- Maps
- Pdf Creation
- Smart Cards And Credit Cards
- Macromedia Flash
- Filemaker Pro As Digital Asset Manager
- Ftp And Http
- Cash Registers And Point Of Sale Systems
- Bar Coding
- Touch Screen Monitors
- Fun And Games
- What Is A Plug-in?
- Plug-inology: Ten Filemaker Pro Plug-ins Explained
- Programming Filemaker Pro Plug-ins
- Debugging Plug-ins
- Resources For Plug-in Authors
- Publicizing Your Plug-ins
- Obtaining The Plug-in Api
- Why Use Standards?
- Definition Of Ascii Characters 32–26
- Value List Conventions
- Layout Conventions
- Relationship Conventions
- Database Naming Conventions
- Script Conventions
- The Initial Client Interview
- Requirements Document
- Present To Your Client
- Estimating Filemaker Projects
- Database System Design Considerations
- Rapid Development Techniques
- Multi-user Design Issues
- Cross-platform Design Issues
- Time Bombs And The Global Back Button
- Filemaker Project Scheduling, Development, And Management
- When You’re In The Development Phase
- Testing Database Systems
- Installing Database Systems
- Documenting Database Systems
- Remote Maintenance Of Database Systems
- Becoming A Professional Developer
- What Is Filemaker Developer?
- The Filemaker Developer Tool
- Runtime Development Notes And Tips
- Distributing And Selling Your Runtime Solution
- Why Use Web Publishing?
- Should You Use Instant Or Custom Web Publishing?
- Hardware And Software: How Much Do You Need?
- Case Study: The Acibuk Museum Of Modern Art
- Configuring The Web Companion Plug-in
- Testing Your Database On The Web
- Custom Web Publishing
- Filemaker Database-driven Web Site Performance
- What Is The Web Server Connector Again?
- Installing The Web Server Connector
- Possible Web Server Connector Configurations
- How Much Will It Cost?
- Configuring And Administering The Web Server Connector
- Web Server Connector Security
- Ready, Set, Go!
- Xml And Xsl
- Java And Jdbc
- Php Scripting Language
- Lasso Professional 6
- Coldfusion
- File Maker Overview
- Filemaker Pro’s Applescript Support
- From The Field: Database Publishing With Quarkxpress And
Indesign - Attaching Applescript Scripts To Filemaker Pro
- Controlling Filemaker Pro With Applescript
- Scheduling Applescript Scripts
- Extending Scriptmaker Scripts With Applescript Commands
- Filemaker Server And Applescript
- What Is Activex?
- Objects, Properties, And Methods
- Filemaker Pro’s Objects, Properties, And Methods
- Filemaker Pro Documents Object
Getting Comfortable With Filemaker Pro
Your First Database
Building Layouts
Records And Data
Developing Relational Databases
Harnessing The Power Of Complex Calculations
Scriptmaker
Securing Your Filemaker Pro Databases
Sharing Filemaker Pro Databases
Taking Data On The Road
Filemaker, Odbc, And Sql
Filemaker At The Center: Emulating Or Integrating Filemaker Pro With Other Software
Filemaker Pro Plug-ins
Filemaker Pro Development Conventions
Designing, Est Imat Ing, Planning, Developing, And
managing Filemaker Projects
Filemaker Developer, The Developer Tool, And
Developing Commercial Solutions
Web Publishing With Filemaker Pro
Filemaker Pro Unlimited, The Web Server Connector,
And Advanced Web Technologies
Applescript Automation Of Filemaker Pro
Activex Automation For Filemaker Pro
