Skip to Content
Former Member
May 25, 2005 at 08:32 PM

Select with aggregate functions? i.e. select max(code)...


The code field on my user table is too small for the key field I want to use but it is still necessary I assume I must generate my own unique value.

The DBDataSource.Query() method doesn't seem appropriate so should I create a SAPbobsCOM.Recordset and use the DoQuery method to select the maximum value currently in the user table?

I found some mentions of requiring such a select statement on this board but no examples of the actual code. I'll go ahead and try the DoQuery method unless I hear of something more appropriate.

Also, I saw a comment that a future release of SAP would have a larger code field for user tables but obviously that didn't happen in 6.7.

Thanks for any comments.

Bill Faulk