Thanks Rob, This story was put on my plate, where I assumed that this would be required. However what you say is true, I just put the license file on a share of a file server and it booted

What kind of license do you have? When it's just pointing to a file, it doensn't matter when you put this file. Ik can be on a local drive or a netork drive. Rob Op

Hi guys and gal's, We are in the process of switching from developing on a shared server, to developing on a local machine. For this we need to install a license server, so the Local studio can

Hello Roman I sent you an email with the database backup

You could try Blb2file(trim(file2blb('test.txt')), 'txt') Im just not sure if that works with 8.3 too because only in v9 all String fuctions can deal with Blobs too. Besides you may run in trouble

Hi Gyula, if you perform get definition in data repository (shift+f2) what default value you see in properties of the date field? Please upload print screen of the properties The question is, where

Hi Wolfgang , Can you share table with one file ,i will check if problem exists in my database?

Yeah, sorry. That doesn't work. I looked at some of my old 8.3 code where I had create each line of an EDI file ending with ~ but no CRLF and I ended up with something like Create

Leave your I/O file line as None, leave your data only on the first form, create a 2nd form, 2 wide, put ascii(13)&ascii(10). Output the the second form in the record prefix with the condition NOT

If the output file is not too large, you can load it into a blob and thenremove the last 2 characters and then recreate the file. update B = file2blb('c:\file.txt') where B is a blob

Format = None output trim(data)&chr(13)&chr(10) This result : Format = None output trim(data)&chr(13)&chr(10) De: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] En

The EOF function that I mentioned is to know the last line on a conversion of files process... from a IO entry to read to IO entry to write, this with Format=None.

Perhaps you can clarify why this is needed. I don't think there's actually an extra line created, the final text line just ends with chr(13)&chr(10) You can tell for sure

Set the IO properties to Format =None. End each line except the last with chr(13)&chr(10). That is, output trim(data)&chr(13)&chr(10) Alternatively, if you don't know

8.30 De: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] En nombre de Steven Blank Enviado el: Martes, 21 de Julio de 2020 03:31 p.m. Para: main@magicu-l.groups.io Asunto: Re: [magicu-l]

What version?

The cursor is positioned on the next line and I want it to be positioned on the last line at the end Regards Andres De: main@magicu-l.groups.io [mailto:main@magicu-l.groups.io] En nombre de

You can try changing the Format on IO properties to None, this stop the native line ending control from Magic. Use the EOF function to check for the end of file reached... and for every line output

How to remove the blank line that is generated when reaching the end of a text output file Regards Andres

Hi Group, I have just faced the following problem with MSSQL database: I have 2 DATETIME fields in MSSQL with database default value: 1901-01-01 00:00:00. There is a date and a time field