ConnString = "DRIVER=SQL Server;SERVER=[Server Name];UID=;PWD=;DATABASE=[Database Name]" Handle = SQLSTRINGCONNECT(ConnString) SQLEXEC(Handle, 'm.Query', 'cResults')Also, for trying them i need to know how to create a variable for saving to m.Query my SELECT Statment above :
' SELECT ft.no[Entidade], ft.nome[Nome Utente],f.telefone [Contacto], ft.etotal [Valor 1], Rtrim(f.refmb1)+SPACE(1)+RTRIM(f.refmb2)+SPACE(1)+RTRIM(f.refmb3) [Ref. MB 1], (CASE WHEN SUBSTRING(area,1,1 ) = ''C'' THEN ''C''+ substring(CAST(ft.ftano AS VARCHAR),3,2) WHEN SUBSTRING(area,1,1 ) = ''H'' THEN ''H''+ substring(CAST(ft.ftano AS VARCHAR),3,2) WHEN SUBSTRING(area,1,1 ) = ''G'' THEN ''G''+ substring(CAST(ft.ftano AS VARCHAR),3,2) WHEN SUBSTRING(area,1,1 ) = ''A'' THEN ''A''+ substring(CAST(ft.ftano AS VARCHAR),3,2) ELSE '''' END) [Amostra] FROM ft (nolock) LEFT JOIN (SELECT no , tlmvl FROM cl ) c ON c.no = ft.no CROSS JOIN ft2 f WHERE f.ft2stamp = ft.ftstamp and ft.ftstamp in (''ADM17091248603,063611992'', ''ADM17091345139,503834522'') 'Thanks again,