How can I modify more than 1 line of data at a time ?


Rgds,

Gunawan

When you modify a record, doesn't the data for the record show up in the modify screen? If so, you can modify any number of lines in the record before you hit the button to submit changes. If this isn't what you meant in your question, then please explain further what you are trying to do.

Thanks,
Chris Whatley

Yes the data show up, but it was onlyfor one record or line.

I will explain in brief
Assume the default.db contains like this:

1|300|857a|Good painting|{US}|Imam Subekti|Active|test|23-Mar-2001|admin
2|500|x123|Picture Now|{US}|Udin|Active|VanGogh3|25-Mar-2001|admin
3|1800|x9867|Woman|{US}|Imam Subekti|Active|botticelli|26-Mar-2001|admin
4|1800|9874h|Austria|{US}|Imam Subekti|Active|VanGogh|26-Mar-2001|admin

The things I want to change in one submit is:
1|300|857a|Good painting|{US}|Imam Subekti|Archive|test|23-Mar-2001|admin
2|500|x123|Picture Now|{US}|Udin|Active|VanGogh3|25-Mar-2001|admin
3|1800|x9867|Woman|{US}|Imam Subekti|Archive|botticelli|26-Mar-2001|admin
4|1800|9874h|Austria|{US}|Imam Subekti|Active|VanGogh|26-Mar-2001|admin

Please see that 'Active' became 'Archive' in 2 lines or 2 records.

That's what I meant.

Please help.

Rgds,

Gunawan

So you want to modify more than one RECORD at a time. I'm sorry, but this is beyond my abilities and more than I have done in any database I am running. As far as I know, the only way to do it is with the Relational MOD.

Perhaps somebody else can take a look?

Sorry and good luck,
Chris Whatley

There is a mod called "Modify Multiple Fields"

If JPDeni has this back up at here site the url was:

http://www.jpdeni.com/dbman/Mods/multmod.txt

This may be what you need

Unoffical DBMan FAQ
http://webmagic.hypermart.net/dbman/

Thank you for this mod.
It's actually I'm looking for. But I have to modify it to suit my needs.

Thanks,

Lembono