Login error in Smartphone and Tablet after be logged.

Topics: Developer Forum
Dec 30, 2013 at 4:26 PM
Friends, when i make a login in a smartphone or tablet, this works fine.
But, when i make another issue into this session, does not work.
The error is this: Caught .NET exception, source: ActiveVFP.server activevfp.server message: avfpsql.login d:\hosting\5153875\html\vfp11\prg\activevfp.prg Error in line 1064 Function name is missing ). 1300
Dec 30, 2013 at 6:06 PM
What does that line say specifically ( Error in line 1064) in the source?

So the login actually works? And nothing works after that?

The error above seems to indicate your SQL login had an error.
Jan 2, 2014 at 8:13 AM
The correct line for my program's error is the line 1042:

THIS.nsqlhandle = SQLSTRINGCONNECT(&lcLogIn)

But, this error just happen in a Smartphone or a small Tablet.

In a Laptop or Desktop works fine.
Jan 2, 2014 at 9:38 AM
Weird problem. I guess I would look at &lcLogin and make sure it's the same string on both Destktop client and Smartphone client. Maybe something received from the Smartphone client is doing something to the string?
Jan 2, 2014 at 11:22 AM
I agree. But I don't know how to test, or how to get this information. Can you help me?
For you see how this it happens, please acess this link and see yourself.

The next page brings the proposals list, click on the proposal number and...

If you are in the Laptop so you will see the proposal.

But if you are in the Smartphone you will see the error.

Link: http://easycash.net.br/clientes/

Empresa: easycash
Usuário: carvalhokleber@carvalhokleber.com Senha: 123
Jan 2, 2014 at 1:26 PM
I just test your link in in IE9 and Safari (desktop) and the same error is happening once you click the proposal. You might want to debug what's happening on these browser since it has it's own developer tool similar to Firefox and Chrome. BTW, it's now happening on Firefox or Chrome as I've done the test.
Jan 2, 2014 at 4:14 PM
Edited Jan 2, 2014 at 4:16 PM
In some browsers really doesn't work.
But I did some tests and got the following results:

Firefox 11 - works fine
Firefox 27 - works fine
Chrome - works fine
Chrome - works fine (SmartPhone Iphone - latest Chrome version)
... - works fine (SmartPhone Android 2.2)
... - works fine (SmartPhone Android 2.3)
... - works fine (SmartPhone Samsung - Android 4.1)
IE8 - works fine
IE10 - works fine

IE11 - doesn't work
Safari - doesn't work (SmartPhone Iphone)

That is how I saved the string login information:

oSession.VALUE("sqlweb", login_string)
Jan 2, 2014 at 4:16 PM
Edited Jan 2, 2014 at 4:18 PM
Some suggestion? Or how I do to debug on browser?
Jan 2, 2014 at 7:46 PM
carvalhokleber wrote:
The correct line for my program's error is the line 1042:

THIS.nsqlhandle = SQLSTRINGCONNECT(&lcLogIn)

But, this error just happen in a Smartphone or a small Tablet.

In a Laptop or Desktop works fine.
What is the value of nsqlhandle on those affected (not working) browser? I will try to trap that portion of code if you think that it's happening on those lines.
Jan 3, 2014 at 8:34 AM
Good morning, thanks for the help.

I don't know how debug the program, cause I'm using just the activevfp.dll.

I'm using the information of your PRG that I found in site:


And the information about the line I taked on browser, after the error.
Jan 3, 2014 at 2:00 PM
In the code of your SQLSTRINGCONNECT, you can a add a quick and dirty debugging which can tell you some significant information:

LOCAL oerr as Exception
THIS.nsqlhandle = SQLSTRINGCONNECT(&lcLogIn)
IF THIS.nsqlhandle <  1
    STRTOFILE(STR(THIS.nsqlhandle), 'connectionerr.log')

You can use AERROR() to get the information specifically and dump it in the text file.
Jan 6, 2014 at 12:28 PM
This way does not work because the program can not save the file until the error is happening.

I have the information so using:

STRTOFILE (VARTYPE (lcLogIn), 'c: \ temp \ conerr0.log')

Thus, I found that the value should be stored in Session (oSession.VALUE ("sqlweb" login_string)) is the problem, he returned: X (NULL).

Is there any way to save this information in SAFARI and IE11?
Jan 8, 2014 at 4:19 PM
Dear, I'm trying use "oSessionTable.VALUE" to solve this situation.

But I found some problems. This function is working in that version?
Jan 9, 2014 at 1:09 PM
I found many problems in IE with Jquery mobile, so we use chrome only. However, I think MS has a fix for IE 11 for some session problem. It may be applicable your case. try google to get the link.