Which is the best way to get data from user difine tables with condition

[Former Member]

Hi everyone,

I would like using SBO DIAPI to get UDT data rows, there is a method of UserTable.getbykey can get one row information, but I like to get a list of rows from UDT, and the get list have its condition such as: field1="Type_A" ect.

also I want to avoid using doquery get data from DB, because there is direct access DB potential Suspect.

I am using SBO 2005 PL09 & visual studio(VB.net) 2005 and I only using DIAPI do not using UIAPI.

Thanks for any advice.

Kathy

[former_member185703 · Accepted solution]

Hi Kathy,

Unfortunately SBObob.GetObjectKeyBySingleValue only works for the B1 business objects as listed in the documentation.

So, when you don't know the keys (= Code) of the records you want to get from your UDT - there's no way around using Recordset object's DoQuery method!

Sorry,

Frank