Use of DatabaseColumns & DatabaseColumnName

fsw · Post by **fsw** » Wed Apr 12, 2006 5:28 pm

I've managed to connect to a SQL Server via ODBC and get the data from different tables without problems.

Pulling out the data was a little bit try & error because PB wants a Column number instead of a column name.

But using DatabaseColumns & DatabaseColumnName (to verify the number with the name) doesn't work.
The return value of DatabaseColumns is always 0...

Shouldn't I set the table first before using DatabaseColumns?
Didn't find a PB command for that.

Am I missing something?
Please bear with me, I'm a SQL novice

Thanks for any help.

Flype · Post by **Flype** » Wed Apr 12, 2006 9:44 pm

works well for me with MySQL

doing something like this :

Code: Select all

If DatabaseQuery(0,"SELECT * FROM mytable")
  nColumn = DatabaseColumns(0)
  While NextDatabaseRow(0)
    result$ = ""
    For i = 0 To nColumn - 1
      result$ + GetDatabaseString(0,i) + ", "
    Next i
    Debug result$
  Wend
EndIf

fsw · Post by **fsw** » Thu Apr 13, 2006 12:18 am

Thanks found my problem:
used them before doing a query...

Thanks again.

Tranquil · Post by **Tranquil** » Sat Apr 15, 2006 4:00 am

I use this Procedure to obtain the problem of column-numbers:

PB3.94 Code!

Code: Select all

Procedure GetDatabaseColumn(name$)
  For N=0 To DatabaseColumns()
    If DatabaseColumnName(N)=name$
      ProcedureReturn N
    EndIf
  Next N
  ProcedureReturn -1
EndProcedure