Re: Application crash after error - please help - Mailing list pgsql-odbc

From Ludek Finstrle
Subject Re: Application crash after error - please help
Date
Msg-id 20051202090530.GA20513@soptik.pzkagis.cz
Whole thread Raw
In response to Re: Application crash after error  ("Andrus" <eetasoft@online.ee>)
List pgsql-odbc
> In klient table I have
> info text,
>
> column.
>
> If I remove this column from klient table, error does not occur.
>
> So it seems that this error occurs if table has text type column.

Hello,

  I investigate it a little bit more and I go to the end of my
knolwdge. I hope someone on the list could help.

Description:
You insert data with data at exec. It mean you call:
1) SQLExecDirect with ? as parameters needed (3 of them)
2) SQLParamData
3) SQLPutData (only for text column)
4) SQLParamData - which execute the query but fail and return SQL_ERROR
5) SQLCancel - this is point of the problem. I don't know if it may
     destroy Binding Parameters at all

6) SQLExecDirect without parameters needed - but ODBC driver execpt
     3 parameters becouse you didn't call SQLFreeStmt (SQL_DROP or
     SQL_ - I forget the name which frees only binding params)
     ODBC driver doesn't investigate number od parameters from statement.
     Maybe this is point of problem?
7) SQLParamData - go throught well
- your application failed. The point of failure isn't exactly in ODBC
driver but it correspond with SQLPutData is needed.

I'm not sure if it's problem of psqlODBC driver. Could someone more
experienced help?

Thanks a lot

Luf

pgsql-odbc by date:

Previous
From: Robert Jireš
Date:
Subject: SQLColAttributes and SQL_DESC_NULLABLE
Next
From: "Zlatko Matic"
Date:
Subject: Re: Data showing up as #Deleted in Access