hi Walter
Try
INSERT INTO mytable(column2) VALUES (12345)
In other words, do not try to insert the column you want to be
auto-generated. The database engine will notice that you are inserting
only a subset of the columns, and SHOULD use the default values for
the missing columns, which would
I think this behaviour is consistent with the ANSI standard. The double
quotes are necessary (if my memory serves me correctly) if there are
characters in the user name that are not letters numbers and underscores.
Maybe hyphens/minus are allowed also. But it's the dot that is annoying the
Hi all
On Tue, 4 Sep 2018, 00:27 'Louis van Alphen' lo...@nucleo.co.za
[firebird-support], wrote:
>
>
> As previous responders have said, generator values are guaranteed to be
> unique. However when transactions fail, the generator will skip a value.
>
Hadn't spotted this: yes that's right and
Two ideas that should work on any SQL database so long as you never delete
invoices
I amNot a guru for this dbms so if a more specific technique is posted it
is likely to be faster
Note however that while my method may be inefficient, it is more likely to
be portable. You pays your money and you
Please clarify.
Are you asking about the server or the client being on Android??
I am guessing the answers may not be the same...
Quite apart from the software itself, an unrooted Android is tricky to use
as a server because of firewall issues.
(I write with experience of trying to run a
Cool thanks for the progress report
On Sun, 12 Aug 2018, 17:25 Mark Rotteveel m...@lawinegevaar.nl
[firebird-support], wrote:
>
>
> On 11-8-2018 12:33, 'River~~' river14ap...@gmail.com [firebird-support]
> wrote:
>
> > I suggested wget as it has options to cope with tha
In principal I like your idea of a Firebird powered archive of Firebird
related emails.
I don't have energy to contribute to that much as I like it though.
R~~
On Sat, 11 Aug 2018, 15:29 Lester Caine les...@lsces.co.uk
[firebird-support], wrote:
>
>
> On 11/08/18 08:29, Mark Rotteveel
Hi Mark
> I'm actually thinking about an accessible archive so they old post
> remain available in some form.
>
Yes so I understood.
> But creating a 'just-in-case' backup is
> good idea.
>
Not least because it allows the post-disaster creation of an accessible
archive.
>
Me:
> it would be
Interestingly, the message by Doug you are replying to has yet to show
> up in my mailbox. I wonder if it ever will.
>
> [...]
>
That eliminates my guess that Yahoo have designed in repetition
sufficiently to prevent loss :(
If we are losing emails as well as duplicating others then that surely
How much does that archive matter?
In my opinion if the archive matters at all needs to be kept in a backup
held offline by the owners or a designated mod.
To rely on the big cyber company to do backups is tempting but sooner or
later something will happen to one of them and groups without
Thinking about the symptoms from a software engineer / sysadmin
perspective...
Hopefully Yahoo have designed their system so that a fault duplicates
rather than skips a given message when a machine goes down part way through
sending out a batch. That's how I would have de signed it too.
It is
I agree with the suggestion NOT to move anywhere with a price list.
Other than that I am equally content to stay or to follow you elsewhere
R~~
In response to G8HFL:
I will add
G8YWO
formerly VP8AEH
;)
On Fri, 10 Aug 2018, 10:54 Lester Caine les...@lsces.co.uk
[firebird-support], wrote:
>
>
Suggestion: if you have admin rights on the machine install a ramdisk
(there are several available for Windows and MS themselves offered them for
some earlier Windows versions) as say R: and tell Windows to use R: for
temp files.
In older versions of Windows you set up
TEMP=R:
TMP=R:
as the
offatt ham...@risingsotware.com
[firebird-support], wrote:
>
>
> On 04/08/18 23:06, 'River~~' river14ap...@gmail.com [firebird-support]
> wrote:
>
>
>
> To say an octet is in hex is no more wrong than to say some number is
> stored as a float. It's all just a bucket of bits.
Hi Mark.
You are pedantically correct but...
ALL storage in ALL modern computers is in binary.
When we declare a field as integer, char, octet, etc we are specifying two
things: how it is presented and what manipulation we can do on it.
To say an octet is in hex is no more wrong than to say
king about much.
>
> BLOBs just seem like over kill for storing a max of 64 chars!
>
> Not sure I follow how to OR, AND the bytes. What does x80 and x7F do?
>
> Thank you, both!
>
> Chuck
>
> On 8/4/2018 12:46 AM, 'River~~' river14ap...@gmail.com [firebird-support]
> w
Hi Chuck
I am a Firebird newbie so don't know if Fbd will let you do what you want.
Perhaps there is a fixed length raw byte field you could use, or perhaps a
blob?
If it does not, then a more efficient work around than the one yours would
be to store only seven bits to a byte, forcing the top
Thanks Kjell.
My preference is to type SQL in a CLI environment. It's good to know of the
free form SQL in FR but it's still not as fast (for me) as doing it in a
console / terminal. To "just open a query window" still looks to me like a
superfluous step.
But each to their own preference.
R~~
Thanks Mark,
Yes and I now I see it and don't know how I missed it before...
Regards
R~~
On Tue, 31 Jul 2018, 20:53 Mark Rotteveel m...@lawinegevaar.nl
[firebird-support], wrote:
>
>
> On 31-7-2018 10:44, trueriver river14ap...@gmail.com [firebird-support]
> wrote:
> > So my question is
> >
>
19 matches
Mail list logo