libmysql.dll - fieldname of column

Rico · Post by **Rico** » Wed Jan 25, 2006 11:33 am

Hello,

can someone please give me an example, how i can get the name of an field in mysql by using the libmysql.dll? Connection, Query etc. works and now i need the real fieldname of an column.

Thanks Rico

Manol · Post by **Manol** » Wed Jan 25, 2006 12:33 pm

Please see the Resources Site:

http://www.purearea.net/pb/english/index.htm

CodeArchiv.

Databases

Rico · Post by **Rico** » Wed Jan 25, 2006 12:47 pm

already, i have used the example (http://www.purearea.net/pb/CodeArchiv/D ... Example.pb), but can't find the way in this example how i can get the fieldname.
Other ideas?

Manol · Post by **Manol** » Wed Jan 25, 2006 1:05 pm

Yes, this is the function:

mysql_field_name

Manol · Post by **Manol** » Wed Jan 25, 2006 1:24 pm

Hi,

Change this code:

Code: Select all

          For i=1 To rowsNum
            *mysqlRow=CallFunction(#libmysql,"mysql_fetch_row",*mysqlResult)
            *mysqlLen=CallFunction(#libmysql,"mysql_fetch_lengths",*mysqlResult)

For this one:

Code: Select all

          Dim FieldName.s(rowsNum)
          For i=1 To rowsNum
            *mysqlRow=CallFunction(#libmysql,"mysql_fetch_row",*mysqlResult)
            *mysqlLen=CallFunction(#libmysql,"mysql_fetch_lengths",*mysqlResult)
            FieldName(i)=CallFunction(#libmysql,"mysql_field_name",*mysqlResult)
            Debug FieldName(i)

Regards,
Manolo

Rico · Post by **Rico** » Wed Jan 25, 2006 1:52 pm

Compiler-Error:
Trying to write an numeric value into a string variable
in Line
FieldName(i)=CallFunction(#libmysql,"mysql_field_name",*mysqlResult)

???