UnixODBC
view release on metacpan or search on metacpan
}
$#hostlabels = -1;
push @hostlabels, @tmplabels;
drawdsnpane ($dsnpane);
}
sub getdsnlogin {
my ($host, $dsn) = @_;
my $dw = new MainWindow (-title => 'Log In');
my $userlabel = $dw -> Label (-text => 'User Name: ')
-> grid (-row => 1, -column => 1, -columnspan => 2,
-padx => 5, -pady => 5);
my $passwordlabel = $dw -> Label (-text => 'Password: ')
-> grid (-row => 2, -column => 1, -columnspan => 2,
-padx => 5, -pady => 5);
my $userentry = $dw -> Entry (-textvariable => \$dsnloginusername)
-> grid (-row => 1, -column => 3, -columnspan => 5,
-padx => 5, -pady => 5);
$dw -> Advertise ('userentry' => $userentry);
my $passwordentry = $dw -> Entry (-textvariable => \$dsnloginpassword,
-show => '*')
-> grid (-row => 2, -column => 3, -columnspan => 5,
-padx => 5, -pady => 5);
$dw -> Advertise ('passwordentry' => $passwordentry);
my $loginbutton =
$dw -> Button ( -text => 'Log In',
-height => 1,
-width => 10,
-command => sub {tablelogin ($dw, $host, $dsn,
$dsnloginusername,
$dsnloginpassword) &&
$dw -> WmDeleteWindow})
-> grid (-row => 3, -column => 1, -columnspan => 4,
-padx => 5, -pady => 5);
my $cancelbutton =
$dw -> Button (-text => 'Cancel',
-height => 1,
-width => 10,
-command => sub {$dw -> WmDeleteWindow})
-> grid (-row => 3, -column => 5, -columnspan => 4,
-padx => 5, -pady => 5);
}
sub tablelogin {
my ($dw, $peer, $dsn, $username, $password) = @_;
my ($peerusername, $peerpassword) = split /::/, $peers{$peer};
my ($evh, $cnh, $sth, $r, $text, $textlen);
my (@tables, $tableobj, @tmpdsns);
my $c = peer_client_login ($peer, $peerusername, $peerpassword);
if ($c =~ m"$CLIENT_LOGIN_ERROR") {
} # foreach my $label (@hostlabels)
$dsnpane -> configure (-scrollregion =>
[0,0, $x_width, $insert_y_org]);
}
sub execute_text_query {
my ($labelptr) = @_;
my $qdialog =
new MainWindow ( -title => 'SQL Query');
my $qtextbox = new_textbox ($qdialog, -height => 15, -width => 60);
$qtextbox -> grid (-row => 1, -column => 1, -columnspan => 2);
$qtextbox -> insert ('end', $userquerytext);
$qdialog -> Advertise ('qtextbox' => $qtextbox);
my $acceptbutton => $qdialog -> Button (-text => 'Submit',
-height => 1, -width => 10,
-command => sub {sql_query ($qdialog, $labelptr)},
@stdargs) ->
grid (-row => 2, -column => 1, -pady => 10);
my $dismissbutton => $qdialog -> Button (-text => 'Dismiss',
-height => 1, -width => 10,
( run in 0.228 second using v1.01-cache-2.11-cpan-a5abf4f5562 )