Hi, I'm working on a vb.net application for PPC (Visual Studio 2008),
with SQLite DB files and I have a problem on creating a master/detail form.
I have created a dataset file (xsd) containg a single table. I also
created a form containg a DataGrid, which is connected with the dataset
through a BindingSource component.
And in the sub MyForm_Load, there is the following code:
Me.MyTableAdapter.Fill(Me.DataSetMyData.mytable)
Everything is just ok.
Afterwards, I added a second table in the dataset file, for
master/detail relationship. And a second DataGrid on the form, which I
connected with the dataset and the second table. And the following code
was added on the _LOAD sub:
Me.MyNewTableAdapter.Fill(Me.DataSetMyData.mynewtable)
When I'm executing the application, a SQLiteException is raised in the
dataset file on the following code:
Public Overloads Overridable Function Fill(
ByVal dataTable As DataSetMyData.mynewtableDataTable
) As Integer
Me.Adapter.SelectCommand = Me.CommandCollection(0)
If (Me.ClearBeforeFill = true) Then
dataTable.Clear
End If
Dim returnValue As Integer = Me.Adapter.Fill(dataTable)
' EXCEPTION RAISED ^^^^^^^^^^^^^^^^^^^^^^^^^^
Return returnValue
End Function
The exception that is raising on the second table is the following:
SQLiteException: Unable to open the database file
at System.Data.SQLite.SQLite3.Open()
at System.Data.SQLite.SQLiteConnection.Open()
at System.Data.Common.DbDataAdapter.QuietOpen()
at System.Data.Common.DbDataAdapter.FillInternal()
at System.Data.Common.DbDataAdapter.Fill()
at System.Data.Common.DbDataAdapter.Fill()
at
MyApplication.PDA.DataSetMyDataTableAdapters.mynewtableTableAdapter.Fill()
at MyApplication.PDA.FormMyData.FormMyData_Load()
at System.Windows.Forms.Form.OnLoad()
at System.Windows.Forms.Form._SetVisibleNotify()
at System.Windows.Forms.Control.set_Visible()
at System.Windows.Forms.Control.Show()
at MyApplication.PDA.Form1.btnTest_Click()
at System.Windows.Forms.Control.OnClick()
at System.Windows.Forms.Control.WnProc()
at System.Windows.Forms.Control._InternalWnProc()
at Microsoft.AGL.Forms.EVL.EnterMainLoop()
at System.Windows.Forms.Application.Run()
at MyApplication.PDA.Form1.Main()
I did a test application for windows (win32 platform) and it seems to
work just fine!!!
What's going wrong?
Thank you in advance.
--
Stratos Nikolaidis
Thessaloniki, Greece
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
