Hi all
When using LIKE I can use the 'String%' to look for partial matches. Not so
when I want to use IN ('String%', 'VariousString%') instead I have to use 2
LIKEs
Is there something I missed for using IN ()? That would allow me to use
partial matches? The IN keeps the query simpler and sho
On 16-2-2013 15:52, venussoftop wrote:
> Hi all
>
> When using LIKE I can use the 'String%' to look for partial matches. Not so
> when I want to use IN ('String%', 'VariousString%') instead I have to use 2
> LIKEs
>
> Is there something I missed for using IN ()? That would allow me to use
> par
Firebird 1.5 Database on Linux
I have a database that appears to be running fine; however, when I try to
restore a backup from FB 1.5 (Linux) to FB 2.5 (Windows), none of the tables
show up in the restored database. I have completed similar restores with other
databases. The first error messa
mateuszloskot [2013-02-15 13:53] :
> Hi,
>
> I need to install and configure Firebird to build and
> test my C++ project on the continous integration service
> at https://travis-ci.org/
> The system is based on Linux (Debian).
>
> Unlike for MySQL or PostgreSQL, travis-ci.org does not provide
>
On 16 February 2013 20:54, philippe makowski wrote:
> mateuszloskot [2013-02-15 13:53] :
>> [...]
>> Firebird installation:
>>
>> sudo dpkg-reconfigure firebird2.5-super
>>
>> My first question is, how can I install, configure and run Firebird
>> without interactive steps?
>>
>> I have found that
Hello,
i often need ranges in my program. Searching for bottlenecks i see that BETWEEN
is sometimes
very slow.
Example table with some 100.000 records, fields (ID,ADATE,NUMBER,)
secondary index on ID,ADATE,NUMBER
First example (slow)
SELECT * FROM table WHERE (ID BETWEEN 1000 AND 1000) AN