ODBC: FM 5.0 vs 5.5 
Author Message
 ODBC: FM 5.0 vs 5.5
Hi,

    Is there a difference between FM 5.0 and 5.5 as to the ODBC support? Has
the 5.5 version features that the 5.0 doesn't have?

Thanks,
Jeff Smith



Tue, 17 Feb 2004 22:26:33 GMT
 ODBC: FM 5.0 vs 5.5



Quote:
> Hi,

>     Is there a difference between FM 5.0 and 5.5 as to the ODBC
>     support? Has  the 5.5 version features that the 5.0 doesn't have?

The new stuff in 5.5 seems to consist of:

1) A new script step: Execute SQL. This executes any SQL statement through
an ODBC connection. You can use this script step to manage data in a foreign
data source. You can supply a field as the SQL statement to execute - you
would typically used a calc field to mix strings of SQL syntax with FM field
data.

2) A new function: Status (CurrentODBCError). This function returns the
error state (SQLSTATE) returned by ODBC. The error state can be obtained
after an ODBC-related script step has been executed to check for known
errors and determine if you want to continue with the script.

However, the basic ODBC support seems otherwise unchanged since 5.0, so far
as I can tell. If there *were* any performance or other significant
improvements I am sure FM Inc would be pushing FM ODBC with a bit more
vigour.

--
Regds, Bob Osola



Wed, 18 Feb 2004 19:48:24 GMT
 ODBC: FM 5.0 vs 5.5
Thanks a lot. I wasn't so sure about what was specific to FMP 5.5 on their
website. They don't make it clear because they don't say anything anymore
about earlier versions.

Thanks again,

Jeff Smith



Sat, 21 Feb 2004 23:03:40 GMT
 
 [ 3 post ] 

 Relevant Pages 

1. Filemaker Pro 5.0 vs 5.5 and FMDeveloper 5.0 vs 5.5

2. FM 5.5 vs FM 3.0

3. Integration of Exchange Server 5.0/5.5 and FM Pro

4. FM Dev 5.5 vs MacOS X 10.2.1 problem

5. Server 5.5 and FM 5.5

6. FM Dev 5 and FM Pro 5.5 compatibility

7. FM 4 (Mac) to FM 5.5 (Win)

8. Decimal vs int across db platforms - Informix 7.x vs SQL Anywhere 5.5

9. fm server 5.5/rh 8.0

10. FM Server 5.5 and RedHat 8.0

11. Differences between FM Server 5 and 5.5 ?

12. Automated scripts in FM 5.5


 
Powered by phpBB® Forum Software