Re: Quick Report toolbar widget
Dear Jim, I seem to be stuck very similar to your situation. We are storing templates in blobs and lets the user select a template, edit, modify, run and store back to blob. No disk documents and the 32 bit plugin area is enough. I see the lack of menus and interface of the new 64 bit subform. I also miss style sheets from the toolbars. Did you succeed in using the source of the components? Was it complicated? Best regards Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 Developer Available
Dear Tom, I wonder if you could assist me in an 4D write / 4D write Pro transition / migration. It is a Mac installation currently running v17.3 in 32 bit. I like to go 64 bit and Catalina, but have been waiting for a command "Create Style Sheet". I understand that it comes in v18... So how do one make a transition... There are also some more 4D write programming that needs to be reprogrammed to Pro. Most of that can be done in v17R4 (32 bit) I think Beside from this 4D write I think that the application is up to date with _latest_. Best Regards Magnus Torell magnus.torell_at_smv.se -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Unusual crash / failure to start 4D - Solved
Dear Mike, I'm glad I could help. Best Regards Magnus -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Unusual crash / failure to start 4D
Dear Mike, In my case I suspected that the installation of an International (UK / US / ...) windows in combination with scandinavian languages as regional settings was the cause. With "in combination" I mean that during the first initial setup of windows I choose a scandinavian language i.e.. swedish in my case. If i reinstalled windows from an swedish (in my case) usb installer and also used swedish regional settings, then 4D worked. I can't say for sure that I tested to revert to some UK / US regional settings on the original windows installation, but I think I did test this and it worked also. Best Regards Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Unusual crash / failure to start 4D
Dear Mike, Maybe this is related to what I have experienced? http://forums.4d.com/Post/EN/26586808/1/26586809 I did make 2 separate topics on this same issue. I have not really understood what is the source of this problem. However it seems to be related to localizations and regional settings. If I install a swedish version of windows everything works. I think that I could also change regional settings to some english/us settings and it worked. So maybe the combination of a an international install of windows and a regional settings containing "nordic countries" is problematic. This can be related to problem with the command SET DATABASE LOCALIZATION under these combinations of Regional settings. Not much of help, but maybe you can fill the gaps also for me. Best Regards Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Delay process bug
Just for the record I can confirm that I have a mac server with a stored procedure that works like beneath, where I have seen this freezing state. Repeat . Find potential things to do Do it if any . Delay Process(Current Process;60*60) // Delay 60 sec Until (stopCallFromOutside) This is a v15R5 server and I think I have had this method to freeze 2 or 3 times times over a period of 1 and a half year. There is no Pause or resume process involved and it is pretty clean. On these occasions I could not stop communicate with this process and it did stop/freeze. Beside that server was doing fine. Did not check for interface update. Only way to resolve it was to restart. Server is running compiled and I "upgrade" frequently i.e. restarts every week. If some say it was introduced in v16 it may to have entered in the R5 release of v15R5 Best Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html 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: Anyone using Thomas Maul's Email Component in v16.x?
Dear Dave or Thomas, I would also very much appreciate the component (and source) for v16 / 17. I use it heavily in v15R5 and preparing for an upgrade and have noticed that my component is not working in v16/17. I did some tweaking on the version I got. Can't remember what, but maybe I need to do it again. I am not sure, but maybe I did a transfer of one method to the host ...rewriteURL... or something. So please if a link could be made public I am most thankful. Maybe some useful changes also have made its way in to the latest... Best Regards Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html 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 15r5 won't run on Windows 10 pro (2018)
Dear Craig, Yes I have encountered this before. We use a Jetway computer (intel atom flavor) with pre installed windows 10. This version doesn't run 4D v15R5. We have not found out why. So instead we install a similar Windows 10 from an usb (indeed an iso gotten from MS) and now things work again. I can't help, but can confirm the behavior. If you find out why I am interested to learn the reason :-) Best Regards Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html 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: Print settings Crash
Dear Chuck, Thanks. On the computer there were 2 admin users. One works and the other one does not. Both are indeed admin. Most likely this was an privileges problem, even though I don't understand how, as both user were admins. Something is probably corrupt with the privileges and has to be fixed. I have not confirmed it is an privileges problem, but anyway 4D seems a bit more sensitive to such kind of problems. Maybe Print Settings could have reported a problem with "whatever went wrong" instead of crashing 4D. However many thanks for all responses Best Regards Magnus -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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-unsubscr...@lists.4d.com **
Re: Print settings Crash
Yes, there is a default printer. I have now also defined a couple of printers and tried with both defined as default. No difference. Going through the debugger it crashes immediately when calling Print Settings(2) Calling Print Settings it crashes immediately after hitting OK in the second dialog. Regards /Magnus -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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-unsubscr...@lists.4d.com **
Re: Print settings Crash
Thanks for replies, I have now installed fresh v16R5 on Server and same on client computer... Running same database (upgraded) Identical behavior as with previous v15R5. see earlier post. Crash upon print of a method (Page Setup works) and crash on Print Settings as before. Hmm... It is 32 bit mode. Client doesn't have any Apple updates waiting for Sierra. Server is newly GoldPartner licensed (upgraded). No messages on server However Client still shows a license info that my license expire in 7 days... It is a Team Developer and I don't understand why the client computer -in remote mode- even looks for licenses as those resides on server... Can this be something? Though it is not expired. The MBP computer is a 2013 model and no Touch Bar 16 Gb Ram. Thinking what to try next... Regards Magnus -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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-unsubscr...@lists.4d.com **
Re: Print settings Crash
Thanks Arnaud, I tried that. From A method window I choose Page Setup and it works. When selecting Print (cmd+P) the application crashes immediately. What does this tell me? I will try to do the same thing with v16R5. Nothing is setup for the moment, so it will be tonight. Best for now Regards Magnus -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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-unsubscr...@lists.4d.com **
Print settings Crash
Dear, Strange problem I run into. The command Print Settings crash my 4D Remote on Mac OSX Sierra after I accept the first dialog. Print Settings(2) crashes immediately. Print Settings(1) works fine. Actually I can't print at all if I go through the print settings confirmation. I have made fresh install, deleted complete cashed folder etc. This is only for one specific computer. Both compiled and interpreted. There is a printer configured and made default and other programs print just fine. 4D Version is v15R5. There are many clients that work without issues for more than a year. This is a semi new MB Pro that I setup for 4D client. I am missing something but I have looked in archives for related topics, but can't find anything. I remember some printing issues some years ago if there was no printer defined at all in the system, but this seems not to be the case. Any ideas are welcome. Best Magnus Torell -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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-unsubscr...@lists.4d.com **
Re: Primary Key in 4Dv15
Hello Ronnie,
I agree with "Roll your own".
I just added new PK fields with the only purpose for journaling
and nothing else so far. With following code You can convert
a database.
I do it in 2 steps. Very first time I create a new datafile and let the
structure
add the fields. This should be done with v14 or 15. After that you can open
any
datafile (v11, 12, 13) with that structure file and conversion will be done
automatically.
I implemented 2 methods. First method I call from On Startup and On Startup
Server.
SYS_PrimaryKey_v14
//
// User name (OS): Magnus Torell
// Date and time: 14-12-29, 01:01:43
//
// Method: SYS_PrimaryKey_v14
// Description
// Method is tested and has to be run as follows:
// Open the structure in v14 with an EMPTY datafile
// This will convert the structure and add primary keys to all tables
// Done
// Now any other Valentis/MultiControl database in v11, v12, v13 can be
just opened and all PKs will be filled and indexed
// None of the automatic conversion dialogs should show up since the
structure is already converted and PKs added
// Upon opening of databases first you confirm that the will be updated to
v14.
// Then the data will automatically be filled with PK values (UUID) and
// Finally the new fields will be indexed
// Either before or after the indexing the PKs will be validated by v14
mechanism
// DON'T forget to enable journaling after conversion is done.
// This method could just lie around till a reasonable amount of time.
// Maybe could be adjusted to If (Application version == "14@")
// Parameters
//
// NB TRIGGERS. Each save will take longer time if triggers are on.
// In the triggers may be calls to interprocess vars that is not yet
initialized Be careful.
// For writer there is a ◊FileArray{}{} which is not yet initialized here
in beginning in On StartUp.
// Noted by: Magnus Torell (15-10-31)
// Followed up on this TRIGGER Part and did not understand why triggers
should be off.
// OK Maybe faster, but no harm seemed to be happening
C_TEXT($statement_t;$tableName_t)
C_LONGINT($curTable_l;$numTables_l)
C_BOOLEAN($b_RunSQL)
If (Application version>="14@")
$b_RunSQL:=True
C_LONGINT($fields_max)
C_LONGINT($field_number)
$curTable_l:=1 // Table 1 = Object
$fields_max:=Get last field number(Table($curTable_l))
$pk_fieldname_t:="pk_"+String($curTable_l;"") //New syntax for
primary
keys: "pk_" where stands for table number in format ""
For ($field_number;1;$fields_max)
If (Is field number valid($curTable_l;$field_number))
$fieldname:=Field name($curTable_l;$field_number)
If ($fieldname=$pk_fieldname_t) //Check if there
already exists a field
with syntax "pk_"
$b_RunSQL:=False
End if
End if
End for
If ($b_RunSQL) // ie. we have not found field pk_0001 in first table
(Object table)
$numTables_l:=Get last table number
For ($curTable_l;1;$numTables_l)
SYS_PrimaryKey_Create ($curTable_l)
End for
End if
End if
and second method
SYS_PrimaryKey_Create
//
// User name (OS): Magnus Torell
// Date and time: 15-07-02, 19:56:28
//
// Method: SYS_PrimaryKey_Create
// Description
//
//
// Parameters
//
C_LONGINT($curTable_l;$1)
C_TEXT($statement_t;$tableName_t)
C_LONGINT($curTable_l;$numTables_l)
C_BOOLEAN($b_RunSQL)
$curTable_l:=$1
$statement_t:=""
If (Is table number valid($curTable_l))
$b_RunSQL:=True
C_LONGINT($fields_max)
C_LONGINT($field_number)
$fields_max:=Get last field number(Table($curTable_l))
$pk_fieldname_t:="pk_"+String($curTable_l;"") //New syntax for
primary
keys: "pk_" where stands for table number in format ""
For ($field_number;1;$fields_max)
If (Is field number valid($curTable_l;$field_number))
$fieldname:=Field name($curTable_l;$field_number)
If ($fieldname=$pk_fieldname_t) //Check if there
already exists a field
with syntax "pk_"
$b_RunSQL:=False
End if
End if
End for
If ($b_RunSQL) //If there is no field already created
$tableName_t:=Table name($curTable_l)
$statement_t:=$statement_t+"ALTER TABLE ["+$tableName_t+"] "
