Hi everyone, our application is a 3-tier application and we're using BDE/Paradox : Server application : TSession+TDataBase->TQuery->TDataSetProvider Client Application : TDComConnection->ClientDataSet
We're trying to migrate to dbexpress with the hope to be multi-database. We've tried connection with MySQL and MSSQL with success. With MySQL and MSSQL the fields created in the TClientDataset weren't different from before except for the TDateTimeField which will replace by the TSQLTimeStampField, so some change in our code(server side and client side) but usefull and efficient changes. But the problem come with Oracle, mainly with the TFMTBCDField. In our tables we have a integer field for index, in the other Databases "Integer" type exist but in Oracle it's "Number" type. Then in delphi "Number"=TFMTBCDField not TIntegerField, that will force us to modify all side of our application Server and client. Here comes my questions, is there someone who experienced this kind of migration (BDE/Paradox and DBExpress/Oracle) ? Or is there a way to modify only server side ? Excuse my english, I'm not sure that I explained rightly my problems so don't hesitate to ask details. Guillaume ROQUES ------------------------------------------------------------ CANYON Technologies _______________________________________________ Delphi-DB mailing list Delphi-DB@elists.org http://lists.elists.org/cgi-bin/mailman/listinfo/delphi-db
