FileMaker 8 & SQL2005 Procedure?

[BowDown]

Here's some basic information:

The ODBC DSN Entry is:

ALPINESQLODBC

Server Information:

Path: //xxx

Database Name: HomeData

SQL Server Version: 2005

Here is the recordset field names for each of the procedures above.

dbo._xxx_getJobHead( jobKey # )

jobKey

custNo

designer

jobDescription

address

city

state

zipCode

I have all the same fields created in a jobHead table in FM8. I'm trying to write a script that will have FM8 run that procedure and populate a record with the SQL result set. Is this not possible in FM8?

[BowDown]

BTW: I figured this out. When you call the procedure you should call it like follows:

[sql Query by Calculation]

"proceedure_name " & jobKey

Or in my case it resulted in a query of:

"dbo._xxx_getJobHead 1234"

Using the (), or ' ', doesn't work when calling it from FileMaker 8.