RE: [firebird-support] Duplicate a set of records

>FB 1.5 > >I have a number of records in a table, that includes a BLOB field, that I need >to duplicate. >Is there an easy way of doing that? Hi Ed! This question may be understood very differently. If you want to exactly duplicate the records, I don't know how to do that. If you want to dupl

[firebird-support] Re: Cannot atach to password database

You need to include host name / IP in database connection string. Instead of "/home/XXX/database.fdb" you should use "localhost:/home/XXX/database.fdb" If you omit that, isql will access database directly (not using service). But it has no read access rights for password database (security2.fdb)

Re: [firebird-support] how to put null at the end in oder by ASC

On Tue, 30 Aug 2011 12:20:56 +0400, Vander Clock Stephane wrote: > Hello, > > how to put the num value at the end of the result (and not at the > beginning) when we are doing > > select xxx order by xxx ASC Something like: ORDER BY field ASC NULLS LAST See also section Sorts in http://www.fir

Re: [firebird-support] how to put null at the end in oder by ASC

On 8/30/2011 2:03 PM, Markus Ostenried wrote: > > On Tue, Aug 30, 2011 at 10:20, Vander Clock Stephane > mailto:svanderclock%40yahoo.fr>> wrote: > > Hello, > > > > how to put the num value at the end of the result (and not at the > > beginning) when we are doing > > > > select xxx order by xxx ASC

Re: [firebird-support] Why drop table can be sometime very very long ?

Stephane, > > > > when i do drop table, sometime it's take hours to return (especially on > > > big table) > > > why ? > > > > no, the database have only one client connected, the client that do the > drop table ... > it's not failed, it's just very very long ! > as soon as it success, creating ag

Re: [firebird-support] how to put null at the end in oder by ASC

On Tue, Aug 30, 2011 at 10:20, Vander Clock Stephane wrote: > Hello, > > how to put the num value at the end of the result (and not at the > beginning) when we are doing > > select xxx order by xxx ASC Howdy, maybe this helps: select xxx from tbl order by xxx asc NULLS FIRST Bye, Markus

[firebird-support] Bug in V2.6.5 on parameterized query?

Hi, I'm using V2.6.5 with .NET 3.5. I've got a simple query like: SELECT * FROM MailObject WHERE MailBody like '%123456%' MailBody is a column of type "Blob SUB_TYPE BINARY". The query is composed using parameters in the "FbCommand": using (command = new FbCommand("SELECT * F

[firebird-support] how to put null at the end in oder by ASC

Hello, how to put the num value at the end of the result (and not at the beginning) when we are doing select xxx order by xxx ASC thanks by advance stéphane

Re: [firebird-support] Why drop table can be sometime very very long ?

On 8/29/2011 9:44 AM, Thomas Steinmaurer wrote: > > > when i do drop table, sometime it's take hours to return (especially on > > big table) > > why ? > > Are you perhaps running the DROP TABLE statement in a transaction with > the WAIT option, while the table is in use by concurrent transactions

[firebird-support] Duplicate a set of records

FB 1.5 I have a number of records in a table, that includes a BLOB field, that I need to duplicate. Is there an easy way of doing that? Ed Dressel

[firebird-support] Re: Cannot atach to password database

--- In firebird-support@yahoogroups.com, Roland Turcan wrote: > > Hello All, > > I have installed new fresh ubuntu server where I installed Firebird > 2.1 Classic server, but I am unable to create any database. > Using [isq-fb -user SYSBDA -password masterkey] then [create database > "test.fdb"

[firebird-support] Re: ERROR: COLLATION UNICODE_CI_AI for CHARACTER SET UTF8 is not installed

Thank you for your answer Michael. I will ask the customer to do that and I will let you know the result. Best regards, Guylain

RE: [firebird-support] Need help

Hi Mark, It is working , thanks a lot for your valuable effort. Thanks mahesh From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of m...@lawinegevaar.nl Sent: Tuesday, August 30, 2011 1:15 PM To: firebird-supp

RE: [firebird-support] RE: Need help

On Tue, 30 Aug 2011 13:54:28 +0530, "Mahesh Pratihari" wrote: > Hi, > > > > While removing the semicon, it is asked for use connect or create > database to specify a database though I have specify the database > .please find the screen shot below >>>isql.exe -database > BG4WS0531:D:\RiTEQFir

RE: [firebird-support] RE: Need help

Hi, While removing the semicon, it is asked for use connect or create database to specify a database though I have specify the database .please find the screen shot below Thanks Mahesh From: firebird-support@yahoogroups.com [mailto:firebir

[firebird-support] RE: Need help

>>isql.exe -database BG4WS0531:D:\RiTEQFireBird\FB_Backup\TIMETEQ-FIREBIRD-28082011-CLEAN.fdb -user 'sysdba' -password 'masterke' -i c:\Scripts\spLabourBudget_Assign.sql; >>while executing the script I am getting "Unable to open >>c:\Scripts\spLabourBudget_Assign.sql;" , please guide me why I

Re: [firebird-support] Need help

On Tue, 30 Aug 2011 12:56:44 +0530, "Mahesh Pratihari" wrote: > I am writing the script like this > > cd C:\Program Files\Firebird\Firebird_2_5\bin > > isql.exe -database > BG4WS0531:D:\RiTEQFireBird\FB_Backup\TIMETEQ-FIREBIRD-28082011-CLEAN.fdb > -user 'sysdba' -password 'masterke' -i > c

[firebird-support] Need help

Hi, I am using firebird 2.5 and I want to generate one batch script like MS SQL which will execute the store proc automatically while executing the script. I am writing the script like this cd C:\Program Files\Firebird\Firebird_2_5\bin isql.exe -database BG4WS0531:D:\RiTEQFir