INSERT clausole Where in string conn

Topic

New Reply

How to insert a clausole Wehre in this con?

sConnString = “Provider=SQLOLEDB;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=” & T_DATABASE & “;Data Source=xxxxxxxxx”
oConn.Open sConnString

oReco.Open “Select * From ” & T_TABELLE, oConn, adOpenStatic
NUMERO_CAMPI = oReco.Fields.Count

note:
T_DATABASE and T_TABELLE are a String variable

Reply | Quote

Replies

C’mon Sal, you shouldn’t need to ask that. You’ve written SQL statements with a WHERE clause before.

Reply | Quote