Hi!
You can use the FCOUNT() or AFIELDS() functions, as well as Field() by index to get field name by field number and evaluate() function to get field's value.
>Taking this a bit further, I went into the SaveChanges and did:
>
>PROCEDURE SaveChanges
>LPARAMETERS oRecord
>
>cRecordId = oRecord.RecordId
>cFullName = oRecord.FullName
>
SELECT Users
>APPEND BLANK
>GATHER NAME oRecord MEMO
>>Adding the 2 lines at the top seems to have refreshed it
>somehow.
>
>Doing it this was works, and I'n not opposed to to using it,
>but the problem now is this:
>
>I have other methods that use the SCATTER to return an object.
>Sometimes I use a SQL to pull only the fields I want to expose
>to the user.
>
>If I intend to 'refresh' each property as I did above, how do I
>then know how many properties are on a given record object.
>
>There is no Count property, and what I'd like to do is:
>
>for i = 1 to oRecord.Count
> vValue = oRecord.Object[I]
>endfor
>>See what I mean?
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.