VB Forum / Database Access / April 2005

I have some problems using ADO to retrieve data from an Interbase (.gdb
file) in Visual Basic 6.0. I am trying to connect excel speedsheet to
interbase but could not.
Here are some parts of the coding involving the database connection:

I have some problems using ADO to retrieve data from an Interbase (.gdb
file) in Visual Basic 6.0. I am trying to connect excel speedsheet to
interbase but could not.
Here are some parts of the coding involving the database connection:

How can i set the default of a field
suppose i add a column
ALTER TABLE myTable ADD COLUMN myField TEXT(20)
now what to do. Can i do this with SQL or what is the command in ADO.

I was trying that Michael with no luck because the only problems are with
moveprevious and movenext. As I see it, it loop until the end of file...I
dont want to do that. Unless ther is something that I don't know.
   With RsTable