Returning an array!

[Smitty020]

I orginally had a function that returned a recordset, so it looked like this

get_list = ...OpenRecordset(SQL,...)
GetObjectContext.SetComplete

but now, I built a new function that returns an array, and looks like:

get_list = array
GetObjectContext.SetComplete

What I want to know is, what does the "GetObjectContext.SetComplete" do? Do I need it when returning an array?

 

[MikePP]

Hi

SetComplete command is normally used for state management. It should have little to do with retrieving data.

This leads me to think you will still need it.

Regards

Sadcow

 

[JohnYingling]

The SetComplete has nothing to do with the array. It indicates to MTS that the transaction is complete and all updates can be committed to the database.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript