Board index » delphi » ADO with MSSQL2000 and Access2000

Markus Waibel

Delphi Developer
Fri, 29 Apr 2005 20:43:01 GMT

ADO with MSSQL2000 and Access2000

I want to use a single Application rather with a MS-SQL2000 or with a
MS-Access2000 Database. Cause of some reasons i have to read the Field-List
at Designtime. Because the Fieldtypes of the both Databases do not fit 100%
(WideText vs MEMO) i become a error when switching between the databases.
What can i do against it?
 
Mike Shkolni

Delphi Developer
Fri, 29 Apr 2005 23:13:51 GMT

Re:ADO with MSSQL2000 and Access2000


Why you need persistent fields (in design-time)? Just work with FieldByName
etc

--
With best regards, Mike Shkolnik
EMail: mshkol...@scalabium.com
http://www.scalabium.com

"Markus Waibel" <Mwai...@vol.at> ???Y/???Y ????? ???Y??:
news:3dcfa5fa@newsgroups.borland.com...

Quote
> I want to use a single Application rather with a MS-SQL2000 or with a
> MS-Access2000 Database. Cause of some reasons i have to read the
Field-List
> at Designtime. Because the Fieldtypes of the both Databases do not fit
100%
> (WideText vs MEMO) i become a error when switching between the databases.
> What can i do against it?

Brian Bushay Team

Delphi Developer
Sat, 30 Apr 2005 13:45:31 GMT

Re:ADO with MSSQL2000 and Access2000


Quote
>I want to use a single Application rather with a MS-SQL2000 or with a
>MS-Access2000 Database. Cause of some reasons i have to read the Field-List
>at Designtime. Because the Fieldtypes of the both Databases do not fit 100%
>(WideText vs MEMO) i become a error when switching between the databases.
>What can i do against it?

If you need persistent fields you will need to create them at runtime.  By doing
that your persistent fields will be comparable with the actual fields in your
table.

--
Brian Bushay (TeamB)
Bbus...@NMPLS.com

Other Threads

1. database update problem with D6 ADO/VCL, ADO v2.6, and MS Access2000

2. ADO Append Method doesnt work :-( D5 MSSQL2000

3. sql to xml using ado with mssql2000

4. D5 ADO to Access2000 Default Parameter Errors

5. Problem connecting to a secured Access2000-Database with ADO

6. ADO-Access2000-Multiuser-Edit Locking?

7. ADO Express and Access2000 Synchroisatio

8. Password issue in ADO & MS Access2000 Database

9. password access2000 + ADO + DELPHI5

10. Alternative Index D5,Ado, and Access2000