delphi - how to locate a hyperlink field -


i have access 2010 table hyperlink field store e-mail adress of clients. before add new e-mail want check if e-mail address there. try use locate statement (delphi 2009; adoconnection, tadodataset):

if table.locate('ml_link',newadress,[locaseinsensitive]) then

this statement gives error message sequence not allowed.

how can search hyperlink fields?

i suspect @ character considered special character. suggest try splitting address 2 parts, email , domain example, search both fields as

if table.locate('email;domain', vararrayof([newemail, newdomain]), [locaseinsensitive]);  

you may need add variants uses clause, depending on delphi version..


Comments

Popular posts from this blog

Payment information shows nothing in one page checkout page magento -

tcpdump - How to check if server received packet (acknowledged) -