... <tim.gahnstrom@i...> wrote: Moin! If you have it exactly so, there could be a problem resulting from not putting the colons as prefix to the variable ... ...
When we were to decide what component to use for our app, zeos was in list, but it faced some problems while working with quite large datasets opened (~ 0.1 -...
... Does this mean that preventing the PS.Z_Personal_ID index from being used like SELECT PS.Z_Personal_ID, HMA.O_Personal_ID FROM T_Personal_Salden PS JOIN...
Hello Set, ... SET> Does this mean that preventing the PS.Z_Personal_ID index from being SET> used like SET> SELECT PS.Z_Personal_ID, HMA.O_Personal_ID SET>...
Sorry for the double post but I am desperate, I need help badly, I do not understand this problem at all. the error is 'Cannot insert a new row' which seems to...
The query may not be returning an updatable result set. If I recall correctly, updatable result sets are optional in the SQL standards, with some very strict...
... What is a TIB_Dataset? What happens in CanInsert (obviously the result of that function is false)? How does the SQL-statement look like which raises the...
Magnus Titho
magnus.titho@...
Jul 1, 2005 12:28 pm
62870
... It's not a database error, it's a client-side error. Causes: one or more of the following: 1) You don't have RequestLive true; or, if you do, it's not...
Hi, Currently we are facing strange behavior of DB in linux (Linux Mandrake, Athlon 64bit ~3GHZ ,Db ~ 3Gb). If someone executes something (Sp or select), what...
... The API overhead is a non-problem. The bottleneck is on I/O, not CPU. To improve performance change your disks to the fastest possible SCSI attached to a...
... I think I'd be checking the health of the database first - before I wanted such an error to pass quietly. If this error is not linked to a specific...
Adomas, ... Doing a "LAST" on a .5 million record table (preferrably in combination with a "SELECT *" I guess) will not be too fast in IBO either, since even...
I had this same exact error for a while and traced it to us accidentally passing in a variable that was too large to one of our udfs. Once we modified the udf...
Steve Wiser
steve@...
Jul 1, 2005 2:14 pm
62876
... yep - UDFs could easily by the issue. And smells like just the reason that linux handles it better than windows Alan...
Does anyone know if interclient (1.51) supports 2-phase commits? I can't seem to get it to work and some of the documentation that I am finding online seems...
Steve Wiser
steve@...
Jul 1, 2005 2:30 pm
62878
In firebird-support@yahoogroups.com, ... That looks like TTable type syntax to me? I thought that good system design would dictate that one should never have...
... Well, lets say I see order transactions from date 2005.01.01 - 2005.02.01 (by default month back), it will be not much, but some "clever" users will...
... Thanks for the input. I tried it but it didn't make a difference in this case. Anyway I found it now (finally!). I had an eroneous trigger on updates of...
Tim Gahnström
tim.gahnstrom@...
Jul 1, 2005 3:06 pm
62881
Hi, I am looking for a database modeling tool that is either GPL or inexpensive. So far I have found 'DBDesigner 4', but it is a dead project and the follow...
... With Vulcan you'll need at least two dlls currently called firebird.dll and engine8.dll. If you want remote access, you'll need remote.dll. You'll also...
... You can start here: http://www.ibphoenix.com/main.nfs?page=ibp_expert2 and then look at the file ods.h in the src/jrd directory of the CVS source tree to...
... as well as they would expect getting 500.000 printed copies of these files within some seconds :-) Funny thing they expect to see data they'd never would...
... Hash: SHA1 Hello, I'd like to ask if is something to be done to speed my query up ? Query below is fast enough (about few seconds) only when I set a day ...
Bogusław Brandys
brandys@...
Jul 1, 2005 5:15 pm
62891
... Try Case Studio www.casestudio.com We use it extensively for large (ie. > 300 table) database schemas with Firebird. Although I would prefer if it had a...
