Re: Trouble with Comment Blocks v18

Yes. Dot notation works fine. Sannyasin Siddhanathaswami On Mar 10, 2020, 12:11 AM -1000, Vincent de Lachaux via 4D_Tech <4d_tech@lists.4d.com>, wrote: Is the database accept dot notation ? vdl ** 4D Internet Users Group (4D

Re: ds.Table.query() field not available

Ok. I guess I was hallucinating or something. It works today with one exception. If I change the name of a field (to remove spaces in field names…..), the new field name doesn’t work in an orda query. I get this error: The "Account_Name" attribute cannot be found in The "Deposits" datastore

ds.Table.query() field not available

Aloha, When I do a ds.Table.query() using a field/attribute of a non-indexed field, I get an error. Of course, I can add an index, but then I seem to have restart the server for it to work. This is super inconvenient, obviously and in may cases not possible at that moment. Is there a command

Re: Trouble with Comment Blocks v18

n 18.0 HF1. John DeSoi, Ph.D. On Mar 9, 2020, at 3:24 PM, Sannyasin Siddhanathaswami via 4D_Tech <4d_tech@lists.4d.com> wrote: Aloha, I’m having trouble getting the new comment blocks to work in v18. Seems silly simple but doesn’t work: /* This is a comment */ This gives a syntax

Trouble with Comment Blocks v18

Aloha, I’m having trouble getting the new comment blocks to work in v18. Seems silly simple but doesn’t work: /* This is a comment */ This gives a syntax error. I’m using v18 on Mac OS Catalina, in client server. I looked for compatibility settings, and anything useful in the

Re: More on 4D Objects and 'Inheritance'

Aloha Aparajita, I’d definitely be interested. Object-oriented programming is something I never learned, but is becoming a requirement in 4D. I’ve been using objects, collections and entity selections quite a bit recently in 4D and love them. I know I’m only scratching the surface. v18 knowing

Re: Deleting a record from a listbox

Aloha Carl and Keith! Thanks! That’s just what I needed. I see both options will work. The key is the LONGINT ARRAY FROM SELECTION and/or BOOLEAN ARRAY FROM SET. Much appreciated. Sannyasin Siddhanathaswami On Jul 3, 2019, 11:16 AM -1000, Carl Aage Wangel via 4D_Tech <4d_tech@lists.4d.com>,

Deleting a record from a listbox

Aloha, I’m trying to update my "delete selection of records from a listbox" code. I’m trying to keep the sort order so that when someone clicks to delete, the only thing they see is the lines they select, get deleted. Here’s the basic code. Of course, deleting a record in this scenario,

RE: Anyone using zipcodeapi

I’m playing with the Google Geocode too. It’s useful for certain things. It’s free for up to $200 worth or requests per month. That’s a lot for minor uses! Sannyasin Siddhanathaswami On Jun 8, 2019, 7:11 AM -1000, David Ringsmuth via 4D_Tech <4d_tech@lists.4d.com>, wrote: John, I’m using the

Re: Variable in Dialog Doesn’t Honor Number Formatting

https://doc.4d.com/4Dv17/4D/17.1/Variables.300-4179325.en.html 2019/05/16 13:27、Sannyasin Siddhanathaswami via 4D_Tech <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール: These are all numeric variables. **

Variable in Dialog Doesn’t Honor Number Formatting

Aloha, Super weird issue. I’m trying to do a simple $ format in a variable on a dialog. Choosing a number format of "$###,##0.00” doesn’t display properly. I enter “50”, I get $0.50. Even when using this: OBJECT SET FORMAT(*;"ShippingCost";"$###,##0.00”) But in the same dialog, if I do the

Re: Collection of JSON Arrays to a Flat Array

Siddhanathaswami On Apr 9, 2019, 4:59 PM -1000, Sannyasin Siddhanathaswami via 4D_Tech <4d_tech@lists.4d.com>, wrote: Aloha, Is there an easy way to make an collection of JSON arrays into a single flat array using the new ORDA collection commands? Here’s a screenshot of the data:

Collection of JSON Arrays to a Flat Array

Aloha, Is there an easy way to make an collection of JSON arrays into a single flat array using the new ORDA collection commands? Here’s a screenshot of the data: https://www.dropbox.com/s/mmjrxfn4t2umejh/collectiontoarray.png?dl=0 If there’s no easy way, I can loop through and manually do it,

Re: JSON from Google Sheet to Property Object

Aloha all, I created the method to convert a Google Sheet JSON to a property:value collection of objects. This has the advantage of being able to use all of the collection method (such as query). Here’s the code. //get Google Sheet via JSON and convert to property:value Collection of

Re: JSON from Google Sheet to Property Object

Last email didn’t work right. I think a Collection might be the way to go with this. If I create a collection of objects: {“ID”:”5912029","First Name”:”Sannyasin”}, {“ID”:”6015906","First Name”:”Mayuran”} I should be able to access the data very easily. Sannyasin Siddhanathaswami On Nov 25,

Re: JSON from Google Sheet to Property Object

** 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: JSON from Google Sheet to Property Object

That makes sense. No wonder I’m confused. :) But if I convert: [ [ID,First Name,Last Name], [5912029,Sannyasin,Siddhanathaswami], [6015906,Mayuran,Sokkan] ] to an array of objects: [ {“ID”:”5912029","First Name”:”Sannyasin”}, {“ID”:”6015906","First Name”:”Mayuran”} ] Does than mean I can access

JSON from Google Sheet to Property Object

Aloha, I’m getting my feet wet with v17’s dot notion/objects. My first use is converting a Google Sheet JSON into something easily accessible. I was thinking to a property:value 4D Object. Does anyone have a utility method that does this? It’s a JSON array of arrays from the Google Sheet that

Re: Related Fields in a Listbox (Manual Relations)

event=On Display Detail) // in the listbox method RELATE ONE([many]linkField) Keith - CDI On Nov 16, 2018, at 12:54 PM, Sannyasin Siddhanathaswami via 4D_Tech <4d_tech@lists.4d.com> wrote: Aloha all, Is there a simple way to include related field (with Manual relations) in a current selec

Related Fields in a Listbox (Manual Relations)

Aloha all, Is there a simple way to include related field (with Manual relations) in a current selection listbox in v17? Not sure why I haven’t done this before with listboxes. Sannyasin Siddhanathaswami ** 4D Internet Users

Listbox Crashes 4D in v17

In v16, I added a spacer column with this code: LISTBOX INSERT COLUMN FORMULA(*;"CCTransactionsLB";3;"SpacerCol";" ";Is text;" ";$headerVar) LISTBOX SET COLUMN WIDTH(*;"SpacerCol";10) OBJECT SET ENTERABLE(*;"SpacerCol";False) //make column unenterable Unfortunately, this crashes 4D (quits to

Re: Preventing Return and Enter from Closing a Dialog

Thanks for everyone's help. I couldn't get the Database Settings solution to work. Very weird. I set it to this and still "Enter" closed the window. https://www.dropbox.com/s/drzxr3othn8dti8/Screenshot%202018-05-20%2016.11.58.png?dl=0 I even restarted the server. Still didn't work. But, I was

Re: Preventing Return and Enter from Closing a Dialog

Thanks! I've never noticed that setting. While changing that setting didn't work, I'm going to try rebooting the server later to see if that's needed to get the setting to work. I'm running v16.3 Mac on server and client. Two Way Communications via 4D_Tech May

Preventing Return and Enter from Closing a Dialog

Aloha, I'm playing with the "proper" way to open up a form. Here's what I have: Open form window([ARInvoice_Payments];"Invoice_Payment_List";Plain form window;On the left;Vertically centered) DIALOG([ARInvoice_Payments];"Invoice_Payment_List") It works fine, but if a user presses

Re: OAuth Code Library

le-api https://github.com/4D-JP/4d-tips-google-mail https://github.com/miyako/4d-tips-facebook-integration https://github.com/miyako/4d-tips-quickbook-integration 1.0 and 2.0 Example https://github.com/miyako/4d-component-oauth 2017/12/07 7:10、Sannyasin Siddhanathaswami via 4D_Tech <4d_tech@lis

Undroppable Fantom Users in 4D v16.2 Server Mac

Aloha, I’m getting users logged in twice to 4D Server 16.2 Mac. One of the duplicate is stuck for days. A manual “Drop User” doesn’t do anything. The only choice is to quit and restart 4D Server. This is becoming a pain as we run out of licenses with stuck users! Anyone run into this?

Re: Love 4D's math interpretation...

For sure! I’ve been burned by 4Ds left to right operators. I assumed 4D followed order of operations…Oops. That was a weird bug to track down. Now I’m obsessive with parentheses! Sannyasin Siddhanathaswami On Sep 28, 2017, 10:14 AM -1000, Tom Dillon wrote: A variation of this sig line would

Re: Listbox Spacing Between Columns

Thanks. This does work reasonably well for this circumstance. As I’m using field based listboxes, I used the following to make the spacer column: LISTBOX INSERT COLUMN FORMULA(*;"CCTransactionsLB";3;"SpacerCol";" ";Is text;"";$HeaderVar) LISTBOX SET COLUMN WIDTH(*;"SpacerCol";10) OBJECT SET

Re: Listbox Spacing Between Columns

Very cool idea! Does this formula evaluation only work with arrays? Or text fields too? Sannyasin Siddhanathaswami On Sep 24, 2017, 3:20 AM -1000, wrote: Next approach is to read the real arrays into text arrays. In this case since they are just display it doesn't really matter. In lots of

Re: Listbox Spacing Between Columns

Me too! (well not a couple of decades—at least 1 decade) I’m looking again seriously at Listboxes as a replacement for ALP. It’s close, but there’s a couple things that don’t quite work well in Listboxes for heavy data editing. I do both the programming and the data editing for this, so little

Re: Listbox Spacing Between Columns

Excellent idea, unfortunately trailing spaces are ignored. Too bad, as that would have been perfect for this circumstance. Any other ideas? Sannyasin Siddhanathaswami On Sep 23, 2017, 12:03 PM -1000, wrote: Have you tried a format that has a trailing space?

Listbox Spacing Between Columns

Aloha! I have a listbox column for dollar amounts (aligned right) followed by a Description column with text aligned left. Unfortunately, that means the text of those two columns are butting up against each other. Is there a way to add a bit more space between columns? See screen shot:

Listbox Column Font Color Change

Aloha! How do I change the font color of a listbox column and not change the background color? I’d like the fonts in certain columns to be “Dark grey”, and have rows alternate colors. This changes the font color to Dark grey (but forces the background of the column to white: OBJECT SET

Re: [OFF] PCI/DSS compliance

Guess they weren’t PCI compliant… PCI compliance is a huge pain. I highly recommend taking the route of not doing charges in house. It avoids most of the issues. Sannyasin Siddhanathaswami On Sep 8, 2017, 9:17 AM -1000, wrote: I find the idea that it is necessary to implement PCI ironic, when

Re: Losing Hightlighted Records in a Listbox

to COPY SET ("$userset";"$userset") on whatever the name of your highlight set. > 2017/09/04 12:01、Sannyasin Siddhanathaswami via 4D_Tech > <4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>> のメール： > I can understand if changing the selection causes the hi

Losing Hightlighted Records in a Listbox

Aloha, I don’t quite understand why my highlighted records are lost. 4D Server v15.4 Mac. I’m doing the following in a button on the form that has a listbox. $ListBoxName:="CCTransactionsLB" COPY NAMED SELECTION([CC_Transactions];"TempCurrentSet") LISTBOX GET TABLE

Re: Datatables Tips

If this helps someone, here’s my code for creating the array of objects, summarized. This gives the same output for Datatables, but is from arrays (the last section builds the array of objects): ARRAY LONGINT($aItemNum;0) DISTINCT VALUES([Sale_Items]Item_Num;$aItemNum) //get items nums

Re: Datatables Tips

For a javascript novice like me, all those weird comma, parenthesis and curly brackets gets confusing immediately! Yes. I have a tough time finding a decent editor too. Having done most of my programing in 4D, I realized I’m spoiled with auto formatting and coloring. Yes I know js is flexible

Datatables Tips

Aloha, Since it’s in the air, I figured I’d share a couple tips I’ve discovered in the past few days. I’m not a Javascript programmer... I think David Adams has done a post on this too. For creating a DataTable (www.datatables.net), first create the data from 4D in a test method:

Re: Array Summary Sum Utility Method

Aloha Nigel! Very interesting. I really haven’t used 2D arrays, I guess in part because I didn’t see a use. Summing a row of a 2D array is very slick. Thank you so much. I ended up just using sets and looping through each unique ID to build the summary array. Sannyasin Siddhanathaswami On

Re: Array Summary Sum Utility Method

Aloha Kirk! This is an awesome tip that I will use! In this case, I’m currently using objects/json to output reports and lists to DataTables (www.datatables.net). I’m really impressed with DataTables. I’m getting into using objects more and more, and love them. Sannyasin Siddhanathaswami On

Array Summary Sum Utility Method

Aloha, Does anyone have a utility method for summarizing (and summing) a set of arrays? For example with Invoice Line Items: Arrays: aItemNumbers aItemDescription aQuantitySold aExtendedSoldAmount Of course, with invoice line items there are multiple records with item numbers. I want a

Tips and Tricks Google Doc

Aloha, Thanks for all the great favorite tips posted in the past few days! I’ve learned quite a bit of helpful time savers. As part of that, I made a public Google Doc (editable by anyone with the link), summarizing all of the tips posted so I could reference and implement them. Feel free to

Picture Buttons in v16

Aloha, I’m trying to make progress preparing our database for v16. Thanks for the help a few months back converting old PICT files. Turns out, Convert Picture was crashing like crazy in v15.2, but works fine in 15.3… Hopefully that helps someone else trying to do the same. Now I’m trying to

Re: ON ERR CALL: Comments & Seeking Comments

Great tip! I’ll check it out for sure. Sannyasin Siddhanathaswami On May 14, 2017, 7:07 PM -1000, wrote: Seriously though, if you want a chance to develop more consistent and coherent code, you can't doo better than to read (or re-read) "Code Complete." (There's a second edition now, for those

Re: ON ERR CALL: Comments & Seeking Comments

Thanks for this! Very helpful! I’ve started to use it more and more nowadays. I’m really curious how errors in 4D process tags are handled (especially in v16). I’m having a tough time debugging these tags through the 4D Web Server in v15. More testing needed as I didn’t realize you could use

RE: 4D Server Crashes When Tracing Buggy Web Connection Code

Aloha, Thanks for the tip. Tons and tons of errors in the first run of Check Syntax in the compiler. It is nice that it highlights the line numbers/issues in an open method. The errors though are mostly or all, “The Variable xxx has not been explicitly declared in the typing methods.” As I

Re: 4D Server Crashes When Tracing Buggy Web Connection Code

Thanks! I’ll be using both of those tips. I haven’t used On Error Call much, but will look into it. At a minimum, I want: “On Error, don’t crash my server!" Sannyasin Siddhanathaswami On Apr 7, 2017, 9:12 AM -1000, wrote: Sannyasin, Two things: I make it a habit to check for -1 anywhere I'm

RE: 4D Server Crashes When Tracing Buggy Web Connection Code

Aloha, Yes. The crash did happen when accessing an array with a negative index! If that’s the only thing that causes the crash, I can be extra careful about that and do checks. Thanks for pointing this out. And yes, I wrote that serious bug. :) As this is an internal database for our

4D Server Crashes When Tracing Buggy Web Connection Code

Aloha, If I trace On Web Connection code on 4D Server v15.3 Mac, and I goof and reference an out of index array (I know I’m the first to ever do that), our server crashes. It just quits to the Finder, no error message nothing. I view the trace via screen sharing to the server machine. This is

Re: Regex Find and Replace with Groups

Thank you so much! That was exactly what I needed! Sannyasin Siddhanathaswami On Mar 29, 2017, 11:44 PM -1000, Vincent de Lachaux via 4D_Tech <4d_tech@lists.4d.com>, wrote: A component is available with source code here : http://forums.4d.fr/Post/EN/7161740/1/7161741#7161741 v i n c e n t d e

Re: Understanding 4D Mobile...

We use 4D internally. Some of our people like web interfaces better than straight 4D. With that in mind, we created a web interface using 4D Mobile/Wakanda to allow users to easily add simple info to identify credit card charges they make. For this, 4D Mobile/Wakanda works fantastically. Its