sql views

[Bre-x]

Hi
We are using MS Access 2000

I need to send to a pervasive sql server the following sql commands

drop VIEW vw_test;

Create View vw_test As
SELECT BKAR_CUSTCODE, BKAR_CUSTNAME FROM "BKARCUST";

Any ideas?

Thank you,

Bre-x

 

[Bre-x]

This seems to do the trick

Function CreateView()
'Declare all necessary ADO objects
Dim cn As New ADODB.Connection
Dim cmd As New ADODB.Command
Dim sqlString As String
'Open connection
cn.ConnectionString = "DSN=UMCClientDB"
cn.Open
'Set up Stored Procedure for execution
cmd.ActiveConnection = cn
sqlString = "Create View RON_GL As SELECT * FROM BKGLTRAN where
BKGL_TRN_GLDPT = 'UMC' AND BKGL_TRN_GLACCT = '1355'"
cmd.CommandText = sqlString
cmd.Execute
cn.Close
Set cmd = Nothing
Set cn = Nothing
End Function

 

[Van T. Dinh]

That's about how I would do it.

If I read your first post correctly, ALTER VIEW would be the way to go.