Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael C. Butler
  Where is Michael C. Butler?
 Austin
 Texas - United States
 Michael C. Butler
 To: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 Tags
Subject: RE: Making items visible
Thread ID: 104280 Message ID: 104839 # Views: 1 # Ratings: 0
Version: Visual FoxPro 9 Category: Forms
Date: Monday, August 21, 2006 11:01:49 PM         
   


> > Good morning....
> >
> >
> > I have a login form with two(2) text boxes, and two(2) command buttons.
> > Text1 = name
> > text2 = password
> > Command1 = login
> > command2 = cancel
> > label1 = "Connection to tables...Please wait...."
> >
> > label1 is initially visible=.F.
> >
> > Now, when the user enters his name / password, and clicks the login button, it calls the login method:
> > thisform.login()
> >
> >
> > LOGIN method:
> > with thisform
> > .label1.visible = .T. &&turn on message
> > .command1.enabled = .f. && disable buttons so users can not click them again
> > .command2.enable = .F.
> > endwith
> >
> > ....
> > verify username / password code goes here
> > It is connecting to an oracle backend, and verifying that the connection is good.
> > ....
> >
> >
> > If failed
> > with thisform
> > .label1.visible = .F. &&turn message off
> > .command1.enabled = .T. && reenable buttons
> > .command2.enable = .T.
> > =messagebox("Login Failed...Please try again")
> > .refresh
> > endwith
> > return
> > else
> > do form mainform
> > endif
> >
> >
> > My problem is this:
> > When the user clicks on the LOGIN button, there is a LONG delay between when the button is clicked, and when the label1 actually becomes visible...
> >
> > Is it almost like it it executing the oracle connection code, before it updates the form, even though I have issued a refresh BEFORE that code executes...
> >
> > Once the connection takes place, the main forms loads quickly, and releases the login form...
> > It is really annoying for the customers, when the label does not appear telling them what is going on.
> > They think the system is frozen, when in fact it is not....
> >
> >
> > Any ideas?

>
>
> Hi,
> I cannot see why you do not call the visibility of the label prior to calling the
> login function... with a please wait for connection to be established!"
>
> If this connection fails then call a messagebox to advise of the failure.
>
> The other thing that I ponder, is I to have Oracle backends and the authentication
> happens in under 1 second? So why is your authentication to Oracle taking sooo long?
>
> Pete from the Great White North. (Only in Canada, ay.) Over and Out ...


I have a simple connection routine...if it makes connection, then the program continues, if not, I throw up the error.

strConnStr = "Driver={Microsoft ODBC for Oracle};Server=prod;Uid=readonly;Pwd=readonly;"
constr = sqlstringconnect(strConnStr)
?constr

if constr < 0
error
else
go to main form
endif

That simple...
Not sure why it takes so long....
Sometimes it will take under a second, other times, it will take as much as 30secs.
I am not the one in charge of the oracle servers, or tables...the DBA takes care of all the backend stuff. I just get my connection, and mess up the tables....

Thanks
MB

ENTIRE THREAD

Making items visible Posted by Michael C. Butler @ 8/14/2006 4:41:51 PM
RE: Making items visible Posted by Rey Magdalaga @ 8/14/2006 5:13:38 PM
RE: Making items visible Posted by Michael C. Butler @ 8/14/2006 8:18:14 PM
RE: Making items visible Posted by Barbara Peisch @ 8/14/2006 10:24:28 PM
RE: Making items visible Posted by Michael C. Butler @ 8/15/2006 1:20:23 PM
RE: Making items visible Posted by Vinay Pagaria @ 8/19/2006 8:15:39 AM
RE: Making items visible Posted by tushar @ 8/14/2006 6:46:36 PM
RE: Making items visible Posted by Pete Sass @ 8/18/2006 6:59:36 PM
RE: Making items visible Posted by Michael C. Butler @ 8/21/2006 11:01:49 PM