Alpha Video Training
Results 1 to 8 of 8

Thread: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events?

  1. #1
    Member
    Real Name
    Suvarchala
    Join Date
    Dec 2011
    Location
    INDIA
    Posts
    111

    Question How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events?

    Hi,

    I want to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events in Grid Component.

    To Insert, Update, Delete Single Grid Data in two database tables.

    If any one knows the solution for this. Please do help in solving this.

    Thanks & Regards,
    Suvarchala.

  2. #2
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    Hi Suvarchala,

    To make use of these functions you will need to understand Xbasic. Eg to Update a record you will need to know how to query the table to find the required record, open the table, change the field, then close the table.

    Practice that first on the desk top then it will be easier to use in a grid.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  3. #3
    Member
    Real Name
    Suvarchala
    Join Date
    Dec 2011
    Location
    INDIA
    Posts
    111

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    Hi Keith Hubert,

    Thanks for your reply.
    Can you please provide me a link where can I use practice an example on these things.

    Thanks & Regards,
    Suvarchala.

  4. #4
    Member
    Real Name
    Kenyon Sprankle
    Join Date
    Jun 2011
    Location
    Marlton, NJ
    Posts
    177

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    You might want to go to Documentation Wiki. Tutorials. Basic for SQL. There are examples of insert, update, and delete in there.

  5. #5
    "Certified" Alphaholic Keith Hubert's Avatar
    Real Name
    Keith Hubert
    Join Date
    Jul 2000
    Location
    London, UK
    Posts
    6,930

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    I am unable to find the link but here is a small sample of what the code could look like.
    Code:
    t =table.open("[PathAlias.ADB_Path]\customer")
    t.fetch_last()
    dim vc_next_id as c
    if t.customer_id=1 then
       vc_next_id="Cus0000001"
      	else
    vc_next_id = increment_value(t.customer_id)
    end if
    t.close()
    Look in the help file for table.open()

    Practice in the Interactive tab.
    Regards
    Keith Hubert
    Alpha Guild Member
    London.
    KHDB Management Systems
    Skype = keith.hubert


    For your day-to-day Needs, you Need an Alpha Database!

  6. #6
    Member JimDK's Avatar
    Real Name
    Jim Andreasen
    Join Date
    Feb 2007
    Location
    Denmark
    Posts
    234

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    You can find info on the wiki here is a link to Alphas 'Learning Xbasic - using Xbasic with sql tables', it is very intuitive.

  7. #7
    Member
    Real Name
    Suvarchala
    Join Date
    Dec 2011
    Location
    INDIA
    Posts
    111

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    Hi Kenyon and Jim,

    Thanks for your reply.
    I will work on it...Thanks for your valuable link.

    Thanks & Regards,
    Suvarchala.

  8. #8
    Member
    Real Name
    Suvarchala
    Join Date
    Dec 2011
    Location
    INDIA
    Posts
    111

    Default Re: How to use CanInsertRecord, CanUpdateRecord, CanDeleteRecord in ServerSide Events

    Hi Keith Hubert,
    Thanks for providing me a sample example. I will work on it...

    Thanks & Regards,
    Suvarchala.

Similar Threads

  1. CanDeleteRecord XBasic
    By Dfred in forum Application Server Version 10 - Web/Browser Applications
    Replies: 0
    Last Post: 06-09-2011, 01:21 PM
  2. CanInsertRecord events
    By Ken Tjia in forum Application Server Version 10 - Web/Browser Applications
    Replies: 1
    Last Post: 05-27-2011, 12:02 PM
  3. Grid events CanUpdateRecord
    By EricN in forum Application Server Version 8
    Replies: 1
    Last Post: 02-15-2008, 08:37 PM
  4. CanInsertRecord & CanUpdateRecord events result in error on Delete
    By Tarek in forum Web Application Server v7
    Replies: 9
    Last Post: 04-30-2006, 03:15 PM
  5. CanDeleteRecord event?
    By John Hertzler in forum Alpha Five Version 5
    Replies: 2
    Last Post: 10-26-2002, 10:27 PM

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
  •