Update function issue

  • I have a players table I’d like to update the records of.

    I’m using the form:

    [abase form=”update” table=”uniqueplayers” columns=”UPlayerId,Forename,Surname,Title,PhotoId$Update” elements=”UPlayerId,Forename,Surname,Title,PhotoId” ack=”red”]

    Nothing shows.

    I’ve managed to get the form=insert is fine but the update no joy.

    Any clues?
    Carl

    https://www.ads-software.com/plugins/abase/

Viewing 4 replies - 1 through 4 (of 4 total)

  • You have to do a search form, and in results use RLINK to link id, and then make the update:
    [abase form=”1,search” table=”wp_routedb” columns=”name” where=”AND in_10=’1′ OR in_21=’1′” ack=”red”]

    [abase table=”wp_routedb” columns=”cragid,areaid,numtopo,name,gradenum,comment” where=”AND in_10=’1′ OR in_21=’1′” rlink=”name,/forupdate/” echo=”0″ ack=”red”]

    In post forupdate
    [abase form=”1,update” table=”……]
    Not forget the 1

    Thread Starter HerbyMcfly

    (@herbymcfly)

    Ok thanks I’ll try this.

    Hi Herby
    I’m experiencing the same issue.
    No update form is produced by abase.
    Did you manage to fix the problem ?

    Thanks in advance for you answer

    Thread Starter HerbyMcfly

    (@herbymcfly)

    Hi

    Yes managed to sort it:

    So now I have:

    Add a player here….

    [abase form=”1,insert” table=”uniqueplayers” columns=”Forename,Surname,Title$Add Player” elements=”Forename,Surname,Title” ack=”red”]

    So this shows the table…

    [abase table=”uniqueplayers” columns=”UPlayerId,Title,Forename,Surname” rlink=”UPlayerId”]

    and with this I can update existing players by clicking on UPlayerId…..

    [abase form=”1,update” table=”uniqueplayers” elements=”UPlayerId,Title,Forename,Surname” fields=”UPlayerId,Title,Forename,Surname$Update Player” ack=”green”]

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Update function issue’ is closed to new replies.