Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Three combos in a form
Message
De
24/08/2001 13:24:47
 
 
À
24/08/2001 12:44:31
Information générale
Forum:
Visual FoxPro
Catégorie:
Gestionnaire d'écran & Écrans
Divers
Thread ID:
00548557
Message ID:
00548818
Vues:
14
>Thank for your reply Michael.
>I wonder to know if you post the code to check it out.
>Thank again.

* This is a selecting of the data based on a varable that is
* related to the selection from a previous combo. ( nProj_no )
* This will go into a cursor. Since it comes through ODBC.

SELECT SEGMENT.seg_no, SEGMENT.user_seg_no
FROM main_one!PROJ_SEG LEFT OUTER JOIN main_one!SEGMENT
ON PROJ_SEG.seg_no = SEGMENT.seg_no
LEFT OUTER JOIN main_one!SEG_TYPE
ON SEGMENT.seg_type = SEG_TYPE.seg_type
WHERE PROJ_SEG.proj_no = ?nProj_no
AND SEG_TYPE.production > 0

SELECT the_cursor
* Set the array that is bound to this control
DIMENSION bound_array[1,2]
bound_array = ""
SELECT the_cursor.user_seg_no, the_cursor.seg_no FROM the_cursor INTO ARRAY bound_array
THIS.REQUERY

*******************************************************************
* As for the code for the floating container.
* If you require this info I could get it to you. No problems.
* But there's a lot of code to post from several places.
* I could make up a text file and send it to you.
*******************************************************************

HTH
MIke
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform