It could be because of the syntax for .set retcancel is missing the "ON". Try this:
.SET RETCANCEL ON .SET RETLIMIT 100 SELECT * FROM tablename;
Recent Threads
Attachments
Library
Quick Reference
Useful Links
Rules of Conduct
FAQs
Join the Forum
Archives
Sample Index
2002 Indexes