Howdy all.
As part of a conversion project, converted the query on which a report is
based to SQL. When I attempt to open the report, I get the msg that the
ObjectPal version used in this form is incompatible with this version of
Paradox....

Found that the SQL version of query results in the UnitCount field being
changed from N to I. Is there anyway to correct this other than:
1. saving rpt under different name for the SQL query as the report is used
elsewhere in the application.
Or
2. Modifying the SQL query into an insert query using the original table.

Below are the respective queries.

Thanks in advance,
Rey

*****************************
AssnSummary = Query ; creates riv:statuna1.db

:PRIV:STATUN0B | UnitNumFK | AssnNumFK

:PRIV:STATUN0B | P1Bal | P2Bal |
P3Bal |

:PRIV:STATUN0B | TotBal |
:HAIDATA:ASSNMAST | AssnNumPK | AssnName | AssnAbrv |
EndQuery
Tbl structure:
AssnNumPK A3
AssnName A50
AssnAbrv A25
UnitCount N
P1Bal N
P2Bal N
P3Bal N
TotBal N


SELECT DISTINCT S.AssnNumFK AssnNumPK, A.AssnName, A.AssnAbrv, COUNT(
DISTINCT S.UnitNumFK ) UnitCount, SUM( S.P1Bal ) P1Bal, SUM( S.P2Bal )
P2Bal, SUM( S.P3Bal ) P3Bal, SUM( S.TotBal ) TotBal
FROM STATUN0B S
INNER JOIN :HAIDATA:ASSNMAST A
ON (A.AssnNumPK = S.AssnNumFK)
GROUP BY S.AssnNumFK, A.AssnName, A.AssnAbrv
ORDER BY AssnNumPK, A.AssnName, A.AssnAbrv

Tbl structure:
AssnNumPK A3
AssnName A50
AssnAbrv A25
UnitCount I
P1Bal N
P2Bal N
P3Bal N
TotBal N

If you are using local SQL you can use:

cast(count( DISTINCT S.UnitNumFK) as NUMERIC) as UnitCount

or you could try:

count( DISTINCT S.UnitNumFK) *1.0 as UnitCount


Anders

Howdy Anders.
Thanks for the suggestion. Just this AM - when I couldn't get back to
sleep - I thought of using Cast. Will give it a try.

Thanks again,
Rey

Good luck, and don't worry, I also figure out many of my SQL statements in
bed! :-)

Anders


"Rey" <reycollazo (AT) cox (DOT) net> skrev i meddelandet
news:am2If.57715$V.22417 (AT) fed1read04 (DOT) ..