× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Hey all, I am adding a page to one of my ASP.NET applications. I do a simple
lookup query to collect some information. Previously, we were on V5R4 and
now on 6.1. My Client Access is still at V5R4 until we migrate all of our
ASP.NET applications to 6.1 (Royal pain BTW). In this app, I am using a
DataSet (xsd) to build the needed code to work with the tables. My statement
looks like:

SELECT PIN13, HOUSE_NUMB, ADDRESS, DEEDHOLDER, MAIL1, MAIL2, MAIL_CITY,
MAIL_STATE, MAIL_ZIP
FROM BECPARP
WHERE (PIN13 = ?)


I am passing in "R010930103004".

My error message is:

---------------------------
Microsoft Visual Studio
---------------------------
SQL Execution Error.
Executed SQL statement: SELECT PIN13, HOUSE_NUMB, ADDRESS, DEEDHOLDER,
MAIL1, MAIL2, MAIL_CITY, MAIL_STATE, MAIL_ZIP, PIN17, PIN12, PIN17DOT,
PINL10, CITYTWP, ACREAGE, GIS_NUMBER, MAP_NAME, CONTRACTTO, SUBDIVDESC,
SECTION, LOT, BLOCK, LEGAL, DEEDED_ACR, TOTAL_LAND, TOTAL_DW...
Error Source: IBMDA400 Command
Error Message: SQL0363: Extended indicator variable value for item 1 not
valid.
Cause . . . . . : The value of the extended indicator variable for item 1
was not within the range of acceptable values. The value must be in the
range of 0 to -7 inclusive. Recovery . . . : Change the value of the
extended indicator variable to one which is allowed for the statement or
context in which it was used. Try the request again.


This was working on V5R4. Any ideas?

Upgrading the client is out of the question at this time like this answer
suggested:
http://forums.systeminetwork.com/isnetforums/showthread.php?t=74921

--
Mike Wills
http://mikewills.me

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.