Idea 2
and 3 are both good in my experience when used together. ie IBX, ADO, or
dbExpress still need to be used in some way and the class factory idea helps to
keep it at a level where you only use TDataset. the main problem i have found is
really the SQL statements themselves and how complex they are. interbase lets
you do select * from PRocedurename(params) where MS SQL does not. i use a class
factory which seperates a bit more having a method ExecuteProcedure(Param:array
of Variant) etc etc which then provide a TDataset to work with the results. if
you tend to use client side SQL selects then you still encounter the issue of
differing SQL on different versions. I like the idea of having a client side
class to mimic a procedure call where you override the GetSQL method for each
subclass version of the procedure for differing database.
ie
TDBGetCustomerProc
TDBGetCustomerProcIB
TDBGetCustomerProcMSSQL
etc
there
are just so many ways i've done this and lots of pros and cons for each
different way to do it.
-----Original Message-----
From: Myles Penlington [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 11 February 2003 9:23 a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: Conversion from Interbase to SQL Server.Hi,We have a requirement to convert(?) an existing application using Interbase to use SQL Server or Interbase - we are using the IBX components currently.I see 3(2?) ways of achieving this - having ruled out using the BDE.1. Replace the IBX with ADO components, using the same set of SQL statements etc for both SQL Server and Interbase. My only query on this is finding a good enough Interbase ADO driver/ODBC driver - suggestions?2. Use class factories etc and have both IBX and ADO components present, using the correct set depending on the database installed.3. Use the Delphi Datasnap/dbExpress technology (I have not used this yet or investigated it yet - so not certain if this is a starter). This needs a SQL Server and Interbase driver to make this feasible - not yet using/installed D7Your comments, experiences and ideas are requested!ThanksMyles.
