Jeremy:
'Quick Edits' of what?
My databases are all compiled. The Designer can do anything, including exiting
the splash screen, and then to user mode. Anyone else can have certain
privileges(or most all), but they can not exit the splash screen.
Easy to do.
> On May 16, 2017, at
PERFECT! I have got to sit down and read the LRM front to back on a regular
basis. I have never used DOCUMENT LIST.
DOCUMENT LIST is instantaneous and works in both the windows and mac
environments.
Thanks Keisuke!
John
//quick and dirty code using DOCUMENT LIST...
Message2Close
On Tue, May 16, 2017 at 6:26 PM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:
> I think SQL EXECUTE SCRIPT is more suited for managing long SQL statements,
> rather than creating a method with Begin SQL~End SQL
>
Just remember that all linked arrays must be process arrays
Regards
This does not work…
$windowsCommand:= "dir “+[Document]File_Name+" /s”
SET ENVIRONMENT VARIABLE("_4D_OPTION_CURRENT_DIRECTORY";"C:\\")
SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")
LAUNCH EXTERNAL PROCESS($windowsCommand;$_t_InputStream;$pathFound)
$pathFound is returned empty.
It
DOCUMENT LIST with the "Recursive parsing" options gives you all the file paths
contained in a folder
(since v13)
http://doc.4d.com/4Dv15/4D/15.4/DOCUMENT-LIST.301-3274226.en.html
it has some other useful options too (Ignore invisible, Absolute path)
tha makes a lot of previous code for
Just tested if using LEP to serve the current paths to the documents is going
to work for me. It is still too slow when compared to retrieving the path
directly from a field in the DB.
Using LEP to get 17 paths on request from the web site takes 7-8
seconds.
Passing the paths
Keisuke,
A great idea. I was not even aware that a file number existed. I am
thinking, however, that the possibility of the number changing makes this
approach a bit scary. Especially considering that a backup recovery would in
fact change the file’s numbers, something I have no
I think SQL EXECUTE SCRIPT is more suited for managing long SQL statements,
rather than creating a method with Begin SQL~End SQL
http://doc.4d.com/4Dv15/4D/15/SQL-EXECUTE-SCRIPT.301-2007434.en.html
**
4D Internet Users Group
as long as the files are moved on the same file system,
and the files are moved or edited, and not over-written (many applications do
that silently...)
then you might be able to track those files by keeping their number.
https://github.com/miyako/4d-plugin-file
-
I am working on a side-project
Keisuke,
For some reason I am getting posts to the NUG from you without content…
> On May 16, 2017, at 12:03 PM, Keisuke Miyako via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
>
> This message contains a digitally signed email which can be read by opening
> the attachment.
Got 2
An app deployed (beta testing) on 15.3 and I'm running into the BLOB to
user bug that was resolved in 15.3HF1.
I can download 15.4 from 4D but can't find 15.3HF1.
Can some good soul point me in the right direction for that?
--
Douglas von Roeder
949-336-2902
This message contains a digitally signed email which can be read by opening
the attachment.
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options:
This message contains a digitally signed email which can be read by opening
the attachment.
**
4D Internet Users Group (4D iNUG)
FAQ: http://lists.4d.com/faqnug.html
Archive: http://lists.4d.com/archives.html
Options:
I have setup code to allow the export and import of records from a
specific table (bug reports).
This allows me to create a bug/feature report and send it to our
server, or import to my local (development) database from a user
entered request/problem.
This worked in v11 and 12, i am now trying
Hi Jeremy,
Thanks for the info.
I need to make sure that if they log in as admin then this restriction is not
there. I have tried for years to dissuade the “power” user from going into
“design mode” but she uses it for quick edits (as unreliable as it has
seemingly become). Anyway...
So I
OK. Would something like this work…
$windowsCommand:= "dir “+[Document]File_Name+" /s”
SET ENVIRONMENT VARIABLE("_4D_OPTION_CURRENT_DIRECTORY";"C:\\")
SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")
LAUNCH EXTERNAL
Hi All,
If I build clients with 15.4 hot fix 2 and then build server with 15.5 (If
and when it comes out). Will client connect and work.
I would guess same issue for earlier versions. If I built with 15.3 hot fix
x and then built server with 15.45 will it connect?
Is there anything I have to be
I am rethinking what I am trying to achieve. The purpose of this exercise is to
update file paths stored in 4D for thousands of architectural drawings when the
folder containing all these nested drawings is moved to a different location
locally or to a different machine.
Ultimately the paths
There is likely a bit of overhead in LEP, plus the overhead of launching
processes, which is going to add up when used in a loop like that.
For this particular case, your fastest option is probably to build a C_OBJECT
with the filenames as keys and the file paths as values, and in your loop
Hi All,
I’m asking this because I have time scheduled tomorrow to try this approach.
But I though I’d explained and see what others have experienced using similar
approaches.
So if I want to protect the db from a user getting into “design mode” - given
we have rolled our own password security
Are you all repeating the LEP in a loop? I am calling SysDoc_Find like this…
vNewFolderPath:=Select folder("Select the the parent folder that contains all
documents... ";1)
ALL RECORDS([Document])
$size:=Records in selection([Document])
For ($i;1;$size)
GOTO SELECTED
I’d second that. I just tried it in the command line on a folder with 5,144
(nested) files and with almost 1,400 results the response was near instant.
So, I tried this in 15.4 and Mac 10.12.5.
Basically stripping the convert path stuff because I was passing in the full
path and those commands
Which version of 4D are you using? Some versions have a bug in LEP that causes
them to use 100% of the CPU when they are waiting for the result, thus
drastically slowing everything down.
If you repeat it from the command line instead from inside 4D, what happens?
--
Jeffrey Kain
Thanks Nigel,
Your suggestion works. So I wrote a quick method to test using the
following…
$_txt_OSASCRIPT:="mdfind -onlyin "+$searchIn+" -name \""+$searchFor+"\”"
Interestingly this is way slower than crawling through the directories.
Using my SearchFolderContents_Jut method
G’day guys,
I stopped counting how often I spit the dummy over the last days - it is just
inhuman.
The initial situation:
A SQL-database with 70 tables (most of them empty) with sequentiell “relations”
only used/written on Windows, wehre columns/fields contain all sorts of alien
gremlins one
Hi
On OSX this is easy to do-something like this should work
$_t_DocumentPath:=<—known name //if a partialthe image path is know
$_txt_OSASCRIPT:="mdfind "+Char(34)+$_t_DocumentPath+Char(34)
$_t_InputStream:=""
$_t_OutputStream:=""
LAUNCH EXTERNAL
I am thinking that perhaps using Launch External Process there might be a way
to search for a file and get back the path to the file if found.
I have a method that recursively crawls through a volume or folder to locate a
file, but it is relatively slow. It is pasted below. Any ideas to make
27 matches
Mail list logo
