Dear Dmitry. I tried to do like this, just inserting the code for Tb001_codigo_posicao,
but when it tries to commit, the error appears again. I'm becoming...
... Without going into your horrendously complicated code, may I suggest that you simply use the standard way to acquire a new generator value for a dataset? ...
This property seems to be set to cpLocal by default. I wonder if it would be advisable to have this set to cpTCP_IP as the default. The reason I ask is...
I am using Firebird hooked to tIboDatabase, compiled with Delphi 6. Since my new server will have its FireBird connection at a location that is different from...
Jack Cane, PhD
jcane@...
May 2, 2004 3:08 am
30755
... ok, if you are using Firebird 1.5, I STRONGLY advise using the database aliasing feature. This allows you to softcode the hard path part in your ...
Delphi 5, IBO 4.3.A, Firebird 1.5 What's the relationship between a db commit and forced writes? If forced writes is true, what does db commit do? Does it make...
Ross Garbig
ross@...
May 2, 2004 9:41 am
30757
Ross, ... Commit makes your changes visible to any other transaction, be it within your program or within another. ForcedWrites=TRUE forces the server to write...
Delphi 5, IBO 4.3.A, Firebird 1.5, TIBOxxxx If there are multiple active transactions within a program and a db commit is issued for one transaction what...
Ross Garbig
ross@...
May 2, 2004 10:27 am
30759
... It depends on the transaction isolation of the other transactions. If the TI of another transaction is ReadCommitted (tiReadCommitted in IBO) it will see...
Helen, Searched my disc and the IBO help file. Could not find aliases.conf. Could you send me a copy and let me know where it should be stored. Thanks for...
Jack Cane
jcane@...
May 2, 2004 12:39 pm
30761
... aliases.conf is not part of IBO, it is part of the Firebird 1.5 server. It is located in the root directory of the Firebird installation (on the server)....
Dear Helen. Tks for advising me of my horrendously complicated code :/, but I'm doing
my best changing codes that came from other users... I've tried almost...
... CREATE TRIGGER "tiki_base_content_trig" FOR "tiki_base_content" BEFORE INSERT AS BEGIN IF ( NEW."contentId" IS NULL OR NEW."contentId" = 0 ) THEN ...
Is it necessary to specify keylinks if a query uses a primary key to find a record? I use and reuse utility queries in this way. [Non-text portions of this...
Ross Garbig
ross@...
May 2, 2004 9:23 pm
30767
... Your code seems to insert a row from the dataset and also calls a SP that inserts another row. I couldn't work out why you were doing that. ... When you...
... Datasets need KeyLinks for a lot of things. One of the "things" is for targeting one and only one row for updates and deletes. For searching, the WHERE...
Hi I am using TIB_Query and would like to define the following InsertQuery: insert into \"Note\"(\"NoteID\", \"Description\", \"NoteDate\") values(:\"NoteID\",...
Alfred Thomas
alfred@...
May 3, 2004 12:32 pm
30770
... If it's a column in the query *and* the query is in the InsertSQL property of the ib_query *and* the query column & parameter have the same identifier, you...
Well, Helen beat me to it :-), but I find the following syntax more readable (if you are doing this in straight code) since you can address the columns by...
... Thanks Helen I have tried this but found the following The Params[] has a Values instead of Value property? Also you need to use an index with it. I tried ...
Alfred Thomas
alfred@...
May 3, 2004 1:07 pm
30773
Hi. This mistake appears when I record a table detail How I can resolve this erro?...
Hi there.... Anybody knows how can i display a Progress of the load of a Query that ask for a BLOB Field from the Database ??? I mean, i have a Blob field in...
Hi all, is there an example, techsheet or something about implementing a many-to-many relationship with IBO ? Regards, -- Dimitrios Chr. Ioannidis [Non-text...
Not any different than what is explained one of the tech papers as in http://techrepublic.com.com/5100-6329-5034790.html ... From: "Dimitrios Chr. Ioannidis"...
... Hi Carlos, have a look at the OnBlobCallback event of TIB_Cirsor or TIB_Query. I'm storing the file size in a separate field so that I can display a...
... Expect it shortly after the IBO for Kylix components. ;) Sorry, Couldn't resist. Their development will probally be driven by demand, so ask early and...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
