Hi I am looking in a few months time at renting a linux server in a data- center to host Firebird. My current ISP has said this is a bad idea, but I would like...
I have been running 1.1 of Borland Interbase on my Solaris box and 1.5 of Firebird on ny Linux box. 1.0 of Firebird absolutely fails with a gbak (restore) of...
I haven't had any problems compiling and/or using IBPP on a Windows 2000 platform. I have not tried it on a Linux platform. I'm using Dev-Cpp (mingw32) to...
Ray, ... Unfortunately, it's true. Not everyone have enough time to participate in the project and actively follow the current development. ... No. ... I'm...
Hi, ... Actually - WHO decides that this would be the right order: 1 11 20 A AA BA ?? What kind of order is this? This is a very custom order... With regards, ...
Hi Martijn, ... I think "the right order" is what the user/programmer needs at a certain point in the application, so it varies from case to case. Todd wants a...
Hi, ... Sounds like writing a custom collation then :) This really is a weird order. Perhaps you can UDF the select and order by UDF(mycol) that returns a...
... You might want to look at some of the information at ibphoenix.com or http://www.brookstonesystems.com/ on collations. Essentially a collation is a...
I would like to do something like this: UPDATE Child SET Child.parentCount = Child.parentCount + 1 WHERE Child.id = :childId; Because I was to increment (or...
The reason I need this numerical order of a char column is because we have one codes table that includes all different kinds of codes. Some of these types of...
... My stored procedure seems to work. I am populating a double precision column with data from the char column. I check each character before adding it to...
Hi Todd, ... I liked your puzzle, so I wrote an SP that converts chars into doubles if possible, and (if necessary) ignores any trailing non-digits, so 12XB...
... No, I think you got it. 12XB returns 12, and 12.2A returns 12.2, but A1Q2U would return NULL because the first character is not numeric. ... I don't have...
... I would use another field to indicate what type of value is stored in the code field and create a two-field index. ... -- Raymond Kennington Programming...
Hi heLen, am sorry, I dint checked it. I was using IB Server and IB Guardian Service. Now I had uninstalled it and reinstalled Firebird Server. Lets see if the...
... No; but the SQL help for IB 6 plus the extra stuff in the Firebird 1 release notes (which are PDF, so you can keep them on-line) will do it for FB 1.0.x;...
Dear list, I have a file of several million records in csv style format. Is there a utility or api that will let me load these efficiently? By efficiently I ...
Hi Mark, ... Use prepared statements - that's a lot faster. If you like, you can try Database Workbench and the CSV import - see www.upscene.com for a trial...
Hi Mark, you can declare an Table as an external file and use this to import your data: create table ext_tbl external file 'file.txt' ( fname char(10), ...
Stengel Christian
christian_stengel@...
Jun 2, 2003 10:43 am
25813
Hi, I have two tables, product and temp with the following structures product ... id integer NOT NULL (PK) desc varchar(50) NOT NULL stock...
Ben Johnson
ben_johns@...
Jun 2, 2003 11:20 am
25814
... Yes and yes. Correct syntax is UPDATE product P SET P.stock = (select T.stock from temp T where P.id = T.product_id) ; where exists(select 1 from temp t2...
Hi Ben, ... you probably should only update those products with existing product related records in temp? Try: UPDATE product P SET P.stock = (select T.stock...
I am configuring ODBC firebird driver to work with Visual FoxPro, and the ODBC is correct. With IBExpert, the conexión is correct. But when try open a table...
A Firebird 1 database. It used to run very fast, lately it has become very slow. gdb is about 60 MB. I am having a copy in my developement machine and from...
Raigo Lukk
raigo.lukk.001@...
Jun 2, 2003 11:48 am
25818
... = "How long is a piece of string?" What is the SQL statement? heLen...
Hi, ... Did you check your queries and why they are slow? With regards, Martijn Tonies Database Workbench - the developer tool for InterBase & Firebird Upscene...
