Create a query that is besed on other one

Y

Yoav

Hi,
How can i define two queries in the MSP visual basic editor that connect to
the MSP SQL DB (let's assume that an ODBC connection is defined) that one
query is based on the other?
The format i'm using now:
Set objConn = CreateObject("ADODB.connection")
objConn.ConnectionString = "DSN=" & DSN & ";UID=" & STR_USER_IDENT &
";PWD=" & STR_PASSWORD_IDENT & ";"
objConn.Open
Set rs = CreateObject("ADODB.Recordset")

'Get all project name for Publishing
sql = [Here should be the SQL line]
rs.Open sql, objConn, 1, 2
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Connecting guestbook to MySQL 0
Add Records to a Table 2
Need code assistance to update pivot table from an ADO recordset 4
ODBC DSN query issue 1
Programmatically setting pivot sourcedata 0
Error Calling SQL Stored Procedure from Access 3
ADO OpenDatabaseConnection 2
Q.) Jet DB error: Multiple Users able to write to MS Access DBsimutaneously? 3

Top