L lijingtong Member Aug 2, 2008 #1 Sub App_Start Form1.Show con.New1 cmd.New1("",con.Value) con.Open("Data Source = " & AppPath & "\pinyin.db") Cmd.CommandText = "select * from pinyin where code='" &"a" & "'" cmd.ExecuteTable("table1",500) End Sub Result: "a" how to do it can the result is "ai" "dai" "aaa"……
Sub App_Start Form1.Show con.New1 cmd.New1("",con.Value) con.Open("Data Source = " & AppPath & "\pinyin.db") Cmd.CommandText = "select * from pinyin where code='" &"a" & "'" cmd.ExecuteTable("table1",500) End Sub Result: "a" how to do it can the result is "ai" "dai" "aaa"……
Erel B4X founder Staff member Licensed User Longtime User Aug 2, 2008 #2 B4X: cmd.CommandText = "SELECT * FROM pinyin WHERE code LIKE '%a'"