>Hi Guys,
>
>I have a form containing a pageframe than consist of 67 pages. Each pages has specific collection of controls like grids, textboxes, editboxes, combobox etc. I also have 67 tables that corresponds to each page. My question is if I have to use the tables in the load event of my form, without re query, will it affect the speed of the form?
>
>Your advice and suggestions will be greatly appreciated....
>Thanks in Advance....
Mike,
Opening of 67 tables has much less impact on speed than creation of objects on 67 pages. (Try with a backup of original as always)
-Create a class for each of your pages (Select controls there and saveas class)
-Also include opening/requerying of table in class
-After creating each class delete objects on page and in Page.activate code :
if type('this.ClassNameForPage')#'O'
this.NewObject('ClassNameForPage','ClassNameForPage','ClassLibName.vcx')
this.ClassNameForPage.Visible = .t.
endif
You might need some enhancing in code.
Cetin