Read response

[Hugh Janus]

Hi all,

This should be a quick one. I am developing an app using the CF
2005. I am interfacing fine with the DB (i.e. creating tables &
adding records) but now I want to read the output of a command that I
send. I want to get a list of tables in the DB so I am using the
following code:

sqlCommand.Comm andText = "SELECT * FROM
INFORMATION_SCH EME.TABLES"
Dim sqlDR As Data.SqlServerC e.SqlCeDataRead er =
sqlCommand.Exec uteReader '.ExecuteNonQue ry()

sqlDR.Read()
MsgBox(sqlDR.Ge tString(0))


But it returns me an error 5 with the text "[ 1,34,TABLES ]". Any
ideas what I am doing wrong? I simply want a list of all tables
returned to me as a string.

TIA,
Hugh

[rowe_newsgroups]

Re: Read response

On Aug 28, 9:59 am, Hugh Janus <my-junk-acco...@hotmail .comwrote:

Hi all,
>
This should be a quick one. I am developing an app using the CF
2005. I am interfacing fine with the DB (i.e. creating tables &
adding records) but now I want to read the output of a command that I
send. I want to get a list of tables in the DB so I am using the
following code:
>
sqlCommand.Comm andText = "SELECT * FROM
INFORMATION_SCH EME.TABLES"
Dim sqlDR As Data.SqlServerC e.SqlCeDataRead er =
sqlCommand.Exec uteReader '.ExecuteNonQue ry()
>
sqlDR.Read()
MsgBox(sqlDR.Ge tString(0))
>
But it returns me an error 5 with the text "[ 1,34,TABLES ]". Any
ideas what I am doing wrong? I simply want a list of all tables
returned to me as a string.
>
TIA,
Hugh

The Read() method returns a boolean - was it true or false?

Thanks,

Seth Rowe