RE: SQL - renaming a field

Good point - I already simply forgot about trying to rename. In concept it would not be an issue as I was only going to rename a field named 'Unused' But there were other considerations to renaming that occurred to me after I posted. in sql - if rename works, I do not see a way to redefine the

Re: SQL - renaming a field

Yup. Actually, many flavours of SQL support table renaming or table duplication with additional keywords on ALTER TABLE since, at least in SQL92 AFAIK it wasn't supported as part of the DDL. For example, the last time I used MySQL with the Sequel Pro GUI tool, It has a table duplication menu o

RE: SQL - renaming a field

Chip, That kind of sucks because doesn't a "drop" destroy data? Steve -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Chip Scheide via 4D_Tech Sent: Friday, July 26, 2019 1:46 PM To: Tom Benedict Cc: Chip Scheide <4d_o...@pghrepository.org>; 4D iNug Technic

Re: SQL - renaming a field

OK Thanks both I guess rename is only possible as Drop + Add Chip On Fri, 26 Jul 2019 11:42:49 -0700, Tom Benedict wrote: > Maybe 4D’s SQL implementation doesn’t support the RENAME keyword? > > I don’t see it in the docs.. > https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html >

Re: SQL - renaming a field

Chip, My initial observations are: * I think [ ] around the table name are not required (that's not part of the SQL standard) * it would seem that 4D's implementation of Alter table doesn't support "rename" Regards, Narinder Chandi, ToolBox Systems Ltd. -- -Original Message- From: 4

Re: SQL - renaming a field

Maybe 4D’s SQL implementation doesn’t support the RENAME keyword? I don’t see it in the docs.. https://doc.4d.com/4Dv16/4D/16/ALTER-TABLE.300-3201314.en.html Tom Benedict > On Jul 26, 2019, at 11:30, Chip Scheide via 4D_Tech <4d_

SQL - renaming a field

I'm trying to use SQL to rename an existing field $Sql:="Alter table ["+$Table_Name+"] Rename "+"Unused"+" to "+$Field_Name+";" When executed I get a parsing error at 'Rename'. can someone better versed either correct my above syntax, or point out a way to rename an existing field using SQL, --

Re: Find in Design and Replace

Thanks Arnaud! On Fri, 26 Jul 2019 15:42:37 +0200, Arnaud de Montard via 4D_Tech wrote: > > >> Le 26 juil. 2019 à 03:34, Chip Scheide via 4D_Tech >> <4d_tech@lists.4d.com> a écrit : >> >> keisuke, >> Thanks. >> I thought of that, but... >> >> Basically I am modifying 50 or so method calls, an

Re: Find in Design and Replace

> Le 26 juil. 2019 à 03:34, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > keisuke, > Thanks. > I thought of that, but... > > Basically I am modifying 50 or so method calls, and the modification adds > 'Count parameters' as a parameter, this make the method calls aestheticall

Re: list box and form open and close detail events

That’s what I’m doing but was curious as to why. Shouldn’t it fire especially when you set edit in the list box Regards Chuck On Thu, Jul 25, 2019 at 8:56 PM Keisuke Miyako via 4D_Tech < 4d_tech@lists.4d.com> wrote: > open/close detail form events are only applicable when a table list form > is u