On 12/2/19 5:06 AM, Tjioe Hian Pin thp_p...@yahoo.com [firebird-support]
wrote:
>
> what about:
>
> SELECT fstName, fiKeyID FROM Members WHERE ' '||fstName||' '
> containing ' '||@po||' '
>
> Cheers,
> Tjioe
>
Again, that is likely prevent use of an index to find the record, and
force a table
On 11/29/19 4:32 PM, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
>
> Not sure what pattern is. If I am searching for two words I use OR or
> AND.
>
> "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE lower(
> @p0 ) AND lower(fstName) LIKE lower( @p1 ) "
>
> I
On 11/28/19 11:30 AM, cte...@gmail.com [firebird-support] wrote:
>
> I have this:
>
> "SELECT fstName, fiKeyID FROM Members WHERE lower(fstName) LIKE
> lower('%' || @p0 || '%')"
>
> Assume fstName includes "Richard" and "Rich". If I search for "Rich"
> it finds both names.
>
> What do I modify
On 11/13/19 9:51 AM, blackfalconsoftw...@outlook.com [firebird-support]
wrote:
>
> Thank you Anne, for your succinct comments regarding the differences
> between the efficiencies of a CHAR and VARCHAR field definitions.
>
> Human observation cannot actually elicit any observable effects
>
On 11/12/19 12:38 PM, cte...@gmail.com [firebird-support] wrote:
>
>
> What are the trade-offs of CHAR vs. VARCHAR? I know that VARCHAR
> consumes less space. Anything thing else (are VARCHAR searches slower)?
>
In some implementations of SQL (I don't know if firebird is one of
them), a row
On 9/28/19 8:52 AM, Clyde Eisenbeis cte...@gmail.com [firebird-support]
wrote:
>
> I'll be using Firebird on my personal laptop. My program (that uses
> that database) will be used often
> every day.
>
> I'm puzzled by some of the questions as I have assumed Firebird is a
> dormant database file
On 8/29/19 3:14 PM, 'Alan McDonald' a...@meta.com.au [firebird-support]
wrote:
>
>
> On 8/29/19 4:45 AM, m.djo...@gmail.com [firebird-support] wrote:
> >
> > In binary representation of the values maybe 4.72 is the closest, but
> > we are talking about mathematic.
> > This is from the
On 8/29/19 4:45 AM, m.djo...@gmail.com [firebird-support] wrote:
>
> In binary representation of the values maybe 4.72 is the closest, but
> we are talking about mathematic.
> This is from the description of the ROUND function in the documentation:
> Rounds a number to the nearest integer. If
On 8/5/19 4:20 AM, mohamed hamza medh...@hotmail.com [firebird-support]
wrote:
>
>
> Hi All,
>
> I am new to sql, I am coming from Xbase system .
> I want to know if it 's possible to execute query using last query
> result?
>
> EXAMPLE
>
> 1 select * from persons where state='CA'
>
On 8/19/19 4:46 AM, m.djo...@gmail.com [firebird-support] wrote:
>
>
> The following query shows that ROUND function does not give similar
> results for similar values:
>
>
> select
> round(cast(0.725 as double precision), 2),
> round(cast(1.725 as double precision), 2),
>
On Apr 16, 2019, at 4:40 AM, respekt...@post.cz [firebird-support]
wrote:
>
> Hi, thank you for reply
>
> But this ordering totaly damage the tree structure
>
> Because PORADI is only relative to parent node, so all child nodes starting
> with 1
>
> If I change the query as you recommend,
On 3/2/19 11:06 AM, Lester Caine les...@lsces.co.uk [firebird-support]
wrote:
>
>
> I think I will probably have to add some extra logic into this problem,
> but it SHOULD be simple enough ...
>
> Table with three fields - Gallery_No, Image_No, Item_position
>
> A gallery can consist of any
On 10/4/17 11:53 PM, Hamish Moffatt ham...@risingsoftware.com
[firebird-support] wrote:
>
> On 04/10/17 22:15, DougC d...@moosemail.net [firebird-support] wrote:
>> Hamish-
>>
>> Windows short path names are decidedly NOT for apps that cannot
>> handle Unicode. They were introduced far earlier
Short File names are to allow apps that can't support long file names
(LFN) to access a file. Long filename support includes wchar encoding.
If Firebird can't support wchar filenames, then it should NOT convert a
short filename to its LFN equivalent (unless there is some other very
important
From: firebird-support@yahoogroups.com
[mailto:firebird-support@yahoogroups.com]
Sent: Thursday, February 9, 2017 11:33 AM
To: firebird-support@yahoogroups.com
Subject: RE: [firebird-support] Re: detect duplicate blobs, how to?
> You are aware of course that you can't use any
On 12/8/15 2:26 PM, r...@seedsbydesign.com [firebird-support] wrote:
>
> I've used FB for years with ISO8859_1 charset and collation.
>
> Now I designing a new DB for a big app update in FB3 and wonder about
> this charset and collation.
>
> For test purposes I am using UTF8 and UNICODE_AI_CI and
16 matches
Mail list logo