Hi:
Been playing with something for a while, and I finally figured out what the problem is... so now I need a work around to make it work.
I would LIKE it so that when someone updated their profile in GTCom, it also updates the profile in Links. I THOUGHT ir was easy, just a:
my $user_db = $DB->table('Users');
$user_db->update ( {
Email => $user->{comm_email}
}, { Username => $user }) or die "Can't Update: $GT::SQL::error";
Inside the GTCom code.
Now I realize that since there us no User.def table definition native to GTCom, I cannot use this nice, easy way to update the User table.
How can I work around this? Should I dummy up a User.edf table for GTCom... or can I somehow add a regular SQL statement (that will not care if there is a def file or not!) to get this done?
Bottom line: how do I get one program to update a table from another program?>
Thanks!
dave
Big Cartoon DataBase
Big Comic Book DataBase
Been playing with something for a while, and I finally figured out what the problem is... so now I need a work around to make it work.
I would LIKE it so that when someone updated their profile in GTCom, it also updates the profile in Links. I THOUGHT ir was easy, just a:
my $user_db = $DB->table('Users');
$user_db->update ( {
Email => $user->{comm_email}
}, { Username => $user }) or die "Can't Update: $GT::SQL::error";
Inside the GTCom code.
Now I realize that since there us no User.def table definition native to GTCom, I cannot use this nice, easy way to update the User table.
How can I work around this? Should I dummy up a User.edf table for GTCom... or can I somehow add a regular SQL statement (that will not care if there is a def file or not!) to get this done?
Bottom line: how do I get one program to update a table from another program?>
Thanks!
dave
Big Cartoon DataBase
Big Comic Book DataBase