General

Re: SQL query error

Greg Collins — Fri, 07 Dec 2007 00:19:46 GMT

Strange... sounds like some issue more with the backend, but it could be InfoPath (just doesn't seem like it).

Maybe try setting up a SPROC and calling that instead of directly running a SQL command. Maybe that will solve the prolem.

Outside that, I don't know.

Re: SQL query error

Meandor — Thu, 06 Dec 2007 06:51:29 GMT

Yes, the Command property is ok and strNewStatus and intHolydayNr are valid values. In 99% of the Query's it works. But when a couple of persons will send Query's to the SQL-Server, this error comes more often. Also I have try/catch in my script which catch any other error, but this error isn't caught. Infopath began to flicker and after 2 till 3 minutes it shows a error-prompt with owerflow. No errorprompt from my catch-exception.

Re: SQL query error

Greg Collins — Wed, 05 Dec 2007 17:37:46 GMT

Have you used the debugger on this to verify that the Command property contains what you expect it to before running the Query()? You'll want to verify that strNewStatus and intHolydayNr are valid values and that the command string is being created properly.

Also use a try/catch to see if there's something else going on.

SQL query error

Meandor — Wed, 05 Dec 2007 15:57:56 GMT

Hello,

I have a little problem with my Infopath-Form.

I create a SQL-Insert-Statement in jscript and after finishing I Query it. Usually the data is correctly stored in the DB. But sometimes, Infopath beginn to flicker and after a few Seconds it brings the error "Stackoverflow". What is the reason for this error? I also can't catch him.

Could please somebody help me. Thanks

Here the code:

XDocument.DataObjects("Send").QueryAdapter.Command = "SET NOCOUNT ON \n " +
"update dbo.tblHolyday set intStatusNr = '" + strNewStatus + "' where intHolydayNr = '" + intHolydayNr + "' \n "+
"select intHolydayNr from dbo.tblHolyday as tblHolyday";

XDocument.DataObjects("Send").Query();