![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 5 of 5 total |
![]() |
Mon, Apr 16 2007 9:24 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Mon, Apr 16 2007 9:27 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Mon, Apr 16 2007 5:30 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Tue, Apr 17 2007 2:34 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Tim
Its on the dvd whenever that arrives. Roy Lambert |
Tue, Apr 17 2007 5:46 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
This web page was last updated on Wednesday, August 14, 2024 at 03:12 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |