Re: Adding fields to tables using SQL

2017-03-02 Thread Keisuke Miyako via 4D_Tech
IMPORT STRUCTURE is powerful, but I don't think it can modify existing tables... http://doc.4d.com/4Dv16/4D/16/IMPORT-STRUCTURE.301-3036688.en.html maybe the plugin entry-point is more forgiving (haven't tried) https://github.com/miyako/4d-plugin-structure-access > 2017/03/03 5:56、bob.miller---

Re: auto update of clients

2017-03-02 Thread Spencer Hinsdale via 4D_Tech
19191 is the new-protocol error. old clients can only update themselves if you use the old network layer option in compatibilty ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive:

Re: Adding fields to tables using SQL

2017-03-02 Thread Charles Miller via 4D_Tech
On Thu, Mar 2, 2017 at 3:56 PM, bob.miller--- via 4D_Tech < 4d_tech@lists.4d.com> wrote: > I've tried this with SQL: > > ALTER TABLE GlobalPricebook ADD TRAILING PB_LTPrefix01 VARCHAR (20) NOT > NULL > Base upon v15 docs I do not see the ability to add NOT NULL or NULL to command. I assume you

Adding fields to tables using SQL

2017-03-02 Thread bob.miller--- via 4D_Tech
Hello, I'm tired of the structure editor and how it requires you to add fields one at a time and how the field palette disappears each time 4D loses focus. I created my own little "Field Adder"utility where I can specify a table, then drop a list of field names and data types from two rows

auto update of clients

2017-03-02 Thread Charles Miller via 4D_Tech
Hi All, we are moving from v11 directly to v15.4. I have built client server merged application and set too allow auto client updates. When I try to upgrade v11 built client, I get the following error on both mac and windows: Error code: -10509 Can't open database "MHD BMS-source-prod".

RE: Way to get chosen ID field name?

2017-03-02 Thread Tai Bui via 4D_Tech
Hi, Sorry I spoke too soon, I thought you wanted to find the primary key fields name for a table, but you wanted the Name set in the preferences. I am not sure why you need this, but it is stored at the end of the following file: ...\4D\Resources\default.4DPreferences It is an xml formatted

RE: Way to get chosen ID field name?

2017-03-02 Thread Tai Bui via 4D_Tech
Hi, I believe the following Tech Tip can help: http://kb.4d.com/assetid=77571 Best Regards, -Tai B. ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html

Way to get chosen ID field name?

2017-03-02 Thread Doug Hall via 4D_Tech
In the structure preference panel, there's a "Primary Key" subpanel which allows the designer to choose a default name and type (Longint/UUID) for their database. Is there a way to programmatically collect that name? Thanks! **

Re: v12 - Query problem

2017-03-02 Thread Chip Scheide via 4D_Tech
HOLY #%^(

Re: How to get array index with hierarchical listbox when using on mouse move

2017-03-02 Thread Arnaud de Montard via 4D_Tech
> Le 27 févr. 2017 à 15:27, Piotr Chabot Stadhouders via 4D_Tech > <4d_tech@lists.4d.com> a écrit : > > Hi, > > I want to use a hierarchical listbox with arrays > When I am in the on mouse move event of the listbox, how can I determine > which element this is? > I have found a tech tip where