Db empty problem...

When I do a query that selects 0 records I get an error. How to avoid this? Here's my code:

VB Code:

DA = New OleDbDataAdapter(Query, myConnString)
Dim CB As New OleDb.OleDbCommandBuilder(DA)
 
DA.InsertCommand = CB.GetInsertCommand
DA.UpdateCommand = CB.GetUpdateCommand
DA.DeleteCommand = CB.GetDeleteCommand
Try
    DA.Fill(DS, Table) ' This is where I get the generic error
Catch e As OleDbException ' I added this code
    Try
        DA.FillSchema(DS, SchemaType.Mapped, Table)
    Catch ex As Exception
        MsgBox(ex.ToString)
    End Try
End Try

There is a peice of code I added to manage this case, but when I add a row to the table and update, the operations goes OK, but I don't have my row in the database.

Thx

Though not relevant to your post, i think the following lines are not needed:
DA.InsertCommand = CB.GetInsertCommand
DA.UpdateCommand = CB.GetUpdateCommand
DA.DeleteCommand = CB.GetDeleteCommand

Quote:

---

Originally posted by Lunatic3
Though not relevant to your post, i think the following lines are not needed:
DA.InsertCommand = CB.GetInsertCommand
DA.UpdateCommand = CB.GetUpdateCommand
DA.DeleteCommand = CB.GetDeleteCommand

---

Without these lines, sometimes, my datadabe will not be updated, so they aren't so bad at all :)

That may have other reasons. I am almost sure that those lines of code wont do anything more than:
Dim CB As New OleDb.OleDbCommandBuilder(DA)

I looked at the local variables, without these lines, commandtexts are Nothing. Maybe it's not important for some types of data, but I noticed that my database without these lines sometimes won't update.

There may be a better way to get around your exception, but you might run a SQLCommand against your database to Select Count for the table you want, and if it returns 0 then abort the fill.

The fact is that I still need to fill the dataset, at least with the schema. How can I insert a record if I don't know the schema?

I get no error running your code even when query return 0 records. Make sure you have no reserved words in your database table fileds name.

Quote:

---

Originally posted by Lunatic3
I get no error running your code even when query return 0 records. Make sure you have no reserved words in your database table fileds name.

---

I never do one error twice:D

Maybe this is a stupid thing I can't figure out now... Maybe tomorrow, when my brain is in peace...