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 Gro
sits" datastore class
This is where I have to reboot the server as the only way to update the
datastore, right?
Thanks for the list of possible errors and troubleshooting options Miyako. I
will use them!
Sannyasin Siddhanathaswami
On Mar 9, 2020, 6:47 PM -1000, Keisuke Miyako via 4D_Tech
&
to run that reloads
whatever list the ds.Table.query() uses to find field/attributes? Or Should I
just index all fields? What do you all do?
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
Archive: http://lists
Makes sense. I was hoping I wasn’t going nuts!
Sannyasin Siddhanathaswami
On Mar 9, 2020, 10:35 AM -1000, John DeSoi via 4D_Tech <4d_tech@lists.4d.com>,
wrote:
I think there was a bug related to this late in the beta cycle. I'm not sure if
the fix made it in to 18.0. Seems to work fine i
,
but all I read says the above should work and be collapsable. What am I missing?
Thanks,
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com
all of this will be a
requirement.
Sannyasin Siddhanathaswami
On Sep 18, 2019, 8:17 AM -1000, Aparajita Fishman via 4D_Tech
<4d_tech@lists.4d.com>, wrote:
I worked on a 4D system originally developed by Aparajita more than 22 years
ago for an investment bank. It used
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.
o figure out how to keep the sort, and get rid of the
deleted records (now showing as blank).
Any ideas?
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists
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
Thank you Miyako!
I changed the compatibility setting, but that didn’t help for this.
I then traced and found, as you suspected, that the variable was text. Makes
sense, as it’s a enterable box. Declaring it properly fixed the issue.
Thanks!
Sannyasin Siddhanathaswami
On May 15, 2019, 7:13 PM
T FORMAT command.
I looked through all of the properties of this variable, but don’t see anything
weird. Creating a new variable also doesn’t work. These are all numeric
variables.
Any clues?
Sannyasin Siddhanathaswami
**
4D Int
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:
it, just thought
once of those combine, or other commands could do it rapidly.
Thanks,
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
Archive: http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman
ult.values[$dataRowNum][$HeaderEleNum]
//set the property and value for each header
End for
End for
Hope someone finds this a bit useful. At least for better understanding
collections. I’m using this currently to get data from a Thinkific course, to
Google Sheets via Zapier, then to 4D.
Sa
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 Siddha
**
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
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 th
that has the headers in the
first “row” of the array "values[0]”:
[
[ID,First Name,Last Name],
[5912029,Sannyasin,Siddhanathaswami],
[6015906,Mayuran,Sokkan]
]
My goal is to be able to reference this new object by doing something like:
$lastName:=$convertedObject[“ID”][“6015906”][“Last Name”]
I
Thanks. Just what I needed!
Sannyasin Siddhanathaswami
On Nov 16, 2018, 9:09 AM -1000, Keith Culotta via 4D_Tech
<4d_tech@lists.4d.com>, wrote:
These have worked:
// ok
GET AUTOMATIC RELATIONS($o;$m) // before the listbox displays
SET AUTOMATIC RELATIONS(True;$m)
// better
: (Form
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
ke column unenterable
Unfortunately, this crashes 4D (quits to the Finder). It only crashes 4D at
when it displays the form, not when executing these 3 lines.
Any clue what changed, or what I’m doing wrong here?
This is Server/Remote on Mac.
Sannyasin Siddhanathaswami
as page 1), it doesn't work.
3. The button must be visible (property of object), enabled and
available
4. The "on clicked" form event must be activated.''
I don't get why it has to be on page 0, but whatever. I'll remember this
now for sure!
Sannyasin Siddhanathaswami
Keisuke Miya
4d.com
**
Sannyasin Siddhanathaswami <mailto:sid...@hindu.org>
May 20, 2018 at 10:06 AM
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"
sing the window.
An invisible button to trap the "Enter" key doesn't work.
Assigning a shortcut of "Enter" to my search button doesn't work
Am I missing something simple?
Sannyasin Siddhanathaswami
**
4D I
Thanks Miyako!
I’ll look at these carefully.
Sannyasin Siddhanathaswami
On Dec 6, 2017, 2:27 PM -1000, Keisuke Miyako via 4D_Tech
<4d_tech@lists.4d.com>, wrote:
OAuth 1.0a and 2.0 work very differently (2.0 is way way easier)
2.0 Examples
https://github.com/miyako/4d-component-goog
support is my next option.
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub
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
OLUMN WIDTH(*;"SpacerCol";10)
OBJECT SET ENTERABLE(*;"SpacerCol";False) //make column unenterable
Sannyasin Siddhanathaswami
On Sep 23, 2017, 5:19 PM -1000, wrote:
This may not work for your situation, but I have used a dummy column to provide
visual 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
glitches and funky UI things make a difference!
Sannyasin Siddhanathaswami
On Sep 23, 2017, 5:04 PM -1000, wrote:
Sorry, that’s about it for me. I’ve been using AreaList Pro for a couple of
decades…
**
4D Internet Users Group
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
://www.dropbox.com/s/w0kjr3bfdm8t6t1/Credit_Card_Transactions.jpg?dl=0
macOS does this in the Finder under the same circumstances:
https://www.dropbox.com/s/skpd8qi1ro9lylw/Dropbox.jpg?dl=0
Sannyasin Siddhanathaswami
**
4D Internet
([CC_Transactions]Date_;-Dark grey)
This sets alternate row colors like macOS Finder (but makes all the font colors
black):
OBJECT SET RGB COLORS(*;"CCTransactionsLB";Foreground color;Background
color;0x00F5F5F5)
Each one overrides the other.
What am I missing?
Sannyasin Siddha
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
Copy Set worked!
Just add one line of the following at the very end:
COPY SET($highlightSet;$highlightSet)` re-highlights records
and it works perfectly. That’s a bit obscure, but super easy. Thank you so much!
Sannyasin Siddhanathaswami
On Sep 3, 2017, 9:20 PM -1000, wrote:
you just have
other
code is executed after the button finishes.
I can understand if changing the selection causes the highlight to be lost, but
then, how do I set the highlight again?
HIGHLIGHT RECORDS doesn’t work for listboxes.
Thanks!
Sannyasin Siddhanathaswami
***
a reference
APPEND TO ARRAY($oaSalesSummary;$oRefCopy)
End for
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http:/
with some success.
Sannyasin Siddhanathaswami
On Jun 22, 2017, 4:28 PM -1000, wrote:
* What's up with how hard it is to find a decent editor or linter? I use or
have used Microsoft's Visual Studio Code, BBEdit (like TextWrangler, but
you give them money), WebStorm (the horror...but it can be configured
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:
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
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
a summary array where there is only 1 element with an item
number, and the aQuantitySold, and aExtendedSoldAmount gets summed.
I know there’s lots of ways to do this, but didn’t want to reinvent the wheel
if possible.
Thanks!
Sannyasin Siddhanathaswami
to add or edit any of them.
https://docs.google.com/document/d/1HpEqRUotpQtO3-3C_Tvpq1_MCte3qh-xSyGbdgJ7DQU/edit?usp=sharing
Thanks again!
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com
.
Is there a simple way to convert all my buttons to a format that works? I can’t
find anything in the conversion documentation.
Thanks,
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
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,
sion, while doing testing from a client/browser.
PS: Thank you for your detailed emails with discoveries and questions and
opinions. I read them with great care and work to implement as much as I can!
Sannyasin Siddhanathaswami
On May 12, 2017, 4:12 PM -1000, David Adams via 4D_Tech <4d_tec
I get to the bad code line. I’ll play
with the webserver on the client to see if I can work around that. Right now
it’s crashing on Distinct Values, which I suspect means there are not
“distinct” values in the selection. I’m a bit shocked how sensitive the Web
Server is!
Sannyasin Siddhanatha
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 anywher
without compiler
declarations.
Sannyasin Siddhanathaswami
On Apr 6, 2017, 11:15 PM -1000, wrote:
To be honest, I don't understand these problems. Our main product relies
heavily on the 4D webserver on the server, for years. So far there aren't any
serious problems. If there are any, we wouldn't
erver?
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub: mailto:4d_tech-uns
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
it takes awhile for one user to timeout. I think you get
2 wakanda/4D mobile license for the same cost as one normal 4D user license.
I don’t see 4D mobile being viable for a general web app because of the license
cost, but I’m never going to use it for that anyway.
Sannyasin Siddhanathaswami
Missed this first time around. I’ll try this first to see what’s up with the
pictures!
Sannyasin Siddhanathaswami
On 7 Feb 2017, at 09:54, Bruno LEGAY <b.le...@ac-consulting.fr> wrote:
Hi,
Take a look here :
http://forums.4d.fr/Post/FR/17329223/1/17329529#17329529
It is 4D code to
is
compressed.
I’ll try these things next:
Convert to PNG. If that works, convert again to JPG
Try PICTURE to BLOB, then BLOB to PICTURE instead of CONVERT PICTURE
Try the obsolete " _o_QT COMPRESS PICTURE”
I’ll let you all know what works for these funky pictures.
Sannyasin Siddhanatha
tures just fine in an input form. If I copy the picture out
of the input form, into another app, then back in, the conversion works fine.
Anyone have any tips on how to approach this? If I run the method to execute on
server, the whole server crashes…
Thanks,
Sannyasin Siddha
someone else will help
you, otherwise, I’d contact 4D. They might be able to help you get a demo
running.
--
Sannyasin Siddhanathaswami
On October 3, 2016 at 9:36:45 PM, Miguel Gonzalez
(magonza...@gmail.com<mailto:magonza...@gmail.com>) wrote:
Thank you Sannyasin for your answer.
I thou
I’ve run into a similar issue with not enough licenses for 4D Mobile, or
licenses that exist are used up. You might try restarting both 4D and Wakanda
to try to get the seats back.
--
Sannyasin Siddhanathaswami
**
4D Internet
Solved!
Tech support found that I had “Reject null input values” on by First Name
field! We must have checked that by accident at some point. Unchecking it fixed
the issue.
--
Sannyasin Siddhanathaswami
On September 1, 2016 at 11:25:56 PM, Sannyasin Siddhanathaswami
(sid...@hindu.org
Regarding the debug log, I was able to start and stop it from the maintenance
tab on the 4D Server administration window. That’s good enough as I didn’t have
any other activity at the logging time. Of course, I don’t understand enough of
what the log says to see any problem...
--
Sannyasin
That’s helpful. I suspect now that it’s some related table that has bad data in
it’s primary key field even though the error I get when saving says it’s in my
main Members table. I doubt this helps, but this is the full error:
Error when executing the method "Test Method" at line number 18
Aloha Kirk, Good hint. I’ll look at related tables/fields for mandatory. I’ll
also double check I have primary keys on everything. I thought I did.
Chip, unfortunately I get this error when I try to save a record with code
without loading a form.
--
Sannyasin Siddhanathaswami
On August 31
;[Members];$x)))
End if
Any clue what’s going on here?
--
Sannyasin Siddhanathaswami
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options: http://lis
on Code Flow (allows for refreshing tokens):
https://apidocs.sky.blackbaud.com/docs/authorization/auth-code-flow/
The second one is better as I don’t have to “allow” every time.
--
Sannyasin Siddhanathaswami
Saiva Siddhanta Church
Kauai’s Hindu Monastery
107 Kaholalele Rd
Kapaa, HI 96746
808-822-7032
63 matches
Mail list logo