RE: ODBC/Table Locking ideas?

["Walden H. Leverich III" <WaldenL@xxxxxxxxxxxxxxx>]

Tim,

What's imcomplete about it? When you say the VB app "deletes" the table on
the as/400 do you mean that it clears out _all_ the old data and completely
refreshes it? If so, why? Why not just upload the new rows in the log. It's
been a *LONG time since I played with the WinFax log, but can't you just
start from where you left off last time? 

If it takes multiple updates to make a iSeries log record "complete"
couldn't you do those updates under commitment control so the web user can't
see anything until it's all there?

-Walden

------------
Walden H Leverich III
President
Tech Software
(516) 627-3800 x11
(208) 692-3308 eFax
WaldenL@xxxxxxxxxxxxxxx
http://www.TechSoftInc.com 

Quiquid latine dictum sit altum viditur.
(Whatever is said in Latin seems profound.)
 

-----Original Message-----
From: Hatzenbeler, Tim [mailto:thatzenbeler@xxxxxxxxxxxxx] 
Sent: Tuesday, April 22, 2003 1:14 PM
To: 'RPG programming on the AS400 / iSeries'
Subject: ODBC/Table Locking ideas?


I was wondering if anybody had an idea, that will work better than mine?

Problem:
I have a PC faxserver (winfax), that I would like to have all the
information (sender, to, durration errors) sent back to the as/400 so i can
present a web page, to the end users, on what happened to their fax.

What I have done:
I have written a VB program, that reads the winfax log, and then via odbc
/deletes a winfax table on the as/400, and then populates it with the new
fax logs, and this program that runs every 6 minutes..
And then a web page, shows the fax results, and will let them see their fax
image, and the results of the fax, and will let them re-send if there were
any errors..

But here is the problem...  If the user views the web page, while the VB
program is update the as/400 table, the web page is incomplete..  whats the
best way, to handle the data during this update process.

Any ideas..

Thanks, tim

This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.
_______________________________________________
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo.cgi/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.