last update using get next from a different file
Richard Kreiss
rkreiss at verizon.net
Wed Sep 24 21:42:56 PDT 2014
Top post.
I still hold with my windows comment. I have always added at least 2 fields to hold who Nast updated a record and when. There have been times that I post the process bane rather that a user name especially if I am having odd data showing up in a record which can be updated from different programs.
Just an aside. !@ub or *@ub could be added to a browse in the file rather then a screen allowing for looking at a lot of records at once.
Richard
Sent from my iPhone
> On Sep 24, 2014, at 6:01 PM, Mike Fedkiw via Filepro-list <filepro-list at lists.celestial.com> wrote:
>
> Well, It seems as though the @ud simply does not work when exporting records. I changed the processing so I could do the output directly from the invy file and the @ud is still stuck on 09/15/14(the first record found @ud) for every record after too. I also went into the invy file using IUA and scanned through a bunch of them. Pretty much every record that I saw had a different @ud date.
>
> The @rn record number works just fine though, I don't get it...
>
>
> 62 ------- - - - - - -
> ◄ If:
> Then: invfile(26)=oh
> 63 ------- - - - - - -
> ◄ If:
> Then: invfile(27)=@rn
> 64 ------- - - - - - -
> ◄ If:
> Then: invfile(28)=@ud
> 65 ------- - - - - - -
> ◄ If:
> Then: invfile(29)=hl
> 66 ------- - - - - - -
> ◄ If:
> Then: end
>
> Mike
>
>
> On 9/24/2014 5:25 PM, Mike Schwartz wrote:
>>>> On 9/24/2014 4:02 PM, Mike Fedkiw via Filepro-list wrote:
>>>> Okay I get what invy(@ud) is but since it returns the exact same date
>>>> for like 20+ thousand records and that's just impossible in my system,
>>> No, "lookupname(@UD)" returns the update date for the *current* record
>>> in the lookup file. Add "!@UD" to a screen in the other file, and browse
>> it in
>>> dclerk. See what it shows.
>>> --
>>> Kenneth Brody
>> If Mike used getnext to do a lookup into some other file, doesn't the
>> getnext open that record in update mode? And wouldn't that always return
>> an @ud with today's date in it?
>>
>> Or doesn't @UD get updated until some of the data in the record gets
>> changed?
>>
>> Or doesn't @UD get updated until the record is released by the next
>> getnext?
>>
>> I'll put this on my bucket list to test. Let's see: That puts it
>> around February, 2094, if nothing on my list preempts it...
>>
>> Mike Schwartz
>>
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> -------------- next part --------------
> A non-text attachment was scrubbed...
> Name: ddd.jpg
> Type: image/jpeg
> Size: 287596 bytes
> Desc: not available
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20140924/189275ad/attachment.jpg>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
More information about the Filepro-list
mailing list