Witango Support
This is from the FileMaker Developer 6.0 documentation:
<x-tad-bigger>SQL supported by the FileMaker JDBC Driver
</x-tad-bigger><x-tad-smaller>The FileMaker JDBC Driver provides support for certain SQL statements, a RecordID pseudo column, a ModID pseudo
column, DbOpen and DbClose pseudo procedures, character escaping, and FileMaker data type mapping to JDBC SQL and
Java data types.The following is a list of the SQL statements and definitions that are supported by the FileMaker JDBC Driver.
</x-tad-smaller><x-tad-bigger>SQL statement Definitions
</x-tad-bigger><x-tad-smaller>SELECT statement
</x-tad-smaller><x-tad-smaller>SELECT { { * | field_name .,.. } [ , RECORDID [ , MODID ] ] }
FROM database_name
[ LAYOUT layout_name ]
[ WHERE { predicate [ { { AND | OR } predicate } ... ] } ]
[ ORDER BY { field_name [ASC | DESC] } .,.. ]
Where predicate equals
{ field_name { = | <> | > | >= | < | <= | LIKE }
{ value | ? } } | {field_name IS NULL} |
{RECORDID = {value | ?}}
</x-tad-smaller><x-tad-smaller>INSERT statement
</x-tad-smaller><x-tad-smaller>INSERT INTO database_name
[ LAYOUT layout_name ] ( field_name .,.. )
VALUES ( { value | NULL | ? } .,.. )
</x-tad-smaller><x-tad-smaller>UPDATE statement
</x-tad-smaller><x-tad-smaller>UPDATE database_name [ LAYOUT layout_name ]
SET { field_name = { value | NULL | ? } } .,..
[ WHERE { predicate [ { { AND | OR } predicate } ... ] } ]
Where predicate equals
{ field_name { = | <> | > | >= | < | <= | LIKE }
{ value | ? } } | {field_name IS NULL} |
{RECORDID = {value | ?} [ AND MODID = { value | ? } ] }
</x-tad-smaller><x-tad-smaller>DELETE statement
</x-tad-smaller><x-tad-smaller>DELETE FROM database_name
[ WHERE { predicate [ { { AND | OR } predicate } ... ] } ]
Where predicate equals
{ field_name { = | <> | > | >= | < | <= | LIKE }
{ value | ? } } | {field_name IS NULL} |
{RECORDID ={value | ?} }
</x-tad-smaller><x-tad-smaller>CALL stored procedure (a script) statement
</x-tad-smaller><x-tad-smaller>{ CALL script_name ( database_name [ ,
{ layout_name | password } ] ) }
Where the outermost curly brackets { } are part of the CALL statement syntax.</x-tad-smaller>
On 19/12/2003, at 8:34 AM, Peter Link wrote:
OSX, Witango 5/5.5 Dev Studio.
When we set up a taf using JDBC to get to Filemaker Pro, the only way we can get a results listing is to turn off the "Get total number of matching rows" box in the Results tab of the RecordList (using Search Builder). I am told by Jane Olivera, LLNL, that using this feature is a requirement for her. Is this a limitation of JDBC or something else? Thanks.
--
Peter Link
System Manager, ISSO
Innovative Business and Information Services
Lawrence Livermore National Laboratory
P.O. Box 808, L-664
Livermore, CA 94550
[EMAIL PROTECTED]
(925) 423-1230
________________________________________________________________________
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
