Unexpected buffer value
IB2007SP2 server 1 user license
IBServerProperties1.LicenseInfo.LicensedUsers must return an Integer but
return Unexpected buffer value error if the server is the gds_2007 instance.
Work' | | 8 | 105 | 3/16/2008 6:21:46 PM |
Delphi2007 TIBDatabase won't connect with firebird 2.0.3 localhost.
My development PC is Vista. I know, bad eh?
Anyways I am having a strange issue.
1. When I use a commercial database front-end tool (DB Workbench, from
Upscene) it won't connec | | 1 | 134 | 3/13/2008 4:28:06 PM |
Bad practice?
Is a bad practice putting SQL statments on a button click for example? and
putting database comps on form?
Should all it be on a DM?
Any articles?
Thanks in advance! | | 9 | 81 | 3/7/2008 2:26:47 AM |
That old "Unsupported Feature" again.
I've struggled for a few days with a form that has a TClientDataset. I
read the records, map to the parameters of a StoredProc and Execproc.
Then get the IBClientError - Unsupported Feature. | | 2 | 272 | 3/6/2008 2:55:39 PM |
One TIBDatabase for all user Application
For each application I use a TIBDatbase and all forms connect to it. I have
many applications for many targets.
Each Application that connects to IBServer use one attachment and one user's | | 1 | 164 | 3/2/2008 8:03:05 PM |
Object locking in a DB
Please tell me that I am being an idiot in trying to implement a
locking scheme in an environment which should already support
concurrency control.
I've tried to make what I wan | | 5 | 87 | 3/1/2008 3:48:06 AM |
IBX 6.08, D6 and null memo field
Hi,
I am using D6 sp2 with IBX 6.08 (I assume this is latest IBX for D6) and IB
6.0.2.0 under WinXP sp2.
I find that no matter how I set a memo field under IBX, IBX always set < | | 5 | 87 | 2/28/2008 1:44:24 AM |
remote servers and tibdatabase
i'm using d7
i'm trying to use an topendialog to select a database on a network
unfortunately the topendialog gives me something like...
"\\recpt\my documents\ib_winmam.gdb& | | 13 | 96 | 2/25/2008 2:34:20 PM |
Lock conflit.
How can I intercept a lock conflit and to know who is the user that lock me?
| | 2 | 115 | 2/21/2008 10:07:34 PM |
TIBTransaction.CommitRetaining
I have 2 TIBDataset with 2 TIBTransanction set as Read_Commmitted,
both in dsBrowse and positionned on same table and same record.
First DB Edit, modify a field and CommitRetaining, its s | | 0 | 215 | 2/21/2008 5:46:29 PM |
TIBDataset OnCalcFields Event
with Delphi 2007 Win32? Version 11.0.2902.10471, I am using
OnCalcFields Event of TIBDataset, and I found that this event fires too
much. Every time cursor move away from current record it | | 6 | 76 | 2/20/2008 9:20:19 PM |
SQL Injection problem in TIBSQL
Hi,
I'm using TIBSQL 6.08, and I've a sql injection problem.
Let me expose an example:
I've a sql text in a string const,
const
SQL = 'SELECT USER_ID FROM | | 6 | 106 | 2/18/2008 8:18:15 PM |
Insert/Update/Delete
Hi all, can you explain what is the best IBX component to use these 3
operations? Any articles? examples?
thanks!
| | 1 | 101 | 2/18/2008 1:22:04 PM |
Missing Service Components in IBX Palette
Hi,
I just installed Turbo Delphi Professional for Win32 and I cannot manage to
get IB Services components in IBX.
Is there something I am missing? On another computer they show up u | | 3 | 93 | 2/11/2008 12:55:11 PM |
Two Phase Commits
Hi everyone,
I have a couple of questions about implementing two phase commits. I
searched Google
and found a post in this newsgroup by Jeff about how you could do a two
phase co | | 9 | 87 | 2/7/2008 2:45:36 PM |
Calculated Fields
I need some help, I want to add a calculated field to a TIBClientDataSet at
runtime, and sets its command text at runtime too.
I tried to figure it out, I add the calculated field by doi | | 5 | 159 | 2/6/2008 12:47:46 AM |
IBX in Delphi for .NET
Can you use Interbase Express data access components in a Delphi for .NET
application? I've run into some very odd behavior and am trying to sort out
the source of the problem. This is my | | 6 | 123 | 2/5/2008 5:55:17 AM |
TIBDatabase - Incorrect Values within SQLDA structure
With Interbase WI-V8.1.0.257 and Delphi Win32 version 11.0.2902.10471 I
get a.m. exception with message
'Dynamic SQL Error SQL error code = 804 ....'
with following query.
Error comes | | 1 | 164 | 2/4/2008 6:25:01 PM |
cant use master/detail querie
hi,
i cant set master/detail or nested queries(tquery both) in a
multitier(clientdataset) app.
i tryied changing the detail query to a ibtable
component and the error is: Transa | | 5 | 143 | 2/4/2008 1:37:40 PM |
Cannot change data in data aware edit box
Dear All,
I have a very basic issue creating a test application (Delphi 7 - Architect)
to retrieve data and amending it using ib components and data aware
components.
I acc | | 28 | 148 | 2/3/2008 3:48:22 PM |
Data Aware Issues
Sorry me once more. - I am the one who bothered all of you with the problems
regarding changes and data aware components. In case that you do not know
(remember) my setup:
I have a | | 3 | 89 | 2/2/2008 9:52:37 PM |
Interbase & Blob fields
Hello
I want to store images in an Interbase table.
How must I declare the blob field and how can fill it via SQL statement
Insert?
Thanks in advance
Sakis
| | 1 | 105 | 2/2/2008 9:48:45 PM |
blob size
how can i get the size of the data stored in a blob field?
i was trying...
sizeof(ibquery1.fieldbyname('picture').Value)
but it always returns a 16
ive also tried< | | 4 | 88 | 2/2/2008 5:05:55 PM |
"Cannot disconnect database with open transactions"
Hi everyone,
I'm getting the following error message: "Cannot disconnect database with
open transactions (1 active)" when performing a TIBDatabase.close in my app.
This is | | 4 | 105 | 1/30/2008 5:23:44 PM |
Possibility to do backup to database file not bak file
Hi.
is possible to do backup of database to file redy to use
Now i do backup and get file ".bak".
this file is not database and i must do restore proces to get database file | | 13 | 89 | 1/29/2008 4:23:43 PM |
XSQLDA error
hi,
i have a master/detail rel. with two ibquery components when i try to open those queries a XSQLDA index is out of range error is raised, why?
| | 2 | 239 | 1/26/2008 8:19:34 PM |
Application hangs after running IBQuery in a DLL using IBDatabase.Sethandle .
Hi everyone.
I have a strange problem when using IBX (v.10.10) in a DLL to modify
metadata. I have uploaded a sample application that reproduces the problem
to b.p.d.attachments (p | | 2 | 92 | 1/22/2008 10:55:16 AM |
snapshot and readcommited transactions errors
i have too many troubles with transactions...
i began have time out, no wait transaction, lock conflict erros
at trying accesing or updating data.
i have two transaction compone | | 6 | 103 | 1/21/2008 4:54:24 PM |
Old GDBs to New Structure...
I am converting an app that was using IB 5.6. This app is installed on many
machines and each machine can potentially have many different GDB files. The
old GDB format isn't compatible with th | | 6 | 109 | 1/20/2008 4:54:01 PM |
BatchMove functionality with IBX?
Is there some way I can easily replicate the functionality of TBatchMove
using IBX? I am upgrade a D5 app and use that to quickly/easily get data
from one GDB to another ( the user filters to | | 6 | 139 | 1/19/2008 11:02:42 PM |
TIBEvent and lost connection
Hello,
I'm using TIBEvent . The method TestConnected is called,
and if the result is false due to a lost connection I try to close the
program but TIBEvent raise the
exception | | 2 | 115 | 1/17/2008 4:52:01 PM |
Alias Failing
I'm having no success trying to make an app use an Alias. I put the
Alias into the Databasename property in my TIBDatabase component. It
seems to want to prefix a path onto that. I have a des | | 4 | 102 | 1/17/2008 2:47:28 PM |
IBX Details?
Why is there no info in the help system for IBX? I type in TIBQuery and I
only get some inferences to it, but no detailed info about members, etc. Am
I missing something?
(btw, Delphi | | 0 | 105 | 1/17/2008 3:51:34 AM |
tibquery errors when calling cds.applyupdates
hi,
i'm receiving errors when i call cds.applyupdates method in
multitier app..
The cds is tied to a tibquery component, datasetprovider
updatemode property is set to upwherekey | | 8 | 219 | 1/16/2008 7:37:38 PM |
IBX vs DBX
I'm the programmer of my Company and we use for the production optimization
a program write by me that use as database Interbase and the language is
Delphi. The component I use for database | | 13 | 85 | 1/15/2008 1:08:37 PM |
Database Alias
I think it was IB 7.5.0 that introduced Database Aliases. I'm looking
for the best way to put out an app that doesn't have the database
hard-coded by the developer. Does IBX support Aliases? W | | 2 | 99 | 1/15/2008 11:54:23 AM |
IBevent in a thread
I want to use the TIbevents component in a thread to trigger an event.
In the Thread i make following commands:
I connect to the database and register the event, then i unregist | | 0 | 106 | 1/15/2008 6:34:20 AM |
Firebird, Delphi 7 , IBX and Windows XP
I am running Delphi 7 on Windows XP and am trying to use Firebird instead of
Interbase 6.0. But when I try and use an IBX component, I get the error
message
Interbase library gds32 | | 5 | 472 | 1/3/2008 6:30:21 PM |
TIBDataset not returning values ?
I have below sql in a TIBDataset.
If I run it in IBConsole or another 3rd part SQL Tool it works fine,
when I open TIBDataset I don't get values of
g.ambname, g.filname,
retrieve | | 2 | 99 | 12/15/2007 8:42:16 AM |
TIBDataset validation column Null Value
In Delphi with TIBDataset I am updating a field in a record whose
content is :
FieldByName('ABINP').AsString = ''
when I post I get this error :
'Validation error for column | | 10 | 173 | 12/10/2007 9:27:10 PM |
ModifySQL with two tables in Select
I have an IBDataset with the following SelectSQL:
select S.ID_ARTIC, S.ID_ALB, S.ID_FACT, S.CANTIDAD_SAL, S.CANTIDAD_UD,
S.PRECIO_SAL, S.IMPORTE_SAL, A.NOM_ARTIC
from SALIDAS S, ARTI | | 5 | 110 | 12/9/2007 3:43:03 PM |
TIBQuery - boolean Parameter returning EIBError -303
In a TIBQuery I have this assignement :
IBQry_PianoConti.ParamByName('flag_mastrinosezio').asboolean :=
flag_mastrinosezio ;
query select from a procedure which expect to receive a | | 0 | 92 | 12/4/2007 7:01:28 PM |
ibx documentation missing (D2007)
I am not sure if I did something or if it was one of the updates (its
running update 3), but I can't find the IBExpress documentation. For
instance pressing F1 on a TIBQuery component brings | | 2 | 85 | 11/30/2007 10:21:24 AM |
Debugger, Exception Failure
I was doing development on a form that pretty simply calls an IB Stored
procedure, which performs a number of steps, and I was adding another
to it. My addition was failing for a simple reaso | | 2 | 79 | 11/20/2007 11:47:50 PM |
Access Violation in GDS32.dll when connecting over the network
Hi.
I have an application that is installed on one machine and it then
connects to a remote interbase. When the app tries to connect to the
remote database I get an Access Violation | | 2 | 119 | 11/15/2007 10:27:49 AM |
IBX and Firebird 2.x
Hi people,
I'd like to know how is the compatibility between IBX and FB (specially
2.1).
There are several years that we hear that since FB and IB are taking
distan | | 4 | 81 | 11/15/2007 3:07:18 AM |
IBX datetime
I getting a datetime of a file (application executable) with
with de FileAge function of Delphi 2007.
Than, I'm saving this datetime on IB table using a TIBQuery like this:
IBQuery.FieldBy | | 6 | 139 | 11/14/2007 7:33:15 AM |
Need to install IB on every node?
Hi,
I am using Delphi 5 , Interbase version 6, IBX 4.4, Win 98.
I have installed Interbase on the server and on the Clients I have copied
GDS32.dll into c:\Windows\System.
Th | | 9 | 101 | 11/12/2007 10:18:49 PM |
TIBSql free vs freehandle
when creating a TIBSql in code
should one use .freehandle or .free (or both) to get rid of it after usage?
with most components we use .free, but TIBSql may be different
Help say | | 1 | 113 | 11/2/2007 2:26:31 AM |
Access violation in TIBTransaction AddSQLObject
Hi
I'm having a strange problem with my server software. I have interbase =
Desktop database and my server software connects to that with IBX 7.08. =
=
The server soft | | 3 | 134 | 10/26/2007 1:52:49 PM |