Hi Dear All,
This is a mixed question of Firebird database and Delphi 5.
I am planning to create a library related desktop
application, for which there would be a single database kept at one place and
this application would be installed at different places more over in different
cities.
Here,
But if I have internet not an Intranet facility, then also would it work ?
From: Aage Johansen
To: firebird-support@yahoogroups.com
Sent: Friday, 7 September 2012 2:24 AM
Subject: [firebird-support] Re: Desktop Application For Centralized Firebird
Database...
Hi All,
I am new to ASP.NET, but familier with Firebird.
I am in search of how to connect Firebird to ASP.NET 2010 web application (code
language I am using is C#). I am trying to create sample application to become
a familier with ASP.NET, I worked with Firebird using Delphi. I used IBObject
Application
To: firebird-support@yahoogroups.com
Date: Sunday, 3 March, 2013, 3:36 PM
Vishal Tiwari wrote:
> I am new to ASP.NET, but familier with Firebird.
>
> I am in search of how to connect Firebird to ASP.NET 2010 web application
> (code language I am using is C#). I am tryi
rect, but only i need is to pass required base group as in the condition
and not any sub-leaf in condition, could you please modify it ? Thanks Again In
Advance. With Best Regards. Vishal On Friday, 2 October 2015 5:23 PM, "Vishal
Tiwari vishuals...@yahoo.co.in [firebird-support]"
wro
from mygroup where linked_to_group is null))) bwhere
b.linked_to_group = (select first 1 pk_group from mygroup where description =
'Vishal Group')
On Tuesday, 6 October 2015 9:56 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Hi N
Hi All,
I am trying to create index on a field which is of data type Varchar(255) using
FlameRobin, while committing I get below error message:
key size exceeds implementation restriction for index "IDX_"
How do I create an index on a field which is of data type Varchar(255) ?
Thanks In Advance.
y increase database page size to 16Kb
Em 13/10/2015 12:20, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
escreveu:
Hi All,
I am trying to create index on a field which is of data type Varchar(255)
using FlameRobin, while committing I get below error message:
key si
gards,
Neil Pickles – n...@csy.co.uk
- Reply message -
From: "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]"
To: "firebird-support@yahoogroups.com"
Subject: [firebird-support] Cannot Create Index
Date: Wed, Oct 14, 2015 06:18
How to increase the database
Hi All,
I have 480 Update SQL statements which I am executing using ADScript component
in Delphi 2010.
Update SQL updates data in only one table called MY_BOOK, but there is a join
with MY_BOOK_HEADER table. Below is the Update SQL, which is taking 81 seconds
to execute all 480 Update SQL statem
u have few ways1. EXECUTE BLOCK and there for select and delete2.
Temp Table3. speed up subselect with expression index on
Upper(Trim(MBH.HEADER_BOOK_CODE)) regards,Karol Bieniaszewski W dniu
2015-10-14 11:21:44 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
Many Thanks, Done it...
On Wednesday, 14 October 2015 11:51 PM, "Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]"
wrote:
On 14-10-2015 07:18, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> How to increase the database page size 16kb ?
HI SET,
PK is GUID type.
On Wednesday, 14 October 2015 10:51 PM, "setysvar setys...@gmail.com
[firebird-support]" wrote:
>>1. EXECUTE BLOCK and there for select and delete
>I am completely unaware about execute block. Would you offer any help,
so I could learn from it.
If PK
fcription1';
By the way, you always write HTH, at the end of mail. What does it stands for ?
Just for curiosity asking.
On Thursday, 15 October 2015 11:46 AM, "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]"
wrote:
HI SET,
PK is GUID type.
A BIG THANK YOU SET AGAIN... YOU ARE A INDIGENOUS.
On Thursday, 15 October 2015 1:17 PM, "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]"
wrote:
Yes..
YOU ROCKS SET AS USUAL.. WORKING ABSOLUTELY FINE.
After increasing page size from 4KB to 16KB, while launching delphi
appliocation using ADConnection component to connect to the firebird database
am getting below error:
[FireDAC][Phys][IB]database @1 shutdown
On Thursday, 15 October 2015 9:52 AM, "Vishal Tiwari
vis
Hi All,
At production department, we are receiving below errors, not for all times,
but frequently. We tried looking into code and found that there is a very
simple insert statement which might cause that issue. Because functionality
executes that Insert statement.
Wondering how to resolve tha
Just checked in the code Transaction components are used. Sorry for mistake.
On Wednesday, 4 January 2017 5:40 PM, "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]"
wrote:
Hi All,
At production department, we are receiving below errors, not for all times,
but
Any other way?
On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support]" wrote:
04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
wrote:
> Error 3:
> *validation error for column VAT,
2017 9:09 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Any other way?
On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support]" wrote:
04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.
Got it from here:
http://api.256file.com/fbclient.dll/en-download-67763.html
On Thursday, 5 January 2017 9:40 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
@WBR: Are you saying, the fbclient.dll and (gds32.dll) are belonging to
older versio
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
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
niaszewski
W dniu 2017-01-13 07:08:19 użytkownik Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] napisał:
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 201
Hi All,
I have created the below cursor on Firbird DB (version 2.5). The update
statement in below cursor is not updating value.
execute block
as
declare contractno CHAR(20);
declare cur_list_of_contracts cursor for (SelectCU.CONTRACTNO From
CLASSIC_UPGRA
if (ROW_COUNT = 0) then
leave; fetch cur_list_of_contracts into contractno; end close
cur_list_of_contracts;end;
HTH,Set
2017-02-17 10:04 GMT+01:00 Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] :
Hi All,
I have created the below cursor on Firbird DB (versio
Another way to connect to firebird database. Watch out with my video:Delphi
Connectivity With Firebird Database
|
|
|
| ||
|
|
|
||
Delphi Connectivity With Firebird Database
For any further communication, kindly mail to "vishuals...@gmail.com". All
valuable sug
ates MD2 ON MD1.MyDate+1 = MD2.MyDate
JOIN MyDates MD3 ON MD2.MyDate+1 = MD3.MyDate
LEFT JOIN SalesDetails SD1
ON SP.SalePersonCode = SD1.SalePersonCode
AND MD1.MyDate = SD1.dtDate
LEFT JOIN SalesDetails SD2
ON SP.SalePersonCode = SD2.SalePersonCode
AND MD2.MyDate = SD2.dtDate
LEFT JOIN SalesDet
77', 'Willy', 'Branch2', '30.01.2010', '400.00',
'350.00', '0086:001b');INSERT INTO BOOK_SELLING_DETAIL (BOOK_NO,
BOOK_ID, PUBLISHER, MAIN_BRACH, PUBLISH_DATE, ORIGINAL_PRICE, SELLING_PRICE,
"DB_KEY")
17 10:59 PM, "setysvar setys...@gmail.com
[firebird-support]" wrote:
Den 05.07.2017 20:15, skrev Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]:
Hi SET,
Just for you my Friend... Please check...
CREATE TABLE BOOK_SELLING_DETAIL ( BOOK_NO Integer, BOOK_ID
Hi All,
As per the attache files or below specified table DDL, DML and SQL, I need to
get below details:
Get Order_ID, Order_Date, Salesman_ID for different Salesmen :1. Who sold
maximum Copy for a day2. Who sold maximum amount of book for a day3. Who got
maximum order for a day
As per below SQL
HI SET,
Please help.
Thanks In Advance.
With Best Regards.
Vishal
On Monday, 17 July 2017 4:04 PM, Vishal Tiwari
wrote:
Hi All,
As per the attache files or below specified table DDL, DML and SQL, I need to
get below details:
Get Order_ID, Order_Date, Salesman_ID for different
otteveel m...@lawinegevaar.nl
[firebird-support]" wrote:
On 17-7-2017 13:31, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> HI SET,
>
> Please help.
I find it rather rude to expect (almost demand) someone to just help
you, and to then ignore the fact t
@Mark: I guess, asking for help, is never be like demanding. It is more over
expecting cooperation according to me.
But anyways no more talk on that issue...
On Monday, 17 July 2017 9:32 AM, Vishal Tiwari
wrote:
Hi Mark,
Kindly don't get me rude here. I always respected eve
Hi All,
I am still trying but could not get maximum data per date, as Order_ID and
Salesman_ID fields are coming in between.
With Best Regards.
Vishal
On Monday, 17 July 2017 9:54 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
@Mark: I guess,
y, 18 July 2017 11:18 PM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Hi All,
I am still trying but could not get maximum data per date, as Order_ID and
Salesman_ID fields are coming in between.
With Best Regards.
Vishal
On Monday, 17 July 2017 9:5
Den 17.07.2017 12:30, skrev Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]:
> Hi All,
> As per the attache files or below specified table DDL, DML and SQL, I need to
> get below details:
> Get Order_ID, Order_Date, Salesman_ID for different Salesmen :1. Who sold
> maximum
ot; wrote:
Den 17.07.2017 13:16, skrev Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]:
Hi SET,
Thank You for the reply. Not an issue, I could understand.
Before I execute this SQL, would like to learn something pretty interesting
logic in the SQL you provided.
I got the in
didn't understand why you wanted the Order_Date repeated three times for
each row, so I removed two of them.
HTH,
Set
Den 21.07.2017 10:05, skrev Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]:
First of all Thank You for the SQL. Let me go through.
I am ready if you get
Hi All,
I have one issue to share with you.
I have one table say "MyTable", which has five columns, say Col1, Col2,...,Col5
and it has 10 rows. Col5 is of Timestamp.
My issue is, whenever I am updating Col3, that time, only for that row of Col5,
Timestamp value should be updated to the current ti
The timestamp should be updated in Col5 only when Col3 is updated and not for
any other column update.
On Wednesday, 9 August 2017 2:20 PM, Vishal Tiwari
wrote:
Hi All,
I have one issue to share with you.
I have one table say "MyTable", which has five columns, say Col1, Col
Hi Paul,
I am getting below error while executing the trigger you shared. May be because
of new FB version? I am executing using FlamRobin tool.
Please see error below:
*** IBPP::SQLException ***Context: Statement::Prepare( create trigger before
update on Table_Nameasbeginif (new.col3 is distinct
I have put table name as Table_Name, which is actual table name.
On Wednesday, 9 August 2017 3:27 PM, Vishal Tiwari
wrote:
Hi Paul,
I am getting below error while executing the trigger you shared. May be because
of new FB version? I am executing using FlamRobin tool.
Please see error
;Paul Vinkenoog p...@vinkenoog.nl
[firebird-support]" wrote:
Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] schreef op
09-08-2017 11:58:
> I have put table name as Table_Name, which is actual table name.
>
> On Wednesday, 9 August 2017 3:27 PM, Vishal Tiwari
> wrote
Hi All,
I am facing deadlock situation as shown in below snap:
What I see is it is a stored procedure called from Delphi application. In that
stored procedure either Insert or Update statements are executed based upon the
flag.
My question is, if I put transaction inside Delphi application of
Hi All,
I would like to know if there is any dedicated book with good examples on T-SQL.
I have googled and found that T-SQL Querying, T-SQL Fundamentals etc books...
But it seems that they are mainly dedicated to SQL Server database.a nd talk
lot of stuffs on other stuffs in database. Since I use
Hi Edward Mendez,
I totally agree with you that this Firebird group has also helped me immensely,
in my critical situations. Thank you so much for the replay and suggestions. I
would go through the link.
But I am still willing to know about T-SQL and how to write it.
Thanking You Again And With
On Wednesday, 18 April, 2018, 1:32:25 PM IST, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 2018-04-18 08:57, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> Hi Edward Mendez,
>
> I totally agree with you that this Firebird group has
All In All, Thank You Everyone for the suggestion and Support.
On Wednesday, 18 April, 2018, 4:00:47 PM IST, Mark Rotteveel
m...@lawinegevaar.nl [firebird-support]
wrote:
On 2018-04-18 12:24, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> Hi Mark,
>
&g
Hi All,
I have below table requirement, where the data should be subtracted for each
record in the row. For each group subtraction should be separate.
Kindly find below example.
At start of each new group total remain must be zero(group by Card_no and
Card_cat)
Card_NoCard_CatIn_Val
Hi Dimitry,
Thank You for the reply.
Let me check and revert.
With Best Regards.
Vishal
On Saturday, 19 May, 2018, 8:50:58 PM IST, Dimitry Sibiryakov
s...@ibphoenix.com [firebird-support] wrote:
19.05.2018 17:12, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]
wrote:
>
We also tried to do sweep but still there is no improvement.
On Thursday, 7 June, 2018, 1:50:12 PM IST, Vishal Tiwari
wrote:
Hi All,
It's urgent...
We are facing a database performance issue. Currently, we are using firebird
version 2.5.2 ODS 11.2.
If we try to run a simple SQ
Attached snap, since it is not displaying in message body.
On Thursday, 7 June, 2018, 2:42:29 PM IST, Vishal Tiwari
wrote:
We also tried to do sweep but still there is no improvement.
On Thursday, 7 June, 2018, 1:50:12 PM IST, Vishal Tiwari
wrote:
Hi All,
It's urgent.
Thank You Helen,
We are discussing on this. I may get back to you.
Thanking You Again And With Best Regards.
Vishal
On Thursday, 7 June, 2018, 3:05:27 PM IST, Helen Borrie
hele...@iinet.net.au [firebird-support]
wrote:
Vishal Tiwari wrote:
> It's urgent...
> We a
Hi All,
It's urgent...
We are facing a database performance issue. Currently, we are using firebird
version 2.5.2 ODS 11.2.
If we try to run a simple SQL i.e. Select * from using FlameRobin,
it is taking time and next time the time span increases.
Same happens from all of our applications side a
It's not homework assignment. I always try to play with SQL and just got an
idea to deal with such tasks, as there are always new requirements come for
displaying report with different formats.
Mostly I try to get the output from SQL execution part itself rather than
stored procedure or from UI
I am using Firebird database with 2.1 version. I have one issue in Order By
clause.I have SQL which gives multile records for multiple employees, i.e. one
employee has multiple records as an output in SQL.I have Four columns in Order
By Clause and I want every columns Null value should be displa
Hi SET,
I have already tried but still not getting the result. Last column displays
Null value in middle of some rows.
With Best Regards.
Vishal
On Thursday, 12 March 2015 6:26 PM, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
>I am usi
Table values are as you shown:
MyTable
FieldA FieldB FieldC
1 2 3
1 2
1 2
2 3 4
2
2 3
On Thursday, 12 March 2015 6:32 PM, Vishal Tiwari
wrote:
Hi SET,
I have already tried but still not getting the result. Last column displays
Null value in middle of some rows.
With Best
Hi SET,
It is not table values, the table you shown is the result of my SQL i.e. my sql
gives the result as your table. Sorry for last wrong explanation.
On Thursday, 12 March 2015 6:47 PM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Table val
|
| ADJADD | DA | RD | RPLI |
| ATTNS_BNS | DRIVE | ADVANCE | STORE |
| BASIC | EXTRA_DUTY | ESI | |
| BATH_ALW | | INC_TAX | |
| BONUS | | BKRD_ADV | |
| CCA | | | |
| MONT_SAL | | | |
| PRD | | | |
On Thursday, 12 March 2015 6:53 PM, "Vishal
Hi SET,
I got the answer from below URL.
How To Display Null Values At the End For More Than One Columns Specified in
Order By Clause?
| |
| | | | | | | |
| How To Display Null Values At the End For More Than O...I am using Firebird
database. I have one issue in Order By clause. I
Hi All,
I have one question, any SQL I write, I would like to get auto-increment number
(separate column obviously) to every row starting with 1. It is just to
numbering every record I get as an output of my sql. I do not want to use
Generate which we do on table. This is just for SQL output I n
Thank You So Much Louis van Alphen
You saved me
Thanks A Ton Again !!
On Friday, 13 March 2015 5:50 PM, "'Louis van Alphen' lo...@nucleo.co.za
[firebird-support]" wrote:
select
cast(rdb$get_context('USER_TRANSACTION', 'row#') as integer) as row_number,
rdb$se
. for second employee
Row_Number as 2, and so on. So finally Row_Number value should endup with 10.
Any idea how would it possible?
Thanks In Advance.
With Best Regards.
Vishal
On Friday, 13 March 2015 6:07 PM, Vishal Tiwari
wrote:
Thank You So Much Louis van Alphen
You saved
Just for your information,
I have EmpCode column in my SQL
On Friday, 13 March 2015 6:13 PM, Vishal Tiwari
wrote:
Hi Louis,
One little bit advance question with respect to my previous question.
Say for example, my sql returns total 100 records in that it returns 10 records
for
Karol Bieniaszewski
- Reply message -
Od: "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]"
Do: "firebird-support@yahoogroups.com"
Temat: [firebird-support] How To Display Null Values At the End For More Than
One Columns Specified in Order By Clause?
Data: pt., m
HI Louis,
It's pretty cool, but i need only in SQL, that too same number for all records
for same employee and next incremental number for all records of the another
employee.
SET any help offered ?
Thanks In Advance.
With Best Regards.
Vishal
On Saturday, 14 March 2015 5:01 PM, "'Louis
Dear All,
I am using Firebird 2.5 database.
I have a table that has column of type Blob field, this table also contains
some other columns.
The issue is, I had total 78,000 records in this table. What I did is as every
record was containing image in it, I then ran an update query and set Null
va
Operating system I am using is Windows 7
With Best Regards.
Vishal
Then what could be the best way to reduce the database size?
All suggestions are appreciated.
With Best Regards.
Vishal
Hi All,
Is there any tool available which would show the relationship/linking between
tables for Firebird database ?
Thanks In Advance.
With Best Regards.
Vishal
Thank You Martijn.
Anybody knows any other tools for the same purpose?
On Wednesday, 15 April 2015 2:55 PM, "'Martijn Tonies (Upscene
Productions)' m.ton...@upscene.com [firebird-support]"
wrote:
Hello Vishal,
>Is there any tool available which would show the relationship/l
Hi All,
I have below SQL and DDL of respective columns used in this SQL.
Below sql takes 6-7 seconds to give the result.
Would it be possible to bring the output time to 1 seconds, coz there are some
other operartion I need to perform based on this sql output withing short
period of time.
SQL:
April 2015 3:24 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Hi All,
I have below SQL and DDL of respective columns used in this SQL.
Below sql takes 6-7 seconds to give the result.
Would it be possible to bring the output time to 1 seconds, coz t
_JOB_ITEMS
from CRM_JOB_ITEMS where PK_JOB_ITEMS = CRM_DOCUMENT_ITEMS.FK_JOB_ITEM
and FK_JOB = '{8BDDED49-8509-48C1-A169-B7E68A74C230}' ROWS 1)
Cheers
Rob
On 16/04/2015 9:54 a.m., Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> Hi All,
>
> I have below SQL
@Rob: Ya, this field is already a primary key in the same table and there a
separate index created on this single column.
On Thursday, 16 April 2015 9:58 AM, "Virgo Pärna virgo.pa...@mail.ee
[firebird-support]" wrote:
On Wed, 15 Apr 2015 21:54:32 +0000 (UTC), Vis
@Virgo Pärna: No speed improvement.
On Thursday, 16 April 2015 12:15 PM, "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]"
wrote:
@Rob: Ya, this field is already a primary key in the same table and there
a separate index created on this single column.
Hi SET,
Nice to see you here, but I am getting below error after executing your sql, i
think group by clause is needed, would you please help?
Error:
Invalid expression in the select list (not contained in either an aggregate
function or the GROUP BY clause)
On Thursday, 16 April 2015 12
Any other way to make this more faster ? Please If possible
On Thursday, 16 April 2015 12:54 PM, "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]"
wrote:
Hi SET,
Nice to see you here, but I am getting below error after executing your sql, i
think group
Pärna virgo.pa...@mail.ee
[firebird-support]" wrote:
On Thu, 16 Apr 2015 07:10:47 + (UTC), Vishal Tiwari
vishuals...@yahoo.co.in [firebird-support]
wrote:
>
> [-- Type: text/plain, Encoding: quoted-printable --]
>
> @Virgo Pärna: No speed improvement.
>
What
Sorry SET, but this is an existing database, I understand your point and
completely agree with you. Shall I try droping that index then ? What you
suggest ?
On Thursday, 16 April 2015 1:35 PM, "Svein Erling Tysvær
svein.erling.tysv...@kreftregisteret.no [firebird-support]"
wrote:
I tried dropping that index, but sql execution time is still same i.e. 1.893
seconds.
On Thursday, 16 April 2015 2:15 PM, Vishal Tiwari
wrote:
Sorry SET, but this is an existing database, I understand your point and
completely agree with you. Shall I try droping that index then
Hi All,
I have a Table called Table1, in that I have a column called Status which is of
type Varchar and contains values link '1', '2', '3' etc, i.e. all integer
values only but in Varchar type.
I need to change this column's datatype to Integer for some reason, any idea
how do we do it ?
I am t
Is there no Alter like SQL available ?
On Wednesday, 22 April 2015 2:01 PM, "Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]" wrote:
On Wed, 22 Apr 2015 09:28:09 +0100, "Tim Ward t...@telensa.com
[firebird-support]" wrote:
> On 22/04/2015 09:26, Mark Rotteveel m...@lawi
If I make all values to null of that column which is of type varchar and then
go for Alter, would you share the sql for it ?
On Wednesday, 22 April 2015 3:10 PM, "Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]" wrote:
On Wed, 22 Apr 2015 09:00:18 +0000 (UTC
Hi All,
I am running one SQL in that Master table has 78 thousand plus records and
detail table has 4 Laks and 3 thousand plus records. I have used Inner Join on
the primary key of Master table with the column in the Detail Table.
When I execute with small size database, but with this database wh
There is enough free disk space (2.75 GB) available.
On Monday, 8 June 2015 10:08 AM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Hi All,
I am running one SQL in that Master table has 78 thousand plus records and
detail table has 4 Laks and
ds are linked to the
master correctly (i.e. JOIN detail d ON d.ForeignkeyField =
m.primarykeyfield)
Post your SQL if you cant see the cause :)
Cheers
Rob
On 8/06/2015 4:49 p.m., Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
> There is enough free disk space (2.75 GB) avail
returning one of every detail record for
> every header (i.e. 78000 * 3000 records !)
>
> Check your query and make sure the detail records are linked to the
> master correctly (i.e. JOIN detail d ON d.ForeignkeyField =
> m.primarykeyfield)
>
> Post your SQL if you can
7;t know what the error message is, you didn't include it! but it is
>> likely your join is wrong and returning one of every detail record for
>> every header (i.e. 78000 * 3000 records !)
>>
>> Check your query and make sure the detail records are linked to the
is sufficient.
What you say ?
On Monday, 8 June 2015 2:27 PM, "'Thomas Steinmaurer'
t...@iblogmanager.com [firebird-support]"
wrote:
Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] schrieb am
08.06.2015 10:16:
> Hi Thomas Steinmaurer,
> I
Hi All,
I am not sure whether this question is suitable here or not, but still I would
like to give a try.
I am using Delphi 2010 with FIB Components like TpFIBDataset, TpFIBTransaction
and TpFIBDataset with Firebird database.
I have already set TpFIBDataset's 'AutoCommit' property to 'False', t
Thank You so much Helen :)
Cheers...
On Thursday, 11 June 2015 3:19 PM, "Helen Borrie hele...@iinet.net.au
[firebird-support]" wrote:
At 09:17 p.m. 11/06/2015, Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support] wrote:
>Hi All,
>
>I am not sure wheth
Hi All,
Is there any limitation on number of times I could run Delete command on any
user defined table ? And then to rest the system table flag I need to do some
activity and then again Firebird allows to delete the records on the same table
?
Thanks In Advance.
With Best Regards.
Vishal
Hi Helen, Hi All,
I have one issue with the transaction, let me explain in detail what is
happening...
I am using Delphi 2010 with FIB Plus components ( TpFIBDatabase,
TpFIBTransaction and TpFIBDataSet ), and Firebird as database.
Case 1:
I have an existing customer's database, on which Commit i
database). And use the start, commit, rollback
methods of the transaction component. Further, you must assign the transaction
component before you do any operations.
Enjoy !!!
On Thursday, 18 June 2015 5:15 PM, "Vishal Tiwari vishuals...@yahoo.co.in
[firebird-support]" wrote:
Hi All,
I have below SQL, which is concatenating the ShortCode column data, but without
ordering as per the ORDER_NUMBER column in ABC table in "WITH" clause.
Please help.
With TBL_SHORT_CODE (SHORT_CODE, FK_KEY) As (SELECT Distinct(XYZ.SHORT_CODE) As
SHORT_CODE, ABC.FK_KEY From ABC Join XYZ On
Even if I don't use Distinct, i don't get expected result.
On Friday, 3 July 2015 7:17 PM, "Mark Rotteveel m...@lawinegevaar.nl
[firebird-support]" wrote:
On Fri, 3 Jul 2015 12:15:31 + (UTC), "Vishal Tiwari
vishuals...@yahoo.co.in [firebird-suppor
Hi SET,
You have done it this time too
Your SQL worked with a small amount of change in below statement
DECLARE VARIABLE FK_BOM2 VARCHAR(2000);
Because FK_BOM2 is of GUID type.
You are awesome as usual.
I would like to say Thank You from bottom of HEART
Thanks Once Again SET... You A
1 - 100 of 109 matches
Mail list logo