... Yes, that looks like a really good idea. I don't know how hard it would be to implement, but I think it is worth entering in the feature-requests tracker. ...
Hi, I would like to write a Firebird SP that will insert system date and time into 2 fields of changed record into some table. What is syntax for this SP? ...
... You use context variables: CURRENT_DATE CURRENT_TIME and the date literal 'NOW' CURRENT_TIME will return the same time for all records affected by a single...
Hi guys, I keep getting the error in the subject line with my stored procedure. Here is the code, hope you guys can help me work out something :-) CREATE TABLE...
... Why are you specifying a segment size? Not sure if that is the actual problem but I would get rid of those designations since you don't declare the fields...
Hey Woody, It was included automatically in the code by EMS SQL Manager, the client program I'm using to manage my DB. I've tried removing it but it doesn't...
... Well, since you never listed the entire DML for the tables, it's hard to guess what the field types are. You might have a problem multiplying and dividing...
Hi all, I have the feeling my broblem was (is) related to http://tracker.firebirdsql.org/browse/CORE-1575 http://tracker.firebirdsql.org/browse/CORE-1477 ...
Hi, for conversion from BLOB to string you can use SUBSTRING function SELECT CAST(SUBSTRING(data FROM 1) AS VARCHAR(40)) FROM ProductTypeData data is BLOB...
Slavomir Skopalik
skopalik@...
Apr 1, 2008 5:16 pm
93285
Dear Slavek, I'll try your suggestion. But why do I have to convert the blob to varchar? Can't stored procedures return blob data type variables? Thanks!...
Dear Woody, Here is the declaration of the other table: CREATE TABLE INVOICEITEMS ( ITEMID INTEGER NOT NULL, INVOICEID INTEGER NOT NULL, QUANTITY INTEGER NOT...
Hi, you must elaborate your code and find point where blob is converted to varchar or numeric. Probably in group by. Also using blob (or varchar) in group by...
Slavomir Skopalik
skopalik@...
Apr 1, 2008 6:54 pm
93288
... I think "group by" (or sorting) on blob fields may be allowed/disallowed/fail depending on Firebird version. Review Slavomir's suggestion so that grouping...
... CURRENT_DATE and CURRENT_TIME can be used for this. Any reason to split this into two fields though? CAVEAT: Firebird will return for you the local time,...
Hi all, I have come across a problem whereby I am unable to write utf-8 strings to the database. I have created the database using the utf8 character set, but...
found it, I needed to install compat-libstdc++-33-3.2.3-62.i386.rpm instead, note very slight difference in the name ... [Non-text portions of this message...
Hi, ... Use the SET GENERATOR statement. You have to figure out the ID numbers by yourself though, as a "generator" by itself has nothing to do with a "table"....
Hi, I have procedure that pass all generators, get max(id) from table connected to generator and set generator value. This is good procedure when empy table or...
... Is you software for a single user, or does it require concurrency (loads of users at the same time)? It is not a really good idea to mess with generators...
I think you can do something like SELECT GEN_ID(gen_table1_id, (select max(id) from table1) - GEN_ID(gen_table1_id, 0)) FROM rdb$database to set the generator...
Dear All, Is anybody got these eror while compiling DBD-InterBase-0.46.tar.gz? The exception error alarmed while I run make test. install_driver(InterBase)...
