SQL Dot net variable Initialization Issue

(0) Share

Report

Posted on by Community Member

Hi, We are having requirement to fetch the data from External SQL table and Insert the values in NAV tables. Once the data has been read then the record should automatically updated as “Completed “ in External table. This Code unit has to be recurred every 30 minutes using NAS. We have used two dedicated SQL Queries : INSERT, UPDATE.

In NAV we have used DOT NET variables (SQLDATAREADER) to read the data from SQL Table. To update the data I have used SQL DATA ADAPTER concept in dot Net variable (System. Data. Common. DB Data Adapter. 'System. Data, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089').

( NOTE: We have not used Automation variable (ADO) , since the NAS is performing at backend. )

Issue faced: While running this Query I am Getting error “ Data Adapter not Initialized “ .

Please let me know any solution which is possible as this has become critical for the project.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (4)

Answers (1)

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

What code did you write using SQL DATA ADAPTER ?

Can you show us the code?

Was this reply helpful? Yes No
Rashed 3,765 on at

Like (0)

Report

Here is an example using datareader.

mibuso.com/.../using-ado-on-rtc-in-nav

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

1. First time i tried this one :

UpdateSQLStr := 'UPDATE [COPY_MFS].[dbo].[MFDB_LEDGER_PRINCIPAL] SET [Copied_NAV] = ''1'' , [Copied_Date] = Getdate() ' +

'WHERE [COPY_MFS].[dbo].[MFDB_LEDGER_PRINCIPAL].[MFDB_LedgerNumber] = ' + FORMAT(LedgNumber);

SQLAdapter := SQLAdapter.UpdateCommand(UpdateSQLStr,SQLConnection);

2. Second time i tried this one :

SQLAdapter.UpdateCommand('UPDATE [COPY_MFS].[dbo].[MFDB_LEDGER_PRINCIPAL] SET [Copied_NAV] = ''1'' , [Copied_Date] = Getdate() ' +

'WHERE [COPY_MFS].[dbo].[MFDB_LEDGER_PRINCIPAL].[MFDB_LedgerNumber] = ' + FORMAT(LedgNumber) ) ;

IN both cases i was getting syntax error

Thanks

Was this reply helpful? Yes No
Verified answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

You should always CREATE automation/dotnet variables before using them..

example code is

IF ISCLEAR(lADOCommand) THEN

CREATE(lADOCommand);

Was this reply helpful? Yes No