varray equivalent?

[hmcheung]

Hi,
Is there anything in FoxPro like the VARRAY datatype in Oracle? So that I can put, for example, more than one email address for each record in my employee table. Thanks! Please visit my WebCam!!

http://i.am/andycheung

 

[TomasDill]

Use just a memo field fo this and separate emails by comma "," or semicolon ";". No need to use unusual types unless you plan to do something special with them. You can get all emails into array from memo field:

alines(emailsArray,chrtran(EmailsMemoField,";",chr(13)))

Where ';' is a separation character.


Vlad Grynchyshyn
vgryn@softserve.lviv.ua

http://www.softserve.lviv.ua

The professional level of programmer could be determined by level of stupidity of his/her bugs