Options
SQL Data Generator forgets python scripts and functions
travisrjohnson
Posts: 2
I have an issue with SQL Data Generator where fields forgot the python function or script that is saved. If I have some code, such as below, and I click out of the field, the preview data shows the values in the column as expected. But if I click back into the column to edit the script, the script text disappears and the value for the column is set to null.
This happens with all python scripts and functions, such as the Cross Column DateAdd. I have multiple columns that each have a date value that is a few days after the previous column. When I wanted to edit the columns to change the number of days that were different between the columns, their all become blank as I clicked on them to edit the DateAdd parameter.
def main(config):
return random.randint(0,50000)
I had python 2.7.8 installed initially, and then unisntalled it and installed 2.7.7. The issue is present with both versions.
This happens with all python scripts and functions, such as the Cross Column DateAdd. I have multiple columns that each have a date value that is a few days after the previous column. When I wanted to edit the columns to change the number of days that were different between the columns, their all become blank as I clicked on them to edit the DateAdd parameter.
def main(config):
return random.randint(0,50000)
I had python 2.7.8 installed initially, and then unisntalled it and installed 2.7.7. The issue is present with both versions.
Comments
Thanks for submitting your inquiry!
I will be working on a reproduction of this issue and will update you as soon as I have more info.
Thanks for your time and patience,
Rick
Technical Support
Red Gate Software Ltd.
I'd like to take this offline and do some additional troubleshooting with you. I will be responding to you through the existing case.
Thanks!
Rick
Technical Support
Red Gate Software Ltd.
Now I have to keep all the scripts in external files and recreate them every time I load the project.