Re: Query by Formula Count of Records in Related Table

2019-02-18 Thread Chip Scheide via 4D_Tech
adjust the comparisons (> < = ) as needed in the method mymethod_related_Rec_Count mymethod_related_Rec_Count (Min_count;Max_Count) c_Boolean($0) relate many([parent_table]field) $0:=((records in selection(related_table]) = min_count) & (records in selection(related_table]) > Max_Count))

Re: Query by Formula Count of Records in Related Table

2019-02-18 Thread Jeremy French via 4D_Tech
Can you use ORDA? $entity_selection_o:=ds.theTable.query("theOneToManyRelationName.length = 0 OR theOneToManyRelationName.length > x") USE ENTITY SELECTION($entity_selection_o) Now each record in the current selection for theTable either has either no related records or more than x-related

Query by Formula Count of Records in Related Table

2019-02-18 Thread Jim Medlen via 4D_Tech
Is there a way to search using Query by formula and Records in selection ? In other words is it possible to query for records that have no related records or greater than X etc. Thanks, Jim Medlen Computer & Information Systems Functional Devices, Inc. j.med...@functionaldevices.com phone

4D Server V17.0 and Windows Server 2016

2019-02-18 Thread Uist Macdonald via 4D_Tech
Hi Has anyone has this error. Access violation. Null pointer. Faulting application name: 4D Server.exe, version: 17.0.0.0, time stamp: 0x5b3d8672 Faulting module name: Kernel.dll, version: 0.0.0.0, time stamp: 0x5b3d7b2f Exception code: 0xc005 Fault offset: 0xc470

Re: change in behavior v 15 to v 16 ?

2019-02-18 Thread Keisuke Miyako via 4D_Tech
evidently this is standard behaviour; or rather, technical limitation. the file / folder select dialog is detached from the main application menu. you can, however, paste from the contextual menu. this is limited to 64-bit (cocoa), it was reported in the early days of 64-bit and the reply from