[Loadstone] ID.

monty at loadstone-gps.com monty at loadstone-gps.com
Thu Sep 24 15:13:49 BST 2009


Hello,

As long as your id numbers are unique you're OK.  If you have 10 points in 
your database the id fields could be numbered 1 to 10 and that would be 
fine too.  Timestamps ensure a fairly unique number so it is good to use.

Monty


On Thu, 24 Sep 2009, Gianfranco Giudice wrote:

> Hello Monty
>
> I used to save a point twice. Once with the building name and the other with
> the street address. To avoid problems I decrease or increase the ID +-1. Is
> that a correct way?
>
> Regards
> Gian
>
>
> -----Original Message-----
> From: loadstone-bounces at loadstone-gps.com
> [mailto:loadstone-bounces at loadstone-gps.com] On Behalf Of
> monty at loadstone-gps.com
> Sent: Thursday, September 24, 2009 11:13 AM
> To: loadstone at loadstone-gps.com
> Subject: Re: [Loadstone] ID.
>
> Kit,
>
> The ID field has to be a unique number so we use the current Unix time stamp
> (like Rob says the amount of time elapsed from jan 1st 1970).  As long as
> you don't create more than one point per second you'll have a unique number.
>
> Monty
>
>
> On Thu, 24 Sep 2009, Kit wrote:
>
>> Hi Rob,
>>
>> Thanks for replying.  Ok, visited that site.  The date for us to
>> enter the info is the one you  given of 1/1/1970 or I enter the
>> current date which is when I create it? 9/24/2009?
>>
>> Thanks.
>> ----- Original Message -----
>> From: "Rob Melchers" <rob at loadstone-gps.com>
>> To: <loadstone at loadstone-gps.com>
>> Sent: Thursday, September 24, 2009 4:37 PM
>> Subject: Re: [Loadstone] ID.
>>
>>
>> The last field in the LS point table row is the UNIX timestamp of the
>> moment the point was generated. At this moment this is 1253784702, the
>> number of seconds elapsed since 1/1/1970.
>> Have a look on:
>> http://www.unixtimestamp.com/index.php
>> for more info.
>>
>> Rob
>>
>> At 9/24/2009, you wrote:
>>> Hi to all,
>>>
>>> I am new to this program.  I am trying to edit the table in the text
>>> format cause it's easier compared with entering through the phone.  I
>>> know all the fields needed but the last field in the table which is ID.
>>>
>>>
>>> How do I get this ID for every point I am adding.  If there no fix
>>> ID, can I just leave it as 0 or empty and let the system generate it?
>>> This is not the User ID field.
>>>
>>> Thanks in advance.
>>> KITT!
>>>
>>>
>>>
>>> _______________________________________________
>>> Loadstone mailing list
>>> Loadstone at loadstone-gps.com
>>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>
>> _______________________________________________
>> Loadstone mailing list
>> Loadstone at loadstone-gps.com
>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>
>> _______________________________________________
>> Loadstone mailing list
>> Loadstone at loadstone-gps.com
>> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>>
> _______________________________________________
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>
> _______________________________________________
> Loadstone mailing list
> Loadstone at loadstone-gps.com
> http://www.loadstone-gps.com/mailman/listinfo/loadstone
>


More information about the Loadstone mailing list