Re: Witango-Talk: ID field in response to new record

2002-10-12 Thread Wayne Irvine
We use the record_ID to retrieve a record after an insert in the same run through the TAF (think a scope of Local), but no where else. For relationships we use Auto Entered serial numbers and carry them through to the records in the related db. That way you can set up the same relationships in FM

RE: Witango-Talk: ID field in response to new record

2002-10-11 Thread Steve Smith
ginal Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Hart > Sent: October 11, 2002 4:56 AM > To: Multiple recipients of list witango-talk > Subject: Re: Witango-Talk: ID field in response to new record > > > --On Thursday, October 10, 2002

Re: Witango-Talk: ID field in response to new record

2002-10-11 Thread Nicholas Froome
>>If you are referring to the RecordID that FileMaker creates for each >>record, it is accessible with the function Status(CurrentRecordID) in >>FileMaker or -recid in CDML. I don't know what it is in AppleScript, but >>you can get it there, too. >> >>As far as "using", it's unique enough if yo

Re: Witango-Talk: ID field in response to new record

2002-10-11 Thread Paul Hart
--On Thursday, October 10, 2002 5:09 pm +0100 Nicholas Froome <[EMAIL PROTECTED]> wrote: > Beverly > > >> I'm assuming that Tango gets the ID and that's what you see in COL 1. > > I didn't think that Tango returned the Record ID, but I just checked - > and it does > > I didn't know it was access

Re: Witango-Talk: ID field in response to new record

2002-10-11 Thread Paul Hart
--On Thursday, October 10, 2002 10:58 am -0400 Beverly Voth <[EMAIL PROTECTED]> wrote: > If you are referring to the RecordID that FileMaker creates for each > record, it is accessible with the function Status(CurrentRecordID) in > FileMaker or -recid in CDML. I don't know what it is in AppleScr

Re: Witango-Talk: ID field in response to new record

2002-10-10 Thread Nicholas Froome
Beverly >I'm assuming that Tango gets the ID and that's what you see in COL 1. I didn't think that Tango returned the Record ID, but I just checked - and it does I didn't know it was accessible from within Filemaker with a Status() command, though it doesn't surprise me I bow, as ever, to yo

RE: Witango-Talk: ID field in response to new record

2002-10-10 Thread Jacob Stevens
Hello Everyone, If possible could someone please send me a link to or an example of the equations used to verify the validity of different credit card numbers. Thanks, Jake Stevens TO UNSUBSCRIBE: send a plain text/US ASC

Re: Witango-Talk: ID field in response to new record

2002-10-10 Thread Beverly Voth
Hello, Nicholas Froome! On 10/10/2002 4:20 PM +0100, you wrote in whole or part: >Beverly > > >Remind us what action it is that changes these internal IDs - are >they changed by compressing the file? They wil certainly be lost >when exporting data to another Filemaker file, won't they? RecordI

Re: Witango-Talk: ID field in response to new record

2002-10-10 Thread Nicholas Froome
Beverly Remind us what action it is that changes these internal IDs - are they changed by compressing the file? They wil certainly be lost when exporting data to another Filemaker file, won't they? >If you are referring to the RecordID that FileMaker creates for each record, it is >access

Re: Witango-Talk: ID field in response to new record

2002-10-10 Thread Beverly Voth
If you are referring to the RecordID that FileMaker creates for each record, it is accessible with the function Status(CurrentRecordID) in FileMaker or -recid in CDML. I don't know what it is in AppleScript, but you can get it there, too. As far as "using", it's unique enough if you're dealing

Re: Witango-Talk: ID field in response to new record

2002-10-10 Thread Nicholas Froome
As far as I know the internal database unique id is inaccessible from outside (or even inside) Filemaker, so don't bother trying to use it You can do serial numbers in variables, but I wouldn't recommend it. I'd use a Global field in FM to store the current serial number (generated from whateve

RE: Witango-Talk: ID field in response to new record

2002-10-09 Thread Steve Smith
alf Of Paul Hart > Sent: October 9, 2002 3:53 AM > To: Multiple recipients of list witango-talk > Subject: Witango-Talk: ID field in response to new record > > > Hi, I'm new to the list and wondered if anyone can help me with what I > think is quite a trivial problem - I just ca

Witango-Talk: ID field in response to new record

2002-10-09 Thread Paul Hart
Hi, I'm new to the list and wondered if anyone can help me with what I think is quite a trivial problem - I just can't seem to get it to work. I'm using witango on a Mac server linked to a filemaker database which is used as a job booking system. What I would like to do is provide a job ID num