Alpha Video Training
Results 1 to 3 of 3

Thread: Get the Auto-increment field rule after opened several xdialogs

  1. #1
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,084

    Default Get the Auto-increment field rule after opened several xdialogs

    Hi All,

    My table (new record) coding does not have any problem when Opened single xdialog.
    but the Auto-Increment field rule did not work after opened several xdialogs.

    The Alternate solution was hide the opened xdialogs but I am not able to hide the xdialogs in some case.

    Does any one have the solution?

  2. #2
    "Certified" Alphaholic MoGrace's Avatar
    Real Name
    Robin
    Join Date
    Mar 2006
    Location
    Los Angeles
    Posts
    3,699

    Default Re: Get the Auto-increment field rule after opened several xdialogs

    Instead of an autoincrement field rule, you could get the next value using

    var = increment_value(tablemax(yourtablename,".t.",yourfieldname))
    tbl.fieldname = var

    which would then be required whereever else you might add a new record to that table.
    Robin

    Discernment is not needed in things that differ, but in those things that appear to be the same. - Miles Sanford

  3. #3
    "Certified" Alphaholic
    Real Name
    John Koh
    Join Date
    Jan 2004
    Location
    Maryland, USA
    Posts
    1,084

    Default Re: Get the Auto-increment field rule after opened several xdialogs

    Hi Robin,

    I spent some times to do update the codes.
    Thanks, Robin.

Similar Threads

  1. Auto Increment filed rule in set
    By shakapdeen in forum Alpha Five Version 9 - Desktop Applications
    Replies: 5
    Last Post: 02-02-2012, 08:07 AM
  2. Auto-increment field rule fails when writing to a table in code
    By alexmuir in forum Alpha Five Version 9 - Desktop Applications
    Replies: 24
    Last Post: 03-04-2009, 11:35 AM
  3. skip field rule after auto increment
    By rwaldsmith in forum Alpha Five Version 8
    Replies: 2
    Last Post: 12-21-2007, 06:19 PM
  4. Auto increment field rule
    By kasiawatson in forum Alpha Five Version 8
    Replies: 16
    Last Post: 07-09-2007, 02:53 AM
  5. Auto Increment Field Rule
    By Sigrist in forum Alpha Five Version 6
    Replies: 9
    Last Post: 09-17-2004, 09:04 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •