exists function

[heefan1]

Hi guys,

what does Exists do?

Just from API, I am still very clear about this function.

E.g.
temp = PMCONT1detail2.Exists

Pls give me some hints. Tks

 

[heefan1]

Pls see the following code,

PMCONT1header.Fetch
Debug.print PMCONT1headerFields("CONTRACT")
temp = PMCONT1header.Exists
PMCONT1header.Fetch
Debug.print PMCONT1headerFields("CONTRACT")

Suppose the current record is "C00001"
so the result will be:
C00001
C00001

However, when I comment temp = PMCONT1header.Exists
The result will be:
C00001
C00002

What had happened when I called Exists?

Confused....

 

[Jay Converse]

It's noise from recording, it has no use.

 

[ettienne]

.Exists checks if a record exists.

 

[heefan1]

thanks

 

[heefan1]

actually, .Exists not only check current record exists I think.

because you see,

.Fetch 'get current record
.Fetch 'get next record

however,
.Fetch 'get current record
.Exists 'check current record
.Fetch 'get current record again, not next record.

so,am I right?

 

[Jay Converse]

Whether you're right or wrong, you're wasting your time. .Exists doesn't add anything to your program.

 

[ettienne]

Property Exists As Boolean
read-only
Member of AccpacCOMAPI.AccpacView
Reports whether the current logical record exists in the database.

What you read into that is up to you.

 

[Jay Converse]

I say it's extra processing that slows things down. You're already doing a .Read or a .Fetch, which gives you the same info.

 

[DjangMan]

You can use it to determine if you need to do a .insert or a .update.

 

[Jay Converse]

I guess, but I've been coding like this for years:

MyView.Browse "SomeThing", True
If MyView.Fetch
Somestuff
MyView.Update
Else
OtherStuff
MyView.Insert
End If

 

[DjangMan]

Move aside, old man.

 

[heefan1]

Thanks all.

I think that's enough for me.
Thanks very much.