Thread: Re: ODBC,Delphi and BLOBS

Re: ODBC,Delphi and BLOBS

From
Matteo Cavalleri
Date:
First of all, thank you for you help.

I am <bold>not</bold> new to C++ Builder, 1.0 and 3.0. I already have
written database applications with Informix SE database and some
components (i.e. to perform I/O operations on hardware ports.)

I work for a no profit organization for handicapped children. I would
like to build a distributed application to manage the medical recordset
of our patients. The first step will use local SQL engines. Our SQL
Engine, Informix SE v.5.x doesn't support BLOB fields and then I think to
use PostgreSQL that seems to be a good, reliable and free product.

But  have a lot of trouble using PostgreSQL with BDE.

I have  created an example table like this


            <bold>    create table prova ( nome char(20), altezza integer) ;

</bold>

then I try to manage table datas in a Windows 95 enviroment, using
PostODBC and BDE.

Both in the data section of SQL explorer and in a little program in C++
Builder 1.0 C/S & 3.0 C/S & Delphi 3.0 C/S, i get the same wrong
behavior.

Inserting 5 records with the "+" button only 2 records are correctly
displayed and the others are lost. All the records however are correctly
stored in the database: Closing and reopening the table will show all the
correct records. Other refresh problems comes with the deletion button
"-" and so on...

To create this situation I do the following items:

1) I have created the prova table

2) In SQL Explorer, clicking on the created table, in the data section,
using the navigation bar + key, I can see the wrong behavior  (do your
data section works weel inserting few record in a table?)

3) C++ Builder 1.0 C/S or  3.0 C/S or  Delphi 3.0 C/S (then I think it is
a BDE or ODBC problem) without writing code I have put a TTable linked to
the table prova via postODBC. Than I put a TDataSource, a TDBGrid and
TDBNavigator. The wrong behavior is identical to the SQL explorer data
section.


Note: I have upgraded the BDE to the 4.51 version and then to the 5.0
version.

I have downloaded the version 6.3.2 of postgreSQL ,compiled and started
on a SUN Sparcstation ULTRA with Solaris 2.6.