General information
Category:
Forms & Form designer
>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
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only