vb.net - 加入两个 Sqlite 表时出现 Crystal Report 错误；数据库架构在“内部”附近发生了变化：语法错误？

Question

我正在使用 Vb net ，在将 Sqlite 数据库的两个表中的数据提取到 Crystal Reports 时出现此错误：“数据库架构已在“内部”附近更改：语法错误？” 这是我的代码：

Private Sub btnReportPontes_Click(sender As Object, e As EventArgs) Handles btnReportPontes.Click

  Dim rpt As New CrystalReport3()
    Dim da As New SQLiteDataAdapter
    Dim myds As Data.DataSet = New Data.DataSet()
    Using cn As New SQLite.SQLiteConnection With
           {
               .ConnectionString = SqliteBuilder.ConnectionString
           }
        Using cmd As New SQLite.SQLiteCommand With {.Connection = cn}

        cmd.CommandText = " SELECT LesPontes.Pontes, LesPontes.Cage,LesPontes.Race, 
                                  LesPontes.EnPonte, LesPontes.Couvant," &
                                 " LesPontes.ŒufsPondus, LesPontes.ŒufsCassés,  
                                LesPontes.Couvés,dbFécondation.Fécondés, dbFécondation.ŒufsClaires" &   
         "FROM dbFécondation inner join LesPontes  ON dbFécondation.CoupleID = LesPontes.CoupleID 
        ORDER BY LesPontes.Pontes;"
        da.SelectCommand = cmd
        da.Fill(myds, "LesPontes")
        da.Fill(myds, "dbFécondation")
        da.Fill(myds)
        rpt.SetDataSource(myds)
        CrystalReportViewer1.ReportSource = rpt
    End Using
End Using
End Sub

所以非常感谢。

标签： vb.netsqlitejoincrystal-reports