Home » Other » General » How I Can Create Query >>> OO4O & VB
icon5.gif  How I Can Create Query >>> OO4O & VB [message #258033] Thu, 09 August 2007 21:09 Go to next message
Messages: 1
Registered: August 2007
Junior Member

I am using the OO4O method in an VB application
and I need help for create Query to print it by Crystal Report

i write code, compiler does not objection
also there is no response for out
may be code is not completed
My code is as follows

@ Module
Public CS As Object
Public DB As Object
Public Tabel1 As Object
Public Query1 As Object

@ Form Load

Set CS = New OracleInProcServer.OraSessionClass
Set DB = CS.OpenDatabase("", "general/case", 0&)
Set Tabel1 = DB.CreateDynaset("Select * from Tabel1 ", 0&)

@ Command

Set Query1 = DB.CreateSql("Select F1,F2 from Tabel1", 0&)

CrystalReport1.ReportFileName = "Q1.rpt"
CrystalReport1.Connect = "uid=intelligence;pwd=case"
CrystalReport1.Action = 1

[Updated on: Thu, 09 August 2007 23:00] by Moderator

Report message to a moderator

Re: How I Can Create Query >>> OO4O & VB [message #258034 is a reply to message #258033] Thu, 09 August 2007 21:30 Go to previous message
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
I suggest you go post in some VB or Crystal Reports forum, because your problem will not benefit from advice about Oracle.
Previous Topic: sqlplus returning output values
Next Topic: What is up with the large download size of 11g?
Goto Forum:

Current Time: Fri Dec 03 06:54:15 CST 2021