>Sergey,
>
>When I dropped the CA class into my DE class, I modified the SelectCmd to include a Where clause.
>
>The weird thing is, even if I use the Nodata = .T. option, it still freezes up.
>
>Is changing the structure to Varchar really imperative?
>
>Thanks
>Dennis
Not really. But desirable, as your tables will occupy less space.
If you change selectCmd when you put this class in DE, add where 1=0 just in case to the CA itself. 1=0 prevents records being brought up. In addition, as I suggested, explicitly list all fields in the SelectCmd, don't use select *
If it's not broken, fix it until it is.
My Blog