how can I port from BDE to ODBC Express (or NativeDB). I know that I can use from the developer standpoint but how to allow the user to select from those tables if there is no BDE "database" to connect to.
The BDE and ODBC are just connectivity options you can use to get at the database. You'll have to create a new end user report solution using different data access components (BDE to ODBC Express components). There is an ODBC Express DADE plugin available from our website in our Friends | Data section. The main problem is converting your user's templates. The templates save dataview definitions down, ie. the classes in the BDE plugin you've used: daDBBDE.pas. The solution is to create a new dataview and save it as ascii text using the DBExpress plugin in a new report. Then compare this to a BDE based report template on the same database and table/fields. You should see that the class names are different for the query dataview classes. You'll have to create a text converter to load the report templates from a BLOB field or file into a stringlist, make you changes to convert the BDE DADE plugin class names to the DBExpress DADE plugin class names. Then save the template back down and try to load it into the new DBExpress report project. Here is an example of loading a binary template as ascii text into a string list and saving it back down as a binary template.
"Luis" wrote in message news:3e6fa9e5$1@dm500.... use those NativeDB have a package that performs this function. Go to the download section of their site. Jon
Comments
database. You'll have to create a new end user report solution using
different data access components (BDE to ODBC Express components). There is
an ODBC Express DADE plugin available from our website in our Friends | Data
section. The main problem is converting your user's templates. The templates
save dataview definitions down, ie. the classes in the BDE plugin you've
used: daDBBDE.pas. The solution is to create a new dataview and save it as
ascii text using the DBExpress plugin in a new report. Then compare this to
a BDE based report template on the same database and table/fields. You
should see that the class names are different for the query dataview
classes. You'll have to create a text converter to load the report templates
from a BLOB field or file into a stringlist, make you changes to convert the
BDE DADE plugin class names to the DBExpress DADE plugin class names. Then
save the template back down and try to load it into the new DBExpress report
project. Here is an example of loading a binary template as ascii text into
a string list and saving it back down as a binary template.
http://www.digital-metaphors.com/tips/ConvertBinaryTemplateToASCII.zip
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
Cheers,
Jim Bennett
Digital Metaphors
http://www.digital-metaphors.com
info@digital-metaphors.com
use
those
NativeDB have a package that performs this function. Go to the download
section of their site.
Jon