The PRACH data is saved into a tab and then moved into another tab file "ToUpdate"
Select * from PRACH_data where Obj into ToUpdate Fetch First From ToUpdate Do While Not EOT(ToUpdate) circ = CreateCircle(Longitude, Latitude, r) Fetch Next From ToUpdate Loop Fetch First From ToUpdate Do While Not EOT(ToUpdate) azimuth = ToUpdate.Azimuth BW = ToUpdate.HBW s = azimuth -(BW/2) e = azimuth + (BW/2) Create Arc into Variable pie (ObjectGeography(circ, 1), ObjectGeography(circ, 2)) (ObjectGeography(circ, 3), ObjectGeography(circ, 4)) s e pie=converttopline(pie) Fetch Next From ToUpdate Loop Fetch First From ToUpdate Do While Not EOT(ToUpdate) alter Object pie Node Add (Longitude, Latitude) pie=converttoregion(pie) Insert into WindowInfo(FrontWindow(),10) (obj) Values (pie) Fetch Next From ToUpdate Loop Commit Table ToUpdate Interactive
The thing is, the program isn't going to the NEXT row/cell in the excel file and creating a new pie at that sector... I am getting 5000 pies (same shape, same Lat, same Lot, same Beamwidth, same azimuth) but not on different points like I want..
It can be viewed in the following pic.
Can someone help please?