Hi,
dbClick on IBTransaction component and you got Transaction editor - and there
you have all values
google for each value
regards,
Karol Bieniaszewski
W dniu 2017-01-13 07:08:19 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
I am using TIBSQL, TIBDatabas
I am using TIBSQL, TIBDatabase and TIBTransaction components. This code is not
fitting there.
Would you please provide me Firebird Tools Group mail ID?
On Friday, 13 January 2017 11:15 AM, "Maya Opperman m...@omniaccounts.co.za
[firebird-support]" wrote:
Hi Vishal, >I need to u
Hi Vishal,
>I need to understand how to set Wait/No Wait Transaction in firebird.
I think you mean in Delphi? Might be better to ask on the Firebird tools group,
but I have replied below
>Also I have one doubt that I when we start transaction through code as shown
>below, the transaction locks
Hi All,
I need to understand how to set Wait/No Wait Transaction in firebird.
Also I have one doubt that I when we start transaction through code as shown
below, the transaction locks particular rows in the table or it locks entire
table?
Delphi code snippet should be:
try
sqlMain.Transa
Hi,
look at my example that I'm using for preparing two DB fou join into one
big.
My be it will help you.
-- Prepare data table for replication
-- Ensure that data in both databases are unique
-- No overlap during replication will occur
CREATE OR ALTER PROCEDURE Repl$SynchronizeDataTable(
Ma
12.01.2017 21:44, startx252...@yahoo.fr [firebird-support] wrote:
> What is the way to make a join from 2 tables in two respective database (in
> same server) ?
No.
--
WBR, SD.
+
Hi all,
What is the way to make a join from 2 tables in two respective database (in
same server) ?
ex :
Db1
TableA
Db2
TableB
how can i make somethink like this :
SELECT tA.MATRICRS, tB.name, tB.age
FROM TableA tA
JOIN TABLEB tB ON ( tA.ID = tB.ID)
ps: I use Fl
If I may be permitted to stick my oar in here
Oracle databases allow timestamp with timezone data types, as well as simple
timezone data types. Every database I've come across in my day job, I'm an
Oracle contract DBA, uses either date (aka date and time) or simple timezone
data types.
just be careful, shits happens ;)
Now, its done:
EXECUTE BLOCK
returns (
result_table varchar(255),
result_idkey varchar(255),
result_done varchar(1)) as
declare variable source_list varchar(8192);
declare variable l_item varchar(255);
declare variable l_lastpos integer;
declare varia
On 12-1-2017 17:22, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> hi All,
>
> I did a procedure that recompute all identity fields of a list with
> items separate by comma, but I need a method to check if table.field is
> identity or not. It´s a procedure of mainnitence.
For Firebird
12.01.2017 17:22, hamacker sirhamac...@gmail.com [firebird-support] wrote:
> I need a method to check if table.field is identity or not.
RTFM README.identity_columns.txt
--
WBR, SD.
+
hi All,
I did a procedure that recompute all identity fields of a list with items
separate by comma, but I need a method to check if table.field is identity
or not. It´s a procedure of mainnitence.
My code:
EXECUTE BLOCK
returns (
result_table varchar(255),
result_idkey varchar(255),
On 12/01/17 14:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Can someone point me in the right direction please?
There have been many attempts to justify storing a time stamp complete
with timezone directly in a time field, but the real answer is that it
is always wrong. Store location
12.01.2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Can someone point me in the right direction please?
Firebird does not handle time zones at all. CURRENT_TIMESTAMP and
CURRENT_TIME return
local time.
--
WBR, SD.
-
On 12-1-2017 15:09, Tim Ward t...@telensa.com [firebird-support] wrote:
> Sorry if this is a really basic question, but some time spent searching
> has failed to find for me the definitive detailed documentation on
> exactly how Firebird handles time zones (I'm particularly interested, to
> start w
Sorry if this is a really basic question, but some time spent searching
has failed to find for me the definitive detailed documentation on
exactly how Firebird handles time zones (I'm particularly interested, to
start with, in using CURRENT_TIMESTAMP to create a value in a TIMESTAMP
field, and
Dear Helen,
Today I did a clean installation for FB 3.0 (from zip package) and get DB
migrated to version 3.0.
It makes me so happy.
The real reason for previous problem is caused by security database file
initialization step.
***
Initialize security database by isql (FB 3.0).
> is
Hi!
There is very promising Typescript ORM https://github.com/typeorm/typeorm
https://github.com/typeorm/typeorm As more and more server side development
moves to JavaScript and Typescript, there is need for Firebird ORM for
Typescript. Is there ongoing work on this (maybe as part of other proj
18 matches
Mail list logo
