Declare SQL variables

[capsprojectos]

Hello, It’s possible to run declare commands with SQL function, like this:

DECLARE @IncrementValue int

SET @IncrementValue = 1

UPDATE Table1 SET Column1 = Column1 + @IncrementValue

Thanks

[David Jondreau]

Not with native Filemaker functions. The ExecuteSQL() function only allows you to read data, not change it (or modify table structure). There are SQL plugins that may do what you need though.

[David Jondreau]

Ah, sorry, I didn't see this was under the ScriptMaster forums. I don't know enough about SM and SQL to give an answer, sorry.

[wbasham]

The ScriptMaster module simply passes the statements to the FIleMaker engine using their SQL plugin API. I'm not aware of whether or not this is allowed through that interface but you could certainly try it and see.

[capsprojectos]

Thanks for your answers,

Didn't work with me, but i don't know ywhy, so please can you help me trying to eliminate some steps:

1. The functions is correct?

2. There is any SQL functions to increment value?

Thanks

[john renfrew]

According to SQL documentation

DECLARE works inside a BEGIN..END block - but it appears to not be supported

OR

you can just use the SET @var =1 notation - but this appears to not be supported either. At the moment at least.

It is not supported in some of the other SQL plugins either, so I would deduce it is not a legal function in FileMaker

So looks like you need some feature requests to FMI