Set field by name "current table::bin"

[jamesjames]

Might be dead simple but ive struggled with it a while now.

I want a set field by name script to automatically select current table and then a field called "bin"

I cant make Get ( ActiveFieldTableName ) to work, or set variable or any other solution...

The problem is the whole select field value must be within "" and Get ( ActiveFieldTableName ) & "::bin" does not work because of this.

reason?

I have a bin field in most table and I want to be able to use one single script and change the current table row bin field, instead of making one for every table/layout i have.

Many thanks for any tips or help.

[doughemi]

Have you tried Quote( Get (ActiveFieldTableName) & "::bin") ?

corrected per subsequent post to insert correct double colon

[jamesjames]

Jup.

It dosent work. The result of that is only ":bin"

so the table name is not following...

[bcooney]

Why would you have a "bin" field in every table, anyway? I question your data model.

[jamesjames]

hehe. I question it sometimes aswell. Its a test to create a flag for hiding the row. But the current table function would still be nice to have.

if I run Quote( Get (LayoutTableName) & ":bin") I get the correct result, but it still dont wanna change the value... ill keep on trying. Thanks for the help so far.

[David Jondreau]

Is there an "active field"?

The Quote() example should have a double colon, not a single.

[comment]

Why would you have a "bin" field in every table, anyway? I question your data model.

hehe. I question it sometimes aswell. Its a test to create a flag for hiding the row.

That is worth questioning, IMHO.

[jamesjames]

Ok. maybe its a bad ide. It is however just en experiment to test the different security settings in fm. Anyway. I think this discussion gave me some new ides to think about.

ps

The Quote( Get (LayoutTableName) & ":bin") gives me the right result but it dont work anyway. And the :: colon just results in a error not finding the field. But im quiting this test and will solve it some other way.

But thanks for all the help anyhow.