Miyako's XLS II
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 Registered in Scotland : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com 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 Tools v2003, Mac
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 Publishing > tel: +44 (0) 207 118 7889 > w: http://www.catbase.com > skype: pat.bensky > * > ** > 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 > ** -- 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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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 **
Naming a web process
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 : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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 2002r8
Thanks very much Janie. It tuns out that my client rebuild their system, but failed to turn off DEP, so their 4D copy was actually OK. 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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. > On 16 Nov 2019, at 13:11, Janie Marlow wrote: > > Good morning, Uist - > > If you still need it, you can download a copy of 4D 2003 installer here (both > 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/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 in Scotland : SC107838 >> >> An ISO 9001 registered company. >> >> This message including any attachments, is intended and authorized for >> the addressee only, and may contain privileged and/or confidential >> information. If you are not the authorized addressee, you are not >> authorized to either review or disseminate this message. Accordingly, >> if you are not the intended and authorized recipient, please disregard >> this message and notify the sender. If you are the authorized >> addressee, you may use this for the purpose for which it was intended; a >> direct, personal communication to you and your legal agents. You may >> not distribute it to or publish it in any public forum without prior, >> specific, written permission from the sender. >> >> ** >> 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 >> ** > ** 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 2002r8
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 in Scotland : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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 **
4D 2002r8
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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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: 4Dv17 as a Windows Service
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 828002 Registered in Scotland : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. > On 16 Oct 2019, at 06:24, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Hi All, > > I have a 4Dv17 application that the client’s IT decided has to run on Windows > Service (under Windows Server 2012r2). > That is fine till a new requirement surfaced. > > They wanted the 4D data files to be stored on separate repository, away from > the 4D Server application and the 4D structure files, ie. the .4DD, .4DR and > the log file will be stored on a drive (with a different IP address) away > from the .4DB and .RSR files and the 4D Server application. > > This works fine when the 4Dv17 Server is run directly as an application. > However the service fails because apparently the service is unable to locate > the data files on the separate server when the service starts. > The service will start and quit. Windows Event Log indicated an error to the > effect that the database cannot be opened. > > Is there any solution for this? > > Regards, > Ronnie > > ** > 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 > ** ** 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 **
Developer needed
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, initially for three months subject to probationary period. This work can be carried out mostly offsite, and is not security restricted. The requirements are 4D V17.x, MSSQL Server 2017 jQuery Datatables/ Editor CanvasJS If you are interested please PM me with your CV and rates. I will be at the 4D World Tour in London today and tomorrow if you would like to chat about this. Best regards Uist Macdonald -- 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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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: Can'r run as a service on Windows 2016
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 Registered in Scotland : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. > On 27 Feb 2019, at 10:40, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> wrote: > > I'm having a bit of trouble trying to set up our 4D app to run as a service > on a Windows server. > > The server version is Windows Server 2016 Standard. > If I run the app "As Administrator" it starts up OK and we can connect to > it. > > If I don't start it as Administrator, I get a message that the database (or > one of its segments) is locked. > If I try to set it up to run as a service, it doesn't work - in the > Services window, it says it's running, but in the Task Manager it says > Stopped. I'm guessing this is because when it tries to start the service, > it can't because of the locked data file problem. > > So, I think the question is: How come it has to run As Administrator? I am > logged on (remotely via MS Remote Desktop) with, supposedly, full admin > privileges. How do I run it as not-administrator? > > Thanks! > Pat > > -- > * > CatBase - Top Dog in Data Publishing > tel: +44 (0) 207 118 7889 > w: http://www.catbase.com > skype: pat.bensky > * > ** > 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 > ** ** 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 **
4D Server V17.0 and Windows Server 2016
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 Faulting process id: 0x1b68 Faulting application start time: 0x01d4b0aabb050995 Faulting application path: C:\Program Files\4D\4D v17.0\4D Server\4D Server.exe Faulting module path: C:\Program Files\4D\4D v17.0\4D Server\Kernel.dll Report Id: 86c6ea1c-540a-4238-a7e6-7af9736c755e Where do you start to solve this? The app works fine on other instances of Windows Server 2016. Regards 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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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 **
Odd thing with iso dates
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
Fife KY15 5QJ
+44 (0) 1334 828002
Registered in Scotland : SC107838
An ISO 9001 registered company.
This message including any attachments, is intended and authorized for
the addressee only, and may contain privileged and/or confidential
information. If you are not the authorized addressee, you are not
authorized to either review or disseminate this message. Accordingly,
if you are not the intended and authorized recipient, please disregard
this message and notify the sender. If you are the authorized
addressee, you may use this for the purpose for which it was intended; a
direct, personal communication to you and your legal agents. You may
not distribute it to or publish it in any public forum without prior,
specific, written permission from the sender.
**
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
**
$D V17 as a service
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 local network. I have tried running as Administrator. Is there some Voodoo that I am missing? 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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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 Server V17.0 crashing on database open
Hi Jeffery We tried that and also logged in as an admin user. The second time you try to start it it quite often will start, but that doesn’t look good :( 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 attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. > On 28 Jan 2019, at 14:24, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Have you tried rebooting the server? Once in awhile our 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_Tech >> <4d_tech@lists.4d.com> wrote: >> >> 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. > > ** > 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 > ** ** 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 **
4D Server V17.0 crashing on database open
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 Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002 Registered in Scotland : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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: Proper decoding for document returned via SOAP call?
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 binary (for a PDF file) - I'm not able to figure out how to save it as a proper PDF document that Acrobat understands. ** 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: Bug with V17?
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 compatibility preference? Neil Privacy Disclaimer: This message contains confidential information and is intended only for the named addressee. If you are not the named addressee you should not disseminate, distribute or copy this email. Please delete this email from your system and notify the sender immediately by replying to this email. If you are not the intended recipient you are notified that disclosing, copying, distributing or taking any action in reliance on the contents of this information is strictly prohibited. The Alternative Investments division of UMB Fund Services provides a full range of services to hedge funds, funds of funds and private equity funds. Any tax advice in this communication is not intended to be used, and cannot be used, by a client or any other person or entity for the purpose of (a) avoiding penalties that may be imposed on any taxpayer or (b) promoting, marketing, or recommending to another party any matter addressed herein. ** 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 ** --- This email has been checked for viruses by AVG. https://www.avg.com -- ** 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 **
Bug with V17?
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
--
**
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: Change in String function between V13 and V16R6
Forget that last one. There was a rounding error, but not here. The problem was actually here: tProduct:=String(InvProduct;"&3") In V13.5 I get 2.10e+2 when InvProduct is 210.5497748441 In V16R6 I get 2.11e+002. So this has been fixed somewhere along the line. Sorry for wasting 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:=""+String(InvProduct;"###,###,###,###,##0") In V13.5 this code gave : 211 In V16R6 you get 210. So is String not rounding any more? Has anybody else noticed this? Uist Macdonald -- Ceres Computer Consultants Ltd ** 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 **
Change in String function between V13 and V16R6
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. So is String not rounding any more? Has anybody else noticed this? Uist Macdonald -- Ceres Computer Consultants Ltd ** 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 v16 Server and Windows Server 2016
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 stops your application beside other problems, e.g. admins not aware that they must not close the server gui. And so on. Even 4D server performs better as a service, at least is this our experience. -- ** 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 v16 Server and Windows Server 2016
Hi Jeff I agree in normal circumstances the OPEN ADMINISTRATION WINDOW view is fine. It is in the case where something unexpected has gone wrong, although you might think you have covered every error scenario with an ON ERROR proc. With V16 if you don't use Interactive Services Detection then your 4D procedure running on the server will just abort quietly as soon as it tries to put up a dialog, or have I read the docs incorrectly. If 4D Server would at least write the dialog message to the system event log then you would get a clue what was wrong. Uist Macdonald On 25/07/2018 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> wrote: 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 hoping pester power will change their minds. An alternative option is VNC in its various flavours, but is frowned upon by system admins. I am leaning towards using a user to run the 4D servers and lock the session between RDC sessions. ** 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 ** --- This email has been checked for viruses by AVG. https://www.avg.com -- ** 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 v16 Server and Windows Server 2016
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 hoping pester power will change their minds. An alternative option is VNC in its various flavours, but is frowned upon by system admins. I am leaning towards using a user to run the 4D servers and lock the session between RDC sessions. Regards Uist -- > On 24 Jul 2018, at 21:46, Jim Hays via 4D_Tech <4d_tech@lists.4d.com> wrote: > > Haven't tried this on Windows 2016 server, only 2012. From a Microsoft > tech note: > > Windows Server 2012 no longer allows interactive services, by default, > which makes the Interactive Services Detection service unnecessary. > > If you must run a legacy application that installs an interactive > service on Windows Server 2012, you may sacrifice server stability for > compatibility by changing the following registry value from the > default of "1" to "0". > > HKLM\SYSTEM\CurrentControlSet\Control\Windows > NoInteractiveServices > > After doing so and rebooting, the Interactive Services Detection > Service will start. > > > > Jim > > ** 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 v16 Server and Windows Server 2016
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 > via VNC. > > -Tim > > > Timothy Penner > Senior Technical Services Engineer > > 4D Inc > 95 S. Market Street, Suite #240 > CA 95113 San Jose > United States > > Téléphone : +1-408-557-4600 > Standard : +1-408-557-4600 > Fax : +1-408-271-5080 > Email : tpen...@4d.com > Web : www.4D.com > > > > > > ** 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 **
4D v16 Server and Windows Server 2016
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 apparently does not work with Remote Desktop Connection ( no mouse,keyboard events passed). This will be a VM and RDC is the only thing on offer to talk to it. If you have Interact with the desktop turned off then you have no clue if and when 4D Server barfs with an error. What do you wise folk do? Regards Uist Macdonald -- ** 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 **
4D View to 4D View Pro upgrade path
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 Scotstarvit Chance Inn Cupar Fife KY15 5QJ +44 (0) 1334 828002 Registered in Scotland : SC107838 An ISO 9001 registered company. This message including any attachments, is intended and authorized for the addressee only, and may contain privileged and/or confidential information. If you are not the authorized addressee, you are not authorized to either review or disseminate this message. Accordingly, if you are not the intended and authorized recipient, please disregard this message and notify the sender. If you are the authorized addressee, you may use this for the purpose for which it was intended; a direct, personal communication to you and your legal agents. You may not distribute it to or publish it in any public forum without prior, specific, written permission from the sender. ** 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 **
4D View upgrade path
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 ** 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: SQL Interface to MS SQL
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) 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 **
SQL Interface to MS SQL
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 fix, or should I worry that 4D might decide it doesn’t like it at some point. Regards Uist -- ** 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 **
