Re: SQL Error

[Jack Kingsley <iseriesflorida@xxxxxxxxx>]

Hi, if your adding a new column in excel, sounds like it might be breaking
the VB code and the SQL code.

On Thu, Nov 4, 2021 at 10:52 AM Jim Hawkins <jhawkins@xxxxxxxxxxxx> wrote:

> Unfortunately, SQL is not something I know real well. I have an SQL
> Program that is called from an Excel Spreadsheet to populate the
> spreadsheet.  I was asked to add a couple of columns to SS. (I did not
> write either the spreadsheet VB code or  the original SQL code). The SQL
> Program is causing an issue now. This line seems to be the issue when I run
> the SQL in debug:
>
> SA020PX.SQLP_I1 = *(SQLP_IND+0);
>
> SA020PX.SQLP_I1 has an initial value of 0
> SQLP_IND has a value of *null.
> Error message is "Pointer not set for location referenced."
> SA020PX is the SQL program name.
>
> I get that the values of *null and 0 are an issue. I have no idea however
> of what these represent, or how to resolve this issue.
>
> I see the line of code in the compile listing and in debug, but it is not
> in original code.
> This line of code occurs after the declaration section, but apparently
> before much else happens, including accepting the passed parms.
>
> Regards,
>
> Jim Hawkins
> Programmer Analyst
> Interkal LLC
> Kalamazoo, MI
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com