Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 3 of 3 total |
RandomRange as Default value |
Fri, Sep 22 2006 5:27 AM | Permanent Link |
Mike Mayer | Hi,
I want to specify default value for one ID field in such format from 1000000 to 9999999. In delphi I could use RandomRange(1000000, 9999999), what operator I should use in DBISAM? Does RAND support numbers range? Regards, Mike |
Fri, Sep 22 2006 10:27 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Mike
Using a random number for the ID field sounds like a BAD idea - its always possible to get duplication - why not use a simple AUTOINC? Roy Lambert |
Fri, Sep 22 2006 2:50 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Mike,
<< I want to specify default value for one ID field in such format from 1000000 to 9999999. In delphi I could use RandomRange(1000000, 9999999), what operator I should use in DBISAM? Does RAND support numbers range? >> Unfortunately, DBISAM does not allow any expressions in default values for fields except for simple constant values or CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, or CURRENT_GUID calls. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |