I have a parent business object with several child objects to handle the data changes when creating statements for customers. I tried to use GetDataBySQLQuery() on one of the business objects, but I get an error that a referenced key (created within the transaction) does not exist. It works fine if I use the same business object, fill the business object and make the same change.

Does the ExecNonQuerySQL() participate in the transaction of the business object? If not, how can I structure the activity so it is included. This action may change 1,000's of records and I'd rather do it with a database hit for speed purposes.

Thanks,
Jeff