Create new BO from Query Result

KnightWare

How would I go about creating a new BO from the results of a query. The query returns one record only from SQL Server DB. I have an AIM table I wish to create new from that record. However some of the field names do not line up with the AIM BO attributes. I would need to insert each field from a field in the Query to a different named field in the BO.

KnightWare

I run a query against a BO. I have a record operation that starts a process when I select a record and passes the BO that the query runs against as input to the process, but the BO is empty. Selecting a record in a query results doesn't bring an instance of the object to context to be passed to the process?

Run Query and have 'Start Process' as record operation.
Pass the BO from the query to the Process as Input.
Process action = DISPLAY MESSAGE BO.ATTRIBUTE.
Display message is blank.

I assume because I selected the query record, I did not get the BO into context before passing to process.

KnightWare

Note to self.
Always, Always, Always make sure when creating a BO to an external DB table, you assign the primary key. Thought I had as I always do. As I could not find a way to do it after the fact, I had to delete the BO, re-create designating it an external DB table (This case a view) and made sure I assigned the primary key.

Wa-la
Genius.