SQL statements from within NAv 2009 Classic

HenningTh

Hi everyone
Any having the perfect idea how to pass on SQL-statments, SQL-selects and similar from a Codeunit, table or report. The idea is to use the Soundex-index in SQL for a very special purpose and this presumeably demands a variety of these commands to retrieve the correct info.

Thanks :-k

manisharma31

This Might Help,

InSetup.GET();// Navision Setup form for conneting to SQL Server/Database/Userid/Password

CREATE(adoConnection);//'Microsoft ActiveX Data Objects 2.8 Library'.Connection

CREATE(adoRS); //'Microsoft ActiveX Data Objects 2.8 Library'.Recordset

adoConnection.ConnectionString('Provider=SQLOLEDB;Data Source='+InSetup."SQL Server"+';'
+ 'Initial Catalog='+InSetup."SQL Database"+';User ID='+InSetup."SQL User ID"+';Password='+
InSetup."SQL Password");

adoConnection.Open;

sSql := 'Select * FROM .[dbo].';

adoRS.Open(sSql,adoConnection,2,3);
adoRS.MoveFirst;

sSql(Text[1024]) := 'INSERT INTO .[dbo].';
sSql2(Text[1024]) :='''Product'''+ //F1

adoConnection.Execute(sSql+sSql2);//Execute the SQL Statment

KYDutchie

There is an excellent post on the ADO subject:

http://www.mibuso.com/forum/viewtopic.php?f=5&t=23038&hilit=Ado

This should put you on the right track.