I use 4d auth but store aditional data about the user in tables.
The user list is exported only on server, only server admin can access it.
But you can store it in the db as well. The 4d user list can be changed by
the 4d admin user, so export from stucture is done every night in the backup
process
After rewriting/removing the triggers on tables created/updated by the
preemptive processes, the REST processes also disappeared from my server.
The performance also improved drastically
Nils Kollandsrud
**
4D Internet Users
I am trying to learn to use SQL in 4D.
I wrote the code below to try a test using the TRIM function.
I have rewritten this several times but it throws a general parsing error every
time.
C_TEXT(vText)
vText:=" sql Text! "
Begin SQL
SELECT TRIM(BOTH FROM :VTEXT) INTO :vText ;
End
Hi Jim,
You are missing the 'from' clause with a table. 4D does not support sql queries
without table.
Eg in Oracle I would write: select trim(both from :vtext) from dual into :vtext;
But it seems 4D sql does not support the dual phantom table either.
Koen
> Op 15 nov. 2018, om 15:50 heeft Ji
I have a recursive routine (genology)
The routine is fine and works as expected - as long as the data is
valid.
I was working in my test data, which I have apparently F*&^%ed and the
routine recurses until I get a stack error and 4D crashes (stand alone).
How can I manage this so that I can e
it can not be this bad
https://news.ycombinator.com/item?id=18442941
Chip
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing
**
4D Internet Users Group (4D iNUG)
Archive: ht
You could keep track of memory, but why not increase size of process first.
Additionally, you could get stack memory and meory data. Call it before
exit get memory stats. You housl now have a ballpark of how much emory each
call takes. You can then perhaps use a counter.
Regards
Chuck
On Thu, No
Oops! Sorry about that—I had no idea!!!
Many Thanks Helge. I see it’s almost 7 in the evening your time—god kveld.
Robert
> On Nov 15, 2018, at 2:36 AM, 4dialog via 4D_Tech <4d_tech@lists.4d.com> wrote:
>
> By the way, Hilsen = Greeting in norwegian :)
*
Chip
I have some recursion stuff I do, sometimes it hit a bad data set that caused
an infinite loop. What I have done is, created a process variable that gets
incremented at the top of the recursion process and decrements at the end. I
then put a check in my code to see if I'm more than say 3
Thanks for sharing.
> On Nov 15, 2018, at 10:20 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
>
> it can not be this bad
> https://news.ycombinator.com/item?id=18442941
>
> Chip
**
4D Internet User
I’ve got a form from another system that I would like to use as a guide in this
new v17 database. I used the Mac to get a screenshot of a windows form and all
seemed well until I dragged that image file onto a new 4D form and noted that
it was far larger than expected. I suppose that the Mac ret
Okay, I found a way that works for me. I triggered the print screen command
via Parallels. Then, I had the image on the clipboard and was able to paste
into Paint 3D. Then crop and save to a file. I’m sure there is a better way but
this works for me for now.
Thanks,
Robert
> On Nov 15, 2018,
Chuck,
The recursion issue is a data related issue.
When the data is good, tested and running for years, there is no memory
issue, and no crashing.
It is the bad data which is causing the issue.
-- I created a relative relationship where an animal was it's own
parent... this is/was the data probl
I've been given a pretty big MySql data dump file (943 Mb) to migrate to
our 4D db. There are lots of tables, many of which I think are not needed
for our purposes.
I want to break this file down into individual files for each table, to
make it more manageable. So I created a method to parse the f
Pat,
>
> On Nov 15, 2018, at 5:18 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> I want to break this file down into individual files for each table, to
> make it more manageable. So I created a method to parse the file and create
> a new file for each table.
> But ...
> The con
In such cases I use a longint parameter "level" to the recursive method. On
first run this parameter is set to 1 and is incremented with every level of
recursion. I then test for an arbitrary "level" (e.g. 1000) and abort the
further recursion.
HTH
Ingo Wolf
4d_tech-requ...@lists.4d.com schri
16 matches
Mail list logo
