Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread news.gmane.org
> It uses the existing connection, cursor and buffers. > Ok if so. -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers c

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Martin Schreiber
On Monday 03 September 2012 07:44:24 news.gmane.org wrote: > >> >> May it be because finalizing COMMIT (because dso_autocommit set) ? > >> > > >> > Probably. Please try dso_autocommitret. > >> > >> It works but is wrong in this scenario since refreshes the data with the > >> SQL+params which includ

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread news.gmane.org
>> >> May it be because finalizing COMMIT (because dso_autocommit set) ? >> > >> > Probably. Please try dso_autocommitret. >> >> It works but is wrong in this scenario since refreshes the data with the >> SQL+params which includes INSERT/UPDATE operations internally => we >> have a >> double data

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Martin Schreiber
On Monday 03 September 2012 07:03:21 news.gmane.org wrote: > >> May it be because finalizing COMMIT (because dso_autocommit set) ? > > > > Probably. Please try dso_autocommitret. > > It works but is wrong in this scenario since refreshes the data with the > SQL+params which includes INSERT/UPDATE o

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread news.gmane.org
>> May it be because finalizing COMMIT (because dso_autocommit set) ? > > Probably. Please try dso_autocommitret. > It works but is wrong in this scenario since refreshes the data with the SQL+params which includes INSERT/UPDATE operations internally => we have a double data update. The below

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Martin Schreiber
On Sunday 02 September 2012 18:33:54 Ivanko B wrote: > May it be because finalizing COMMIT (because dso_autocommit set) ? Probably. Please try dso_autocommitret. Martin -- Live Security Virtual Conference Exclusive live

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
Also, there's no other way in PostrgeSQl to call a function than SELECTing it or participation in WHERE/JOIN condition. -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
And BEGIN/COMMIT/ROLLBACK can't be called within a PostgreSQL procedure ( disabled by syntax ) . -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
May it be because finalizing COMMIT (because dso_autocommit set) ? Me need dso_autocommit here since the (original) SELECT-looking function really updates the database & only returns the update status. And the SELECT function (select * from f_enter_window(:OFFICE_CODE,:WINDOW_CODE,:OPER_CODE,:OPER

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
For me, me have wrong counters for "srtEnterWindow.active:= true" for the below component: object srtEnterWindow: tsqlresult fielddefs = < item Name = 'aresult_code' DataType = ftInteger Precision = -1 Size = 0 end item Name = 'ahandled

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Martin Schreiber
On Sunday 02 September 2012 17:30:04 Ivanko B wrote: > Another issue: > > TSQLSCript returns "rowsreturned = -1" & "cols.count = 0" for whatever > SQL SELECT code me call. > Works for me. Martin -- Live Security Virtual C

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
TSQLSCript === Oops, tsqlresult :) -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions w

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
Another issue: TSQLSCript returns "rowsreturned = -1" & "cols.count = 0" for whatever SQL SELECT code me call. (PostgreSQL 9.1 under WinXP X86_64) -- Live Security Virtual Conference Exclusive live event will cover all t

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Martin Schreiber
On Sunday 02 September 2012 11:39:13 Ivanko B wrote: > Have You tried with VARCHAR(x) OUT parameter off function as mentioned > in the example ? > No. > PS: > Really not an issue unless noticeable slowdown for 33.6K dial up > connections. Which difference as to data retrieval between ftString &

Re: [MSEide-MSEgui-talk] (no subject)

2012-09-02 Thread Ivanko B
Fixed, thanx ! -- Live Security Virtual Conference Exclusive live event will cover all the ways today's security and threat landscape has changed and how IT managers can respond. Discussions will include endpoint securit

Re: [MSEide-MSEgui-talk] The IDE doesn't build

2012-09-02 Thread Ivanko B
Sometimes it is necessary to do a first run with -B and then a second time without. No, only -O1 option helps here. -- Live Security Virtual Conference Exclusive live event will cover all the ways tod

Re: [MSEide-MSEgui-talk] PostgreSQL 9.1 & TSQLResult: resulting ftMemo even for VARCHAR(255) type

2012-09-02 Thread Ivanko B
Have You tried with VARCHAR(x) OUT parameter off function as mentioned in the example ? PS: Really not an issue unless noticeable slowdown for 33.6K dial up connections. Which difference as to data retrieval between ftString & ftMemo ? ---

Re: [MSEide-MSEgui-talk] The IDE doesn't build

2012-09-02 Thread Martin Schreiber
Ivanko B wrote: > Hmm... Me have to set "-O" to "1" to build the IDE. > Most likely the second build works. FPC is a little bit fragile with unit handling. Sometimes it is necessary to do a first run with -B and then a second time without. Martin ---

Re: [MSEide-MSEgui-talk] (no subject)

2012-09-02 Thread Martin Schreiber
On Saturday 01 September 2012 19:37:18 Ivanko B wrote: > Files are attached. The rest of related files can't be send since > contains no-public-access data :) Please try again with git master a1970b7a2359f770b30b52d2ede67bd3405ad1d0. Martin ---