This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- InstallShield
- :
- InstallShield Forum
- :
- Re: Bug in Creating SQL Script
Subscribe
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 25, 2009
02:17 AM
Bug in Creating SQL Script
hi,
When i created a SQL Script using the Database Wizard for a database i found that the script is not getting created in the proper order. The User Defined function script is getting created at the last and Views are created before. If i am using this User Defined function in the create View which is executed before creation of functions i am getting error when i run the generated script in sql Client.
Please let me know what is the problem asap.
regards,
Raghavendra
When i created a SQL Script using the Database Wizard for a database i found that the script is not getting created in the proper order. The User Defined function script is getting created at the last and Views are created before. If i am using this User Defined function in the create View which is executed before creation of functions i am getting error when i run the generated script in sql Client.
Please let me know what is the problem asap.
regards,
Raghavendra
(1) Reply
- Mark as New
- Subscribe
- Mute
- Permalink
- Report Inappropriate Content
Aug 29, 2009
11:29 PM
I would not use the database import wizard. I would run individual SQL scripts in the necessary order using batch mode. That way, you can control which script(s) run before other scripts.
Tim
Tim
![](/skins/images/8CE4FAD0DE6F3A6F9D0567434D2D2DAE/responsive_peak/images/icon_anonymous_message.png)