Re: 4D and Mongo
Thanks Chuck and Tom! On Thu, 7 Mar 2019 at 20:34, Tom DeMeo via 4D_Tech <4d_tech@lists.4d.com> wrote: > Hi, > > > I’ve worked on a web site that does quite a bit of this. A MongoDB is > typically part of an Apache/PHP based web site configuration which would > already have a PHP Mongo module in place (its just a database of JSON > objects). If that is the case, a 4D DB can make HTTP Client requests, and > the requests can be handled on their side by a web page written to handle > your AJAX request with PHP based queries. > > > Tom DeMeo > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky * ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: code crashes server
Hi Chuck, I’m wondering whether the crash is related to HAVING. Have you tried it without HAVING to do the subquery? Would it work to simply change HAVING to AND? I guess I could set up a test system to try it out, but I’m lazy. The 4D docs claim that HAVING should work without a GROUP BY.\, so my suggestion is likely a long shot. Tom Benedict ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
code crashes server
Hi All the first begin sql end sql works 100% of the time -- ARRAY TEXT($InspectionIDs_atxt;0) Begin SQL select [LSS_Inventory].[LSS_InventoryId_s] from [LSS_Inventory], [LSS_Inspection] where [LSS_Inspection].[LSS_CondFoundationCurr_s] = '2' and [LSS_Inspection].[LSS_InventoryId_s] = [LSS_Inventory].[LSS_InventoryId_s] into :$InspectionIDs_atxt; End SQL ARRAY TEXT($INVIDs_atxt;0) This next begin end loop crashes the server every time. Anyone have any idea as to why Begin SQL select [LSS_Inventory].[LSS_InventoryId_s] from [LSS_Inventory], [LSS_Inspection] where [LSS_Inspection].[LSS_CondFoundationCurr_s] = '2' and [LSS_Inspection].[LSS_InventoryId_s] = [LSS_Inventory].[LSS_InventoryId_s] having [LSS_Inspection].[LSS_InspectionDate_d] = (SELECT Max([LSS_Inspection].[LSS_InspectionDate_d]) from [LSS_Inspection] where [LSS_Inspection].[LSS_InventoryId_s] = [LSS_Inventory].[LSS_InventoryId_s]) into :$INVIDs_atxt; End SQL Regards Chuck - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: 4D and Mongo
Hi, I’ve worked on a web site that does quite a bit of this. A MongoDB is typically part of an Apache/PHP based web site configuration which would already have a PHP Mongo module in place (its just a database of JSON objects). If that is the case, a 4D DB can make HTTP Client requests, and the requests can be handled on their side by a web page written to handle your AJAX request with PHP based queries. Tom DeMeo ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: sql assistance
OK here is another related question has anyone used the CASE inside 4D SQL in the context of my previous post Regards Chuck On Thu, Mar 7, 2019 at 12:49 PM Charles Miller wrote: > > Hi All > > Given the following > Table_1 > Table_1Key > > Table_2 > Table_2Key > Table_1Key > Table_2Date > > Table_3 > Table_3Key > Table_2Key > Table3_Criteria > > I am trying to figure out how to write a sql statment that would get > the table_1Keys where Table3_Criteria exists for max(Table_2Date) > > I am pretty sure this can be done, but it has been a long time since I > coded anything but really basic sql > > Thanks and regards > > > Chuck > -- > - > Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 > Informed Solutions, Inc. > Brookline, MA 02446 USA Registered 4D Developer >Providers of 4D, Sybase & SQL Server connectivity > http://www.informed-solutions.com > - > This message and any attached documents contain information which may > be confidential, subject to privilege or exempt from disclosure under > applicable law. These materials are intended only for the use of the > intended recipient. If you are not the intended recipient of this > transmission, you are hereby notified that any distribution, > disclosure, printing, copying, storage, modification or the taking of > any action in reliance upon this transmission is strictly prohibited. > Delivery of this message to any person other than the intended > recipient shall not compromise or waive such confidentiality, > privilege or exemption from disclosure as to this communication. -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: 4D and Mongo
according to their web site there is a ODBC driver. Go take a look and see if it meets your needs Regards Chuck On Thu, Mar 7, 2019 at 2:02 PM Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Had a request from a client wanting to know if our 4D app can integrate > with their Mongo data. > Can it? > > > -- > * > CatBase - Top Dog in Data Publishing > tel: +44 (0) 207 118 7889 > w: http://www.catbase.com > skype: pat.bensky > * > ** > 4D Internet Users Group (4D iNUG) > Archive: http://lists.4d.com/archives.html > Options: https://lists.4d.com/mailman/options/4d_tech > Unsub: mailto:4d_tech-unsubscr...@lists.4d.com > ** -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
4D and Mongo
Had a request from a client wanting to know if our 4D app can integrate with their Mongo data. Can it? -- * CatBase - Top Dog in Data Publishing tel: +44 (0) 207 118 7889 w: http://www.catbase.com skype: pat.bensky * ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
sql assistance
Hi All Given the following Table_1 Table_1Key Table_2 Table_2Key Table_1Key Table_2Date Table_3 Table_3Key Table_2Key Table3_Criteria I am trying to figure out how to write a sql statment that would get the table_1Keys where Table3_Criteria exists for max(Table_2Date) I am pretty sure this can be done, but it has been a long time since I coded anything but really basic sql Thanks and regards Chuck -- - Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064 Informed Solutions, Inc. Brookline, MA 02446 USA Registered 4D Developer Providers of 4D, Sybase & SQL Server connectivity http://www.informed-solutions.com - This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Printing forms modified with Duplicate Object
> Le 7 mars 2019 à 15:48, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > [...] > it was useful, because the old label editor could only position objects in > mac points (1/72 of an inch) > > but I see that the doc says C_LONGINT. > > https://doc.4d.com/4Dv17/4D/17.1/Print-object.301-4179612.en.html > > B <== Print object : 27 : ( * ; a ) | Y ; L' ; L' ; L' ; L' > > so I seems like I was wrong. I've noticed the same, I suppose the command rounds the value if it has decimals. It was nice anyway to use real numbers and let the command do the rounding job. And once printed, a pixel is small (~0.35mm)… Strangely I've noticed that GET MOUSE(x;y;b) returns x & y as real numbers: something to do with retina? Else? -- Arnaud de Montard ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Printing forms modified with Duplicate Object
that has been my experience, in particular when I wrote my own label editor. https://github.com/miyako/4d-component-label-editor it was useful, because the old label editor could only position objects in mac points (1/72 of an inch) but I see that the doc says C_LONGINT. https://doc.4d.com/4Dv17/4D/17.1/Print-object.301-4179612.en.html B <== Print object : 27 : ( * ; a ) | Y ; L' ; L' ; L' ; L' so I seems like I was wrong. > 2019/03/07 22:28、Jeremy French のメール: > Can we use real values for positioning and width/height with the "Print > object" command? ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Printing forms modified with Duplicate Object
Can we use real values for positioning and width/height with the "Print object" command? > On Mar 6, 2019, at 7:41 PM, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > have you looked into the "Print object" command? > > you can print … at any position (decimal, not integer positioning) ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
