News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP (Archived) VBA, ADO, and GP2010.....

Microsoft Dynamics GP (Archived)

VBA, ADO, and GP2010...Sample of updating a deleting SQL records needed for code upgrade.

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

I am upgrading some VBA code to GP2010 and need to upgrade the syntax for ADO. All of that was going fine until I hit the "update" code. I cannot find any samples or instructions for doing the following and everything still compiles. I know I can build up a text command but that seems like a big step backwards. Below is the old way which worked, does anybody know how or have a sample with the new method?

I bomb on the rst.AddNew line.

rst.AddNew

'rst("ITEMNMBR") = AlternateItems.ItemNumber.Value

rst!ITEMNMBR = AlternateItems.ItemNumber.Value

'rst("ALTPART_I") = AltPart.Value

rst!ALTPART_I = AltPart.Value

'rst("Exclude") = Exclude.Value

rst!Exclude = Exclude.Value

rst.Update

*This post is locked for comments

All responses Img

All responses (2)

Answers Img

Answers (0)

sandipdjadhav 18,265 on at

Like (0)

Report

RE: VBA, ADO, and GP2010...Sample of updating a deleting SQL records needed for code upgrade.

What error it throw?
Bryan Prince 660 on at

Like (0)

Report

RE: VBA, ADO, and GP2010...Sample of updating a deleting SQL records needed for code upgrade.

Hi Jon,

AddNew is still the proper method to use in order to create a new record in Dynamics GP 2010.

Perhaps there is a separate issue? Are you sure you opened the recordset properly? If you could post a complete code sample reproducing the issue we could look into it further.

Bryan Prince

Straight Arrow Consulting, Inc.

(615) 337-9248

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2

Martin Dráb 230,235 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans