pg.ddx.io pgsql-interfaces@postgresql.org mailing list archive
help / color / mirror / Atom feedRe: ODBC,Delphi and BLOBS
5+ messages / 3 participants
[nested] [flat]
* Re: ODBC,Delphi and BLOBS
@ 1998-08-20 15:09 Andrzej Szydlo <andrzej@gv.edu.pl>
0 siblings, 0 replies; 5+ messages in thread
From: Andrzej Szydlo @ 1998-08-20 15:09 UTC (permalink / raw)
To: Matteo Cavalleri <matteo@bp.lnf.it>; +Cc: pgsql-interfaces@hub.org
On Thu, 20 Aug at 1998 14:34:05 +0200, Matteo Cavalleri wrote:
>
> I am going to use VCL & BDE with PostODBC and PosrgreSQL.
> I have got the same problem when BDE attempts to write a filled blob field
> in the table.
> Do you think that the BOLBs parameter in DBE database configuration cab be
> useful?
I'm not sure how this proprty works, but I don't think it might
influence the BLOB writing problem. Tried different values, anyway,
and it didn't change anything.
> Howewer I have got another problem that may be caused to misconfigurations.
> Simply using a TTable connected to a TDataSource and TDBGrid and loading
> records the refresh is not correct and I need to restart the application in
> order to see all the record in the database.
> Have you got the same problem? Could you please give me your DBE & ODBC &
> TTable configuration parameter?
> How version of PostOdbc & PostgreSQL are you using?
I use PostgreSQL 6.3.2 and PostODBC 0249 - the latest version, with
some extra changes made by Byron.
I don't have any problems with refreshes. Some ODBC drivers cause
such problems, but PostODBC doesn't. My ODBC and
BDE settings are atteched below. I don't change TTable default
settings (obviously except for datasource, table name and indices)
Hope this helps. Let me know if you still have any problems.
Andrzej
++++
ODBC
++++
DSN info: DSN='pgsql
template',server='tech-1',port='5432',dbase='template1',user='postgres
',passwd=''
readonly='0',protocol='',showoid='0',fakeoidindex='0',showsy
stable='0' conn_settings=''
translation_dll='',translation_option=''
conn = 48433276, SQLConnect(DSN='pgsql template', UID='postgres',
PWD='') Global Options: fetch=100, socket=4096, unknown_sizes=2,
max_varchar_size=254, max_longvarchar_size=4094
disable_optimizer=1, unique_index=0,
use_declarefetch=0 text_as_longvarchar=0,
unknowns_as_longvarchar=0, bools_as_char=1
extra_systable_prefixes='dd_;', conn_settings=''
+++++++
BDE alias
+++++++
TYPE: PostgreSQL
PATH:
DATABASE NAME:
USER NAME: postgres
ODBC DSN:
OPEN MODE: READ/WRITE
SCHEMA CACHE SIZE: 8
SQLQRYMODE: SERVER
LANGDRIVER:
SQLPASSTHRU MODE: SHARED AUTOCOMMIT
SCHEMA CACHE TIME: -1
MAX ROWS: -1
BATCH COUNT: 200
ENABLE SCHEMA CACHE: FALSE
SCHEMA CACHE DIR:
ENABLE BCD: FALSE
ROWSET SIZE: 20
BLOBS TO CACHE: 64
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC,Delphi and BLOBS
@ 1998-08-20 18:29 Andrzej Szydlo <andrzej@maciek.gv.edu.pl>
0 siblings, 0 replies; 5+ messages in thread
From: Andrzej Szydlo @ 1998-08-20 18:29 UTC (permalink / raw)
To: Matteo Cavalleri <matteo@bp.lnf.it>; +Cc: pgsql-interfaces@hub.org
Hello,
One more detail - which BDE version do you have? Only the 4.51 is proven
to work relatively correctly.
Andrzej
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC,Delphi and BLOBS
@ 1998-08-24 08:24 Matteo Cavalleri <matteo@bp.lnf.it>
0 siblings, 1 reply; 5+ messages in thread
From: Matteo Cavalleri @ 1998-08-24 08:24 UTC (permalink / raw)
To: Andrzej Szydlo <andrzej@maciek.gv.edu.pl>; +Cc: pgsql-interfaces@hub.org
>Hello,
>One more detail - which BDE version do you have? Only the 4.51 is proven
>to work relatively correctly.
>Andrzej
I have upgraded the BDE to 4.51 and then 5.0. I have donwloaded the source
version of Postgres 6.3.2 and recompiled it.
I have checked both in Delphi 3 C/S and Builder 3 C/S that a simple TTable
connected to a TDatasource, TDBGrid and TDBNavigator dosend't work well.
(i.e: Inserting a few records will cause some confusion on the DBGrig like
a refresh display is missing. )
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC,Delphi and BLOBS
@ 1998-08-25 07:53 Andrzej Szydlo <andrzej@maciek.gv.edu.pl>
parent: Matteo Cavalleri <matteo@bp.lnf.it>
0 siblings, 0 replies; 5+ messages in thread
From: Andrzej Szydlo @ 1998-08-25 07:53 UTC (permalink / raw)
To: Matteo Cavalleri <matteo@bp.lnf.it>; +Cc: pgsql-interfaces@hub.org
On Mon, 24 Aug 1998, Matteo Cavalleri wrote:
> >Hello,
> >One more detail - which BDE version do you have? Only the 4.51 is proven
> >to work relatively correctly.
> >Andrzej
> I have upgraded the BDE to 4.51 and then 5.0. I have donwloaded the source
> version of Postgres 6.3.2 and recompiled it.
> I have checked both in Delphi 3 C/S and Builder 3 C/S that a simple TTable
> connected to a TDatasource, TDBGrid and TDBNavigator dosend't work well.
> (i.e: Inserting a few records will cause some confusion on the DBGrig like
> a refresh display is missing.
Could you please send me your table structure? I'll try it here.
Andrzej
^ permalink raw reply [nested|flat] 5+ messages in thread
* Re: ODBC,Delphi and BLOBS
@ 1998-08-25 08:15 Matteo Cavalleri <matteo@bp.lnf.it>
0 siblings, 0 replies; 5+ messages in thread
From: Matteo Cavalleri @ 1998-08-25 08:15 UTC (permalink / raw)
To: Andrzej Szydlo <andrzej@maciek.gv.edu.pl>; +Cc: pgsql-interfaces@hub.org
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.
^ permalink raw reply [nested|flat] 5+ messages in thread
end of thread, other threads:[~1998-08-25 08:15 UTC | newest]
Thread overview: 5+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1998-08-20 15:09 Re: ODBC,Delphi and BLOBS Andrzej Szydlo <andrzej@gv.edu.pl>
1998-08-20 18:29 Re: ODBC,Delphi and BLOBS Andrzej Szydlo <andrzej@maciek.gv.edu.pl>
1998-08-24 08:24 Re: ODBC,Delphi and BLOBS Matteo Cavalleri <matteo@bp.lnf.it>
1998-08-25 07:53 ` Andrzej Szydlo <andrzej@maciek.gv.edu.pl>
1998-08-25 08:15 Re: ODBC,Delphi and BLOBS Matteo Cavalleri <matteo@bp.lnf.it>
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