retrieving and dispaying database

Hi All

I am quite new to perl. I am trying write a perl script to

1. retrieve records from an MS sql 2000 database.

2. display it in perl Gui(i have got a book on perl/tk, but did not
seem to help much).

2. click on a button on the GUI to save the recordset as an MS excel
document.

3. I also want to be able to upload the recordset onto a sybase
server. I am able to write the perl codes to retrieve records from MS
sql server. not sure how to proceed with the following

1. display the record on a GUI
2. create a button on the GUI that on clicking will save the record as
an excel doc.
3. create a button that ''on clicking'' will save the record to a
sybase database

Your help will be greatly appreciated.

Thanks

Nathan Eluma

Messages in this topic (1) Reply (via web post) | Start a new topic

.

--- In perl-beginner%40yahoogroups.com">perl-beginneryahoogroups.com, "Nathan" <n.eluma...> wrote:
&gt;
> Hi All
>
> I am quite new to perl. I am trying write a perl script to
>
> 1. retrieve records from an MS sql 2000 database.
>
> 2. display it in perl Gui(i have got a book on perl/tk, but did not
> seem to help much).
&gt;
> 2. click on a button on the GUI to save the recordset as an MS excel
&gt; document.
>
> 3. I also want to be able to upload the recordset onto a sybase
&gt; server. I am able to write the perl codes to retrieve records from MS
> sql server. not sure how to proceed with the following
>
> 1. display the record on a GUI
> 2. create a button on the GUI that on clicking will save the record as
> an excel doc.
>; 3. create a button that ''on clicking'' will save the record to a
> sybase database
>
> Your help will be greatly appreciated.
>
> Thanks
&gt;
> Nathan Eluma
&gt;
You really need to spend some time with Perl Tk.
It will do what you want with ease. If your Tk book is "Mastering Perl
Tk&quot; from Oreilly then everything you need is in it.
http://search.cpan.org/dist/Spreadsheet-WriteExcel/lib/Spreadsheet/WriteExcel.pm
There is also a DBD-Sybase module on CPAN
You just have to join the individual parts up.

Messages in this topic (2) Reply (via web post) | Start a new topic

.