Bug #257 MYSQL_FIELD
Submitted: 8 Apr 2003 23:41 Modified: 9 Apr 2003 11:10
Reporter: Danilo Giuliani Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:4.0.12 OS:Microsoft Windows (Win 9X,2000,XP)
Assigned to: CPU Architecture:Any

[8 Apr 2003 23:41] Danilo Giuliani
Description:
I am testing the new version of MySql (4.0.12).

I have same problem with structure MYSQL_FIELD.
the member "type" return always a bad value = -1163005939.
my source code with old version of mysql works very well.
If I use mysql server 4.0.12 with old client 3.23.56 all is right.

The functions mysql_connect, mysql_create_db, mysql_drop_db are unknow.

SO: windows 2000 professional, windows 2000 server, XP professional.
My language: Visual objects.

Example:

LOCAL MYSQL_FIELD AS _tcxMYSQL_FIELD
.............
.............
FOR n := 0 UPTO nFields
   MYSQL_FIELD:=mysql_fetch_field_direct( SELF:oMyRecordSet:pmySQL_RES ,n)
   cCampo := Upper(MYSQL_FIELD.name)
   IF IS_PRI_KEY(MYSQL_FIELD.flags)
        ....................
   ENDIF
  IF IS_AUTO_INCREMENT(MYSQL_FIELD.flags) 		
        ....................
  ENDIF
  nType:=MYSQL_FIELD._type  //always -1163005939(with 3.23.56 correct      value) 
  ..................
ENDIF

How to repeat:
[9 Apr 2003 11:10] MySQL Verification Team
These functions are deprecated. The options you have:

1- Update your application with the new functions

2- Build with VC++ your own library using the flag:

   USE_OLD_FUNCTIONS
   
   In the preprocessor definitions