From: | Matteo Cavalleri <matteo(at)bp(dot)lnf(dot)it> |
---|---|
To: | Andrzej Szydlo <andrzej(at)maciek(dot)gv(dot)edu(dot)pl> |
Cc: | pgsql-interfaces(at)hub(dot)org |
Subject: | Re: ODBC,Delphi and BLOBS |
Date: | 1998-08-25 08:15:52 |
Message-ID: | 3.0.32.19980825101549.007373f4@nic2 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
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.
Attachment | Content-Type | Size |
---|---|---|
unknown_filename | text/enriched | 2.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | James Olin Oden | 1998-08-25 11:25:06 | Re: [INTERFACES] Can't locate docs for libpq++ |
Previous Message | Andrzej Szydlo | 1998-08-25 07:53:40 | Re: ODBC,Delphi and BLOBS |