I'm new to Interbase so I hope this is an intelligent question! The TQuery component in Delphi 5 offers a RequestLive property so that you can return a "live"...
134
Helen Borrie
helebor@...
Oct 2, 2000 11:42 pm
... Actually, TIBQuery is only the IBX counterpart of TQuery. The IBObjects counterparts of TQuery (TIBOQuery for TDataset compatibility and TIB_Query for...
135
Michael Bohl Jenner
mj@...
Oct 3, 2000 2:00 pm
Dear Group, Any hints on how to move data from .mb (Paradox files for binary picture data) to Interbase blob fields ? Thanks in advance, Michael...
136
mss@...
Oct 3, 2000 2:26 pm
... Helen, There is no such animal as forums.inprise.com. The nearest I could find is borland.public.delphi.database.interbaseexpress. - Dale Francis....
137
Doug Chamberlin
dchamberlin@...
Oct 3, 2000 2:29 pm
... The server is actually forums.borland.com but I see you found the group Helen was referring to....
139
Claudio Valderrama C.
cvalde@...
Oct 4, 2000 5:05 am
I think you could simply load the BLOB from the source and feed it into a parameterized insert or update SQL command, depending on whether you already moved...
140
Michael Melling
michael.melling@...
Oct 5, 2000 11:02 am
I am a relative novice when it comes to database design and management. I work for a company of 15-20 people, which uses a Novell NetWare 5 network and relies...
141
Helen Borrie
helebor@...
Oct 5, 2000 12:40 pm
... No: nobody knows. There is a project under way on Firebird but so far no indication of when a test kit will be available. ... Probably not advisable....
142
Michael Melling
michael.melling@...
Oct 6, 2000 3:03 pm
thankyou for all your comments Michael Melling +44 (0)20 7375 3211 This email, and any attachments it may contain, is confidential and is intended only for the...
143
mj@...
Oct 17, 2000 6:43 am
Does this mean: (1) I need to find the original .gif files (which currently seems to be the only supported format by Paradox) (2) Write e.g. a c program with...
144
Helen Borrie
helebor@...
Oct 17, 2000 11:51 am
... No! all you need is a binary stream from blob to blob. ... Hmm, if you must. ... ..all this if C is your only programming tool. ... If you mean, has...
145
mj@...
Oct 17, 2000 3:37 pm
... yes, ... out. This was exactly what I meant. I wonder why the Interbase people haven't made such a tool available? ... it seems like a must if you want to...
146
Doug Chamberlin
dchamberlin@...
Oct 17, 2000 3:54 pm
... I'm confused by this message thread. I have used Paradox itself to transfer/load/update blob fields between Paradox tables and Interbase tables for a long...
147
Helen Borrie
helebor@...
Oct 18, 2000 1:07 am
... Oh - I never considered using the Paradox IDE for this - and didn't recommend the DBD until I knew whether the inquirer had Delphi/CPPB. But, since the...
148
Marcos Fabiano Mendes...
marcosf@...
Oct 27, 2000 12:52 pm
Good Morning ! How I can convert a syntax Sybase to Interbase ? For ex: NULLIF(variable,0) This syntax verify if a variable is null, if true, then variable...
149
Helen Borrie
helebor@...
Oct 27, 2000 1:37 pm
... InterBase doesn't support NULLIF yet (but it is early on the Agenda for the first Firebird release). You can handle it in a stored procedure pretty easily....
150
Helen Borrie
helebor@...
Oct 27, 2000 1:39 pm
Oh, and please don't post HTML to the list. The adverts are bad enough, without getting them in technicolor. Thanks. Helen (wearing Moderator hat) All for Open...
151
Marcos Fabiano Mendes...
marcosf@...
Oct 27, 2000 4:56 pm
Hello! What´s a syntax for stored procedure ? Because I am use the syntax below and the Interbase show me one error "Token unknown - END" CREATE PROCEDURE...
152
Ann Harrison
harrison@...
Oct 27, 2000 5:10 pm
... In ISQL the syntax for defining a procedure is this: set term !!; create procedure <whatever> [(input params)] [returns (output params)] as [variable...
153
Marcos Fabiano Mendes...
marcosf@...
Oct 27, 2000 5:16 pm
ok, thanks ... From: Ann Harrison <harrison@...> To: <IB-Conversions@egroups.com>; <IB-Conversions@egroups.com> Sent: Sexta-feira, 27 de...
154
Marcos Fabiano Mendes...
marcosf@...
Oct 27, 2000 5:17 pm
Hello! What´s a syntax for stored procedure in Interbase ? Because I am use the syntax below and the Interbase show me one error "Token unknown - END" CREATE...
155
Claudio Valderrama C.
cvalde@...
Oct 28, 2000 1:22 am
PLEASE POST IN PLAIN TEXT, NOT IN HTML. Download the IB6 documents that exist as a ZIP file on interbase.com site where you probably downloaded IB6. C....
156
Marcos Fabiano Mendes...
marcosf@...
Oct 30, 2000 4:49 pm
Hello! I am run the procedure below and Interbase show me this message : "Statement failed, SQLCODE = -104 Dynamic SQL Error -SQL error code = -104 -Token...
157
Helen Borrie
helebor@...
Oct 31, 2000 1:30 am
... Every statement needs to end with a semi-colon. CREATE PROCEDURE Procedure1 AS BEGIN select * from table ; END H. All for Open and Open for All InterBase...
158
Jean-Jacques Goldschm...
jjgoldschmidt@...
Oct 31, 2000 4:47 pm
Try this : SET TERM !! CREATE PROCEDURE Procedure_1 AS BEGIN SELECT * FROM MyTable ; END!! With best regards Avec mes meilleures salutations Mit freundlichen...
159
Claudio Valderrama C.
cvalde@...
Nov 1, 2000 1:52 am
Please use PLAIN TEXT and not HTML for Interbase emailing lists and newsgroups. ... This list is ONLY for conversions from your rdbms X to Interbase. A general...
160
Andrew Gould
andrewgould@...
Nov 6, 2000 7:27 pm
I am thinking about converting a Decision Support database from MySQL. The UPDATE statement in MySQL doesn't support updating the values in one table using ...
161
Claudio Valderrama C.
cvalde@...
Nov 7, 2000 2:47 am
... This is an invalid syntax in IB. You have two options: 1.- Normal select statement. You can do a sub-select for each field that you want to change: update...
162
Gleison
ggs@...
Nov 9, 2000 1:17 pm
I went a function like NVL(arg1,arg2) for Interbase if arg1 is null result= arg2 else result= arg1 end if; for any kind of datatype in arg1 and arg2 if you...
163
Helen Borrie
helebor@...
Nov 9, 2000 1:32 pm
... NULLIF(), right? Not currently supported, but on the Agenda for Firebird 1. Helen All for Open and Open for All InterBase Developer Initiative ·...
