Search found 324 matches

by jsetzer
2020-01-16 21:13
Forum: Getting Started
Topic: can only add to first lookup field?
Replies: 11
Views: 137

Re: can only add to first lookup field?

Hmm, with AppGini 5.81 I cannot reproduce the reported error. I can create new policies #1, #2 and #3 using any of the (+) buttons next to the dropdown. Afterwards the created policy exists in the dropdown as expected. After save, those values get restored as expected, too. chrome_LOyOXZUTA6.png May...
by jsetzer
2020-01-16 20:58
Forum: Getting Started
Topic: Deleted tables and fields remain in the database
Replies: 1
Views: 33

Re: Deleted tables and fields remain in the database

Hi, I have just added a test-table to one project, then generated the application, then removed the table and generated again. I can confirm that the generated database migration script ( updateDB.php ) does NOT contain any DROP TABLE statements for tables which have been removed from the model. Thi...
by jsetzer
2020-01-16 20:36
Forum: Getting Started
Topic: can only add to first lookup field?
Replies: 11
Views: 137

Re: can only add to first lookup field?

Hi, I've not seen this behaviour before. Actually, usually I normalize my tables to avoid such binding if possible. But there are projects in which I have tables with maximum 2 similar lookup bindings on the same parent field. This works well in both tables (child-table/parent-table). Honestly, I di...
by jsetzer
2020-01-14 07:50
Forum: Getting Started
Topic: Delete record: Ignore only specific "table"
Replies: 5
Views: 52

Re: Delete record: Ignore only specific "table"

Hi Olaf, in your specific case, when using a view "as" child table, the built-in cascading delete should fail for those views. In MASTERTABLE_dml.php file I cannot see any check for views. This means, on delete, AppGini handles any modeled child-table as if it was a database table. So - as mentioned...
by jsetzer
2020-01-14 07:19
Forum: Getting Started
Topic: Delete record: Ignore only specific "table"
Replies: 5
Views: 52

Re: Delete record: Ignore only specific "table"

Good morning, Olaf, the built-in functionality mimics SQL's ON CASCADE DELETE functionality which is available in most relational database systems nowadays. You are completely right: If you enable cascading delete, deleting a master record will delete child records of all related tables. If you need...
by jsetzer
2020-01-14 07:01
Forum: Bugs/annoyances
Topic: Console Error on login & home page in V5.8.1
Replies: 2
Views: 71

Re: Console Error on login & home page in V5.8.1

Good morning,

according to Ahmed's answer of October 26th 2019 we all CAN IGNORE this log entry. It does not break any functionality and he is going to remove that debug information in a future release.

Best,
Jan

PS: This is what we are talking about:
chrome_vBADcOrNJs.png
chrome_vBADcOrNJs.png (3.22 KiB) Viewed 69 times
by jsetzer
2020-01-02 04:06
Forum: Bugs/annoyances
Topic: Found 2 elements with non-unique id
Replies: 3
Views: 157

Re: Found 2 elements with non-unique id

Re: current table error message Yes, there is that message on certain pages and we can ignore it. That error msg does not break the execution of the rest of our code. I got the information that this debugging information will be removed in the future or at least will not have red error formatting in...
by jsetzer
2020-01-01 16:47
Forum: Advanced Customizations > Others
Topic: all users unable to login
Replies: 3
Views: 177

Re: all users unable to login

Hi Bob, if I got it right, login works for new users but not for existing users. So the integrity of membership table should not be the problem. As far as I remember there was a change in 5.73 related to a more secure password encryption. You could try to reset a password for one of the non-working ...
by jsetzer
2019-12-26 09:59
Forum: Tips And Tricks
Topic: Stop transaction if quantity is 0
Replies: 7
Views: 275

Re: Stop transaction if quantity is 0

Hi Lectura, you will have to modify function update_balances($data) in hooks/transactions.php according to your needs . If, for example, quantity on stock is 30 and order-quantity in transaction is 100, there are at least three different ways which immediately came into my mind how to handle this sc...
by jsetzer
2019-12-21 10:00
Forum: Tips And Tricks
Topic: Stop transaction if quantity is 0
Replies: 7
Views: 275

Re: Stop transaction if quantity is 0

There is also a client-side (browser) way to cancel submit if quantity is zero (or less than zero). By default quantity is a decimal(10,2) field in OIM demo app. Depending on your specific scenario, "greater than zero" can be interpreted as ">= 0.01" or as ">= 1". Possible solution for Quantity >= 1...
by jsetzer
2019-12-21 09:42
Forum: Tips And Tricks
Topic: Stop transaction if quantity is 0
Replies: 7
Views: 275

Re: Stop transaction if quantity is 0

I'm not sure if I got your point. If you want to cancel a transaction before calculation/update of balance, you can modify both before_insert and before_update hook functions. Replace return TRUE; in transactions_before_... -hooks like this: // file: hooks/transactions.php // [...] function transact...
by jsetzer
2019-12-19 19:18
Forum: Tips And Tricks
Topic: How to convert the description of the field "Un collapsed"?
Replies: 2
Views: 122

Re: How to convert the description of the field "Un collapsed"?

Do you mean something like this ... chrome_HT8AiXSCWu.png ... or even that (without blue info-circle) ... 1xgpkPDfan.png ... instead of the default help-block? 9pOI3J7sUY.gif Only a small change for example in hooks/header-extras.php : <script> $j(document).ready(function() { $j("span.help-block").a...
by jsetzer
2019-12-17 08:08
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniCommon setImage fails on custom page
Replies: 11
Views: 237

Re: AppGiniCommon setImage fails on custom page

onoehring wrote:
2019-12-17 08:01
But/And this code works on other pages.
Yes, and that's the reason why we need a valid (absolute) URL and not a path.

Referencing resources in most cases depends on the starting-location.
by jsetzer
2019-12-17 08:02
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniCommon setImage fails on custom page
Replies: 11
Views: 237

Re: AppGiniCommon setImage fails on custom page

Hi Olaf, yes, please. Jan PS: Documentation for .setImage() function here: https://appgini.bizzworxx.de/products/javascript-library/documentation/global/navigation-bar/set-picture/ var url="https://www.bizzworxx.de/agh32.png"; new AppGiniCommon() .setTitle("<b>CLINIC</b>Management") .setImage(url);
by jsetzer
2019-12-17 07:58
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniCommon setImage fails on custom page
Replies: 11
Views: 237

Re: AppGiniCommon setImage fails on custom page

Hi Olaf,
did you try with a valid url?
From your screenshots I can still see /ECoMo.png.
Best,
Jan
by jsetzer
2019-12-17 07:52
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: datepicker on mobile browser
Replies: 1
Views: 92

Re: datepicker on mobile browser

Hi, this behaviour is not directly related to AppGini nor to AppGini Helper JS Library, but to bootstrap datetimepicker (and other input widgets) on mobile devices in general. I'm not sure if there is a common solution at all, because it depends on the operating system of your mobile device and the ...
by jsetzer
2019-12-17 07:01
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 388

Re: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?

Good morning @peebee,

I totally agree with you. The way you did it and your code looks fine. After narrowing it down to this point, this is something for Ahmed to look into.

I would appreciate it if you could post the results here.

With kind regards,
Jan
by jsetzer
2019-12-16 07:44
Forum: Getting Started
Topic: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?
Replies: 12
Views: 388

Re: Using AppGini Filters + $options->QueryWhere = causes SQL syntax error?

Good morning, this is a wonderful complete bug-report! By setting up a new app you have removed any possible influence coming from other sources, well done! I cannot see any error in your code, that looks fine. Just to be 100% sure, I would put single quotes ' instead of double quotes " in your Quer...
by jsetzer
2019-12-15 13:50
Forum: Getting Started
Topic: calculated field
Replies: 8
Views: 185

Re: calculated field

Are you sure both fields (Rent and the calculated field) are numeric?
by jsetzer
2019-12-15 12:45
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniCommon setImage fails on custom page
Replies: 11
Views: 237

SOLVED: AppGiniCommon setImage on custom pages

Hi again, it has been written that there were problems in AppGiniHelper's .setImage() -function in custom pages . I can NOT confirm this . The setimage() function works as expected! I have just double checked it by creating a completely new custom page according to AppGini's specification here: http...
by jsetzer
2019-12-15 12:13
Forum: bizzworxx AppGini Helper JavaScript Library
Topic: AppGiniCommon setImage fails on custom page
Replies: 11
Views: 237

SOLVED: AppGiniCommon setImage fails on custom page

Sorry, for late response, I somehow missed this post. The error message for currentTableName is related to core AppGini, NOT to AG Helper JS Library. As G Belgrado has already mentioned: This error comes from common.js.php which is an core AppGini script. Also the warnings coming from scriptaculous....
by jsetzer
2019-12-15 04:22
Forum: Getting Started
Topic: AppGini Helper JavaScript Library
Replies: 33
Views: 2980

Re: AppGini Helper JavaScript Library

I'm sorry, I do not understand your request. Can you please describe or add a screenshot?
by jsetzer
2019-12-14 20:45
Forum: Getting Started
Topic: calculated field
Replies: 8
Views: 185

Re: calculated field

What exactly does not work? Just in case it shows 0 as result, you should change from integer to double or decimal data type.