JM, try adding a PAUSE 1 on the line after the offending code, with output to the 
screen and error messages on


"J.M. GRATIAS" <[EMAIL PROTECTED]> wrote:

>
>Hi all,
>
>I have some troubles in one of my app writen 10 years ago ....
>
>This command make abort RB45++ and return to OS (same with DOS, W95/W98) :
>
>SELECT COUNT(*) FROM TableName WHERE FKName = "Value"
>
>The error message is flashing too fast and can't be red.
>Same happen when command is into a command file and typed on the keyboard.
>
>Following command works OK :
>
>SELECT COUNT(FKName) FROM TableName WHERE FKName = "Value"
>SELECT COUNT(*) FROM TableName
>SELECT COUNT(*) FROM TableName WHERE FKName = "Value" AND OtherIndexName =
>"OtherValue"
>
>DB structure seems correct (no AUTOCHECK/RSCOPE) errors.
>As I suspected a corrupted index, the DB have been reloaded : same problem.
>I also played with MICRORIM_MAXBLK system variables without succes.
>
>
>Question :
>
>- Is there a way to read/record �error message ?
>I tryed OUTPUT FileName /OUTPUT printer before SELECT COUNT but with no
>success ....
>
>- What could cause this problem ?
>
>TIA
>
>J.M. GRATIAS, Logimatique
>
>


-- 
Albert Berry
Full Time Consultant to
PSD Solutions
350 West Hubbard, Suite 210
Chicago, IL 60610
312-828-9253 Ext. 32


__________________________________________________________________
McAfee VirusScan Online from the Netscape Network.
Comprehensive protection for your entire computer. Get your free trial today!
http://channels.netscape.com/ns/computing/mcafee/index.jsp?promo=393397

Get AOL Instant Messenger 5.1 free of charge.  Download Now!
http://aim.aol.com/aimnew/Aim/register.adp?promo=380455

Reply via email to