ExecuteSQL - getting started

[sal88]

Hi

I'm trying to use SM's ExecuteSQL function. Given that it has the same name as FM's built in sql function, how does it know which one it is using?

Thanks

 

[Wim Decorte]

Rename the SM one...

[ryan360Works]

Sal88,

It would not be rather FileMaker knows which one to use but rather if you know which one you are selecting. As Wim Decorte stated above, the best action would be to rename the SM function so that it is easier to differentiate between the two when making your scripts.

 

Regards,

Ryan DeMaeyer

[sal88]

I'm not doing very well with this  How do I rename?

[ryan360Works]

Heres a screen shot of where to rename.

[sal88]

Oh I see, I assumed that wasn't the place as there's a space between the words Execute and SQL, unlike when you actually select the function.

Thanks a lot guys!