Home » Other » General » PLEASE help!!! the 1st record not displayed? in VB DataReport
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!!!
Previous Topic: Database Replication
Next Topic: connect oracle through vb
Goto Forum:
  


Current Time: Sat Nov 23 03:22:12 CST 2024