Trevor,

Thanks for the feedback. =)

Does McCasland's, or your modified CA Builder convert or build the CAs in a batch? Or does it have to be done one table at a time? If the former, any tips on how to achieve that?

Dennis


>We also use CA's. We used xCase to convert the VFP dbf's to SQL. We modified Mark McCasland's(?) CA builder to build the CA's (several hundred of them) from the sql database. We wrote a generic recursive procedure to convert the data without having to worry bulk updates etc.
>It's a huge job and you have to watch subtle differences like null fields are not EMPTY fields etc.
>Trevor
>
>>Patrick,
>>
>>Same here. What I did was rely heavily on the CursorAdapter class and the DataEnvironment class, which I made subclasses of and stuffed them heavily with method and properties to suit my needs. The 'cumbersome' part though, is to create a CA class for every table. I am figuring out how to do this via code-generation.
>>
>>Afterwards though, you can just forget about them being SQL tables. You can continue on using xBase commands as they are now your regular VFP cursors.
>>
>>>I am working on a conversion. Two things I have found very useful are the cursoradapter class and the code references tool. That is a lot of forms. What sort of application is it? How many tables are involved?
>>
>>It seems from this thread that there are a lot more using SPTs than CAs huh?
>>
>>Dennis