Distinct Commands With Lasso 8

[Zero Tolerence]

With Lasso 8, you can use a "-Distinct" command to call only distinct records in mySQL however, this command is not supported by Filemaker.

Basically this Distinct command only returns unique values.

I have a database, with a "submitted_Date" Field, there can be numerous records with the same submitted date, I would like to only return that submitted date one time however. Just wondering if anyone knew if this was possible with Lasso 8?

[Steve T.]

Hmmm.... I hear Lasso's pretty versatile, so if it has some kind of looping mechanism, you might be able to loop and compare to the previous value and skip it if it is the same as the previous value... something like...

y='novalue'

loop 1 to nrecords

.. x=[field:myfield]......// x is equal to the field value

.. if x != y ..................// if they are not equal to each other

.. .. [record]

.. .. [field:myfield]

.. .. [/record]

.. y = [field:myfield]....// y is set to compare with x on next loop

endloop

I think that's right, anyway. I saw in another post how you can define variables in Lasso with the [var:] tag. If there's a loop of some kind, I think you'll be alright, eh?

Here's hoping!

--ST

[Zero Tolerence]

I found an easier way, thanks tho. I am now doing it through Filemaker. I just created a vaule list based on the field I wanted only distinct values returned from, since they don't duplicate, it works just great.