Suneido

Integrated Application Platform

  • Home
  • Learning
    • Suneido Manual
    • Beginners
      • Inside Suneido
      • The Suneido Programming Language
      • The Suneido Database
      • Installing Suneido
      • Building Suneido
      • IDE Go To Tour
      • Upgrading To A New Release
    • Advanced
      • Canvas Control
      • DrawControl Part 1
      • DrawControl Part 2
      • DrawControl Part 3
      • SAX Like XML Processing
      • A Plug-In Architecture
      • A Simple Wizard Framework
      • An HTML Include Facility
      • An RSS 2 Feed Creator
      • MIME Generation
      • A New Add-on Facility
      • Workspace Improvement Hack
    • Mockito for Suneido
    • The Suneido Task Scheduler
    • Contributing To Suneido
    • Contributor Assignment of Copyright
    • Language Translation
    • Future Directions
    • Interview With Andrew Mckinlay
  • Forum
    • Announcements
    • Internals & Enhancements
    • Cookbook
    • General
  • FAQ
  • Screenshots
  • Downloads
  • Links

How to use autonumber of Access?

Integrated Application Platform › Forums › General › How to use autonumber of Access?

  • This topic has 2 replies, 2 voices, and was last updated 9 years, 8 months ago by ajith.
Viewing 3 posts - 1 through 3 (of 3 total)
  • Author
    Posts
  • June 1, 2013 at 6:32 pm #756
    ajith
    Participant

    Hello,

    I was trying to use the nextnum: option of AccessControl. I want to know, if I have specified it correctly. The code is used was

    #(Access
    'StkTrades'
    nextNum: #(field: 'sT_Key', table: 'tradenum', table_field: 'tradenum')
    )

    The field sT_Key is the field in the StkTrades table which needs to be filled with autonumber.I presumed the following: tradenum is the table which will store the autonumber in the field tradenum. This table and column are specified only the purpose of the autonumber and are not that of StkTrades. If I am right till now, this is bringing up an error – “query: select: nonexistent columns: (getnextnum_reserved_till)”; otherwise, guide me on the correct use. Even if I do create getnextnum_reserved_till column in tradenum table, it gives another error: GetNextNum failed, no records in: tradenum . What is wrong?

    Thanks in advance,
    ajith

    June 1, 2013 at 8:02 pm #993
    amckinlay
    Keymaster

    I think you are using it correctly.

    You can use GetNextNum.Create(table, field, num) to create the table with the required fields and output an initial record to it.

    June 1, 2013 at 8:11 pm #994
    ajith
    Participant

    Hello,
    That has corrected the problem,
    Thanks,
    ajith

  • Author
    Posts
Viewing 3 posts - 1 through 3 (of 3 total)
  • You must be logged in to reply to this topic.
Log In

Search Forums

Log In
Welcome to the new Suneido Web Site and Forum.
Register
Lost Password
users of the previous PHPBB Forum should be able to log in with their previous username and password.

Recent Topics

  • Alpha copy of gSuneido to play with
  • how to start jsuneido ?
  • Problem Starting Suneido…
  • Dialog not showing buttons
  • New link for Suneidojo

Contact Us | Legal Statement | Privacy Statement | SiteMap

Copyright © 2023 Axon® Development Corporation. All Rights Reserved. - Open Source Integrated Database and Programming Language