SQL - fieldget freeze

[IGSoftDev]

Hello

I have a problem with SQLConnection and SQLSelect (MySql 8)

c:= "SELECT CFORMAT FROM FACTURE WHERE NUMFACT=15400"
oserver := SQLSelect{c,osql}
IF oserver:Execute()
cvar := oserver:fieldget("CFORMAT") ==> Freeze
endif

All other fieldget are working, but not this one.

If I assign oserver to a bbrowser:
- without field CFORMAT it works
- with field CFORMAT it freeze too

No problem in Heidisql



Any idea ?

Jean-Luc

[IGSoftDev]

changing the column from char(1) to varchar(5) has resolved my freeze...

[ArneOrtlinghaus]

The type of column can influence much. I remember that we had problems reading LOB-fields (LONG fields) from SQLServer/Access DBs via ODBC with our ODBC usage some years ago. It is difficult to find the reason or alternative access possibilities. So it is good, if you can find workarounds like this.

Arne