RE: ODBC/Table Locking ideas?

I took the approcah to clear/and repopulate the tables, every 6 minutes...
And this programs runs on the PC...  But durring this process, if someone
views the web page, the data presented would be imcomplete...  It takes
about 20 secounds for this process to complete... (this actually brings me
to another question)  My ODBC connection has sloweeeeeed down so much, since
I put on the new 5.1 client access odbc driver or service pack..  This type
of process used to be instant, but now it takes forevere it seems...  And I
have checked everywhere, for tracing/debuging being accidently turned on,
but nothing, its just slow...

Any how I solved my delima, by having the PC delete/insert the info into a
temporary table, and then I call a stored procedure 'CL' to copy the temp
data into the web view table..  It seems to work ok...  Not exactly the way
I would have liked it though...

tim
> -----Original Message-----
> From: Carel Teijgeler [SMTP:coteijgeler@xxxxxxxxx]
> Sent: Wednesday, April 23, 2003 11:30 AM
> To:   rpg400-l@xxxxxxxxxxxx
> Subject:      Re: ODBC/Table Locking ideas?
> 
> Tim,
> 
> why bother? Web pages are most times static, unless you script something
> in JavaScript. To get an updated screen a user have to refresh the screen.
> 
> Afterthought: perhaps something like that, using a timer function in
> JavaScript to update the table.
> 
> Regards,
> Carel Teijgeler
> 
> *********** REPLY SEPARATOR  ***********
> 
> On 22-4-03 at 10:14 Hatzenbeler, Tim wrote:
> 
> >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.
> 
> 
> 
> _______________________________________________
> 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.
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.