[fpc-pascal]ODBC

[Michael Van Canneyt]

On Mon, 9 Jun 2003, DEMIERRE Osvaldo        TECSIS wrote:

> Hi
>
> I am running FPC 1.06 on WIN2000 and I want to work with MySQL 4.0.13.  I
> tried to run el demo program "TESTODBC.PP" (previous adapter it) but I have
> problem with fields of type "VARCHAR"... Question: only support is for type
> "CHAR"?

This depends on the ODBC driver, not on the Pascal binding to ODBC.

>
> Another question: I have modified this example program for show the values
> after "select" but there are any wrong with these (I received the data
> TRUNCATED):
>
> My modified code:
>
> (...)
>         repeat
>             for c:=1 to colCount do
>             Move(Cols[c].Coldata^,var1,Cols[c].ColSize);
>             writeln(var1);
> (...)
>
> The package "ODBC" work with ODBC 3.51 or only with ODBC 2.5?

The headers of 3.51 have been converted.

>
> Can someone give me a hint?
>
> Where are more examples?

There are none except for the ones in the sources. You can also look at the OOP
wrapper in the fcl/db/odbc directory.

Michael.