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
SQL - fieldget freeze
Re: SQL - fieldget freeze
changing the column from char(1) to varchar(5) has resolved my freeze...
- ArneOrtlinghaus
- Posts: 405
- Joined: Tue Nov 10, 2015 7:48 am
- Location: Italy
Re: SQL - fieldget freeze
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
Arne