Subject | ODBC Question |
---|---|
Author | Yves Glodt |
Post date | 2001-09-06T14:35:49Z |
Hello,
I have an (windows)-application that can use a paradox or an Interbase
database. It's written in Delphi5, so it goes through the BDE.
With paradox it works fine.
Now I've tried the firebird odbc-driver (With Interbase 6.01 database).
The bde seems to create automatically an alias for every registered
odbc driver. Therefor, to change the database, I only have to use
another alias.
With Interbase I've got the following.
- All the selects from my app work,
- I can also delete records.
- But I can not update/insert. I always get a message saying "Table is
readonly".
I used a tquery component, and the tdatabase.readonly property is of
ourse set to false.
It seems to me that this is a bde/delphi problem nut I'm not sure.
Can anybody help me?
yves
--
Linux 2.4.9 #1 Thu Aug 16 22:56:53 CEST 2001 i686
4:27pm up 16 min, 1 user, load average: 0.94, 0.65, 0.40
I have an (windows)-application that can use a paradox or an Interbase
database. It's written in Delphi5, so it goes through the BDE.
With paradox it works fine.
Now I've tried the firebird odbc-driver (With Interbase 6.01 database).
The bde seems to create automatically an alias for every registered
odbc driver. Therefor, to change the database, I only have to use
another alias.
With Interbase I've got the following.
- All the selects from my app work,
- I can also delete records.
- But I can not update/insert. I always get a message saying "Table is
readonly".
I used a tquery component, and the tdatabase.readonly property is of
ourse set to false.
It seems to me that this is a bde/delphi problem nut I'm not sure.
Can anybody help me?
yves
--
Linux 2.4.9 #1 Thu Aug 16 22:56:53 CEST 2001 i686
4:27pm up 16 min, 1 user, load average: 0.94, 0.65, 0.40