Connecting Navision using ADO SQL Query Parameter.

Dev1978

I am trying to connect the local client to SQL Server database using the ADO functionality. It is working proper. But my question is that how can i like a parameter to the query.

nm :='JOHN';
SQLString := ' SELECT * FROM [MSRETAIL].[dbo].[MS Retail$CUSTOMER] ' +
' WHERE [NAME] = ' + nm ;

I have declared the nm as a text parameter in global variables.

When i run the code it gives me error 'invalid column name JOHN';

How to link the parameters to the query.

jup

Hi,
try this:

SQLString := ' SELECT * FROM [MSRETAIL].[dbo].[MS Retail$CUSTOMER] ' +
' WHERE [NAME] = ''' + nm + '''';

bbrown

Use "ADOCommand.CreateParameter" and "ADOCommand.Parameters.Append"

Dev1978

Thanks jup it is working....

Now how to display the decimal values using ADO in navision?

ara3n

in your sql statement you need add cast to a float and then in nav you can receive into a decimal datatype.