4D View to 4D View Pro upgrade path

2018-06-27 Thread Uist Macdonald via 4D_Tech
I see that 4D View is not supported on V16 64 bit client. I use many programmatically created dynamic V13 4D View Areas. Is there an upgrade path from 4D View to 4D View Pro? I never use saved 4D View docs. Uist Macdonald -- Ceres Computer Consultants Ltd Registered Office: South

4D View upgrade path

2018-06-27 Thread Uist Macdonald via 4D_Tech
I see that 4D View is not supported on V16 64 bit client. I use many programmatically created dynamic 4D View Areas. Is there an upgrade path from 4D View to 4D View Pro? I never use saved 4D View docs. Uist Macdonald -- Ceres Computer Consultants Ltd

Re: SQL Interface to MS SQL

2018-05-03 Thread Uist Macdonald via 4D_Tech
Thanks Jeff Uist On 03/05/2018 15:06, Jeffrey Kain via 4D_Tech wrote: Just ignore it - I've seen this happen before even on perfectly valid SQL statements pointed to 4D's own engine. ** 4D Internet Users Group (4D iNUG)

SQL Interface to MS SQL

2018-05-03 Thread Uist Macdonald via 4D_Tech
Hi I am developing a V16.6 app which uses MSSQL as the backend database. I have a slight problem in that I am storing Unicode in NVARCHAR fields which 4D indicates is a syntax error next to the line, although it actually works fine in practice. The app compiles OK. Is this something I can

Re: 4D v16 Server and Windows Server 2016

2018-07-25 Thread Uist Macdonald via 4D_Tech
00:31, Jeffrey Kain via 4D_Tech wrote: What do you need to do on the server itself compared to what's available in the OPEN ADMINISTRATION WINDOW view from the client? -- Jeffrey Kain jeffrey.k...@gmail.com On Jul 24, 2018, at 5:29 PM, Uist Macdonald via 4D_Tech <4d_tech@lists.4d.com>

Re: 4D v16 Server and Windows Server 2016

2018-07-25 Thread Uist Macdonald via 4D_Tech
Good point. On 25/07/2018 08:19, Epperlein, Lutz (agendo) via 4D_Tech wrote: I am leaning towards using a user to run the 4D servers and lock the session between RDC sessions. We have done this in the past. But we will never do it again. It's calling for trouble. Every nightly Windows update

Re: Change in String function between V13 and V16R6

2018-08-24 Thread Uist Macdonald via 4D_Tech
ting bandwidth Uist On 24/08/2018 12:03, Uist Macdonald via 4D_Tech wrote: Hi All I have been updating a database from V13 to V16R6, and an eagle eyed user spotted an apparent rounding error when converting a real to text. When InvProduct is 210.5497748441 pInvProduct:="

Change in String function between V13 and V16R6

2018-08-24 Thread Uist Macdonald via 4D_Tech
Hi All I have been updating a database from V13 to V16R6, and an eagle eyed user spotted an apparent rounding error when converting a real to text. When InvProduct is 210.5497748441 pInvProduct:=""+String(InvProduct;"###,###,###,###,##0") In V13.5 this code gave : 211 In V16R6 you get 210.

4D v16 Server and Windows Server 2016

2018-07-20 Thread Uist Macdonald via 4D_Tech
I am upgrading a database to V16 and this is going to be run on Windows Server 2016 as a service. This has worked reasonably well with earlier windows servers. I have looked at the various tech notes on the subject showing how to re-enable the interactive services detection service, but this

Re: 4D v16 Server and Windows Server 2016

2018-07-20 Thread Uist Macdonald via 4D_Tech
Thanks Tim, but access is tightly controlled - only RDC is an acceptable method. -- > On 20 Jul 2018, at 20:02, Timothy Penner wrote: > > VNC doesn't have the same limitation: > http://kb.4d.com/assetid=77932 > > VNC can be installed via RDC, then connection to the machine could be done >

Re: 4D v16 Server and Windows Server 2016

2018-07-24 Thread Uist Macdonald via 4D_Tech
Hi Jim The gotcha with Server2016 is that although you can enable Interactive Services Detection, session 0 does not accept keyboard and mouse events. Microsoft argues this is not a bug, but a defence against hacking, however so many people use RDC for remote server management that they are

Bug with V17?

2018-11-13 Thread Uist Macdonald via 4D_Tech
I have this code which works on V16R6 but not on V17. C_COLLECTION(c) c:=New collection C_OBJECT(obj) obj:=New object("name";"jim") c.push(obj) On V17 it gives an error ":=" expected. The 'push' is not syntactically highlighted like V16R6. Any thoughts? Uist --

Re: Bug with V17?

2018-11-13 Thread Uist Macdonald via 4D_Tech
That was it. I pulled in object code from V16 and forgot about this. Many thanks Uist On 13/11/2018 17:01, Dennis, Neil via 4D_Tech wrote: c.push(obj) On V17 it gives an error ":=" expected. The 'push' is not syntactically highlighted like V16R6. Did you turn on dot notation in the

Re: Proper decoding for document returned via SOAP call?

2018-12-12 Thread Uist Macdonald via 4D_Tech
Hi Bob You will need to use BASE64 DECODE on your returned $Value, and then save it as a doc. http://doc.4d.com/4Dv16/4D/16.4/BASE64-DECODE.301-3979394.en.html Regards Uist On 12/12/2018 03:07, Bob Miller via 4D_Tech wrote: Hi Everyone, I'm confounded by a SOAP service that returns a

4D Server V17.0 crashing on database open

2019-01-28 Thread Uist Macdonald via 4D_Tech
Hi I am having a problem with 4D Server 17.0 on Windows Server 2016. When I open any database, even an empty one, it crashed. Anybody else had this? Of course it happens only on the client machine. My dev server is fine. Uist -- Ceres Computer Consultants Ltd Registered Office: South

Re: 4D Server V17.0 crashing on database open

2019-01-28 Thread Uist Macdonald via 4D_Tech
ur server will get into > a pattern like this and the only solution is a reboot. I believe, but haven't > proven yet, that it has something to do with 4D Server not closing all of its > ports correctly when you shut down. > >> On Jan 28, 2019, at 9:06 AM, Uist Macdonald via 4D_T

Re: Can'r run as a service on Windows 2016

2019-02-27 Thread Uist Macdonald via 4D_Tech
I wish 4D could produce an idiot’s guide to setting up 4D Server on Windows Server 2016 Standard as a service, especially as a web server. I am going in circles. Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002

Odd thing with iso dates

2019-02-08 Thread Uist Macdonald via 4D_Tech
I do not understand what is happening here in V17.0: String(Date("14/8/2017");ISO date GMT) //UK date format gives 2017-08-13T23:00:00Z i.e. the day before! My regional setting are correct. Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar

4D Server V17.0 and Windows Server 2016

2019-02-18 Thread Uist Macdonald via 4D_Tech
Hi Has anyone has this error. Access violation. Null pointer. Faulting application name: 4D Server.exe, version: 17.0.0.0, time stamp: 0x5b3d8672 Faulting module name: Kernel.dll, version: 0.0.0.0, time stamp: 0x5b3d7b2f Exception code: 0xc005 Fault offset: 0xc470

$D V17 as a service

2019-01-28 Thread Uist Macdonald via 4D_Tech
Hi When I run 4d Server V17.0 as an app under Windows Server 2016, I can connect to it OK. However if I run it as a service, I cannot connect. I am wondering if it has something to do with an SSL certificate, which I normally get a warning for in the browser, as I am connecting from the

Developer needed

2019-05-13 Thread Uist Macdonald via 4D_Tech
Hi I am part of a consortium which is installing and running three biometric laboratories, part of which is a laboratory information management system. This is in a fairly advanced state, however I need another pair of hands and a brain to complete it. This would be a contract position,

Re: 4D 2002r8

2019-11-11 Thread Uist Macdonald via 4D_Tech
forgot to say - Windows On 11/11/2019 13:40, Uist Macdonald via 4D_Tech wrote: Does anyone have a copy of 4D2003r8 installer? Or a link? Thanks Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002 Registered

4D 2002r8

2019-11-11 Thread Uist Macdonald via 4D_Tech
Does anyone have a copy of 4D2003r8 installer? Or a link? Thanks Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002 Registered in Scotland : SC107838 An ISO 9001 registered company. This message including any

Re: 4D 2002r8

2019-11-16 Thread Uist Macdonald via 4D_Tech
t; Windows and Mac). > > https://spaces.hightail.com/receive/l9cpuks2Gm > > Janie > > >> On November 11, 2019 at 8:40 AM Uist Macdonald via 4D_Tech >> <4d_tech@lists.4d.com> wrote: >> >> >> forgot to say - Windows >> >>> On 11/1

Naming a web process

2019-12-08 Thread Uist Macdonald via 4D_Tech
Is it possible to name a web session so that the name is visible in 4D Server Processes tab? I know, Why would you want to do that? Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002 Registered in Scotland :

Re: 4Dv17 as a Windows Service

2019-10-16 Thread Uist Macdonald via 4D_Tech
The user that the service is running under must have network access privileges. It is unlikely the default will have these privileges, so cannot see your data files. Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334

Re: 4D Tools v2003, Mac

2020-01-29 Thread Uist Macdonald via 4D_Tech
Tried sending you a copy but it bounced. Send me another email. Regards Uist Macdonald > On 29 Jan 2020, at 15:18, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Anybody got a copy? > > Pat > > -- > * > CatBase - Top Dog in Data

Miyako's XLS II

2021-04-06 Thread Uist Macdonald via 4D_Tech
Hi I have posted this the the forum but just in case... Does anyone know how to create a XL workbook with 'XLS Create'? I can open and read existing files. Uist -- Ceres Computer Consultants Ltd Registered Office: South Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002