| PLEASE help!!! the 1st record not displayed? in VB DataReport [message #121715] |
Tue, 31 May 2005 12:02 |
eggie
Messages: 6
Registered: October 2004
|
Junior Member |
|
|
hi,
i have a porblem, i am using oracle as database. i am displaying a report using Visual Basic's DataReport.
my problem is the first record that is found is not displayed. it starts with the secode record.
here is my code:
Private Sub cmdPrintAll_Click()
Dim cn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim ALLSQL As String
ALLSQL = "SELECT ............."
Set cn = New ADODB.Connection
cn.Open "Provider=MSDAORA.1;Password=tiger;User ID=scott;"
Set rs = New ADODB.Recordset
Set rs = cn.Execute(ALLSQL)
Set DRALL.DataSource = rs
DRALL.WindowState = vbMaximized
DRALL.Show 1
cn.Close
End Sub
what seems to be the problem?
in MS Access this code works, however in oracle it does not display the first record found.
i have already checked the SQL statement and it works fine in the SQL PLUS
PLEASE HELP!!!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
