Declare and Set variables

[fmsavey]

Has anyone declared and set a variable before a select statement and then used that variable in the select statement with no errors (see below)? I am trying to do this in a SQL 2000 Server db.

Declare @title AS varchar (25)

SET @title = 'COUNSEL'

SELECT * FROM timekeep WHERE tktitle = @title

[Ted S]

This is all about SQL right? Since FileMaker doesn't use SQL you would probably be off asking this question on a site that was focused on the SQL language.

[fmsavey]

No it is not just about SQL. The example works just fine when executed via query analyzer and is a valid select statement. The select statement works just fine without the DECLARE and SET function when it is used in an FM import script step. I am puzzled that when the DECLARE and SET is included FM returns an error. My thinking is that the (valid) query statement is just being passed through to the sql server 2000 db as defined in the ODBC admin tool and don't understand why FM would generate an error.

Edited November 23, 2005 by Guest