Peculiar behaviour with the SPT Data Access builder: Involuntary deletion of getsqlstring method.

I noticed a little problem with the SPT Data Access builder which I think is a bug. It concerns Business Objects that use dataenvironments based on SQL Pass Through. More in particular when these dataenvironments are edited from the Business Object Builder through the Data Access Edit Form for SPT. The phenomenon is that code in the methods gets deleted when changing a property.

Example 1) When there is already code in the getsqlstring method and the nodataonload property is changed to .T. By checking the checkbox ‘no data on load’, followed by clicking the OK button, saving changes and closing the MM BizObjbuilder, the contents of the getsqlstring is deleted.(the no-Default text disappears)

Example 2) When I want to associate a Business Object to a SPT ‘environment’ that already exist (by selecting it in the combobox of the Business Object builder) and I click the edit button, the getsqlstring of that SPT data access object appears also to be deleted.

Has anyone experienced the same problem? What can be done?


Mark.