I'm trying to update a single record using an SDK Utility function using vb.net. I seen the example Sage provided that can update ALL field records. Here's syntax:
Util.RunNonQuery("Update titluli SET sDesc = something")
This will update all records for field sDesc in table titluli.
I only want to update select records. I thought this may work
Util.RunNonQuery("Update titluli SET sDesc = something" Where lITRecid = "something")
I do NOT get a syntax error, but nothing gets updated. Do you know why? Is there a way to update a specific record for a specific field using the SDK utility functions?
Thanks.