Virtual Dataset, When and how to use?

Erik · January 2004

I am looking for documentation on when and how to use a "Virtual Dataset" on a report band.

Specifically I am looking for a way of specifiying field names on a report where the underlying data component could change.

I am using Codebase for my database. My datasource started as a Codebase table, but later on I changed it to a query. All of the field names remained the same, but I had to change the prefix of every single field from cbTable."Blah" to cbQuery."Blah".

I am looking for a way to reference my fields without having to hard code the component. This way if the component changes, but the fieldname remains the same, I don't have to change all the fields.

I am hoping a Virtual Dataset will hold some answers, but I can't find any documentation. Any help would be greatly appreciated.

Regards,

Erik

gordk · January 2004

Hi that won't solve your problem
when a band's data source is set to virtual with a record count. all it realy does is control the number of times the band appears.
regards

Erik · January 2004

Is there another way of solving the problem where I have to rename all of my field references if the data component changes?

-Erik

llutti · January 2004

You can use the frUserDataset, to control manually the information. Other way is use only ???TQuery???, because, I think, it???s better and faster that ???TTable???.

Luciano Cargnelutti

Virtual Dataset, When and how to use?

Comments

Leave a Comment