Hi Folks,
The API 7.6.3 removes the restriction of char 0 (& Diary) fields from ARGetListEntryWithFields from its doc (it's about time!) but that same doc does not indicate what happens when that API is used against an older server. What can happen is: 1) The restriction is abided by, that is char 0 fields are not returned in the arrays of field values 2) The API issues separate calls to return these values so that these fields are returned. If (2) what types of calls and what is the performance impact? Ie if there are 1000 results, are the an additional 1000 ARGetEntry calls made? If (1) then I wonder further, If a single call to ARGetListSQL get those fields for the set of returned records would be a reasonable thing to do (to have a total of 2 server calls for 1000 records) (and with a constructed where clause). The only issue would be that Administrator is required (almost always used anyhow) and that Get filters change could these fields values (unlikely but possible). I note that the documentation for the new ARSetGetEntry() includes a description of what happens on older servers. If I had my preferences, that SetGet would also handle Creates and Merges as I need to do a SetGet in those cases as well. So, SetGet is only a limited performance gain for me. Thanks Ben Chernys Senior Software Architect Software Tool House Inc. Canada / Deutschland / Germany Mobile: +49 171 380 2329 GMT + 1 + [ DST ] Email: <mailto:ben.cher...@softwaretoolhouse.com> ben.cher...@softwaretoolhouse.com Web: <http://www.softwaretoolhouse.com/> www.softwaretoolhouse.com Check out Software Tool House's free Diary Editor. Meta-Update, our premium ARS Data tool, lets you automate your imports, migrations, in no time at all, without programming, without staging forms, without merge workflow. <http://www.softwaretoolhouse.com/> http://www.softwaretoolhouse.com/ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug11 www.wwrug.com ARSList: "Where the Answers Are"