search

hankinsoft / SQLPro

SQLPro bug & features tracking.
100 stars 27 forks source link

Failed to generate View script #908

Closed cwolcott closed 1 year ago

cwolcott commented 1 year ago

Describe the bug Selected a existing view and used the Menu 'Script as' ...'Create to' ... 'New query window' and received the following error

/* Generation failed with the following error: ORA-31603: object "SF_DSF_VIEW" of type TABLE not found in schema "MOLMAN"

Why does it think this is a TABLE and not a VIEW? Selecting a TABLE and performing the same menu actions works just fine.

To Reproduce Steps to reproduce the behavior:

  1. Select any view
  2. Click on 'Script as' ... 'Create to' ... 'New query window'
  3. See error

Expected behavior A creation script would be generated for the VIEW.

Screenshots

image

Environment details (please complete the following information):

hankinsoft commented 1 year ago

I should have this sorted for a build next week.

hankinsoft commented 1 year ago

New build have been approved and should be available. If not then by tomorrow. If you get the chance, please give it a try and let me know if things are sorted up.

cwolcott commented 1 year ago

Version 2023.50 (Build 575.5) fixes the issue. Thank you.