I need to handle some dates to a month resolution, that is the day of
the month isn't important.
I was thinking of having update/insert triggers to force the day of
month to the 1st. But how easy is it to write queries that ask for items
that are, for example, 24 months old?
Scott
Are NULLs considered values for unique constraints on a table?
e.g.
CREATE TABLE blah (
col1 INT NOT NULL,
col2 INT,
CONSTRAINT unq_blah UNIQUE(col1, col2)
);
INSERT INTO blah (col1, col2) (123, 321);
INSERT INTO blah (col1, col2) (123, 999); /* okay */
INSERT INTO blah (col1, col2)
On 08/05/2019 21:46, Drew Jensen drewjensen.in...@gmail.com
[firebird-support] wrote:
>
> What you want to do is to choose ODBC or JDBC if you want to connect to
> a FireBird server instance.
>
What is the reason they don't have direct connection to FB servers as an
option? They've already got
On 06/17/2017 06:34 PM, thirdshiftco...@yahoo.com [firebird-support] wrote:
> well ... that's life.
>
> I can't get by it. make throws an error in linux when I do source
> install. I will have to go to icu boot camp so I can test out gpre later.
>
> if there is an easy way to get by this please
On 27/09/16 04:22, trsk...@yahoo.com [firebird-support] wrote:
> Is it possible to insert image into FB database directly via sql stament
> using isql or flamerobin?
There's a utility, FSQL, that behaves like ISQL and extends some of the
SQL syntax, including directly referencing files in an
On 06/11/15 19:21, Helen Borrie hele...@iinet.net.au [firebird-support]
wrote:
> Still, I'm bemused as to why you want to fiddle with the constraints
> if you're not changing them.
Well, to give some rough data; with constraints, my test case takes 10
mins to import, without, 4 mins (that
I have a feeling that the answer is 'no', but...
In a FB2.5 system is there a way to temporarily disable foreign key
constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
Got a big lump of clean data I want to drop into a table.
Alternatively, how safe is dropping/recreating the FKs on
On 06/11/15 16:15, Rik van Kekem r...@graficalc.nl [firebird-support] wrote:
> Scott Morgan bl...@blueyonder.co.uk [firebird-support] wrote:
>> In a FB2.5 system is there a way to temporarily disable foreign key
>> constraints? i.e. something like 'ALTER INDEX ... INACTIVE'
> Wel
On 05/08/15 11:58, Tor Jørgen Brekka tor.jor...@kameleongruppen.no
[firebird-support] wrote:
Here is a part of it like it is today:
---
BEGIN
SELECT PRODUCTIONLINENR FROM TBLPRODUCTIONLINE WHERE ESXKEY =
:ESXPRODUCTIONLINE into
On 21/11/14 11:21, hugo.lar...@yahoo.com [firebird-support] wrote:
Can someone advice on how to set the encoding of the connection with
Firebird C++ API isc_attach_database call.
I want to set it to ISO8859_1 but cant find an example.
Firebird doesn't have a C++ API, it has a C API and there
On Wednesday, April 30, 2014 1:49 PM, sukhend...@yahoo.com
I want to create my own installation to install firebird with my
application.
i have downloaded the manual script and i need to attach my own
security2.fdb as my own userid/password is saved with this db.I have
replaced my system
I checked the FB Book but can't see anything obvious.
Is it possible to use PSQL procedures as functions in SQL? Assuming the
procedure only returns one value, and it's type matches as required,
something like:
SELECT VAL, MY_PSQL_PROC(VAL) FROM SOME_TABLE;
or
SELECT * FROM SOME_TABLE WHERE
On 17/04/14 15:28, Thomas Steinmaurer wrote:
PSQL-based stored functions are implemented for V3, which is in Alpha
state at the moment, thus not ready for production.
Ah, even more to look forward to with v3.
For pre V3, you can use a selectable stored procedure in something
called inline
On 31/10/13 19:47, Fabiano - Desenvolvimento SCI wrote:
Embedded is used as a local database for a single system.
IF you can connect more than once you will have a BIG database
corruption, read the embedded documentation.
You must use the regular Firebird installation -
On 15/04/13 15:06, Hans wrote:
It may be present in other versions too, I haven't tested that..
...code snipped...
Returns:
A = 1 and B = 11 instead of giving some error by the parser.
Can be difficult to find this coding error.
That's expected behaviour, comments can cover line-breaks,
Is it possible to tell if a DB connection was made via an alias? Is
there something in one of the RDB$ tables that flags this?
Scott
On 25/02/13 15:25, Thomas Steinmaurer wrote:
Is it possible to tell if a DB connection was made via an alias? Is
there something in one of the RDB$ tables that flags this?
Not a real flag, but only by having a look at the string when, e.g.
querying.
select mon$attachment_name From
On 08/02/13 16:54, SoftTech wrote:
I have a stored procedure where I pass in a begin and end date.
Is there way to process each date within a for or while loop so that I can
return a record for each date regardless if I find any data to report on for
that date?
Any tips on how to code this
I've been importing data from an old system, part of which contains a
big table full of text. The table contains around 1.5 million entries,
but a lot of them are duplicate to the the extent that unique entries
total less than 10,000.
It's pretty easy to create a list of these duplicate
On 08/01/13 14:47, Andy Gable wrote:
Hi all,
Does anyone know if I can access a firebird server from Windows 3.11 and if
possible to run firebird embedded
on Windows 3.11?
Maybe an old Interbase lib could connect to a modern FB server.
Doubt fbembed would be possible, for starters I think
On 11/14/2011 09:23 AM, Lucas Franzen wrote:
Am 14.11.2011 10:05, schrieb Mr. John:
That is working from inside NSIS installer:
ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw
mypassword'
Remember to check this with different OS.
Under 2003/2008 you usually also have
21 matches
Mail list logo