Search found 7 matches

by ohinrichs
2014-07-04 08:10
Forum: Getting Started
Topic: many-to-many
Replies: 3
Views: 2411

Re: many-to-many

Need to use a many-to-many relationship. Can't recreate a db-scheme like this: http://666kb.com/i/cprw3eaig0odd6xy2.png I always got an error: Error checking: Field 'tblOrderDetails.OrderID' cannot be a primary key and a foreign key at the same time. How can i create a scheme like in the picture abo...
by ohinrichs
2014-07-03 08:55
Forum: Advanced Customizations > Hooks
Topic: SQL statement after_update hook
Replies: 1
Views: 1377

Re: SQL statement after_update hook

Problem (and others) solved with help from Uday Vatturi.

Code: Select all

function geraete_after_update($data, $memberInfo, &$args){
	
	$setRueckl=sqlValue("UPDATE `geraete` SET `geraete`.`rueckl`='1'   WHERE `geraete`.`lieferdat2` IS NOT NULL");
		
return TRUE;
by ohinrichs
2014-07-03 08:49
Forum: Advanced Customizations > Hooks
Topic: Code Helper
Replies: 29
Views: 28528

Re: Code Helper

Uday is a great man, he solved my problems within very short time with fast replies.

Thank you very, very much, Uday!!!
by ohinrichs
2014-07-02 11:51
Forum: Advanced Customizations > Hooks
Topic: SQL statement after_update hook
Replies: 1
Views: 1377

SQL statement after_update hook

I want to execute this sql statement after update an item: UPDATE `geraete` SET `geraete`.`rueckl`="1" WHERE `geraete`.`lieferdat2` IS NOT NULL; I have added the statement as an "Advanced lookup option" - but it don't work. (with MySQL Workbench everything works fine) How can i use the statement wit...
by ohinrichs
2014-07-02 09:52
Forum: Getting Started
Topic: Is it possible to mass delete all records in a table
Replies: 6
Views: 2754

Re: Is it possible to mass delete all records in a table

ahh...found the "allow mass delete" checkbox in appgini.

sorry for double post!
by ohinrichs
2014-07-02 08:59
Forum: Getting Started
Topic: Is it possible to mass delete all records in a table
Replies: 6
Views: 2754

Re: Is it possible to mass delete all records in a table

Can't find a mass delete function in 5.30-628. Where is it?
by ohinrichs
2014-02-03 10:14
Forum: Advanced Customizations > Others
Topic: Change the reference of auto-fill fields
Replies: 1
Views: 1310

Change the reference of auto-fill fields

Hello! Is there a way to change the reference of auto-fill fields? I have a table which uses two lookup-fields from the same table "persons", which are called "initiator" and "user". Appgini use for auto-fill the first lookup-field(initiator) as reference. I need to use the auto-fill function for th...