On Apr 9, 3:21 am, [EMAIL PROTECTED] (Jenda Krynicky) wrote:
> From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
>
> > I am struck on how to write data into a MS-Access data base.
>
> > I know how to retrieve data. I am using Win32::ODBC -- fetchRow to
> > retrieve a complete row. I need to write this row into another table.
>
> > Kindly suggest on how to go about this.
>
> Use DBI and DBD::ODBC instead. Win32::ODBC should not be used in new
> script except for maintaining the DSNs.
>
> If you want to copy a row from one table to another it's better to do
> it directly:
>
> INSERT INTO SecondTable (The, List, Of, Columns)
> SELECT The, List, Of, Possibly+Computed, Columns
> FROM FirstTable
> WHERE some = condition
>
> If you do need to copy the row to a different database you may do
> something like
>
> my $sth_ins = $db2->prepare(
> 'INSERT INTO SecondTable (The, List, Of, Columns) VALUES (?,?,?,?)'
> );
>
> my $sth_sel = $db1->prepare(
> 'SELECT The, List, Of, Possibly+Computed, Columns
> FROM FirstTable
> WHERE some = condition'
> );
>
> $sth_sel->execute();
> while (my $row = $sth_sel->fetchrow_arrayref()) {
> $sth_ins->execute(@$row);
>
> }
>
> Jenda
> ===== [EMAIL PROTECTED] ===http://Jenda.Krynicky.cz=====
> When it comes to wine, women and song, wizards are allowed
> to get drunk and croon as much as they like.
> -- Terry Pratchett in Sourcery
Thanks Jenda,
Your information was really useful... Useful to kick off my work.
Thanks a lot.
Sundeep
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
