Subject | RE: [IBO] Seeming duplicate rows in IB_Grid - with work around. |
---|---|
Author | Brian Dunstan |
Post date | 2001-02-08T01:17:38Z |
Svein,
Anyhow, the good news is that I have found the problem. Here is the
offending code in OnCalculate event:
if AField.FieldName = 'ENCOUNTER' then
with ARow do
if ByName('ENC_START_DATE').IsNull then
ByName('ENCOUNTER').Clear
else
{line 6}qryPatMorb.Fields.ByName('ENCOUNTER').AsString := format('%-10s
%-40s',
[FormatDateTime('ddddd t', ByName('ENC_START_DATE').Value),
ByName('ENC_PROVIDER_DESC').Value]);
The problem is that when converting from IBOQuery I had to change references
to ARow instead of referencing the query directly. Well, I missed one
reference on line 6. I guess that reference was changing the cursor position
or something.
Thanks for your interest.
Brian
> you do explain your problem very well, but nothing that couldThere is soooo much code in all of these things....
> help us help
> you. Please show us your SQL, SP definition, and any
> properties that may be
> of interest.
Anyhow, the good news is that I have found the problem. Here is the
offending code in OnCalculate event:
if AField.FieldName = 'ENCOUNTER' then
with ARow do
if ByName('ENC_START_DATE').IsNull then
ByName('ENCOUNTER').Clear
else
{line 6}qryPatMorb.Fields.ByName('ENCOUNTER').AsString := format('%-10s
%-40s',
[FormatDateTime('ddddd t', ByName('ENC_START_DATE').Value),
ByName('ENC_PROVIDER_DESC').Value]);
The problem is that when converting from IBOQuery I had to change references
to ARow instead of referencing the query directly. Well, I missed one
reference on line 6. I guess that reference was changing the cursor position
or something.
Thanks for your interest.
Brian