SQL - fieldget freeze

Public support forum for peer to peer support with related to the Visual Objects and Vulcan.NET products
Post Reply
User avatar
IGSoftDev
Posts: 10
Joined: Tue Sep 12, 2023 2:23 pm

SQL - fieldget freeze

Post by 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
User avatar
IGSoftDev
Posts: 10
Joined: Tue Sep 12, 2023 2:23 pm

Re: SQL - fieldget freeze

Post by IGSoftDev »

changing the column from char(1) to varchar(5) has resolved my freeze...
User avatar
ArneOrtlinghaus
Posts: 389
Joined: Tue Nov 10, 2015 7:48 am
Location: Italy

Re: SQL - fieldget freeze

Post by 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
Post Reply