AspWebSolution Forums » Products » ASP Report Wizard v2

index | search | no replies | posting guidelines | help

» »

:: database views (server side) :: (23)

Post a New Message | Post a Reply

Oct 1 2004, 12:05 PM

Re: database views (server side)

Post a Reply

harveyb

from: ny

<%

Dim objWiz
Set objWiz = Server.CreateObject("AspWebSolution.ReportWizard2")

'Make sure you initialize before adding any HTML text
'TODO: Change this to your actual connection tring

'objWiz.DatabaseType = ""

'...
'objWiz.DatabaseTablesQuery = "SELECT [Name] FROM SysObjects WHERE ([TYPE]= 'U' or [TYPE] = 'V') AND [UID] = 1  ORDER  BY 1"
'objWiz.DatabaseViewsQuery = "SELECT [Name] FROM SysObjects WHERE [TYPE] = 'V' AND [UID] = 1  ORDER  BY 1"

'put this where you want your reports

  objWiz.DatabaseTablesQuery = "SELECT [Name] FROM SysObjects WHERE [TYPE]= 'U' AND [UID]=1 ORDER BY 1"
  objWiz.DatabaseViewsQuery = "SELECT [Name] FROM SysObjects WHERE [TYPE]= 'V' AND [UID]=1 ORDER BY 1"

  objWiz.DatabaseType = "SYBASE"
  'objWiz.Init(strConnectionString)
  objWiz.Init("PROVIDER=ASAProv;DATA SOURCE=research-frodo;")

objWiz.DisplayReports

Set objWiz = Nothing

%>

Oct 5 2004, 10:02 PM

Re: database views (server side)

Post a Reply

harveyb

from: ny

hi,

did you get a chance to review the sourcecode?

Oct 6 2004, 12:55 PM

Re: database views (server side)

Post a Reply

ghost

from: Washington, DC

haven't had a chance to get a copy of Sybase Anywhere...but I will try to download a copy as soon as possible.

-------------------------
Ghost

Pages: (2) 1 [2]