stored procedures

[saraswati]

In FileMaker is it possible to write stored procedures ?

[SteveB]

I assume you know about scripts, as these are FM's stored procedures. What specifically are you trying to do?

Steve

[saraswati]

i need to write some SQL queries and take the result of the queries and run a loop and get count of a particular field based on some conditions. It is kind of a complicated mess. I am trying to figure out how to go about it in FileMaker. Has anyone been in a similar situation ?

[kennedy]

Well, with that rough description, you'll get rough answers.

In FMP, what is often done with SQL queries is done via "Find" to

select the set of records of concern... then you can use the fields

of those records in various calculations... or you can iterate through

the found set by using "scripts". Open up ScriptMaker and you'll see

that it offers a fairly general purpose programming language for

processing data.

[Ugo DI LUCA]

Why not

1) turn the querries into global keys or global concanate keys, Keyword 1 & " " & Keyword 2 & " "& Keyword3 (call it cg_CompoundKey)

2) Count using the Count (::Relationship: field)

Where the Relationship involves the cg_CompoundKey for the left side and an indexed key at right side (which would be the stored CompoundKey for each record)

[saraswati]

thanks for the suggestion. I will try to think more on Ugo's idea.

[Leb i Sol]

1st hide your SQL books it will confuse u more....SQL logic is barely used in FM...the closes I got was with Ugo's "joined" fieids approach.However, those scripts are pretty nice althoug "1 step at the time" kind of approach

goto filed...enter...peform find...goto layout...blah blah

whereas u just "run" the stored_proc with all the AND IN WHERE in one nice little statement

Ayhow, most definetly spend time looking at those scripts

All the best!