Synthesis AG - SyncML Discussion Forum  

Go Back   Synthesis AG - SyncML Discussion Forum > Synthesis SyncML Products (english) > SyncML Servers (Linux, Windows, MacOS X)

Reply
 
Thread Tools Display Modes
  #1  
Old 2007-01-26, 21:06
ajpurkiss ajpurkiss is offline
Junior Member
 
Join Date: 2007-01
Posts: 17
Default Generating a PKey

I need to genereate my own pkey - I was just going to start with a simple timestamp to millisecond accurary. I don't howeer see how I can make use of the millisecond script method to populate my SQL Statement

<insertdatasql>INSERT INTO contacts (id,date_entered,date_modified,%N) VALUES (need it here, %M,%M,%v)</insertdatasql>

ideas ?
Reply With Quote
  #2  
Old 2007-02-01, 00:20
ajpurkiss ajpurkiss is offline
Junior Member
 
Join Date: 2007-01
Posts: 17
Default Re: Generating a PKey

Ok, I found the solution

<specialidmode>unixmsrnd6</specialidmode> instead of <obtainidafterinsert> and then use %X for a new id and %x to use the last generated id for where I use the same id in a few places
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 09:25.


Powered by vBulletin® Version 3.7.0
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.