RE : [fpc-pascal] SQLdb :: Commit, Rollback, etc.

2011-12-01 Thread Ludo Brands
I can't keep a transaction (server locked) all the time. What database are you using that locks up the server when a transaction is started? Oracle for example starts an transaction as soon as you send an executable SQL Statement. Opening a connection starts a transaction on the server.

RE : RE : [fpc-pascal] SQLdb :: Commit, Rollback, etc.

2011-12-01 Thread Ludo Brands
MS SQLServer 2008. Lock the registers, not the server... sorry. I guess you mean rows, pages or tables. Ok, I can accept the TADOConnection can hiding a lot of things from me, but I think it do open many transactions all the time. Using SQLServer Profiler, I can see all SQL that are

Re: RE : RE : [fpc-pascal] SQLdb :: Commit, Rollback, etc.

2011-12-01 Thread Marcos Douglas
On Thu, Dec 1, 2011 at 11:26 AM, Ludo Brands ludo.bra...@free.fr wrote: MS SQLServer 2008. Lock the registers, not the server... sorry. I guess you mean rows, pages or tables. Ok, I can accept the TADOConnection can hiding a lot of things from me, but I think it do open many transactions all

[fpc-pascal] WideString and TRegexpr

2011-12-01 Thread Mark Morgan Lloyd
Has anybody with experience of WideStrings tried compiling the new Regexpr unit to support them? I'm in a position where I could very much benefit from using these, but I think that I'm only seeing patterns match for characters = #$00ff and even then am not seeing the match strings returned.