>>Hi folks!
>>
>>Using CA Builder, how do you deal with the 255 character limitation?
>>
>>TIA
>Copy both window contents to a temp code window, decrease field count so error doesn't occur, paste copied ones.
>At least till I design my own :)
>Cetin

Hi Cetin,

Download my CA VCX Builder and it will do this for you. It will create a VCX with a CA for every table in the DB [a DBC, SQL Server or Oracle]. It will put as many fields in the CursorSchema as possible without exceeding the 255 limit. It will then put the full schema in code for use at runtime.

It is free, contains all source code and a ton of info in the form of comments at the beginning of the PRG file.

http://www.mctweedle.com

Then click the FoxPro Tools link.