>Hi,
>
>I have a DBC with 18 tables and 11 views. Most of the tables have relation between them. When I used GenDBC program on this database to create a program 'Myprog' to recreate the database, it gives me an error, program too long. And it gives error on the line 460, where the GenDBC tries to compile myprog.
>
>Any ideas to avoid this....?
>
>Actually, I need to add more views to this database. Probably 20 to 25 views. So I need GenDBc to work on this DBC.
>
>Please Help....
This is a known problem with GenDBC in VFP 5.0. The GenDBC in version 6.0 addresses this by breaking the resulting program into separate procedures for you.
I highly recommend the public domain utility GenDBCX. It addresses the issue by instead creating a class definition whose methods each recreate a single table, view or relation. It also has a method that calls each method, so the end result is the same as how GenDBC was supposed to work. I think GenDBC is here in the files section.
Erik Moore
Clientelligence