Re: IfxMRData problem

From: "Mark V. Lobanov" <mvlobanov@ukrpost.net> > >For inserting data into IfxMRData column I must to use (Excalibur Text >Search DataBlade Module User's Guide): > >INSERT INTO videos2 (id, name, description) >VALUES(1012,'The Sting',Row ('/local0/excal/desc2.txt', 'server'));> >How I can SELECT from IfxMRData column into _file_? > >SELECT lotofile(col::lvarchar::blob,"c:\\file.dat!","client") >WHERE sn=10 > >not works :-( > >PS: I'm using iif 9.20.tc1, etx 1.30.tc3 UNLOAD TO "c:\\file.dat" SELECT col FROM videos2 WHERE sn = 10 ? ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com

Hi, Obnoxio! > > > >How I can SELECT from IfxMRData column into _file_? > > > >SELECT lotofile(col::lvarchar::blob,"c:\\file.dat!","client") > >WHERE sn=10 > > > >not works :-( > > > >PS: I'm using iif 9.20.tc1, etx 1.30.tc3 > > UNLOAD TO "c:\\file.dat" SELECT col FROM videos2 WHERE sn = 10 I can't execute this SQL from client :-) -- Kind regards, Mark Lobanov ICQ:54124832