PoppapumpJ
Programmer
This is the error I keep getting when trying to work with a Dataset.
Object reference not set to an instance of an object.
Here is my code.
public function BuildPublishersList() as datagrid
dim dsPublishers as dataset()
dim objDatabase as clsDatabase()
dim x as string
'clsDatabase is a Class Mod that returns a dataset based on the supplied SQL. Schema = source
objDatabase.SQL = "Select * from Publishers"
dsPublishers = objDatabase.ReturnDataset
'This is where the error occurs
x = dsPublishers.Tables("Publishers"
.Columns("PubName"
.caption
end function
Object reference not set to an instance of an object.
Here is my code.
public function BuildPublishersList() as datagrid
dim dsPublishers as dataset()
dim objDatabase as clsDatabase()
dim x as string
'clsDatabase is a Class Mod that returns a dataset based on the supplied SQL. Schema = source
objDatabase.SQL = "Select * from Publishers"
dsPublishers = objDatabase.ReturnDataset
'This is where the error occurs
x = dsPublishers.Tables("Publishers"
end function