How to read columns Item from Indexes GetSchema ?

How to read columns Item from Indexes GetSchema ?

Postby Andrea Rocca » Wed 10 May 2006 13:19

Dim Dtl As System.Data.DataTable
Dim Row As System.Data.DataRow
Dim Cols() As Char
Dim S as string

Dtl = mvarConnectionDB.GetSchema("Indexes")
For Each Row In Dtl.Rows

'This not work ?
Cols = CType(Row.Item("columns"), Char())

'This return System.Byte[]
S = Row.Item("columns").ToString

Next Row
Andrea Rocca
 
Posts: 5
Joined: Fri 10 Mar 2006 15:50

Postby Alexey » Thu 11 May 2006 07:10

We have found the problem and now we are fixing it. Look forward to the next build.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Postby Alexey » Thu 11 May 2006 08:03

Use Protocol=Ver20 in the ConnectionString property for workaround.
Row.Item("columns").ToString statement will return string containing the
numbers of columns which form index.
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43


Return to dotConnect for PostgreSQL