#VAR = SQL COUNT(*)
Started by andykay, Jun 22 2006 07:21 PM
23 replies to this topic
#17
Posted 28 June 2006 - 01:04 AM
Hi Andy,
We use v5.5 and our SELECT..INTO..WHERE statements work fine. The issue you are experiencing sounds like v4.6 does not handle these type of SQL statements correctly. If I cast my mind back (way back) to my v4.6 days, I recall we had to use the solution that Martin suggested earlier in his post. Its not hard to implement, it works and it sure beats having to sequentially increment a counter variable in ARNE logic, which kind of defeats the whole purpose of using a RDBMS anyway.
Rgds,
Jeff.
We use v5.5 and our SELECT..INTO..WHERE statements work fine. The issue you are experiencing sounds like v4.6 does not handle these type of SQL statements correctly. If I cast my mind back (way back) to my v4.6 days, I recall we had to use the solution that Martin suggested earlier in his post. Its not hard to implement, it works and it sure beats having to sequentially increment a counter variable in ARNE logic, which kind of defeats the whole purpose of using a RDBMS anyway.
Rgds,
Jeff.
#21
Posted 28 June 2006 - 05:01 PM
Got It
It turn out it was an error on placement of the SQL code. As I originally stated, I had a LU with an incremental counter that counted the records returned from a standard SQL query...that worked fine. So, I placed the new SQL query, with the INTO statement, in the same Default Logic of the LU as the original Sql query was...the new query never worked there and I have a pile of hair on the floor here to prove as testament .
When I moved the SQL query to After Field Logic, of the field that called the counting LU in the first place, it worked like a charm...lightning quick, too.
Thanks All.
Onward and Forward
AK
BTW...Who does England play next in the WorldCup?
It turn out it was an error on placement of the SQL code. As I originally stated, I had a LU with an incremental counter that counted the records returned from a standard SQL query...that worked fine. So, I placed the new SQL query, with the INTO statement, in the same Default Logic of the LU as the original Sql query was...the new query never worked there and I have a pile of hair on the floor here to prove as testament .
When I moved the SQL query to After Field Logic, of the field that called the counting LU in the first place, it worked like a charm...lightning quick, too.
Thanks All.
Onward and Forward
AK
BTW...Who does England play next in the WorldCup?
THE LIGHT AT THE END OF THE TUNNEL IS THE HEADLAMP OF THE TRAIN THAT'S ABOUT TO HIT YOU!!!
#22
Posted 28 June 2006 - 05:57 PM
We play Portugal on Saturday...
Rob.
Rob.
Reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users