|
Creating a file with Print Data PA3.3
Graham White
Hi,
Is there anyway to use the Print Data event to create a file with out Excel loading? I want to create the file only and not have Excel start and display the file.
Regards
Graham White
IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments. If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: www.eccreditcontrol.co.nz – www.eccreditcontrol.com - www.eccreditcontrol.com.au for more information about use, disclosure and access). EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of any affected message or attachments.
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: How to insert Macron eg Ā letter with line above in a field. XPA 3.3
Graham White
Thanks Steve for your answer. I will have a play around and see how I get on. We have just been asked by one of our bigger clients if we can handle these fields but no timeframe until we are expected to. We will intially get these from an xml file supplied by the client and if we need to maintain them in our system we will need to install the Maori keyboard on the users who will be editing the relative forms.
Regards Graham White
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: searching for a file save-dd-mm-yyy*.*
Hi guys,
thanks for your hints... I wanted to avoid making a dir > dirlist, and after searching in that list... But, as I'm idiotic, i wanted just to make one save per day... so why add the time to the save filename ??? So i just changed the name to save-yyyy-mm-dd.7z and then ioexist worked fine.. Getting older, you don't always get smarter... Anyway, thanks for your help :):) Jacques
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: How to insert Macron eg Ā letter with line above in a field. XPA 3.3
Graham,
toggle quoted messageShow quoted text
Pervasive has supported Unicode data for quite a while now – in the PVSW world, this datatype is known as WString. I just did some poking around in Magic xpa v3.3g and find that the Magic Btrieve (ISAM) gateway in v3.3g provides apparently-full support for Unicode columns as well as for indexes on those columns, so you should be good to go. Columns in which you want to store Unicode data should be defined in the Data Sources Repository as Attribute:Unicode, Stored As: WString. As I mentioned, Unicode columns may also be included in indexes. FYI, internally, Unicode characters consist of two bytes each, so a ten-character Unicode column will consume 20 bytes in the fixed-length portion of the record. I don't know how Pervasive collates WString index segments, so you may yet still need to implement an Alternate Collating Sequence in order to fully implement Maori as you desire. The other unknown – applicable to ANY backend database – is how to actually TYPE these characters in a Unicode Edit Control, a problem here left as an exercise for the student. ;) HTH. Steven G. Blank SGBlank Consulting
On 8/8/2021 2:39 PM, Graham White
wrote:
Hi Steve,
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: Magic XPA 4.7 ERR THREAD ABORTED
#xpa
GD
Hi,
It seems we had resolve by update to XPA 4.7.2 and add this flag : SQL_OLEDB='Y' in databases properties. It's been a week and we don't have this problem anymore. Hope this helps.
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: searching for a file save-dd-mm-yyy*.*
Todd Baremore
Jacques,
toggle quoted messageShow quoted text
Try this: Invoke OS ( I forget what to use in 8.3) dir c:\Save-2021-08-05*.7z > c:\filelist.txt File2blb('c:\filelist.txt') instr (Blob,'Save-2021-08-05')>0 Todd On 8/5/2021 8:46 AM, Jacques wrote:
Hello,
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: searching for a file save-dd-mm-yyy*.*
In the current versions you can use
 But i don't know since wich version (but i think it is not in v8) Did you try the DIR Functions form get.dll? dir_init/dir_read? Best regards Friedrich
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: How to insert Macron eg Ā letter with line above in a field. XPA 3.3
Graham White
Hi Steve,
Thanks for your reply. When I do a test in a ascii convertor for ā to ascii I get a 196 129. If I do ASCIIVal('ā') in Magic I get 97 which is a (no macron). I guess this means it is not ANSI but Unicode, correct? Does this mean the only way I can store it in Magic is in a Blob? These characters are from the New Zealand Maori alphabet. Regards Graham
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: How to insert Macron eg Ā letter with line above in a field. XPA 3.3
Graham,
toggle quoted messageShow quoted text
There are two separate aspects to your topic: (1) are you talking about one-byte (ANSI) or two-byte (Unicode) characters, and (2) are you talking about ISAM Pervasive or ODBC Pervasive? Assuming you're talking about one-byte characters, any old Alpha field is able to store, retrieve, display, etc such extended characters. Regarding sort sequence, by default, Pervasive collates characters in STRING indexes by ASCII value. Thus, if your special character has an ASCII value of, say, 217, Pervasive will collate this character AFTER the special character whose ASCII value is 216, but BEFORE that special character whose ASCII value is 218. However, if you implement a custom Alternate Collating Sequence, then Pervasive (and Magic, too, for that matter) will collate such special characters according to that ACS instead. In other words, by implementing a proper ACS, Pervasive could collate these special characters equally with their non-augmented counterparts, if that's what you're after. For example, Pervasive could be tricked into collating all of the following characters equally: A, À, Á, Â, Ã, Ä, Å Sans a custom ACS, the above characters would be collated simply by their ASCII values, which would separate "A" from the rest of the list by a great number of characters. HTH. Steven G. Blank SGBlank Consulting
On 8/5/2021 6:14 PM, Graham White
wrote:
|
||||||||||||||||
|
|
||||||||||||||||
|
How to insert Macron eg Ā letter with line above in a field. XPA 3.3
Graham White
Hi all,
Is there a way to have a field in which characters with a macron (line above letter) in it? If there is will PSQL handle it ok? How would it sort them?
Regards
Graham White
IMPORTANT NOTICE: This e-mail message and any attachments are confidential to EC Credit Control and subject to legal privilege (which is not waived or lost by mistaken delivery). If you have received this e-mail in error, please advise the sender immediately and destroy the message and any attachments. If you are not the intended recipient you are notified that any use, distribution, amendment, copying or any action taken or omitted to be taken in reliance of this message or attachments is prohibited. EC Credit Control collects personal information to provide and market our services (see our privacy policy at: www.eccreditcontrol.co.nz – www.eccreditcontrol.com - www.eccreditcontrol.com.au for more information about use, disclosure and access). EC Credit Control’s liability in connection with transmitting, unauthorised access to, or viruses in this message and its attachments is limited to resupply of any affected message or attachments.
|
||||||||||||||||
|
|
||||||||||||||||
|
searching for a file save-dd-mm-yyy*.*
Hello,
quite trivial, but no way to get it... but with an old version, still 8.30 I create a save when starting an application the first time of the day in the form of Save-2021-08-05_hh-mm-ss.7z if restarting it later, i will avoid making a new save i try to get an answer to IOEXIST (Save-2021-08-05*.7z) No way to get a valid answer... Any hint, avoiding to make a dir ??? Getting older, Alzheimer may be at work... Jacques
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: Font sizes
John Dowbiggin
Hi Sherm
toggle quoted messageShow quoted text
These names match my font table but increasing them doesn't make any difference unfortunately. Anybody go other suggestions? John
-----Original Message-----
From: main@magicu-l.groups.io <main@magicu-l.groups.io> On Behalf Of sherman levine Sent: 04 August 2021 12:58 To: main@magicu-l.groups.io Subject: Re: [magicu-l] Font sizes John, This is what I increased in 9.4 and it seemed to cover most of the bases I'm sure the numbers are different but perhaps the names have persisted Sherm 3 Default Dialog Edit Fields 23 Table Fields 30 Toolkit Window Font 31 Small Font 37 Variable Pallet Arial Narrow On 8/4/2021 4:29 AM, John Dowbiggin wrote: Hi
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: [EXTERNAL][magicu-l] UP1.9 Cannot display Font or Color Settings
Jim Stephenson
Thanks Todd, that worked.
On Tue, Aug 3, 2021 at 5:19 PM Todd Baremore <tbaremor@...> wrote:
|
||||||||||||||||
|
|
||||||||||||||||
|
csv to xlsx utility
Todd Baremore
You may find this useful. Does not require Excel.
https://github.com/nmolinos/csv2excel/tree/master/csv2excel/bin/Release Todd
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: Font sizes
sherman levine
John,
toggle quoted messageShow quoted text
This is what I increased in 9.4 and it seemed to cover most of the bases I'm sure the numbers are different but perhaps the names have persisted Sherm 3 Default Dialog Edit Fields 23 Table Fields 30 Toolkit Window Font 31 Small Font 37 Variable Pallet Arial Narrow
On 8/4/2021 4:29 AM, John Dowbiggin wrote:
Hi
|
||||||||||||||||
|
|
||||||||||||||||
|
samenwerking
Hello Magicians, The following information/questions are intended for Dutch speaking persons. It's meaning is to initiate a company for developing en selling special software in the Netherlands and (maybe) Belgium. Als een al op leeftijd zijnde (74) Magic-ontwikkelaar heb ik in de afgelopen jaren een pakket ontwikkeld voor planning en facturering van hijskranen. Oorspronkelijk ontwikkeld in 5.7, daarna overgezet naar 8.3 en nu in uniPaaS. Vele malen pakket kunnen verkopen o.a. aan van Seumeren Holland, Mammoet, van de Weghe, Sarens, maar door het zzp-er zijnde (risico-vol voor grote bedrijven) zijn alle klanten op één na overgestapt naar andere software terwijl ze vol lof waren over de software zelf. Deze overgebleven klant vindt dit zo'n ontzettend mooi pakket dat hij de aanzet gegeven heeft de 8.3 versie te moderniseren hetgeen resulteerde in de uniPaaS versie. Hier dient nog wel het een en ander aan digitalisering te worden toegevoegd/gewijzigd. Daarnaast had hij het verzoek ook de planning en facturering van zijn hoogwerkers in het pakket op te nemen. Daar is intussen door mij het een en ander voor ontwikkeld. Mijn bedoeling is om de software onder te brengen in een coöperatieve vereniging waarin meerdere ontwikkelaars aan deelnemen zodat het risico van ondersteuning gespreid wordt om zodoende het één-persoon-risico voor de gebruikers te voorkomen en mij dan uit de deelneming terug te trekken Er is reeds één andere Nederlandse Magic-ontwikkelaar die interesse heeft getoond. Mijn vraag dus of er meerdere Magic-ontwikkelaars zijn die hieraan zouden willen deelnemen. Hierbij is het belangrijk om te weten dat je bij een coöperatieve vereniging geen risico loopt en dat je je zelfstandigheid niet kwijt bent. Ik wacht eventuele reacties af. Je kunt mij mailen op undix76@.... Groet, Teun van Unen - UNDIX InformatieSystemen - Putten (NL)
|
||||||||||||||||
|
|
||||||||||||||||
|
Font sizes
John Dowbiggin
Hi
Up1.9. I need to increase the font sizes in tool kit as I have cataracts and my screen eyesight is terrible. Anyone know which font numbers I have to changes
|
||||||||||||||||
|
|
||||||||||||||||
|
Change specific character in runtime (Slash)
Gábor Bor
Dear Magicians,
We would like to change slash (/) character to backslash (\) dynamically when we debugging on windows. (We store paths and use it different ways) Could we redefine slash separator when the code is running? Do you have any idea to solve this question? Best regards, Gábor
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: [EXTERNAL][magicu-l] UP1.9 Cannot display Font or Color Settings
Todd Baremore
Jim,
toggle quoted messageShow quoted text
Try deleting the contents of C:\Users\[user]\AppData\Roaming\MSE\uniPaaS Todd On 8/3/2021 6:32 PM, Jim Stephenson
wrote:
|
||||||||||||||||
|
|
||||||||||||||||
|
Re: [EXTERNAL][magicu-l] UP1.9 Cannot display Font or Color Settings
Jim Stephenson
Thanks Wes, that took care of one of the issues. The one where fields get dropped onto the right border. But, it didn't do anything about the Font, Color, Logical Name, etc... panels not showing up.
On Tue, Aug 3, 2021 at 12:43 PM Wes Hein <wes.hein@...> wrote:
|
||||||||||||||||
|
|
