Hello, On Fri, 31 Oct 2003 23:31:11 -0000, rockwithme77 wrote: r> Hi Milan and Olivier once again, r> r> If and when IBPP supports the full range of dates,...
Hello, On Sat, 01 Nov 2003 10:03:59 +0100, Olivier Mascia wrote: OM> r> If and when IBPP supports the full range of dates, where can I get to OM> r> know about...
Hello Steve, ... We have an application deployed on hundreds of sites for 3 years and running against IB 6. Each month, a pump script updates/creates/deletes...
there is a FB database on a Linux remote server. From a remote PC, I'd like to async connect to the server, assign a time consuming batch job, disconnect, wait...
Hello I get a char(10), called dep_date, as input to a stored procedure. the format of the value is YYYY-MM-DD. How do I allocate a new var in the SP and set...
Datatal AB - Gauffin,...
jonas@...
Nov 1, 2003 11:35 am
31783
... declare the local var as a DATE type: .. declare variable DateVar DATE; ... DateVar = cast(dep_date as DATE) - 1; ... Language Reference book (LangRef.pdf)...
Hi, What is the appropiate character set if I am to store spanish strings with accented vowels and other spanish special characters? (é, á, ñ, etc). Sorry...
... I've heard that ISO8859_1 with the ES_ES collation sequence works well. Or you could try WIN1252 with the PXW_SPAN collation... Or you could be patient...
Hi, I have a question on Embedded Firebird database. Basically, we may create an embedded firebird database and create some table on it. From the OS point of...
... For connecting to Embedded, you use only the path. ... Accessing a database in a memory stream isn't "normal" for DBX. What do you actually mean by "access...
I like the idea of being able to use FB as an embedded database. First, where can I read up on the "meat" of doing this? Can I use the embedded DB on a...
... Release notes for v. 1.5 (embedded server isn't available prior to 1.5). ... All in the release notes. :-) Currently available (not yet release-ready) ...
... As normal means I can use TSQLDataSet to access the database. ... I use the embedded firebird database to store some sensitive data. When I release the...
Greetings, I really like Firebird/Interbase for it ease of use and the fact that a Database administrator is not required. However there are a few things that...
Hi Michael, ... that ... It has come this far (about 18 yrs, I believe) without em. Which does NOT mean it cannot be supported, or no-one needs them - but to...
Sorry Martijn, ... Hey don't get me wrong, I am a register user of this very fine product and use it all day long, every day and it is an indispensable tool in...
Too week for business ? Just a good joke - we run IB for 10 years - with a 4GL a survived all thinkable catastrophes even a hard disk crash - we cd solve...
Clausheeg
heeg.c@...
Nov 2, 2003 1:39 pm
31797
Hello I got a trigger (before delete) on a table called bokning. I got a identical table called bokning_historik that all old entries should be moved to by the...
Datatal AB - Gauffin,...
jonas@...
Nov 2, 2003 1:45 pm
31798
... Ah, no need - I wrote a ":-)" behind it... Just joking around. ... product. ... then ... I know what you mean - pretty much any user can now view schemata...
... Hmmm, the document just solves privileges problems, it is not bound to any specific method (i.e. it is usable with GSEC, old User API, new Services API,...
... No TIS-620/ISO-8859-11 is included, last time I looked. But thanks to the fine documentation at: http://www.nectec.or.th/it-standards/thaistd.pdf ...
Would it be feasable to expect a global field rename. The alter Table FieldName to FieldNewName works great, as long the FieldName isn't used in some...
Hans Hoogstraat
hans@...
Nov 2, 2003 5:41 pm
31802
Yves, ... Step 1 -- Create select SP CREATE PROCEDURE GET_LAST_4_ENTRIES ( EmployeeName VarCHAR( 80) ) RETURNS ( datetime date, blabla bla ) AS BEGIN For ...
Hi Jonas, ... What did you have choosen on delete? If you have choosen cascade, then there is no need to delete the row in bokning_passagerare. That is done...
Walter Neumann
walter@...
Nov 2, 2003 7:20 pm
31805
... While I would mostly agree with this, I prefer to use fiscal year archives. I have developed the simple code necessary to do multi-database queries that ...
... Yes, I can state ISO8859_1 with ES_ES collation works fine. ... -- Jaume Andreu Sabater Malondra jsabater@... http://www.linuxsilo.net "Ubi...
Jaume Sabater
jsabater@...
Nov 2, 2003 8:28 pm
31807
I would like to add my 2 bits. I have found that MS SQL server has some draw backs. The data types TIME and DATE are supported by interbase and not SQL server....
