Catherine,
Here is a snippet of code from a program I wrote that checks the length of the info in a field. From the length it determines if there are one or two photos to open.
Not the best person at MapBasic but maybe this will spark an idea.
Could also do by checking for values in multiple fields.
Hope this helps.
if PhotoLen = 10 Then
Photo = TempPhoto.Photo_ID
PhotoPath = "C:\Program Files\Internet Explorer\IEXPLORE.EXE X:\Infrastructure\Utilities\StormWaterInventory\Photos\"+Photo
Run Program PhotoPath
Else if PhotoLen = 22 Then
Dim Photo1 as String
Dim Photo2 as String
Dim PhotoPath1 as String
Dim PhotoPath2 as String
photo1 = Mid$(TempPhoto.Photo_ID,1,10)
photo2 = Mid$(TempPhoto.Photo_ID,13,10)
PhotoPath1 = "C:\Program Files\Internet Explorer\IEXPLORE.EXE X:\Infrastructure\Utilities\StormWaterInventory\Photos\"+Photo1
Run Program PhotoPath1
PhotoPath2 = "C:\Program Files\Internet Explorer\IEXPLORE.EXE X:\Infrastructure\Utilities\StormWaterInventory\Photos\"+Photo2
Run Program PhotoPath2
else
No_Photo:
Run Program "C:\Program Files\Internet Explorer\IEXPLORE.EXE X:\Infrastructure\Utilities\StormWaterInventory\Photos\NA.jpg"
Resume End_Photo
End if
Leith C. Britt
Town of Cary
Technology Services
GIS/Database Analyst
phone: 919-469-4383
fax: 919-319-4597
web: townofcary.org
_______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
