Simplicty and flexibility!


Function::Mathematical

Sin


Parameters


Returns/Result


Examples


Reference

sin

Type

Trigonometric Function

Purpose

The sin function calculates the sine of an angle expressed in radians.

Syntax

sin( NUMERIC VALUE)

Returns

A numeric value.

Usage

The numeric value in a Trigonometric function can be a constant value (as shown below), a variable, a field value, or an expression.

Examples

sin( 2.53)

Returns: 0.574172

 

sin( -3)

Returns: -0.14112

See Also


On the forum about Sin

Printing Old Version of Dataease Using DOSbox 0.74

I have a VERY old version of Dataease that has been running on Microsoft XP.  That hard drive crashed and I've been successful in accessing my Dataease DOS files on our Windows 7 computers using DOSBox 0.74.  However, I can NOT print because...

Product: LegEasy DOS. Written by Retta Holefca 15/06/13 at 03:14:30

Re:Printing Old Version of Dataease Using DOSbox 0.74

There is a multitude of different solutions for this. In Normal DOS you can simply redirect LPT ports to a share name with Net Use.This will however not work in DOSbox 0.74 as it is a full DOS emulator which is why DFD works under x64.&nbsp;<b...

Product: LegEasy DOS. Written by DataEase Tech Support 15/06/13 at 09:59:30

Re:Printing Old Version of Dataease Using DOSbox 0.74

Install Windows XP within VirtualBox. &nbsp;It's better than DOS Box and everything works exactly the same as in Windows 7 32-bit....

Product: LegEasy DOS. Written by Earl Wertheimer 08/08/13 at 07:05:13

Re:Re:Printing Old Version of Dataease Using DOSbox 0.74

There is a lot of viritualiszation solutions like VMWare Player etc. that will allow you to run XP or another OS as simultaneous process under Windows 7/8 x64, but the problem with them is that it is quite heavy stuff just to run DFD.We came u...

Product: LegEasy DOS. Written by DataEase Tech Sup 08/08/13 at 22:10:32

Create a PDF file using fields in a form as the file name

Hi Is it possible to create a pdf file using some of the fields in the form as part of the file name with print document any ideas ...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 10/09/13 at 04:54:10

Re:Create a PDF file using fields in a form as the file name

Download Sample Yes! We made a small sample to show how to do this some time back, but I think it was so long ago that it was not published on this forum.....

Product: Dataease [{8}]FIVE. Written by DataEase 10/09/13 at 07:40:46

Re:Re:Create a PDF file using fields in a form as the file name

Great works a treat, thank you ...

Product: Dataease [{8}]FIVE. Written by Gregor Popp 11/09/13 at 09:31:40

Error using SetGlobal

Can anyone point out why I am getting this error message! ...

Product: Dataease [{8}]FIVE. Written by Kensington 22/10/13 at 16:22:07

Re:Error using SetGlobal

The Function is SetVar() not SetGlobal(). SetGlobal() is a CDF function that allow you to set 100 string values in memory by number. SetVar() is a built in function to transfer named variables. To retrieve value you use...

Product: Dataease [{8}]FIVE. Written by DataEase 22/10/13 at 20:14:57

Re:Re:Error using SetGlobal

I still get the same message! ...

Product: Dataease [{8}]FIVE. Written by Kensington 22/10/13 at 20:24:47

Re:Re:Re:Error using SetGlobal

Define a temp field such as:- define temp "dummy" Number . and then assign to this field the result of the SetVar:- dummy := SetVar("gcandelete","yes") . ...

Product: Dataease [{8}]FIVE. Written by Peter Birney, PB Associates 22/10/13 at 21:33:01

Re:Re:Re:Re:Error using SetGlobal

Sorry, still no luck. Now I am getting ...

Product: Dataease [{8}]FIVE. Written by Kensington 23/10/13 at 09:15:57

Re:Re:Re:Re:Re:Error using SetGlobal

My Guess is that you are using an early version of DE8 before we switched the names on SetGlobal() to SetVar(). Due to conflict with the old CDF. What version of DE8 are you using. General advice is to always update to the l...

Product: Dataease [{8}]FIVE. Written by DataEase 23/10/13 at 09:40:57

Re:Re:Re:Re:Re:Re:Error using SetGlobal

Below is the version I am currently using. I am going to upgrade it and post the results. ...

Product: Dataease [{8}]FIVE. Written by Kensington 23/10/13 at 10:28:28

Re:Re:Re:Re:Re:Re:Re:Error using SetGlobal

I upgraded it to 8.0.0.1375 and it now works! Thanks ...

Product: Dataease [{8}]FIVE. Written by Kensington 23/10/13 at 10:32:11

Re:Re:Re:Re:Re:Re:Re:Re:Error using SetGlobal

Also I want to add that if you are making changes then you should also update the help. The Set/GetGlobal() help is out of date and it would have saved me a lot of time if it had been updated. ...

Product: Dataease [{8}]FIVE. Written by Kensington 23/10/13 at 10:38:28

Re:Re:Re:Re:Re:Re:Re:Re:Re:Error using SetGlobal

You couldn't be more correct of course. This is an unforgivable omission and we will rectify it immediately. On the humoristic side though, the help was correct for the DataEase version you had when you started ;-) ...

Product: Dataease [{8}]FIVE. Written by DataEase 23/10/13 at 18:27:25

move files from a directory to another directory using CDF

There is a way to copy file(s) from a directory to another using a CDF function? I've tried to use CopyAFile but it seems to me that it's not work with multiple file using star convention (*.*) ...

Product: DataEase for Windows 7.x. Written by Marco Marchesi 31/10/13 at 09:17:24

Re:move files from a directory to another directory using CDF

Download Sample Firstly sorry for the late reply. We are suffering from a bout of flu in the organisation so our resources is even harder stret...

Product: DataEase for Windows 7.x. Written by DataEase Tech Sup. 01/11/13 at 09:20:13

Re:move files from a directory to another directory using CDF

Hello! What can you suggest, if I need to move files from variable directories to one directory? I have a field, where the path to the file is shown, if this information is required. Wish, you will help me. ...

Product: Dataease [{8}]FIVE. Written by Max MacKeel 02/11/13 at 16:06:58

Re:Re:move files from a directory to another directory using CDF

In our sample i use to fixed catalogues that are sub-directories of the app catalogue, but you can use the same method with variable catalogues and full paths too. Simply derive the function rather than "hard code" it. ...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 04/11/13 at 08:28:26

Re:Re:Re:move files from a directory to another directory using CDF

Many thanks for your reply. I will try to use fileexec for copying and removedir to remove the old directory....

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 07/11/13 at 15:34:49

The list of objects is about missing or is corrupted

The list of the object seems corrupted and/or incompleted only using the menu File&gt;Open, but if I use directly the catalog all the object are listed correctly and works fine.&nbsp;I tried to:- Refresh the database (via Application&gt;...

Product: DataEase 6.x. Written by Marco Marchesi 28/01/14 at 08:52:53

The list of objects is about missing or is corrupted

The list of the object seems corrupted and/or incompleted only using the menu File&gt;Open, but if I use directly the catalog all the object are listed correctly and works fine.&nbsp;I tried to:- Refresh the database (via Application&gt;...

Product: DataEase 6.x. Written by Marco Marchesi 28/01/14 at 08:52:53

Re:The list of objects is about missing or is corrupted

The backup/restore procedure ends normally but the problem is still present....

Product: DataEase 6.x. Written by Marco Marchesi 29/01/14 at 11:04:07

Re:Re:The list of objects is about missing or is corrupted

The problem is most likely in Application Objects which is corrupted in one way or the other.The table definitions are stored in RDRR but the Document information (Forms, Reports, Procedures, Menus) are stored in Application Objects which is r...

Product: DataEase 6.x. Written by DataEase Tech Sup 29/01/14 at 11:11:46

Modifying each record in a table using data from the previous record in the same table

I am trying to copy data from one field in the first record of a table to a field in the second record of the table and to continue that process through all the records in the table. There is no sequential field in the table because I'm clustering...

Product: DataEase for Windows 7.x. Written by Edward Gordley 21/02/14 at 21:40:17

Re:Modifying each record in a table using data from the previous record in the same table

It they are clustered and you simply want to copy a field value from a previous record to the next it is easy:any DQL with no sorting will process data in saved i.e. clustered orderdefine "MyValue" text .define "Counter" number ....

Product: DataEase for Windows 7.x. Written by DataEase 22/02/14 at 08:23:14

Re:Re:Modifying each record in a table using data from the previous record in the same table

[@EOF@]...

Product: DataEase for Windows 7.x. Written by Edward Gordley 24/02/14 at 03:19:29

Setting DEPATH/DENAME in Windows 7/8 without using a bat file.

So we now start Dataease from .bat file – which opens a Command Prompt window – how can we get this to close automatically?...

Product: LegEasy 6 Windows. Written by Rob 28/05/14 at 15:00:38

Re:Setting DEPATH/DENAME in Windows 7/8 without using a bat file.

Even though Autoexec.bat etc. is obsolete in Windows7/8 which is where we used to set these things, you are still able to configure environment variables in Windows.1. Open the Start Menu and right click on <strong style="background-color: ini...

Product: LegEasy 6 Windows. Written by DataEase Tech Sup 28/05/14 at 15:02:46

Missing functions in DE8 Catalogue Help

We have now updated the DE8 catalogue help so it will show all functions. We have also had a quick run through of the same function to make sure all of them contain atleast a minimum description on "usage".The Website in the DE8 Catalogue is u...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 12/09/14 at 18:58:02

Re:Missing functions in DE8 Catalogue Help

Got the same problem wtih setstyle() as i did with setcolor.&nbsp; New form works, an existing form doesn't.So I've abandoned looking at that one.&nbsp; I've got a perfect example of the earlier problem SETCOLOR which i'll send over in a few mo...

Product: Dataease [{8}]FIVE. Written by Simon B 15/09/14 at 09:55:20

Re:Re:Missing functions in DE8 Catalogue Help

Example emailed over, i've stripped out all other tables and dql's so it's nice and small....

Product: Dataease [{8}]FIVE. Written by Simon B 15/09/14 at 10:18:19

Re:Re:Re:Missing functions in DE8 Catalogue Help

Hi again Simon and thanks for the sample.The problem is not that the function is not working, but the way you apply it.Setfunctions including SetColor are manipulation functions and this is conceptually completely new in DataEase terms...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 18/09/14 at 07:36:14

Re:Re:Re:Re:Missing functions in DE8 Catalogue Help

Only just found this reply, not got a notification and never noticed it on the home pg, odd. Nevermind.&nbsp; I understand what you're saying, I misunderstood the nature of how it SHOULD be used, I incorrectly took the virtual field example as a best...

Product: Dataease [{8}]FIVE. Written by Simon B 22/09/14 at 13:25:08

Slow calculations on 2011 Small Business Sever with using SMB2

DataEase 8.2I have a DataBase that contains a CashBook with @200,000 recordsIn the cashbook there are two fields Credit &amp; DebitsWithin a Form I have two lookup fields linked by relationships that need to calculate <e...

Product: Dataease [{8}]FIVE. Written by 17/10/14 at 12:15:23

Re:Slow calculations on 2011 Small Business Sever with using SMB2

It is hard to diagnose this without sitting on top of the problem.For a very long time it was a speciality of DataEase support to work on the notion of conflicts, registry settings, patching and wizardry&hellip; I used to work on DataEase suppo...

Product: Dataease [{8}]FIVE. Written by DataEase 20/10/14 at 19:10:12

Re:Re:Slow calculations on 2011 Small Business Sever with using SMB2

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Graham Brown 22/10/14 at 13:28:50

Is there any difference in the syntax of the function MemoReplace used in a button or using MemoExecDQL?

Use this text in a button on the form order. This works as it should.SetValue("DQL_Nr" ,"104") + Wait(0.1) + MemoExecDQL( DQL ,"2","","","","") +Wait(1) + MemoReplace(settings,"[{filename}]",GetVar("VarSt...

Product: Dataease [{8}]FIVE. Written by Tor Nerland 12/11/14 at 09:42:53

Re:Is there any difference in the syntax of the function MemoReplace used in a button or using MemoExecDQL?

The syntax on a button and in a DQL is different but only in how you reference the column and when/where.In a form you will always have the PRISM column available but in a DQL it depends on where in the DQL you try to address it.1. Do yo...

Product: Dataease [{8}]FIVE. Written by DataEase 12/11/14 at 10:53:54

Using function key in 8.2

I have Upgrade DataEase form vers 8.1 to 8,2. Now I can’t use the &lt;F2&gt; for saving and alt &lt;F5&gt; for searching. So I have to reinstall the old version or.....

Product: Dataease [{8}]FIVE. Written by Finn Edvin 26/11/14 at 09:05:33

Re:Using function key in 8.2

Dear Finn. Edvin.That has not changed from 8.1 to 8.2 nor from any earlier version of DataEase for WIndows. It must be something wrong with your installation. Try to first restart your computer if that doesn't help, De-install DE8 fully and re...

Product: Dataease [{8}]FIVE. Written by DataEase Tech Sup 26/11/14 at 09:21:37

Highest of messing up a previous selection

I have a procedure that selects data, creates a report and exports it:for joborders with (closed = 0 OR closed =blank ) ;&nbsp;&nbsp; --Some calculations here&nbsp; for production with ( phase = 10 AND stb not = "1" );&nbsp...

Product: Dataease [{8}]FIVE. Written by George Washington 14/01/15 at 09:06:00

Re:Highest of messing up a previous selection

The result of any selection/filter etc, in DataEase is a MultiView i.e. a Data-Set that contain all the columns and rows of the selection you query.As a relational database everything is also relationships. Any Script, Table Definition, Relati...

Product: Dataease [{8}]FIVE. Written by DataEase 14/01/15 at 10:35:33

Re:Re:Highest of messing up a previous selection

Thanks for the tip, it worked....

Product: Dataease [{8}]FIVE. Written by George Washington 14/01/15 at 10:53:34

Re:Re:Re:Highest of messing up a previous selection

Glad it did.Sorry for the long lecture, this forum is part of the "documentation" which we will soon publish so we try to give as extensive answers as possible so future generation will get something out of it too ;-)...

Product: Dataease [{8}]FIVE. Written by DataEase 14/01/15 at 11:01:00

DBA Missing Error Message

One of my client getting DBA files are missing error in his database. This is only happening on few tables. And when he reorganize the database.Question is, is there an easy way to fix this via RDRR edit?...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 30/01/15 at 16:15:02

Re:DBA Missing Error Message

This basically means that the .TDF is missing. Message is just so old that it say .DBA.in 8.2 you can delete a table even when the table is missing, so simply go to Tables in Catalog and delete the "offensive" tables.You will get a lot...

Product: Dataease [{8}]FIVE. Written by DataEase 30/01/15 at 16:40:43

Re:Re:DBA Missing Error Message

After working with my client, this is fixed now. All of these message came out of TEMP tables.Once we deleted those tables, everything is good....

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 16/02/15 at 01:19:28

Re:Re:Re:DBA Missing Error Message

It is normally temp tables that has been created in RDRR but where the .TDF/.DBM has successfully been removed, so simply to delete them in the Table View of the Catalogue will almost always be successful....

Product: Dataease [{8}]FIVE. Written by DataEase 16/02/15 at 09:34:04

PDFplay in DE8.5 using MemoExecDQL and HTML.

Hmmm...&nbsp;With one hand you preach DataEasy and with the other advanced functionality ;-) GOOD!You can store the result of a DQL as a Text (HTML) file, you can save it in a Memo etc. When you have finished all your reports you can s...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 14:22:43

Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Unable to download the sample................

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 07/07/15 at 14:48:37

Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Just tested and it works fine. Maybe it is your virus software that block it. It is a zip file, the have a tendency to not like them to muc.http://www.dataease.com/static/ulimages/PDFPlay.zip...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 16:48:19

Re:Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Yes, something was wrong with my Chrome. Tried it under IE, it worked. I guess IE wins!!...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 08/07/15 at 13:32:19

Re:Re:Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

Don't be to quick to assume that Arul ;-)They all have their weaknesses and strengths. To get background image on Body is much harder in IE than in Chrome/Firefox that is why in this sample you have full paths etc.In a way it was a goo...

Product: Dataease [{8}]FIVE. Written by DataEase 08/07/15 at 13:45:45

Missing GERMAN language files in DFW 5.x

HI, I am getting this message when I try to start DataEase for Windows 5.5 on my computer (GERMAN Windows).The missing files are: DERES.GER DERESDLG.GERfor the DateEase-Version: DataEase for Windows 5.5 UI Build...

Product: DataEase for Windows 5.x and before.... Written by Thomas H 26/08/15 at 14:18:05

Re:Missing GERMAN language files in DFW 5.x

In DataEase 5.x there was national versions in some countries. I don’t know if there was in Germany, but anyhow we don’t have them. The problem is that when you run DFW 5.x on a german Windows it will report language version 6 whi...

Product: DataEase for Windows 5.x and before.... Written by DataEase 26/08/15 at 14:20:12

DE 8.5 Beta, Error 2 closing application General out of memory failure

When I close the application i get this error every time. Anyone know what causes it?"Error 2 closing application General out of memory failure"ThanksKevin...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 21/10/15 at 12:02:31

Document Management? Is anyone using a document management system with any DE? is it integrated?

Document Management? Is anyone using a document management system with any DE? is it integrated?I'm looking to build an app with 8.5 and would like to connect it in some way with a document management system. If any one has any experience or...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 23/11/15 at 13:27:16

Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

Document management span so much...1. Do you have a Document Management system already that you want to integrate with?2. What kind of documents do you want to manage?It is quite straight forward to make a Document Management syste...

Product: Dataease [{8}]FIVE. Written by DataEase 23/11/15 at 15:41:14

Re:Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

What i'm dealing with here on this one is a transportation/trucking company which generates a lot of bills of lading, inventory/packing lists, signed delivery receipts, workers time sheets, and invoices that are sent out off of the accounting system....

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 23/11/15 at 15:49:22

Re:Re:Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

Do you want to create the documents directly in DataEase or do you want to import them as PDFs etc....

Product: Dataease [{8}]FIVE. Written by Christine Porteous 24/11/15 at 14:39:43

Re:Re:Re:Re:Document Management? Is anyone using a document management system with any DE? is it integrated?

Primarely it would be importing .pdf's.&nbsp; Then secondary would be to generate them out of DE...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 24/11/15 at 14:41:41

DataEase Licensing Terms Explained

Dear Mr. Zakaria. Firstly, your reply itself make it clear to us that you have acted as you believed to be correct but: DataEase as a software is 35 years old and with changing times and changing technology also Licensing terms change....

Product: Dataease [{8}]FIVE. Written by DataEase 02/01/16 at 13:44:39

Using DataEase 8.5 Beta software in production.

The reason that DataEase 8.5 is not officially released is that officially release a software involves some formalities like us putting the final stamp on it, listing the changes to both product and license so you all can make an educated decision to...

Product: Dataease [{8}]FIVE. Written by DataEase 20/01/16 at 07:41:20

Re:Re:Using DataEase 8.5 Beta software in production.

Everyone is entitled to their opinion but that doesn't mean that it is of general interest.&nbsp;We have a very strict policy of not redacting information on the forum, but that is with the mutual understanding that one use it for giving or ge...

Product: Dataease [{8}]FIVE. Written by DataEase 20/01/16 at 10:43:39

Re:Re:Re:Re:Re:Using DataEase 8.5 Beta software in production.

Yes, I agree.Some people go off topic unnecessarily.&nbsp;I must admit DataEase 8.5 go beyond and above with power and functionality compare to where we were before 5 years ago.Unfortunately pretty much all the programming out the...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 20/01/16 at 15:15:01

Using 7zip as a backup program from inside DE85.

Download Sample As discussed the built in Backup/Restore was discontinued in 8.0 but the functions...

Product: Dataease [{8}]FIVE. Written by DataEase 05/03/16 at 17:54:49

Issues with @DFDDQLPrism using DEOS

I have been bringing across procedures from a DFD 5.15i&nbsp;system using @DFDDQLPrism most of which have outputs.&nbsp; While the procedures themselves appear to come across fine the format of the output rarely come...

Product: Dataease [{8}]FIVE. Written by Rob Birney 10/03/16 at 10:56:38

Re:Issues with @DFDDQLPrism using DEOS

Hi Rob.You are correct. The problem is that the format in DFD.As this is "ancient" stuff it doesn't always fall the way we would think today.&nbsp;Our assumption when we started this project was that the DFD files would contain...

Product: Dataease [{8}]FIVE. Written by DataEase 10/03/16 at 12:44:17

Can you give us an example of using webpublisher

Can you give us an example of using webpublisher.&nbsp;...

Product: Dataease [{8}]FIVE. Written by Mohd Sedik Zakaria 17/03/16 at 04:06:01

Re:Can you give us an example of using webpublisher

HI Mohd.WebPublisher was a flop that never worked and the last version that supported it was 7.1.At the moment there is no Web Tool that is generally available to DataEase users, but we are working on "GoAllTheWeb" which will allow you...

Product: Dataease [{8}]FIVE. Written by DataEase 18/03/16 at 09:54:04

Error in parsing derivation for field

I have experienced when if I try to change a form and&nbsp;accidentally&nbsp;remove a field which is used by another field for a calculation I get the error message&nbsp;"Error in parsing derivation for field...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 21/04/16 at 09:37:25

Re:Error in parsing derivation for field

Hi Marco,yes i think the same, this is a know problem since a long time. At first because of this and many other reasons SAVE and BACKUPas many times as you can ! So my way to handle with, is if i have this kind of problem i take back my...

Product: Dataease [{8}]FIVE. Written by grohmann.papier@t-online.de 22/04/16 at 19:56:41

Re:Error in parsing derivation for field

This problem occurs when a previously valid derivations suddenly become invalid.DataEase derviations are compiled so they will be valid from the day they were compiled till DataEase try to recompile them. If a field it depend on has disappeare...

Product: Dataease [{8}]FIVE. Written by DataEase 23/04/16 at 08:47:09

How to print æøå using DOS 4.53

Hi, I have DataEase 4.53 installed on Windows 7 32 bit. This works fine after some adjustments. But I need ÆØÅ in print. DataEase not write ÆØÅ. how can I achieve this?&nbsp;...

Product: LegEasy DOS. Written by John Bang 12/05/16 at 09:26:36

Re:How to print æøå using DOS 4.53

Is the problem that DataEase itself won't allow/show ÆØÅ in forms or is the problem that it won't come out correctly on a printer?...

Product: LegEasy DOS. Written by DataEase 12/05/16 at 18:30:39

Re:Re:How to print æøå using DOS 4.53

Hi, this applies both when I write in DataEase and when I print. When I type in Windows itself so I write æøå and the printer in Windows æøå...

Product: LegEasy DOS. Written by John Bang 12/05/16 at 20:34:04

Re:Re:Re:How to print æøå using DOS 4.53

Then it is the standard DOS problem.DFD use ASCII character set which is an 8 bit character set.In DOS the majority of the upper 128 was graphical characters -borders etc, so you had "millions" of different ASCII character sets for dif...

Product: LegEasy DOS. Written by DataEase 13/05/16 at 07:59:33

Re:Re:Re:Re:How to print æøå using DOS 4.53

no.&nbsp;no, tried and tested but is not working.&nbsp;DataEase writes æøå in windows. but not in DataEase. In Dataease it is this &nbsp; æ = ' &nbsp; &nbsp;&nbsp;&nbsp;ø =&nbsp;; &nbsp;&nbsp;&nbsp;&nbsp; å = [ &nbsp; &nbsp;<p...

Product: LegEasy DOS. Written by John Bang 18/05/16 at 15:47:23

Re:Re:Re:Re:Re:How to print æøå using DOS 4.53

It is not a DataEase problem as such but a DOS problem.Do you get ÆØÅ in DOS when you type it&nbsp;C:\ÆØÅIf you get ÆØÅ in DOS you will get it in DataEase too.The problem is your keyboard setting in DOS, which need to u...

Product: LegEasy DOS. Written by DataEase 19/05/16 at 11:57:33

Re:Re:Re:Re:Re:Re:How to print æøå using DOS 4.53

yes i get æøå in cmd (DOS).&nbsp;Microsoft Windows [Versjon 6.1.7601]Copyright (c) 2009 Microsoft Corporation. Med enerett.C:\Users\nils&gt;æøåbut not in dataease....

Product: LegEasy DOS. Written by John Bang 20/05/16 at 09:22:39

Re:Re:Re:Re:Re:Re:How to print æøå using DOS 4.53

yes i get æøå in cmd (DOS).&nbsp;Microsoft Windows [Versjon 6.1.7601]Copyright (c) 2009 Microsoft Corporation. Med enerett.C:\Users\nils&gt;æøåbut not in dataease....

Product: LegEasy DOS. Written by John Bang 20/05/16 at 09:22:39

Re:Re:Re:Re:Re:Re:How to print æøå using DOS 4.53

yes i get æøå in cmd (DOS).&nbsp;Microsoft Windows [Versjon 6.1.7601]Copyright (c) 2009 Microsoft Corporation. Med enerett.C:\Users\nils&gt;æøåbut not in dataease....

Product: LegEasy DOS. Written by John Bang 20/05/16 at 09:22:39

Re:Re:Re:Re:Re:Re:Re:How to print æøå using DOS 4.53

I use the utility sprinter to solve my problem reports, with it I ended up with special characters problems with the DOS DataEase Portuguese: http://www.dsbglobal.com/dosprinter/...

Product: LegEasy DOS. Written by Reinaldo Neves 23/05/16 at 14:51:17

Re:Re:Re:Re:Re:Re:Re:Re:How to print æøå using DOS 4.53

The problem is still the 8-bit character set in your DOS window.Windows operate with a 16 and 8 bit character set. Default is 16 and the DOS window itself support 16 but DataEase does not so you need to configure the code page/character set to...

Product: LegEasy DOS. Written by DataEase 24/05/16 at 15:30:59

Error 503 adding field Missing operator in formula

I've been having &nbsp;this problem i few times now and its really bogging me down. Does anyone know what causes it or how to correct it?I've tried the usual. Saving the form/table under another name then deleting and re-creating. But I still h...

Product: . Written by Kevin O'Donnell 20/06/16 at 18:29:55

Re:Error 503 adding field Missing operator in formula

I always forget to add that this is in DE8.5 latest version....

Product: . Written by Kevin O'Donnell 20/06/16 at 18:35:37

Re:Re:Error 503 adding field Missing operator in formula

I think this one is easy to explain.In DE85 there is a lot of "original" features that has been re-instated for very good reasons.A lot of things was "hardcoded" to behave different than originally designed in DFW 5.x/6.x/7.x.&nbsp;<br...

Product: Dataease [{8}]FIVE. Written by DataEase 20/06/16 at 18:51:16

Re:Re:Re:Error 503 adding field Missing operator in formula

That doesn't seem to fix the problem. Would you like me to post a copy to you its pretty small?...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 20/06/16 at 19:05:54

Re:Re:Re:Re:Error 503 adding field Missing operator in formula

yes, please ;-)...

Product: Dataease [{8}]FIVE. Written by DataEase 20/06/16 at 19:50:36

Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

I hope it attached properly.user Kevinpw 1350...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 20/06/16 at 19:52:22

Re:Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

Hi Kevin.&nbsp;You sent us only a DBM file i.e. data file of one table....

Product: Dataease [{8}]FIVE. Written by DataEase 21/06/16 at 07:32:43

Re:Re:Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

How about this...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 21/06/16 at 11:11:48

Re:Re:Re:Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

Hi Kevin, which form is it?I suspect it is BarclaySte ?As you see here there is non of the above forms that defines the table, just "use" it.&nbsp;<img src="/static/ulimages...

Product: Dataease [{8}]FIVE. Written by DataEase 21/06/16 at 13:50:19

Re:Re:Re:Re:Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

yes, Barclayste...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 21/06/16 at 13:59:07

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

I'm glad it was a simple problem. I don't know how it became unchecked and why didn't i see that.Thank you !! &nbsp;for you help. &nbsp;...

Product: Dataease [{8}]FIVE. Written by Kevin O'Donnell 21/06/16 at 14:07:37

Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Re:Error 503 adding field Missing operator in formula

We are equally glad that it was a simple problem.These things happens and sometimes one only need a fresh set of eyes to see the "obvious".When one work a lot with something one see what one "want" to see after a while. We have all bee...

Product: Dataease [{8}]FIVE. Written by DataEase 21/06/16 at 14:09:47

DQL export using MemoExecDQL with 2 tables

The attached DQL export&nbsp;data from 2 different dataease&nbsp;tables but if i use it as normal DQL procedure it works perfectly but if i try to use it via MemoExecDQL it&nbsp;doesn't works. Why? Thanks (DataEase version 8.2.0.1700)&nbsp;...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 27/06/16 at 08:04:12

On the blog about Sin

New Sample - How to manipulate records in a sub form using DatePicker()

Download SampleWe got a challenge under the AskUS "Program" so we jumped on it. It was quite nifty actually, and since it gave us an "awakening" we tho...

Product: Dataease [{8}]FIVE. Written by DataEase 24/07/13 at 13:52:18

How to create a multi column output using a data view

A data view in DG3 outputs a sequence of data from a live table, a live dql or a live transfer. To make these data list in one column is easy just using a standard table and setting a &lt;table&gt; tag in view header and &lt;/table&gt; in view foo...

Product: DataEase Generation 3. Written by DataEase Development 23/08/13 at 07:18:10

How to upload images to different paths when using the richtext editor

Earlier in an blog post, we showed how to set up file upload in richtext editor in DG3. This time we will tell you how to upload files to dif...

Product: DataEase Generation 3. Written by DataEase Development 17/12/13 at 08:57:08

DataEase 8.2 - New Sample showcasing Email (full) and PDF, MoveObject etc... (Ver. 8.2.0.1686)

Download Email and PDF sample This is not an article but a quick explanation of the sample application attached so you can "steal" the features we use.&nbsp;it is...

Product: Dataease [{8}]FIVE. Written by DataEase 14/11/14 at 18:16:20

Using DE8.2 Emailing with GMAIL

If you are going to use DE8.2 together with GMAIL you need to change the security settings of GMAIL.GMAIL is configured by default only to be accessible (SMTP) to only accept connections from GOOGLE tools so you need to "lower" the security to...

Product: Dataease [{8}]FIVE. Written by DataEase 15/11/14 at 18:35:39

New Sample - Using Subform as Open Related Dialogue with multiple returns (Ver. 8.2.0.1686)

Download "Open Related"&nbsp;Sample Open Related is a "awkward" and outdated way of doing "picklists". As you have pointed out it is slow and you can only really r...

Product: Dataease [{8}]FIVE. Written by DataEase 17/11/14 at 18:26:41

single quote showing as a question mark

Not sure why, but quite often like in this blog post, everytime you have used a single quote: 'It show on my screen as a question mark: ?I've checked this in firefox and IE and it's the same.&nbsp; Makes your sample scripts confusing!</p...

Product: . Written by 05/03/15 at 10:24:25

PDFplay in DE8.5 using MemoExecDQL and HTML.

Download Sample! PS! You will need the latest version of DE8.5 BETA to run this sample, you will fin...

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 11:49:54

Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

WOW!This is very good. My next project will be in 8.5......no question about it.BTW: since you are building "SR-71 Blackbird"....I thought no harm in asking :-)...

Product: Dataease [{8}]FIVE. Written by Jeyarajah Arulrajah 07/07/15 at 14:36:56

Re:Re:PDFplay in DE8.5 using MemoExecDQL and HTML.

He,he!&nbsp;Never harm in asking. It is your best "skill" that you are never afraid of asking the question. If one don't ask one won't get an answer....

Product: Dataease [{8}]FIVE. Written by DataEase 07/07/15 at 15:41:00

Enable/Disable based on Global variable using SetStyle(),SetState(),SetVar(),GetVar(),MoveObject()

Download Sample! We got a request from a user on how to control the users...

Product: . Written by DataEase 25/09/15 at 08:54:32

Simple Calendar in DE85 using ExecDQL with Body ver 1.0 - Will be continued....

Download Calendar Sample It is Christmas after all so why not give you guys another little "present" ;-...

Product: Dataease [{8}]FIVE. Written by DataEase 30/12/15 at 15:29:44

DataEase 8.5 - Product Licensing plan

DataEase 8.5 is a watershed moment in DataEase history.&nbsp; Here we will draw the line between of the old ways and start introducing the modern ways. You...

Product: Dataease [{8}]FIVE. Written by DataEase 26/01/16 at 10:56:02

How to highlight active record in a subform by using GetCurrent("RowNumber"), SetStyle(with * and #) and GotFocus/Mousdown.

Download Sample We got a very good question o...

Product: Dataease [{8}]FIVE. Written by DataEase 28/01/16 at 11:26:05

Available Products, De-supported Products and available for licensing

We frequently get enquires about the availability of older versions of DataEase as well as the status of bug fixing/support for these products. Above you see a t...

Product: Dataease [{8}]FIVE. Written by DataEase 01/03/16 at 10:59:49

DataEase 8.5 - Using 7zip as a backup program from inside DE85.

Download Sample As discussed the built in Backup/Restore was discontinued in 8.0 but the functions...

Product: Dataease [{8}]FIVE. Written by DataEase 05/03/16 at 18:09:55

How To Export Data Using the Export Dialog

The DataEase export Dialog lets you export data from a DataEase application so that you can then import it to another DataEase (DOS or Windows) application or an...

Product: Dataease [{8}]FIVE. Written by Fatma Adel 12/05/16 at 10:57:00

DataEase 8.5.0.2291 - GetCurrent("OSVersion") and GetCurrent("OSInfo") added.

New keywords to GetCurrent added to make it possible to find out what Operating system you are running and if the operating system is x64 or x32.GetCurrent("OSVersion") will return the version of your operating systems. Due to changes and limi...

Product: Dataease [{8}]FIVE. Written by DataEase 15/07/16 at 18:10:08

L4D - How to print RAW when using Windows Print Dialogue to select printer.

L4D in default mode will interpret the output and convert it to windows print. It will scale etc. so it fit in the assumed paper size i.e. the paper size the device report it is using etc....

Product: LegEasy DOS. Written by DataEase 25/11/19 at 19:37:50


dg3_HelpView