Re: My list D2007 annoyances/todo's I would like to see resolved in D2008
- From: "Ray Porter" <ray_porter@xxxxxxx>
- Date: Tue, 1 Jul 2008 16:21:34 -0400
I have another one for you that I first reported back with D6. Using the
dbGo components and the Oracle 9i OLEDB provider, sometimes the code in the
OnCalcFields event of the TADODataSet seems to lose track when concatenating
two string fields together to create a new, calculated field. Data will be
concatenated in the correct format but from the wrong database row. For
example, say I have the following database fields and rows:
Row FirstName MiddleName LastName
1 John James Smith
2 Mary Margaret Smythe
3 John Q Public
4 Susan Kathryn Johnson
5 Catherine Evelyn Everett
Say I create a calculated field called FullName that is formatted as
FirstName + ' ' + MiddleName + ' ' + LastName and I then run a query to
retrieve a result set. Sometimes, I get something like the following in my
resultset
Row FullName
1 John James Smith
2 John James Smythe
3 Mary Margaret Public
4 John Q Johnson
5 Susan Kathryn Everett
If I take the code out of the OnCalcFields event and put the concatenation
logic in the method that is stepping through the resultset rows, everything
works just fine. The problem only shows up when using Oracle (OLEDB
provider for 9i). I haven't seen it with SQL Server databases. The problem
also does not always happen, even with Oracle OLEDB.
This problem has been present since D7. Code that worked just fine in D5
produced the correct results while D7 and forward intermittently produced
erroneous results. Over the past few years, I've had to gradually remove
most OnCalcField code that involves concatenating database fields from my
Oracle-based applications. However, it would certainly be nice to have this
work as anticipated in all situations since implementing the concatenation
code in the calling routine is less than optimal.
Ray Porter
"Tommi Prami" <tommi.nospam.prami@xxxxxxxxxxxxxxxxxx> wrote in message
news:4869fe9c$1@xxxxxxxxxxxxxxxxxxxxxxxxx
Hello,
Now that D2008 is in work in progress and I have used 2007-version for a
awhile I have short list of things that are annoying or todo/feature
request(s). If someone of these is just product of using the IDE wrongly I
hope someone will point me into right direction, and sorry of my bad
English...
I will not list Obvious, "Faster this, Bigger that" - things. I (Would)
think that this is already taken care of by Code Gear it self (hopefully)
(And by FastCode and/or .basm dudes). (Would love to see that more
efficient containers and some speed ups in object creation and
destruction, because these would speed up very many programs "for free")
1. IDE can't find same set of files (Ctrl+Enter) than compiler
(complained this some time back in some .Ide group, but all I
got that "it should find..." answers, but clearly it will
not...)
A: Most of the time that I need to open file that is not
already Open I try to open it with Ctrl+Enter
from uses clause IDE just can't find it.
B: This I could live with, but when I go to dir'
where the file is I click Open,
it still can't find it.
Then I have to manually tell that I want to
open .pas file with that name (by writing .pas
after file name)
2. Containers (TList, TObjectList, TStrings...) should
have way to sort with compare function definer as
Object method (defined as of objcet).
Lack of This leads to extremely
weird code. I Can make public (enough) var which
is visible to compare function, and the object
who knows how the particular list should be
sorted is exposed to compare code, and I can
go around this (one solution I came up with
yesterday). But this is far from beigh thread
safe (if sorter is thread it could do this with
out any locks etc.)
3. Code Completion-Todo, When you have
object/component which you are not too
familiar with what you do is that you write
C. and hit Ctrl+Space and you browse the
list provided, when you find something that is
interesting you hit enter. Then maybe go
into code/help to see what it actually does.
if it was not what you expected, you want to
browse the list again. Would be cool that
when you would do Ctrl+Space again, and
while moving tha cursor to the C.|SomeProperty
that SomeProperty would stay selected, maybe
by (going left with crtl+Left Arrow etc)
so you could continue the adventures of that
mysterious class from where you where.
4. Generics, this is requested a very much,
and lack of generics makes some code
with (for example) TObjectList, with tons
of typecasts and is/as operators etc. to
make that list safe, or you must
make wrapper around that list to make
sure that only objects you expect will
go into that list, but this adds,
in some cases, very much of basically
unneeded code
5. Class Completion-enhancement. I would love
to give hints how Ctrl+Shift+C should
Complete class.
by writing
property Prop1: Integer; // default I think
property Prop2: Integer read F write Set;
property prop3: Integer read F write F;
property Prop4: Integer read Get;
and It would use private member with name
F+PropertyName, Get / Set gettera and setters
would be automatically created if I specify it
now I can make both but can't limit
(as far as I know) it at this level I would
like.)
6. D2007 will mess up my project files uses
clause. (D6 did know how to handle
this much better)
I have .inc file which tells what to compile
into the project. for example I have
{$IFDEF USE_FASTMM}FastMM4,{$ENDIF}
in the project files. When I add unit to the
project all the ifdef-stuff disappears from uses
clause. And have to manually fix it again.
OO, these I came up with too much thinking, ones I feel are
important/annoying, which I need to face almost every day in my work...
Hope to get feedback, and even better that most of these are User errors
and there already is all/most of this available, I just don't know it :D
-Tommi Prami-
.
- References:
- My list D2007 annoyances/todo's I would like to see resolved in D2008
- From: Tommi Prami
- My list D2007 annoyances/todo's I would like to see resolved in D2008
- Prev by Date: Re: Isn't today the day CodeGear officially becomes part of Embarcadero?
- Next by Date: (rant) Ending 8 months of nuisance - ditching Vista at last
- Previous by thread: Re: My list D2007 annoyances/todo's I would like to see resolved in D2008
- Next by thread: Re: My list D2007 annoyances/todo's I would like to see resolved in D2008
- Index(es):
Relevant Pages
|
|
