Table Update

I Have a Form with some records, one of field record is a boolean type.

In my form I have a Button and I would like to Puch the button and the Boolean field becames TRUE, in all my records selected on form.

How can I do It?

Olá…

I will answer in portuguese and then in english… [:)]

Tens the ser um pouco mais especifica na tua dúvida…

No entanto, presumo que estás a falar de actualizar um campo booleano de uma tabela. Assim, terás que utilizar as funções INIT e INSERT:

recTable.INIT;

recTable.boolean_field := TRUE;

recTable.INSERT;

Bom Trabalho.

Now I’m sharing my answer with the comunnity…

You have to be more specific in your question…

However, I assume you’re talking about updating a boolean field in a table. So you’ll have to use the functions INIT and INSERT:

recTable.INIT;

recTable.boolean_field := TRUE;

recTable.INSERT;

Olá José Monteiro

Agradeço o Português

Eu consigo actualizar a tabela mas apenas para um dos registos do meu form, no entanto eu tenho 4 registos, marco-os com CTRL F1, e ao carregar no botão queria actualizar os 4.

The Updat is OK, but for one record only. For the other 3 marked records I don’t know how.

Regards

Hi Luana,

try

modifyall(YourField,true);

Regards,

Jan

CurrForm.SETSELECTIONFILTER(Rec);

( Your field) := TRUE;
MODIFY;

Hi Luana,

Did you ever find a solution to your problem? If you did, would you mind sharing it with us and if any of the posted answers helped you on the way, then please verify them.

Thank you.