displaying output of an external exec

[fmroy]

Hello,

I'm new to FM as you will soon find out Good to find this place.

Situation:

Connecting to my SQL Server 2000 works fine and it can display tables, read fields, modify fields,all is good. I'm trying to exec sql queries through the ODBC, after executing, there is a slight delay (obviously working), and then, nothing.

Question:

How to view the output of the exec query?

Thanks

Roy

[Jonathan Monroe]

The optimal way of interoperating with SQL Server is to use "External SQL Sources" (ESS), which it sounds like you have working. With ESS, you don't have to write an SQL at all.

However, there may be times when you want to execute SQL statements directly - for example, if you need to execute a stored procedure. In that case, there are two FM script steps which support ODBC: "Execute SQL" and "Import Records".

"Execute SQL" is for SQL statements that don't return a recordset, such as INSERT and UPDATE statements. "Import Records" is for executing SQL statements that return recordset, such as the SELECT statement. Either one can be used for executing stored procedures.

Jonathan Monroe

Actual Technologies - ODBC for Mac OS X

http://www.actualtech.com

[fmroy]

Fantastic, "import records" works great.

Thank you Jonathan!