Creating Tables by running a method

I know that this feature has been around for a long time ~ 4D 2011. I am now using 16R6. I now have a method that creates a table with the fields I want added. The challenge I am having is setting indexes (and index types), as well as Primary Keys. I looked in the Knowledge Base for code

Re: v16 Time picker - bound variable changed

tures to the > community, > as well as collect feedback from 4D developers during the beta phase to make > sure R releases are as stable as possible. > > that is why 4D publishes (blog and documentation) new features well in > advance of release. > >> 2018/06/12

Re: v16 Time picker - bound variable changed

h@lists.4d.com> wrote: > > LISTBOX SET PROPERTY was created in 16R2, it's normal that it won't compile > on 16.3 (if that is what you mean) > > http://doc.4d.com/4Dv16R6/4D/16-R6/LISTBOX-SET-PROPERTY.301-3547819.en.html > > 2018/06/12 6:09、Jody Bevan via 4D_Tech > &

Re: v16 Time picker - bound variable changed

I submitted a bug on Sunday in regard to 16.3 Hotfix 4 where the command Listbox Set Property and all the lk_ constants are not dereferenced (thus cannot compile). In the Method editor one ends up with just a numerical reference. Jody > On Jun 11, 2018, at 2:40 PM, Keisuke Miyako via

Re: Save Record($vptr_Table->)

om> wrote: > > >> Le 10 juin 2018 à 23:18, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> a >> écrit : >> >> Sujit: >> >> I do not think it is a table number issue in our code. We built the local >> pointer early into the new process by cod

Re: Save Record($vptr_Table->)

Sujit: I do not think it is a table number issue in our code. We built the local pointer early into the new process by code similar to $vptr_Table:=->[StandardOrder] In one last try, before giving up on the few hours of code I wrote and go to my backup from last night, I compacted the

Re: Save Record($vptr_Table->)

> wrote: > > If there are any Unique fields in that table (I'm sure there are!) check > that you aren't trying to save a duplicate value in one of them. > > PB > > On 10 June 2018 at 21:02, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> > wrote: > >&

Re: Save Record($vptr_Table->)

able directly identified '-1' Jody. > On Jun 10, 2018, at 1:54 PM, Douglas von Roeder wrote: > > Jody: > > Try using the actual table name. What’s in//disable the trigger. > > On Sun, Jun 10, 2018 at 12:50 PM Jody Bevan via 4D_Tech <4d_tech@lists.4d.com > <mailto

Save Record($vptr_Table->)

The method that this err occurs in is used hundreds of time throughout the system. All record saves go through it. I have a record I used Add Record which opened up our ‘Input’ form. Within the Form Method On Load I update information in the record, and from the User Interface I update

Re: Date entry

Bob: Nasty date formats. About 15 years ago we created our own tool for the date entry, and display in 4D. The dates are always stored in date fields, but we let the user define the way the dates get displayed. This way it does not matter what the computer’s region or date settings are. The

Re: Losing memory on 4D web application

Aparajita: We loved ObjectTools at Jonoke for well over a decade. We could not have done what we did without it. It was fantastic. Thanks for ObjectTools over all those years. We never had a memory leak from it while we used it. It is great having plug-in developers creating tools for us,

Drag from outside of 4D into a 4D Form

I thought it would be good for an Import to let people drag a file from the desktop onto a form. It certainly is not a critical feature, the old style select from a file dialog works good for me. I was looking for an example database, or tech note but could not find one. The Drag and Drop

Re: Subform - Detail

me. Sincerely Jody Bevan > On May 30, 2018, at 11:57 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Jody, > > On Wed, May 30, 2018 at 10:39 AM Jody Bevan via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> 1. How can the parent form

Re: Subform - Detail

Kirk: THANKS!! That sounds great, and you taught me more too. Jody > On May 30, 2018, at 11:57 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Jody, > > On Wed, May 30, 2018 at 10:39 AM Jody Bevan via 4D_Tech < > 4d_tech@lists.4d.com> w

Subform - Detail

While this old timer is going to use a Detail Subform for the first time. I have read the documentation a few times, but I missing one thing (thus far). 1. How can the parent form know that a change was made in the Subform Detail form (which is information from another table) so that it will

Re: First experiments with 4D View PRO

I am of similar mind as Jeff in regard to charging if one just uses for the extra Listbox features. There are times where the features of being able to show pictures, numbers, Strings, etc in the same column of the Listbox has proved very useful. Having done this in our shell, it means we

Re: Server Administration Window - I must have been dreaming

I know we can make our own Server window that can be displayed from anywhere. I thought I also remember too that we can modify the existing one (or maybe they meant create a custom one that gets used). This is great news when looking after hundreds of servers, or just one. Jody Jody Bevan

Re: 4D Write Pro Interface component v16R6

Thanks for sharing Randy. That will save me time… now I need to remember you told us. Jody > On May 13, 2018, at 7:28 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Just a word of warning to prevent headaches for anyone else in the future. > > I just finished spending a few

Access to Runtime Explorer

In a Multi Developer environment none of the developers sign in as the ‘Designer’ user. We have a group that has access to the Design environment. We then put developers into this group. Therefore, when working on the system none of us have access to the Runtime Explorer. Sometimes that could

Re: New network layer update

Jeff: I gather that if this continues for a few weeks, that you will switch to 64bit clients? Jody > On May 2, 2018, at 3:16 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > We flipped the switch on our production server at midnight this morning and > ran all day. We peaked

Re: Compiler_ Methods

Ferdinando: These are the standard for the method where the compiler will look to declare the variables the way you want them. If you do not do this, then the compiler will declare the variables as it comes across them. I do not remember which version this became the rule, but it has been for

Re: Macro to check that local variables are declared in a method?

Bob: Another thought to watch out for. As you know in some cases 4D names some of it’s own things starting with a ‘$’. For example a Process name can be named starting with a ‘$’. If you have strictly named local variables those should be easy to filter out. Jody > On Apr 27, 2018, at 9:54

Re: Macro to check that local variables are declared in a method?

Bob: I would suggest if you are going to write something this far, why not make it so that it will declare all local variables for you, and remove declarations that are no longer needed. A great time saver. Of course to go that far, there needs to be a strictly enforced naming convention.

Re: list box on a subform

Chuck: We use forms to be Included forms on multiple tables, and multiple different forms. The listboxes are all set up in code, and can be changed by each individual user. We have not set up a Listbox outside of code in years now. I cannot see a reason to leave Listboxes, or not use them in

Compound Indexes

Recently a new Database I am working on 16.R2 build 209757 has a problem. We have a 5 compound Indexes in the structure. We have a dialog that will display the tables, fields, and index name for the compound indexes. The problem I am having is that the following indicates there are 4 compound

Re: 4D data on the web - what do you use?

Tim: The story is long, but the steps for them are: 1. Set up an RFP that is targeted such that their cronies are the only ones that can deliver (ISP - Telco), thus every current vendor must partner with the telco. 2. Refuse to give out important interface information to various public

Re: 4D data on the web - what do you use?

Tim: > On Mar 14, 2018, at 12:36 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I guess that explains why you “retired” and moved to that “tropical" place. > You sold your company and got rich. Congratulations! There is a much different ending than you have given. I like your

Re: 4D data on the web - what do you use?

This is a very timely topic for me. We put a good chunk of our medical application on the Web back in 2004. Back then we used Apache up front, and then just used 4D to generate the HTML. We had 4D serve the HTML through a 4D Client back through Apache. It worked very well, and is still running

Re: [SAD NEWS] legendary developer and 4D base-rock Ortwin Zillgen

Bob Miller, I agree with you. I always enjoyed reading Ortwin’s posts. It is like we know Ortwin from his posts. He contributed to many systems through his posts. Jody Bevan Argus Productions Inc. BTW, I enjoy reading almost all posts here. I learn so much from this group, and the previous

Re: European Data Protection Reglementation to take effect on May 25 - 4D compliance?

Low level data encryption at rest is best achieved with hardware. The major server vendors provide RAID controllers that look after this for you on the fly. This way the data is always encrypted on the hard drives. That way if someone steals the server computer they need that RAID controller in

Re: Re(2): "Goodbye 4D Write" email

I will add my 2 cents worth here too. I agree with Jeff. As a previous post noted a big cause of this problem was Apple. They forced change on us, and on 4D. I was involved in an industry where each month brought new requirements that were forced upon us by various governments that we had to

Re: 4D Server / Remote 16.2 64-bit macOS 10.12.6 or 10.13

When I read that Apple was moving ahead with the new filing system in 10.13 I decided to wait that change out - likely until 10.14. Apple tried that once before and fell flat. I see that there have been a couple of big problems with the new file system - happy I waited. I really appreciate

Re: The speed penalty for pointers is pretty low compiled

Kirk: You are right how we stick to our old habits. We do though because they have proven to work and sticking with them saves a lot of time. What we have done is to rewrite our shell every so often. The goal is to make use of all of the new features of 4D that we can, and to try new ways of

Re: 4D v6.8

Wayne: Thanks - you confirmed what my research was telling me. I should be good to go with my original MacBook Pro. Jody > On Nov 16, 2017, at 4:35 PM, Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi, > > Scratch that, I've got it running in both 10.5 & 10.6 (next time

Re: 4D v6.8

Tim: That is a good idea for these old structures. I checked out my original MacBook Pro and it is running 10.6. So I should be good to go. This will be a good idea for the future. I did read that 10.6 is still available from Apple. Jody > On Nov 16, 2017, at 2:22 PM, Tim Nevels via 4D_Tech

Re: 4D v6.8

Chuck: Thanks! I will keep your offer in mind. I do have a computer running 10.6.x with lots of room - original MacBook air. Jody > On Nov 16, 2017, at 2:32 PM, Charles Miller via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Great idea I have 10.6.8 server running as a VM ware partition for

Re: 4D v6.8

t for that but gave up > > Regards > Chuck > > Sent from my iPhone > >> On Nov 14, 2017, at 11:16 AM, Jody Bevan via 4D_Tech <4d_tech@lists.4d.com> >> wrote: >> >> my old (1st version of MacBook Air has on it) That just might do the

Re: 4D v6.8

Thanks everyone. I will read up on the vll upgrade manual. That is helpful and give the official word on how to do it. I will look to see what version of the OS my old (1st version of MacBook Air has on it) That just might do the trick. I will contact 4D sales about getting the necessary

4D v6.8

I did not think I would be dealing with anything before v12, so I deleted all my old versions of 4D a few years ago. Oh well, of course when one does that you need to have what one has deleted. I need to convert a v 6.8 database up to v16. The problem I am encountering is that there are

Re: Server Process "Frozen"-ish

I was hoping that with the Preemptive processes we could actually accomplish this. I have not tried it as of yet though with v16. I will stick with ‘Butlers’ as we called them, for now. Jody Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc.

Re: Widget performance

Maybe 4D does not need what we do anymore, but old habits die hard. When we have multiple pages we split the code for setting up all the objects on the form into ‘Page_Methods”. The specific page methods are only run the first time the user clicks to go to that page. That way it usually makes

Re: 4D server "pausing" every 15 minutes

Jeff: We love dashboards too. At Jonoke we had a dashboard that would display information on all our client’s servers, and various ‘Butlers’. This way we were often notified before they called of an issue. Collecting the stats also helps to uncover issues. They take time to write, but they

Re: Using SVG for button graphics

Kirk: The way we did this was to have one picture object on the form for our button palette. When we built the button pallet we created the SVG on the fly and positioned the buttons where we wanted them to go. We did this because we controlled through security what buttons were available for

Get notification when there is a Backup Error

Ferdinando: I have sent the contents of the On Backup Shutdown method that we use. When the backup quits for what ever reason, we determine the results. We then send a message to the System Admins (and any others needed) to let them know. I have sent it as an Exported 4D method. Let me know

Re: Backup failure

Ferdinando: I sent you code that will do what you are looking for I believe. Did you not get it? Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc. > On Aug 21, 2017, at 12:15 AM, stardata.info via 4D_Tech >

Re: Unable to Compile - Crash - looking for ideas

Randy: Keep us posted. That is a scary one. Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc. ** 4D Internet Users Group (4D iNUG) FAQ:

Re: How to show / hide all on Property List in v16?

I didn’t know about this shortcut either. Never tried it before - or now. > On Aug 14, 2017, at 3:06 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Never knew about this shortcut... > > -- > Jeffrey Kain > jeffrey.k...@gmail.com > > On Aug 14, 2017, at 5:04 PM, Kirk Brooks

Re: Preventing Duplicate Data WAS UUID vs Longint primary key

Chip: I have always tried doing at the point of data entry. Obviously no code is perfect, and either is the object between the keyboard and the chair. My experience is that few Administrators would take the time to filter through duplicates. Getting them to do system maintenance was almost

​Re: Preventing Duplicate Data REAL WORLD

I thought I would share this real world experience in regard to data, as it is somewhat humorous, but not for the people in the back seat. Long long ago, in another country, I was a police member patrolling the downtown streets of a city in economic boom circumstances. There were lots and lots

Re: Preventing Duplicate Data WAS UUID vs Longint primary key

John: Thanks for sharing this. I had not thought of this way after all these years. I will take the idea and apply where appropriate, in addition to my normal code to reduce duplicates. Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc.

Re: External data storage question

Tim: Thanks for posting this. I was totally unaware of this - probably started in my brief hiatus from programming. This is exactly what I was asking for a couple of weeks here. I will use this for my documentation now, and add in a few comments from time to time. Jody Bevan ARGUS Productions

Re: UUID vs Longint primary key

So what might be not so good with UUIDs? After watching how people work with our systems for 26 years (most of it without UUID capability) I noticed that they often referred to the record by the Unique LongInt we created for each record. For the first year we hid our unique ID - why would

Re: External data storage question

John: We did this big time long before 4D permitted it autosaving the ‘picture’ outside of the data file that they looked after. Therefore we had to look after the saving, and when loading up the form we had to look after retrieving the ‘picture’ as well. It sounds like you have done almost

Re: Encrypted Data at Rest

Richard: Hardware acceleration in the CPU is still not nearly as fast as this task being done by the drive controller. All software runs through the CPU. Yes, the CPU can support specific types of code which helps. Just like GPUs, the advanced support in the drive controllers makes a big

Re: JSON Tools Was: Re: C-objects and memory use

David: Of your four options I choose #1. ;-) Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc. > On Aug 2, 2017, at 11:34 AM, David Adams via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > > Without compile-time verification

Re: Encrypted Data at Rest

Chip: Even longer than the hardware/firmware solutions there has been software to do this. The performance hit is substantial though. I remember testing out a software solution about 15 years ago with a compiled standalone version of our application. Essentially with these they intercept the

Re: Encrypted Data at Rest

Justin: That is a requirement of Health Care Systems in Canada for more than 15 years. It is actually a good idea. Fortunately there is an ‘easy’ way to do it and it does not take once ounce of programming (not good for billable hours). The clients purchase the drive controllers and drives (if

Re: zipping files - Solved

So I took a day off to move someone, and a good night sleep. Started out testing - not working. Then put the debug hat on again to test my inputs. Yah - saw it without testing. I tacked a time string on the file name. Yup you already guessed it - left the colon in the time string! ARH!!! Stupid

Re: zipping files

Matthias: I delete the plugin file I was using. I then put in the plugin that is located within the structure package I was using that it worked. I restarted 4D and application. Same result as before. Head scratcher. Jody Bevan ARGUS Productions Inc. Developer Argus Productions Inc.

Re: zipping files

tps://www.facebook.com/ArgusProductions/> > On Jul 27, 2017, at 5:06 PM, Keisuke Miyako via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > what happens if you replace tokenised constants with their literal values? > >> 2017/07/28 6:24、Jody Bevan via 4D_Tech <4d_tech@li

zipping files

I have looked through the Knowledgebase, and past nug posts. I tried PHP to do this but got no where (something obviously I am doing). I ended up (thus far) with miyako’s 4D plugin for zipping. I go into his test db and try it out and it works perfectly. So now I want to implement in our shell.

Re: User activity

Ferdinando: Yes, we always found that too where people have long ago quit out of Remote Desktop, but not 4D. Many users just do not understand the differences. All they know is that the application is no longer on their screen. We would find this when we went to do maintenance on their server

Re: C-objects and memory use

David: You could very well be right. I don’t get to see behind the curtain to have even a hint. It is the same with all aspects of a company. Jonoke became ISO 9001 certified, and we became better each year in communication with our users. Because the person at the top thought these things

Re: User activity

Ferdinand: In another ‘life’ we had several thousand users on Remote Desktop to 4D client. The problem usually was that their connection to the client server was broken (internet problems). They really liked that they could reconnect and their was their work. Therefore we didn’t worry about

Re: LOG File TO JSON - How does it name the files

the size to "1" and see for yourself: > > $path:=System folder(Desktop) > LOG FILE TO JSON($path;1) > > I got > > JournalExport.json > JournalExport2.json > ... > JournalExport10.json > > so there is not underscore. > >> 2017/07/26 7:09、

Re: C-objects and memory use

I understand the documentation issue - I just posted yesterday about a hole in the documentation. Having done a lot of documentation (still doing it), and being the person in charge of all operations I can understand that things fall between the cracks. What would be nice though is that there

Re: Bug with Open Document on macOS Sierra

David: Log files - love them too. Saved huge amounts of time to debug code (at least all the bugs I create ;-) ) In our shell I am trying to stay away from plugins - what we and others do with the shell for specific projects after that does not matter. What I have done for logs thus far in

Re: C-objects and memory use

I would like that objects created in a specific way could be accessed by worker methods. We store so many settings it is somewhat of a pain to not be able to use them like we do everywhere else. I have not tried this ‘feature’ and until it is a documented feature I likely will not try it. From

Audit Trail

We have written full audit trails with previous applications. They are not simple to ensure everything gets audited, and everything recorded, and then be able to display any record at a point in time. I like the new command LOG FILE to JSON that was added in v15R4. It seems like a great

Re: What exactly is the scope of the On err call between 4D server & Client?

On Error Call is process based. Therefore each process needs to call it. Sincerely Jody Bevan > On Jul 7, 2017, at 16:45, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I think I know the answer to this but think I'll ask anyway. > > When my server starts up in installs an error

Corrupted index and likely record - which Record(s)

I think the terrible power where I live got my data file. It has been corrupted in a way that crashes the application 100% of the time. I have gone to backups, but even old backups seem to have the same problem - strange they ran fine for months. Deleting the Index file and recreating does not

Re: Modal dialog dilemma

am expecting about the June 2018 timeline. Jody > On Jun 29, 2017, at 12:21 AM, Robert ListMail via 4D_Tech > <4d_tech@lists.4d.com> wrote: > > Wow Jody—impressive! So, when does your new shell go on sale? :) > > Robert > > Sent from my iPhone > >> O

Re: Saving open windows in Design environment feature

Jim: Yes, always nice when the gang in Paris will write a feature. They have lower level access to this than we do and usually do it nicer than we can. In the mean time with the Design Object Access commands you could write this feature in for yourself. We are using these commands more and

Re: Modal dialog dilemma

ave. My motivation didn't have anything to do > with bleed through. They came about as I was working more and more with > objects and dynamic variables. > > On Sat, Jun 17, 2017 at 2:35 PM, Jody Bevan via 4D_Tech < > 4d_tech@lists.4d.com> wrote: > >> 1. On all forms we nev

Re: Modal dialog dilemma

Pat: ‘Bleed Through’ or as I have called it the ‘Butteryfly Effect’, has always been a nasty surprise and something that takes experience (and discipline) in large systems to not bite you from time to time. I know I have been bitten too many times. Pat without knowing for certain why this is

Re: How to trap a form save keystroke in an object method ?

Peter. Get rid of the auto save action. Then you can handle what ever situations you need to. We have not used auto action buttons for 25 years. Sincerely Jody Bevan > On May 17, 2017, at 19:51, Peter Jakobsson via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi > > I rarely come across this

Re: Object visualize / browse

David: We started our new shell with v15. Now on v16.3 as we continue creating it. The very first thing we built (Ok Adam built all our object code), was our object tools. He built in dot notation into all the tools. We were used to the power of ObjectTools. Then he built our Object Viewer.

<    1   2