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

This forum is for eXpress++ general support.
Post Reply
Message
Author
User avatar
unixkd
Posts: 579
Joined: Thu Feb 11, 2010 1:39 pm

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

#1 Post 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

User avatar
rdonnay
Site Admin
Posts: 4813
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

#2 Post by rdonnay »

What are the dates on your Xbase++ files?

Alaska fixed this bug for me way back in 2008.
The eXpress train is coming - and it has more cars.

User avatar
unixkd
Posts: 579
Joined: Thu Feb 11, 2010 1:39 pm

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

#3 Post by unixkd »

December 19, 2008

Thanks.

User avatar
rdonnay
Site Admin
Posts: 4813
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

#4 Post by rdonnay »

How about ADSDBE.DLL ?

Have you been applying HOTFIXES over the years?
The eXpress train is coming - and it has more cars.

User avatar
unixkd
Posts: 579
Joined: Thu Feb 11, 2010 1:39 pm

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

#5 Post by unixkd »

ADSDBE.DLL date is DECEMBER 5, 2006

I have not been applying HotFixes

Thanks.

Joe

User avatar
rdonnay
Site Admin
Posts: 4813
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: SQL cSql INTO ARRAY aInvoices INTO OBJECTS aObjects INTO

#6 Post 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.
The eXpress train is coming - and it has more cars.

Post Reply