Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help - Cannot Access The Selected Table (Error 1152)
Message
 
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00534701
Message ID:
00534764
Views:
11
Mark,

I guess, it's a typo in your code. DisplayValue is a property, not a method. I made the corrections.

BTW, I guess, your code would not work (though I didnt' try). These variables would go out of scope. Better to use form's properties, as Sergey suggested.

>Let's try to simplify and clean this up first. You can remove the AND NOT DELETED() if you already have SET DELETED ON.
In form's Init:
>WITH THISFORM
>   .cboQuadra.ROWSOURCETYPE = 3
>   .cboQuadra.ROWSOURCE = "SELECT nome_num, codigo FROM quadras ;
>      WHERE NOT DELETED()AND cod_loteamento = ?cCBO1_Value ;
>      order by nome_num INTO CURSOR cur_quadras"
>
>   .cboLote.ROWSOURCETYPE = 3
>   .cboLote.ROWSOURCE = "SELECT numero, codigo FROM lotes ;
>      WHERE lotes.Status = stat_venda AND NOT DELETED() ;
>      AND cod_quadra = ?cCBO2_Value order by numero INTO CURSOR cur_lotes"
>ENDWITH
>In the InterActiveChange of Combo1:
>DoDefault()
>local cCBO1_Value
>cCBO1_Value = This.DisplayValue
>This.Parent.cbo2.Requery()
>In the InterActiveChange of Combo2:
>DoDefault()
>local cCBO2_Value
>cCBO2_Value = This.DisplayValue
>This.Parent.cbo3.Requery()
>
>
>>I have 3 combos in a form (cbo1, cbo2, cbo3)the second combo cbo2 value depends ond the value chossen in cbo1 and the same happends with cbo3.
>>
>>When I move the pointer in the table, I allways rebuild the cursors on which cbo2 and cbo3 are based calling a function.
>>
>>Thanks in Advance
>>
>>Peter
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform