From: Matteo Cavalleri <matteo@bp.lnf.it>
To: Andrzej Szydlo <andrzej@maciek.gv.edu.pl>
Cc: pgsql-interfaces@hub.org
Subject: Re: ODBC,Delphi and BLOBS
Date: Tue, 25 Aug 1998 10:15:52 +0200
Message-ID: <3.0.32.19980825101549.007373f4@nic2> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: matteo@bp.lnf.it, andrzej@maciek.gv.edu.pl, pgsql-interfaces@hub.org
Subject: Re: ODBC,Delphi and BLOBS
In-Reply-To: <3.0.32.19980825101549.007373f4@nic2>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox