Page 1 of 1

SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO ...

Posted: Thu Feb 26, 2015 6:11 am
by unixkd
Hi Roger

Your sample program SQLTEST.PRG not working. It gives a runtime error: Invalid alias.

When I query the alias name returned by this expression, I discoved the alias name is always QUERY instead of the alias passed.

SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO CURSOR cAlias ...

I am using Xbase++ 1.90.350 Express++ 258

Thanks.

Joe

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

Posted: Thu Feb 26, 2015 6:42 am
by rdonnay
What are the dates on your Xbase++ files?

Alaska fixed this bug for me way back in 2008.

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

Posted: Thu Feb 26, 2015 6:55 am
by unixkd
December 19, 2008

Thanks.

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

Posted: Thu Feb 26, 2015 7:11 am
by rdonnay
How about ADSDBE.DLL ?

Have you been applying HOTFIXES over the years?

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

Posted: Fri Feb 27, 2015 1:51 am
by unixkd
ADSDBE.DLL date is DECEMBER 5, 2006

I have not been applying HotFixes

Thanks.

Joe

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

Posted: Fri Feb 27, 2015 7:10 pm
by rdonnay
That's the problem.
A hot fix was put in ADSDBE.DLL in 2009 to fix this problem.

You may want to consider downloading them.

I recommend hot fix 43.