Hi has anyone done up a mod for editing a group of records. When we do a search and it brings back x number of records we would like to edit these records from a table view. Some what like editing via a spreadsheet.
Aug 3, 2000, 12:45 PM
Veteran / Moderator (8669 posts)
Aug 3, 2000, 12:45 PM
Post #2 of 14
Views: 4445
I copied the subroutines from Links (with a few modifications). There is a file at http://www.jpdeni.com/dbman/Mods/multmod.txt.
Please let me know if it works.
JPD
http://www.jpdeni.com/dbman/
Please let me know if it works.
JPD
http://www.jpdeni.com/dbman/
Aug 10, 2000, 5:11 PM
Veteran / Moderator (8669 posts)
Aug 10, 2000, 5:11 PM
Post #4 of 14
Views: 4394
Aug 10, 2000, 6:22 PM
Veteran / Moderator (8669 posts)
Aug 10, 2000, 6:22 PM
Post #6 of 14
Views: 4372
One other question -- Does this happen with all the records your modifying, or just one?
JPD
http://www.jpdeni.com/dbman/
JPD
http://www.jpdeni.com/dbman/
Aug 10, 2000, 7:07 PM
Veteran / Moderator (8669 posts)
Aug 10, 2000, 7:07 PM
Post #8 of 14
Views: 4362
Try adding
my (%rec) = @_;
to the beginning of sub validate_record and then change every instance of
$in to $rec
just within that subroutine!!
JPD
http://www.jpdeni.com/dbman/
my (%rec) = @_;
to the beginning of sub validate_record and then change every instance of
$in to $rec
just within that subroutine!!
JPD
http://www.jpdeni.com/dbman/
Aug 10, 2000, 10:45 PM
Veteran / Moderator (8669 posts)
Aug 10, 2000, 10:45 PM
Post #10 of 14
Views: 4396
Did you change
($db_valid_types{$col} && !($rec{$col} =~ /$db_valid_types{$col}/)) and
JPD
http://www.jpdeni.com/dbman/
($db_valid_types{$col} && !($rec{$col} =~ /$db_valid_types{$col}/)) and
JPD
http://www.jpdeni.com/dbman/
Aug 11, 2000, 9:43 AM
Novice (13 posts)
Aug 11, 2000, 9:43 AM
Post #11 of 14
Views: 4343
Thanks my error.
Works great now do think it is possible to have the editable search results in a column format instead of the form format?
One other question we are asked if it would be possible to have have the users database so one could work on it offline. I can't think of a way except to do up a program in access to access the database and then copy and check it to the online file. The customer wants to take the online database and put it on his laptop when he is one the road and work on it, but the trouble is if someone adds data to the online database everything would get screwed up. Plus because dbman runs from scripts my only option to put in on a laptop would be like I said earlier is to create a access form, and then create a script that would read the remote database and check it against the online database. Something like that, let me know if you have any ideas.
Again thanks for you help so far, impressive.
Works great now do think it is possible to have the editable search results in a column format instead of the form format?
One other question we are asked if it would be possible to have have the users database so one could work on it offline. I can't think of a way except to do up a program in access to access the database and then copy and check it to the online file. The customer wants to take the online database and put it on his laptop when he is one the road and work on it, but the trouble is if someone adds data to the online database everything would get screwed up. Plus because dbman runs from scripts my only option to put in on a laptop would be like I said earlier is to create a access form, and then create a script that would read the remote database and check it against the online database. Something like that, let me know if you have any ideas.
Again thanks for you help so far, impressive.
Aug 11, 2000, 2:50 PM
Veteran / Moderator (8669 posts)
Aug 11, 2000, 2:50 PM
Post #12 of 14
Views: 4358
As for your other question, yes, someone could work on the database offline by a number of different ways. But, as with any database, it is unwise to have more than one copy of the database, either of which could be edited. If the guy with the laptop works on the file and then uploads the file, it would wipe out any changes that had been made since downloading the file.
JPD
http://www.jpdeni.com/dbman/
Aug 14, 2000, 5:51 PM
Novice (13 posts)
Aug 14, 2000, 5:51 PM
Post #13 of 14
Views: 4338
Two things
What i mean by editable results in a column format is instead of having each record in a form have each record so that is in one row ie if there is 10 records there would be 10 rows. I guess it would look like edited a spread sheet.
Question 2
A couple of posts ago you had me add the following
Try adding
my (%rec) = @_;
to the beginning of sub validate_record and then change every instance of
$in to $rec
just within that subroutine!!
Now I am trying to implement the following
if ($data[1] eq $in{'Lastname'})
{
return "duplicate entry"; }
in the same routine but when I do it doesn't work unless I change the validate_record back $rec to $in
the following link is a duplicate record routine I think you were helping on
http://webmagic.hypermart.net/dbman/field33.txt
Jason
What i mean by editable results in a column format is instead of having each record in a form have each record so that is in one row ie if there is 10 records there would be 10 rows. I guess it would look like edited a spread sheet.
Question 2
A couple of posts ago you had me add the following
Try adding
my (%rec) = @_;
to the beginning of sub validate_record and then change every instance of
$in to $rec
just within that subroutine!!
Now I am trying to implement the following
if ($data[1] eq $in{'Lastname'})
{
return "duplicate entry"; }
in the same routine but when I do it doesn't work unless I change the validate_record back $rec to $in
the following link is a duplicate record routine I think you were helping on
http://webmagic.hypermart.net/dbman/field33.txt
Jason
Aug 14, 2000, 10:06 PM
Veteran / Moderator (8669 posts)
Aug 14, 2000, 10:06 PM
Post #14 of 14
Views: 4321
Displaying search results with one record per row is no problem. I still don't know what you mean by "editable." Isn't that what the "multiple mod" mod does?
To display one record per row, take a look at my "spreadsheet" mods -- http://www.jpdeni.com/...ods/spreadsheet.html. There are four different permutations there, depending on what you want to do.
Regarding your other problem, if it works with $in, use $in.
JPD
http://www.jpdeni.com/dbman/
To display one record per row, take a look at my "spreadsheet" mods -- http://www.jpdeni.com/...ods/spreadsheet.html. There are four different permutations there, depending on what you want to do.
Regarding your other problem, if it works with $in, use $in.
JPD
http://www.jpdeni.com/dbman/