i want to get 4 variables out of a oracle dB.
this variables (MOTORWAY_ENTRANCE_ID , MOTORWAY_ENTRANCE_NO , NAME and DISTRICT_ID ) should insert in a multidimensional array.
the select statement is the following and works :
my query = "select MOTORWAY_ENTRANCE_ID,MOTORWAY_ENTRANCE_NO,NAME,DIS TRICT_ID from MOTORWAY_ENTRANCE where DISTRICT_ID LIKE '09%' AND VERSION_NO = '0' AND Version_END IS NULL"
How can I declare a multidimensional array and insert this variables into the new array in Testpartner ( VB ) ?
the second step is to get all the Motorway_Entrance between two MOTORWAY_ENTRANCE_NO
in the array above. this search has to go in both direction ( up and down between the MOTORWAY_ENTRANCE_NO ).
how can i implement this search in Testpartner (VB )?