On Tue, 2005-12-06 at 02:19 -0200, Alexsander Rosa wrote:
> Today I started the porting of a medium-sized application (~100 kloc)
> from D7 with CLX to Lazarus (used the 2005-12-05 snapshot). I was
> wondering if a diary of this could be useful - I do not want to forget
Make a blog - that's also nice for the PR-people ;)
> - My OPF has an option to trim the strings it gets from (or write to)
> the DB. It used Trim(X) where X is a Variant. FPC did not like that,
> and I had to change it to Trim(VarToStr(X)). There's hundreds of files
> that use that construct in my project, but thanks God it's all code
> that is automagically generated by a custom made tool.
Why don't you overload Trim with a Trim(v : variant); version? Maybe
that should be even done in the RTL?
> - Instead of TTransactionDesc, there is TSQLTransaction. It led to a
> lot of changes, including this one that I'm afraid is not a good one
> (the condition seems to be different):
> if Transaction.Active {FdscTrans.InTransaction} then ...
> My OPF controls the transactions, throwing its own errors when you try
> to start a transaction when there's one started, or try to commit when
> there's no transaction. Is the TSQLTransaction is always active when
> the connection is open?
No, but if you open a query in a transaction, the transaction is
automatically opened.
> - A weird thing was an error using the LIMIT clause of some SQL
> queries. I removed them by now, but these LIMIT clauses are needed for
> the correct operation of the OPF. I will get back to this later.
Does it work if you set ParseSQL to False? Maybe that the sqldb-parser
can't handle LIMIT clauses.
--
Met vriendelijke groeten,
Joost van der Sluis
CNOC Informatiesystemen en Netwerken
http://www.cnoc.nl
_________________________________________________________________
To unsubscribe: mail [EMAIL PROTECTED] with
"unsubscribe" as the Subject
archives at http://www.lazarus.freepascal.org/mailarchives
