Information générale
Catégorie:
Gestionnaire d'écran & Écrans
You were right on the money - that was indeed my problem. Thanks for your suggestion - it works perfectly!
>If I'm right that's the problem. You use that cursor as a rowsource and probably "makelists" method is trying to do a reselect into same cursor in interactivechange. It cannot because they're in use by combos. Well I think what I say is not clear. OK here is whatto do. Since your combos rely on SQL cursors to show their content, instead of preparing SQL then setting their RowSourcetype as fields, let combos have RowSourceType = SQL and their Rowsource = "select ... into cursor myCursor". Of course cursorname would be different for each combo. Then all you need is to call a requery when SQL content should change :
>
>RowSourcetype = SQL && (I think it was 3)
>RowSource = "select PatName,PIDCode "+;
> "from Patient_ "+;
> "where PIDCode = thisform.pgf.page1.TxtPIDCode.value "+;
> "into cursor myPIDCode"You could put this in init of combo. Leave combo properties for Rowsource* as (None) in designer. Their "requery" could be called in gotfocus of combo if needed :
>this.requery(). If you do this right you would probably need no interactivechange code too (honestly I couldn't understand the purpose there).
>
>Cetin
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement