Database

i got this code :
but cannot run for SQLite :

i get this error in sqlite :

<code>SQLite error near "INTO" : syntax error </code>


<pre lang="sql">cmd.CommandText = @&quot;SELECT top(5)  IdAmlak, ParentId, NameOpp, Price, [Square],
       OstanShahrMantagha, PhoneAddress, CountAmount
    INTO Melk
FROM      OPENDATASOURCE(
         &#39;SQLOLEDB&#39;,
         &#39;Data Source=217.66.216.77,1633;User ID=tinadbuser;Password=dbtin123ir&#39;
                 ).[CRM-CMS].dbo.tblTesting&quot;;</pre>

Insert Melk (field, names, list) Select ...

select sum(iif(FIELDNAME = 'Bundle', 1, 0)) as NumBundles,  
sum(iif(FIELDNAME = 'Bowed Board', 1, 0)) as NumBowedBoards,  
sum(iif(FIELDNAME = 'Jam', 1, 0)) as NumJams  
from TABLENAME

Select Fieldname, Count(*)
from Tablename
Group By FieldName

SELECT CAST(ISNULL(COUNT(ProdType),0) AS VARCHAR(10)) + ' '+ ProdType FROM ProdDtls GROUP BY ProdType

_Damian S_ wrote:

any wonder I didn't think to look there!!

SELECT V.MeaninglessColumnNameImposedBySystem1 [First Name],
       V.MeaninglessColumnNameImposedBySystem2 [Last Name], 
       V.MeaninglessColumnNameImposedBySystem3 [Address 1],
...
FROM LongViewName AS V
WHERE etc=@etc