Hi All, Just wondering what peoples experiences have been running IBO based Windows applications under Linux using Wine. A client is beginning trials of a...
Hi Geoff, Fortunately, we've been running an IBO-based application with CrossOverOffice (Commercial Wine?) under Mandrake Linux for over 3 years now. You can...
I always suggest people look at the performance monitor/SQL trace because the query requesting that information may not be working optimally and the addition...
I'm not sure why there is a problem. What I see below looks fine. However, this looks like something that belongs inside a stored procedure... Jason Wharton ...
Hi Jason, what kind of index we must add to our database, an Index on system tables ? But this kind of operation are not discouraged ? I don't remeber why but...
I notice that I can create a shortcut to a database using the ... Is there a way to include the username or password on the commandline? Rgds, David...
Hi Jason, i have used IBO Monitor on my example and i have extracted some parts: [ 01/06/2005 18.00.12 ] PREPARE STATEMENT TR_HANDLE = 16871616 STMT_HANDLE =...
Hi All, What would prevent a TIB_Connection for closing? My code is like this: DM.dbXm.Connected := False; // not working Result := (not DM.dbXm.Connected);...
Covenant Data Systems, Inc. is a software and web solutions company. We help our clients meet business objectives through software consulting, coaching,...
... A transaction that is still running and is not read to roll back? Typically, a SELECT query hasn't finished fetching all of the requested rows. ... You'll...
Hi Mario, ... Thanks for that, I was not aware of CrossOver. Some interesting stuff in their FAQs that should help me. I am presuming (hoping) the guy building...
You are correct that some indexes on system tables can get lost in a backup and restore. What I advise you to do is to check for a named index at some ...
Please check the source code and if it isn't there I'm sure you could easily add it in since Delphi makes it pretty easy to handle input parameters. This would...
Enrico, ... Firebird 1.5 introduced three new indexes on system tables, thus this was one reason why the ODS (On-Disk Structure) was increased from 10.0 to...
... True Enrico, this query doesn't benefit from any indexes you may define on rdb$indices. I don't know the internals of Firebird good enough, if the...
Hi, ... It wouldn't make much difference even if it would be using an index. Just do a comparison between the number of rows where I.RDB$RELATION_NAME starts...
Hello! I've encountered a hard to reproduce bug in my program: after callin Post() on IBOTable, the table is still in dsEdit mode, but no exception is thrown!...
Robert Osowiecki
robson@...
Jun 2, 2005 5:17 pm
35818
From: "Robert Osowiecki" <robson@...> ... In most cases, I have found this to be an event procedure of some type that fires when the Post occurs....
Hi, I'm using a TIB_Cursor to scan data in a table and, depending on some conditions, update some of the rows. However I get an exception with SQLError -510...
... Jason, That works, but defeats my goal of updating only changed columns (or no update if nothing changed). Also why don't the update statements that IBO...
Hi all.. I need a little help... look this: I have two different programs. Each program have your own TIB_Transaction ( both isolation level is tiCommited) ....
Hi Eyal! Does the error occur if you explicitly set KeyLinks? I'm not saying that there is no error to be fixed, just that if there is an error, then maybe it...
... I did try to explicitly set KeyLinks with identical results. IBO correctly identified the key column and used for the searched update, the problem is that...
... I suppose you do have RequestLive true? If so, it seems as though your KeyLinks are not able to uniquely identify an underlying row in the table you marked...
... In Set A, you have some rows containing some columns from TableX. In Set B, you have some rows containing some columns from TableX and some columns from...
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.
