joseyaz

Use rlink=”filename”

No, abase hasn`t limitation on foreign key, it’s my mistake. I’m sorry.

I re-create the table, and created 14 foreign keys and working properly.

The difference between before and now I’ve been creating foreign keys using:

[abase sql = “ALTER TABLE xxxxx ADD FOREIGN KEY (xxxx_key) REFERENCES titles (xxx_id) ON UPDATE RESTRICT ON DELETE RESTRICT”]

In the first case I had created the foreign keys using the plugin Adminer

Thanks.

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

Other example:

[abase table=”calls” form=”1,search” columns=”description=%description%”]

This works for me. Search result with a SQL condition:

[abase form="1,search" table="wp_routedb" columns="areaid,numtopo,name,gradenum,comment,in_10$Search dato" elements="areaid,numtopo,name,gradenum,comment,in_10"]
[abase table="wp_routedb" columns="areaid,numtopo,name,gradenum,comment,in_10" where="AND <code>gradenum</code>='7b+'" echo="0" ack="blue"]

< code > = `
form the forum replaces ` with < code >

This example works for me:

[abase form="2,search,/wordpress/resultados/" table="wp_routedb" columns="Nombre^name=%name%" elements="name,gradenum,in_10"]

[abase form="search,/wordpress/resultados/" table="wp_routedb" columns="Grado^gradenum" elements="name,gradenum,in_10"]

[abase form="3,search,/wordpress/resultados/" table="wp_routedb" columns="Nueva^in_10$Buscar" elements="name,gradenum,in_10"]