I am a very novice SQL and Stimulsoft person. I would like to create a reference of all the fields in each database with the field type and length. I can do a SELECT * on each database and then place all retrieved fields on a report manually. But is that the only way? Some of the databases have hundreds of fields and this would be a very time-consuming task. Is there a way to just generate a report like this automatically?
Thank you!
Easier way to generate list of all fields in a table than SELECT * and placing
Re: Easier way to generate list of all fields in a table than SELECT * and placing
Hello.
There are the Schema wizard and the report wizards.
You could use them.
The Schema wizard helps you to add data sources without writing SELECT *.
The Report wizard helps you to create the list.
Thank you.
There are the Schema wizard and the report wizards.
You could use them.
The Schema wizard helps you to add data sources without writing SELECT *.
The Report wizard helps you to create the list.
Thank you.
Re: Easier way to generate list of all fields in a table than SELECT * and placing
Thank you for your reply! Maybe I posted in the wrong area because my Stimulsoft Report Writer screens don't look like anything on the schema wizard link in your post. I am working in Stimulsoft Reports v 2018.1.8 from 19 February 2018, ASP.NET, Flex . When I click to add a data source, I don't have the option to check "skip wizard." or really any of the other things in the schema link. Am I in the wrong place?
-
- Posts: 6266
- Joined: Tue Mar 20, 2018 5:34 am
Re: Easier way to generate list of all fields in a table than SELECT * and placing
Hello,
Unfortunately, this feature is not available in the flex version.
Thank you.
Unfortunately, this feature is not available in the flex version.
Thank you.