Connection.begintrans

Dear all,

I am using VB to connect to Oracle Database
I have three questions:
(1) Sql Statement is :
select [field1], [field2] from table1 where [field1]='ABC' order by [field1]

The backet cannot work. It is big problem for me as the SQL statement is generated by the program and it need "" symbol for oracle. Any solutions:

Sql="select " & "[" & text1 & "] , [ " & text2 & " ] from table1.

(2)

set cm.activeconnection=cn ' cn is anther connection
cm.commandtype= adcmdtype
cm.commandtext=CSQL ' csql is sql statement

.....

cm(0)="VarType" ' it prompt the error
cm(1)=....

the error is "set parameter info has not been executed"

(3) connectionname.begintrans

prompt the error.
I think whether the connection has been created or the connection string parameter problem???
What is your view? Please help/.

Plz add the inverted comma in the end of the sql statment:Sql="select " & "[" & text1 & "] , [ " & text2 & " ] from table1"...