Subject | Workaround to IB_QUERY.Params.LoadFromFile() ? |
---|---|
Author | hamacker |
Post date | 2012-10-30T12:49:11Z |
I have a query (IB_QUERY) :
select result_value from sp_test(1,2,3,4,:p1,:p2,:p3);
then...
ParamByName('p1').LoadFromFile('c:\blabla\bla1.txt');
ParamByName('p2').LoadFromFile('c:\blabla\bla2.txt');
ParamByName('p3').LoadFromFile('c:\blabla\bla3.txt');
when I try to myquery.open then debugger goes to ib_components.pas :
procedure TIB_Column.LoadFromFile( const AFileName: string );
begin
raise Exception.Create( E_NotImplemented );
end;
But I remember using ParamByName.LoadFromFile before. Whats happen ?
There is a wokaround to load a text file or large string to a query ?
Other question, AFileName will not be WideString for file name because
string limit size or utf-8 filesystem ?
select result_value from sp_test(1,2,3,4,:p1,:p2,:p3);
then...
ParamByName('p1').LoadFromFile('c:\blabla\bla1.txt');
ParamByName('p2').LoadFromFile('c:\blabla\bla2.txt');
ParamByName('p3').LoadFromFile('c:\blabla\bla3.txt');
when I try to myquery.open then debugger goes to ib_components.pas :
procedure TIB_Column.LoadFromFile( const AFileName: string );
begin
raise Exception.Create( E_NotImplemented );
end;
But I remember using ParamByName.LoadFromFile before. Whats happen ?
There is a wokaround to load a text file or large string to a query ?
Other question, AFileName will not be WideString for file name because
string limit size or utf-8 filesystem ?