Re: [firebird-support] Working with SQL (might be using loop)

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

[firebird-support] Re: URGENT - Database performance is very slow

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... We

[firebird-support] Re: URGENT - Database performance is very slow

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 SQL i.e

Re: [firebird-support] Getting Group By subtracting total for every record in the group

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] <firebird-support@yahoogroups.com> wrote: 19.05.2018 17:12, Vishal Tiwari vishuals...@yahoo

[firebird-support] Getting Group By subtracting total for every record in the group

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

Re: [firebird-support] Book on T-SQL

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] <firebird-support@yahoogroups.com> wrote:   On 2018-04-18 12:24, Vishal Tiwari vishuals...@yahoo.co.in [fi

Re: [firebird-support] Book on T-SQL

. On Wednesday, 18 April, 2018, 1:32:25 PM IST, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] <firebird-support@yahoogroups.com> wrote:   On 2018-04-18 08:57, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Hi Edward Mendez, > > I totally

Re: RE: [firebird-support] Book on T-SQL

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

[firebird-support] Book on T-SQL

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

[firebird-support] Does Locking Stored Procedures Also Locks Tables Inside It?

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

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

;Paul Vinkenoog p...@vinkenoog.nl [firebird-support]" <firebird-support@yahoogroups.com> 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 Au

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

I have put table name as Table_Name, which is actual table name. On Wednesday, 9 August 2017 3:27 PM, Vishal Tiwari <vishuals...@yahoo.co.in> wrote: Hi Paul, I am getting below error while executing the trigger you shared. May be because of new FB version? I am executing

Re: [firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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

[firebird-support] Re: On Updating One Column Value, Update Time Stamp in Another Column

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 <vishuals...@yahoo.co.in> wrote: Hi All, I have one issue to share with you. I have one table say "MyTable", which

[firebird-support] On Updating One Column Value, Update Time Stamp in Another Column

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

Re: [firebird-support] How to get different Maximum Data for every single date in the table?

is a huge table. I 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

Re: [firebird-support] Doubt (Problem) In Writing SQL

<firebird-support@yahoogroups.com> 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 logi

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

y, 18 July 2017 11:18 PM, "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com> 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. Visha

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

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]" <firebird-support@yahoogrou

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

@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 <vishuals...@yahoo.co.in> wrote: Hi Mark, Kindly don't get me rude h

Re: [firebird-support] Re: How to get different Maximum Data for every single date in the table?

eel m...@lawinegevaar.nl [firebird-support]" <firebird-support@yahoogroups.com> 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

[firebird-support] Re: How to get different Maximum Data for every single date in the table?

HI SET, Please help. Thanks In Advance. With Best Regards. Vishal On Monday, 17 July 2017 4:04 PM, Vishal Tiwari <vishuals...@yahoo.co.in> 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, Orde

[firebird-support] How to get different Maximum Data for every single date in the table?

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

Re: [firebird-support] Doubt (Problem) In Writing SQL

:59 PM, "setysvar setys...@gmail.com [firebird-support]" <firebird-support@yahoogroups.com> 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_DETA

Re: [firebird-support] Doubt (Problem) In Writing SQL

BLISH_DATE    ) BSD2    ON     BSD1.PUBLISHER = BSD2.PUBLISHER And BSD1.MAIN_BRACH = BSD2.MAIN_BRACH And BSD1.PUBLISH_DATE = BSD2.PUBLISH_DATE And BSD1.BOOK_NO = BSD2.BOOK_NO         Group By BSD1.PUBLISHER, BSD1.MAIN_BRACH, BSD1.PUBLISH_DATE, BSD1.BOOK_NO  ) BSD3ON BSD.BOOK_NO = BSD3.BOOK_NO

Re: [firebird-support] SQL output required in vertical format

THEN 1 ELSE 0 END) AS Brn5 FROM SalesDetails WHERE dtDate BETWEEN :FromDate and :ToDate GROUP BY 1 Mixing these two together should not be all too difficult, you just need separate referenced to SalesDetails and expand the GROUP BY. HTH, Set -----Original Message- From: firebird-support

Re: [firebird-support] Cursor not Executing Properly

OW_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] <firebird-support@yahoogroups.com>: Hi All,  I have created the below cursor on Firbird DB (ver

[firebird-support] Cursor not Executing Properly

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

Re: Re: [firebird-support] Steps to Set Wait/No Wait Transaction

sgoogle for each value regards,Karol Bieniaszewski   W dniu 2017-01-13 07:08:19 użytkownik Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] <firebird-support@yahoogroups.com> napisał:  I am using TIBSQL, TIBDatabase and TIBTransaction components. This code is not fitting there. Would

Re: [firebird-support] Steps to Set Wait/No Wait Transaction

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:

[firebird-support] Steps to Set Wait/No Wait Transaction

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    

Re: [firebird-support] Insert SQL Deadlock Issue

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]" <firebird-support@yahoogroups.com> wrote:   @WBR: Are you saying, the fbclient.dl

Re: [firebird-support] Insert SQL Deadlock Issue

2017 9:09 AM, "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com> wrote:   Any other way? On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" <firebird-support@yahoogrou

Re: [firebird-support] Insert SQL Deadlock Issue

Any other way? On Wednesday, 4 January 2017 6:11 PM, "Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]" <firebird-support@yahoogroups.com> wrote: 04.01.2017 13:36, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: > Error 3: > *validatio

Re: [firebird-support] Insert SQL Deadlock Issue

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]" <firebird-support@yahoogroups.com> wrote:   Hi All,  At production department, we are receiv

[firebird-support] Insert SQL Deadlock Issue

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

Re: [firebird-support] Cannot Create Index

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

Re: [firebird-support] How To Speed Up Update SQL

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,

Re: [firebird-support] How To Speed Up Update SQL

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]" <firebird-support@yahoogroups.com> wrote:   Yes..  YOU ROCKS SET AS USU

Re: [firebird-support] How To Speed Up Update SQL

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]" <firebird-support@yahoogroups.com> wrote:   HI SET, PK is GUID type.

[firebird-support] How To Speed Up Update SQL

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

Re: [firebird-support] Cannot Create Index

Many Thanks, Done it... On Wednesday, 14 October 2015 11:51 PM, "Mark Rotteveel m...@lawinegevaar.nl [firebird-support]" <firebird-support@yahoogroups.com> wrote:   On 14-10-2015 07:18, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: &

Re: [firebird-support] How To Speed Up Update SQL

ahoogroups.com> wrote:   Hi, you 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.c

Re: [firebird-support] Cannot Create Index

page size? What is the collation of that field? Try 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

Re: [firebird-support] Cannot Create Index

e page size when restoring it.  Regards, Neil Pickles – n...@csy.co.uk - Reply message ----- From: "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com> To: "firebird-support@yahoogroups.com" <firebird-support@yahoogroups.com>

Re: Re: [firebird-support] How To Get Entire Linked Group Details

entire structure details, one way that is correct, 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 vishu

Re: Re: [firebird-support] How To Get Entire Linked Group Details

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]" <firebird-support@yahoogrou

Re: Re: [firebird-support] How To Get Entire Linked Group Details

correct, 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]&q

Re: Re: [firebird-support] How To Get Entire Linked Group Details

d 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]" <firebird-support@yaho

Re: [firebird-support] How To Get Entire Linked Group Details

Hi SET, Could you please help me ? With Best Regards. Vishal On Friday, 2 October 2015 10:11 AM, "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" <firebird-support@yahoogroups.com> wrote:  In tree format, the logical structure looks like as belo

Re: Re: [firebird-support] How To Get Entire Linked Group Details

tps://firebird21.wordpress.com/2015/09/05/ejemplo-de-recursion-6-repitiendo-las-filas/ Greetings. Walter. On Fri, Oct 2, 2015 at 7:52 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] <firebird-support@yahoogroups.com> wrote:   Hi Karol Bieniaszewski, Yess, YOU ARE THE MA

Re: Re: [firebird-support] How To Get Entire Linked Group Details

o 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]" <firebird-support@yah

Re: Re: [firebird-support] How To Get Entire Linked Group Details

G1_PARENT GP ON RT2.PARENT=GP.DESCRIPTION  INNER JOIN MYGROUP TT2 ON TT2.PK_GROUP=RT2.A  with this query i got the same result as you showed in table below  regards,Karol Bieniaszewski  W dniu 2015-10-02 06:36:16 użytkownik Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] <firebird-support@y

[firebird-support] How To Get Entire Linked Group Details

Hi All,  I have attached a table DDL and Insert  record script in "Table Script.txt" text file. And also attached a snap of how data looks in the table in the file "Entire Table Data.png" I need to get all the details for the main group called "Vishal Group1", please refer "Expected

Re: [firebird-support] How To Get Entire Linked Group Details

hich falls under 'Vishal Group1' because he is the base group.) if that group is not used in specific table then I would delete that record from respective table. Please help.  Thanks In Advance. With Best Regards. Vishal On Thursday, 1 October 2015 6:29 PM, "Vishal Tiwari vishuals

Re: [firebird-support] How To Get Entire Linked Group Details

is the base group.) if that group is not used in specific table then I would delete that record from respective table. Please help.  Thanks In Advance. With Best Regards. Vishal On Friday, 2 October 2015 10:06 AM, "Vishal Tiwari vishuals...@yahoo.co.in [firebird-support]" <fir

Re: [firebird-support] Order By Not Working Using WITH Clause

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

Re: [firebird-support] Commiting Data is Not Working

the 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] firebird-support

[firebird-support] Commiting Data is Not Working

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

Re: [firebird-support] Rolling back Transaction Doesn't Work with TpFIB Components

Thank You so much Helen :) Cheers... On Thursday, 11 June 2015 3:19 PM, Helen Borrie hele...@iinet.net.au [firebird-support] firebird-support@yahoogroups.com wrote:   At 09:17 p.m. 11/06/2015, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] wrote: Hi All, I am not sure

[firebird-support] Rolling back Transaction Doesn't Work with TpFIB Components

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',

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

* 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 cant see the cause :) Cheers Rob On 8/06/2015 4:49 p.m., Vishal Tiwari vishuals...@yahoo.co.in

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

(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) available. On Monday, 8 June 2015

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

say ?   On Monday, 8 June 2015 2:27 PM, 'Thomas Steinmaurer' t...@iblogmanager.com [firebird-support] firebird-support@yahoogroups.com wrote:   Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] schrieb am 08.06.2015 10:16: Hi Thomas Steinmaurer, I have given temporary

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

the detail records 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

Re: [firebird-support] Error While Executing Simple Inner Join SQL With Big database

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] firebird-support@yahoogroups.com wrote:   Hi All, I am running one SQL in that Master table has 78 thousand plus records and detail table

[firebird-support] Error While Executing Simple Inner Join SQL With Big database

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

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

09:00:18 + (UTC), Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote: Is there no Alter like SQL available ? There is, but it doesn't support conversion from (VAR)CHAR to INTEGER. The conversion isn't done at ALTER time, but when the field

Re: [firebird-support] How To Change Column DataType From Varchar To Integer ?

Is there no Alter like SQL available ? On Wednesday, 22 April 2015 2:01 PM, Mark Rotteveel m...@lawinegevaar.nl [firebird-support] firebird-support@yahoogroups.com wrote:   On Wed, 22 Apr 2015 09:28:09 +0100, Tim Ward t...@telensa.com [firebird-support]

[firebird-support] How To Change Column DataType From Varchar To Integer ?

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

Re: [firebird-support] Re: Need Speed Optimization for SQL

+ (UTC), Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote: SELECT   Sum(CRM_DOCUMENT_ITEMS.QUANTITY) AS Delivered,   CRM_DOCUMENT_ITEMS.FK_JOB_ITEM FROM   CRM_DOCUMENT_ITEMS   INNER JOIN CRM_DOCUMENT_HEADER

Re: [firebird-support] Re: Need Speed Optimization for SQL

@Virgo Pärna: No speed improvement. On Thursday, 16 April 2015 12:15 PM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote:   @Rob: Ya, this field is already a primary key in the same table and there a separate index created

Re: [firebird-support] Need Speed Optimization for SQL

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] firebird-support@yahoogroups.com wrote:   Hi SET, Nice to see you here, but I am getting below error after executing your sql, i

Re: [firebird-support] Need Speed Optimization for SQL

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

Re: [firebird-support] Re: Need Speed Optimization for SQL

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 vishuals...@yahoo.co.in wrote: Sorry SET, but this is an existing database, I understand your point and completely agree with you. Shall I try

Re: [firebird-support] Re: Need Speed Optimization for SQL

...@mail.ee [firebird-support] firebird-support@yahoogroups.com wrote:   On Thu, 16 Apr 2015 07:10:47 + (UTC), Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com wrote: [-- Type: text/plain, Encoding: quoted-printable --] @Virgo Pärna: No speed

Re: [firebird-support] Re: Need Speed Optimization for SQL

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]

Re: [firebird-support] Need Speed Optimization for SQL

3:24 AM, Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com 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

[firebird-support] Need Speed Optimization for SQL

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:

Re: [firebird-support] Need Speed Optimization for SQL

AND EXISTS(select PK_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

[firebird-support] Table Relationship Tools

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

Re: [firebird-support] Table Relationship Tools

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] firebird-support@yahoogroups.com wrote:   Hello Vishal, Is there any tool available which

Re: [firebird-support] Database Size Is Not Reducing

Then what could be the best way to reduce the database size? All suggestions are appreciated. With Best Regards. Vishal

Re: [firebird-support] Database Size Is Not Reducing

Operating system I am using is Windows 7 With Best Regards. Vishal

[firebird-support] Database Size Is Not Reducing

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

Re: Odp: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause?

, Karol Bieniaszewski - Reply message - Od: Vishal Tiwari vishuals...@yahoo.co.in [firebird-support] firebird-support@yahoogroups.com Do: firebird-support@yahoogroups.com firebird-support@yahoogroups.com Temat: [firebird-support] How To Display Null Values At the End For More Than One

Re: [firebird-support] How To Generate Auto Increment Number in SQL Itself ?

Just for your information, I have EmpCode column in my SQL On Friday, 13 March 2015 6:13 PM, Vishal Tiwari vishuals...@yahoo.co.in wrote: Hi Louis, One little bit advance question with respect to my previous question. Say for example, my sql returns total 100 records

Re: [firebird-support] How To Display Null Values At the End For More Than One Columns Specified in Order By Clause?

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]

Re: [firebird-support] How to connect Firdbird Database to ASP.NET 2010 (C#) Web Application

to ASP.NET 2010 (C#) Web 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

[firebird-support] How to connect Firdbird Database to ASP.NET 2010 (C#) Web Application

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

Re: [firebird-support] Re: Desktop Application For Centralized Firebird Database...

But if I have internet not an Intranet facility, then also would it work ? From: Aage Johansen aagjo...@online.no To: firebird-support@yahoogroups.com Sent: Friday, 7 September 2012 2:24 AM Subject: [firebird-support] Re: Desktop Application For Centralized

[firebird-support] Desktop Application For Centralized Firebird Database...

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.