🚀 go-pugleaf

Hi All

I need to read from a VB Script a BLOB field in my Paradox 7 table
"messages".
Using the script below, I was able to connect to the database and retrieve
some of the entries, but ADO does not return the BLOB fields.

MSDN KB confirms this situation:
Q300189: Paradox ISAM Does Not Support Some Paradox 4.x Types

As this article if from 2004, is there a solution in the meantime to read
BLOB fields through ADO?

I tried to ask this question to the PARADOX gurus, but no answer there...

Rds
Marc

***************
Set dbc_conn = CreateObject("ADODB.Connection")
dbc_conn.Open "Driver={Microsoft Paradox Driver (*.db )};" & _
           "DriverID=538;" & _
           "Dbq=c:\database\;" & _
    "CollatingSequence=ASCII"


set rs= createobject("adodb.recordset")
sql="select * from messages"
rs.open sql, dbc_conn,1


while not rs.eof
 for each i in rs.fields
  MsgBox rs(i.name)
 next
 rs.movenext
wend