Help, does anyone know about this

ISC Error 335544485 bad_stmt_handle Invalid Statement Handle,

for some reason we just got the error, can anyone explain it?

Thanks
Craig

________________________________

From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com] On Behalf Of Tim
Sent: Friday, 7 July 2006 3:40 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] trying to avoid large datasets



Do a google for "SOUNDEX" - you can write a UDF to perform a SOUNDEX
search with the same functionality.

<later>

Search for SOUNDEX in this article

http://firebird.sourceforge.net/index.php?op=useful&id=Connectivity&nosb
=1
<http://firebird.sourceforge.net/index.php?op=useful&id=Connectivity&nos
b=1>

regards

Tim

At 07:03 07/07/2006, you wrote:

>i'm in the process of porting a music catalogue maintenance program
>from clarion (which natively handles large datasets well) to c++.
>
>entering new title into database revolves around a screen that lists
>*all* the titles in the catalogue (about 120000) which takes 10
>seconds or so to load in order (unordered takes almost no time). the
>data entry operators like this because it allows them to locate where
>an item might be and then quickly scroll up and down to see if it's
>already been entered but with a spelling mistake.
>
>i realise this is more of ye olde paradox way of doing things but
>they've said it's a compulsory feature so there's not much i can do. i
>was wondering if i could fudge some similar kind of functionality by
>doing something like...
>
>SELECT FIRST 10 ...
>FROM ...
>WHERE param = 'whatever they enter'
>ORDER BY title
>
>but also selecting items preceeding whatever they're searching for?
>kinda like
>
>SELECT PREVIOUS 10 ...
>FROM ...
>WHERE param = 'whatever they enter'
>ORDER BY title
>
>so it might return
>
>whatever they eeter
>whatever they enter
>whatever they etner
>
>TIA
>
>

[Non-text portions of this message have been removed]





________________________________

Message protected by MailGuard: e-mail anti-virus, anti-spam and content
filtering.
http://www.mailguard.com.au





[Non-text portions of this message have been removed]