sql error

hi I wrote a code that works properly inside sqlite But inside b4a gives an error Dim str As String str = $"CREATE VIEW view_moshtari_sath as Select ROW_NUMBER() OVER ( ORDER BY year ASC , mon ASC , day ASC , ath1.ID ASC ) RowNum , ath1.bedehkari , ath1.talabkari...

Sub Service_Create 'This is the program entry point. 'This is a good place to load resources that are not specific to a single activity. Log("starting") If File.Exists(File.DirInternal,"dddNorm.db") = False Then...