Skip site navigation (1) Skip section navigation (2)

Re: ODBC,Delphi and BLOBS

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 (view raw or flat)
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: unknown_filename
Description: text/enriched (2.0 KB)

pgsql-interfaces by date

Next:From: James Olin OdenDate: 1998-08-25 11:25:06
Subject: Re: [INTERFACES] Can't locate docs for libpq++
Previous:From: Andrzej SzydloDate: 1998-08-25 07:53:40
Subject: Re: ODBC,Delphi and BLOBS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group