Start a new topic

Create Static Query with IOM

Hello,


I am doing an import of Solicitors into exiting RE Gifts. the import works fine but I need to create a static RE query of all Gifts for which I imported Solicitors. I am not getting any errors in the Create and the AddRecord methods  but when I try to save the query, IOM gets stuck and never finishes the import. When I cancel the Import, the query exists in the RE Query Module but has zero records. 


I had this working at some point earlier this year but then unfortunately lost the code and I did not back this one up anywhere.


Note: I would use the built-in functionality to create a Gift query but there is only an option for imported gifts, not modified gifts.


I hope somebody can point me in the right direction.


This is what I have so far:


Dim oStaticQuery as CStaticQ


Public Sub BeforeImport

  ostaticQuery = new cstaticQ

  oStaticQuery. Init (import.Sessioncontext)

  oStaticQuery.createWithoutPrompt (12, "Solicitor-Import", "Solicitor Import", "Solicitor Import"

End sub


Public Sub BeforeConstituentSave

....

  Load Constituent

....

   loop through gifts to find one I am seeking

...

  oStaticQuery.AddRecord(ogift.Fields(EgiftFields.Gift_fld_ID)

....


End sub


Public Sub AfterImport

   oStaticQuery.EndCreate (me, False,False)    

                                                                           Records into the static query

   oStaticQuery.CloseDown

   oStaticQuery =Nothing

End Sub


Thanks, Philip


if it works is looks pretty simple. Thanks!
Well, After I posted this I found a solution that worked for me:

I exchanged the <code> me </code> with <code> nothing </code> :

<code> oStaticQuery.EndCreate (Nothing, False,False) </code>

If somebody has a better method of creating static queries with IOM I would be interested to know.

Login or Signup to post a comment