Tim

Messing about trying for case insensitivity

ran

select _subject, _msgno, _sent,_received from mandn
order by _subject

then, without closing the dataset ran

select _subject, _msgno, _sent,_received from mandn
where _subject collate ansi_ci like '%addict%'
order by _subject

================================================================================
SQL Error (ElevateDB 1.02 Build 1)
================================================================================

Cannot perform this operation on an open dataset



Roy Lambert

Tim

Closed the result set, closed EDBMan. Restarted EDBMan, ran

select _subject, _msgno, _sent,_received from mandn
where _subject collate ansi_ci like '%addict%'
order by _subject

tried to close the result set got an av at 20747365


Roy Lambert

Roy,

<< Messing about trying for case insensitivity >>

Could you send me your edbdatabase.edbcat catalog file for the database ?

Thanks,

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Its on the dvd whenever that arrives.

Roy Lambert

Roy,

<< Its on the dvd whenever that arrives. >>

Cool, thanks.  I will keep it close since I suspect that it will come in
handy.

--
Tim Young
Elevate Software
www.elevatesoft.com