Simplicty and flexibility!


Function::Internal

Create
Create("NewTablename","Keyword","TemplateTable")
Create("NewTable130215","Copy","MyCustomers")
Create("MyTable","Delete")
retval:=Create("ATable","CopyWithFormOpenDT","Customers") .


To create a table during runtime that can be used for storing history, data-manipulation and eventually direct user interaction.

In version 1 this function will only be usable from ExecDQL as all other Documents/procedure can only access pre-defined tables.

Parameters


NewTableName: Text
    Name of new table that you want to create. Can be any text and also constructed via derivation i.e Jointext ("Customers",current date) etc.

Keyword: Text

    Copy: This will copy the structure including the Relationship from the TemplateTable.
    Delete : This keyword will delete the table named in NewTableName.
   DeleteWithForm: Delete the table and any corresponding form with the same name.
   CopyWithForm: Will copy the table and form (if any) with the same name as the table
   CopyWithFormOpen: Will copy the table and form with same name as table and open this form in User Mode.
   COpyWithFormOpenDT: Will copy the table and form with the same name as table and open this form in Design Mode.

TemplateTable: Text
    This is the name of the table that we want to copy the structure from.

Returns/Result


Result:text

"0" : Success
"1" : No table with given name, failure. No action.
"2" : No korresponding Form, table will be copied but without form.

Examples


Reference

See Also


On the forum about Create

Forum createt in Dataease

Hallo together, i have read that this Forum was createt in Dataease. Can i get more Information how to do that and what kind of Software i need? I am using since 15 years Dataease but not in connection with the Internet ( like Internetshop or Internetfo...

Product: DataEase Generation 3. Written by Markus 18/09/12 at 06:27:51

Re:Forum createt in Dataease

Dear Markus. Thank you for taking the time to write to us. This entire website is developed in DG3 Web Framework, which is the first product in the new DG3 product line. It is still an Alpha product, which means that it is still in Development and tha...

Product: DataEase Generation 3. Written by DataEase 20/09/12 at 16:35:52

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

How to create "dummy" records for export

Hi there,I am a new forum user and this is my very first post, so, in the first place, hail to everybody.I am trying to export to a txt file the order placed by every customer in the past year, grouped by months. I succeeded in grouping...

Product: DataEase for Windows 7.x. Written by George Washington 12/12/13 at 13:15:22

Re:How to create "dummy" records for export

If this is DataEase 7 there is fewer alternatives than in 8 but still possible ;-)I will concentrate on the brute force and you can do the details of exporting it yourself.define temp "january" number .define temp "februay" number...

Product: DataEase for Windows 7.x. Written by DataEase 13/12/13 at 06:39:05

Re:Re:How to create "dummy" records for export

Hi Mr. DataEase and thank you for answering.I tried a modified version of your solution (I have added an additional selection criterion on the customer: without that it gives me the same total for each customer) and it has some problems. The fi...

Product: DataEase for Windows 7.x. Written by George Washington 13/12/13 at 08:45:38

Re:Re:Re:How to create "dummy" records for export

Hi Again.The alternative is to create a nested DQL where you run a For inside a for, and then the second one is nesting a table where you have only one record for each month.for MyData ;for MyMonths ;list recordsSum of MySa...

Product: DataEase for Windows 7.x. Written by DataEase 17/12/13 at 11:24:12

Re:Re:Re:Re:How to create "dummy" records for export

That's smart, a sort of join with another table, thank you now it works....

Product: DataEase for Windows 7.x. Written by George Washington 19/12/13 at 12:00:19

HOW TO CREATE SEQUENCE NUMBER AT THE SAME FORM

I make form (CUSTOMERS) and have field {NAME},{DATE OF BIRTH} and {NUMBER LINE OF BIRTH DATE}.Now I want sequence number in field {NUMBER LINE OF BIRTH DATE} with same date in field {DATE OF BIRTH}.If different date in field&nb...

Product: Dataease [{8}]FIVE. Written by msbz288@streamyx.com 26/03/15 at 16:43:43

HOW TO CREATE SEQUENCE NUMBER AT THE SAME FORM

I make form (CUSTOMERS) and have field {NAME},{DATE OF BIRTH} and {NUMBER LINE OF BIRTH DATE}.Now I want sequence number in field {NUMBER LINE OF BIRTH DATE} with same date in field {DATE OF BIRTH}.If different date in field&nb...

Product: Dataease [{8}]FIVE. Written by msbz288@streamyx.com 26/03/15 at 16:43:43

Re:HOW TO CREATE SEQUENCE NUMBER AT THE SAME FORM

You can't use Sequence Number as that is definite and not relational.YOu have to use Highest of Relationship and create relationship in such a way that it only match Customer and Day of birth.Then in the "sequence" field you simply put...

Product: Dataease [{8}]FIVE. Written by DataEase 27/03/15 at 11:45:28

Re:Re:HOW TO CREATE SEQUENCE NUMBER AT THE SAME FORM

Im not understand what you try to explain....

Product: Dataease [{8}]FIVE. Written by msbz288@streamyx.com 27/03/15 at 14:15:05

Re:Re:Re:HOW TO CREATE SEQUENCE NUMBER AT THE SAME FORM

Function::Internal Highest Of </p...

Product: Dataease [{8}]FIVE. Written by DataEase 27/03/15 at 16:55:13

QBM - How to create your own crashing database with 1 table and 2 fields.

Trying to create a test for a dataease crash and can't because dataease crashes during creation of a basic test database! lol.&nbsp; Easily duplicated and I did it again from scratch in an empty folder in under 5 minutes, so here's how to do it.<p...

Product: Dataease [{8}]FIVE. Written by Simon B 17/04/15 at 13:01:24

Has anyone created a smartphone app that links back to a Dataease application

Has anyone created a smartphone app that links back to a Dataease application? I'd be very interested in hearing and or seeing any if they are out there wither in iOS or Android....

Product: DataEase Generation 3. Written by Kevin O'Donnell 02/11/15 at 15:30:16

Re:Has anyone created a smartphone app that links back to a Dataease application

We have created several, and it will be much easier to do when we release the DataEase server next year.We are also working on a framework to make it easier to package a DataEase Web App as an app both for iOs and Android.You can devel...

Product: DataEase Generation 3. Written by DataEase 03/11/15 at 11:13:19

How to create sequence reference number in my invoice but running more than one computer

How to create sequence reference number in my invoice but running more than one computer?&nbsp;I have some customer, asking me can i create invoice with running reference number sequenly but they&nbsp;have many computer will&nbsp;generate invoi...

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

Re:How to create sequence reference number in my invoice but running more than one computer

I use for that an form &nbsp;"INVNR"&nbsp;where the Invoicenumber is stored.&nbsp; In this form must be only one record with&nbsp;the actual number.I check this every time bevor i use the number: &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n...

Product: Dataease [{8}]FIVE. Written by Thomas Hergenröther 29/06/16 at 07:42:08

Re:How to create sequence reference number in my invoice but running more than one computer

Hallo there..... :)I thing that using // sequenced number // with the combination of // uniqe // will do the same thing you expecting.I use this since years in a microsolft network with no problems....Kind regards&nbsp;Mark...

Product: Dataease [{8}]FIVE. Written by Markus 29/06/16 at 17:26:06

Re:How to create sequence reference number in my invoice but running more than one computer

Sorry for the late reply.When you say they are running many computers are these computers linked in a network i.e. running the same application from one location or do they run many different applications in many different locations?...

Product: Dataease [{8}]FIVE. Written by DataEase 06/07/16 at 19:56:22

DE 8.5 How can I create a 'Data Entry Form' to use in creating reports?

In DFD we were able to create "Data Entry Forms"&nbsp; to use as filters in creating reports. Can this be done in 8.5 ?...

Product: . Written by Kevin O'Donnell 15/07/16 at 15:12:21

Re:DE 8.5 How can I create a 'Data Entry Form' to use in creating reports?

KevinI create Data-Entry Forms this way Click – FileNewClick - Procedure (DQL)Click – OK(Procedure opens in new window)Click – <strong...

Product: . Written by KEV 15/07/16 at 19:39:19

Re:Re:DE 8.5 How can I create a 'Data Entry Form' to use in creating reports?

That's great....Thank you!Kevin O...

Product: . Written by Kevin O'Donnell 15/07/16 at 20:19:20

Can somebody please eleborate on window types and how to create modal forms ? Many Thanks....

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by Luigi Faso 27/12/16 at 20:12:40

Re:Can somebody please eleborate on window types and how to create modal forms ? Many Thanks....

To start with you can have a look at this sample.http://www.dataease.com/DG3_BlogList/?ParentID=0000000314&amp;field1=0000000314...

Product: Dataease [{8}]FIVE. Written by DataEase 28/12/16 at 12:17:46

Re:Re:Has anyone created a smartphone app that links back to a Dataease application

"and it will be much easier to do when we release the DataEase server next year."Is this something that is out now (Dataease Server) ?...

Product: DataEase Generation 3. Written by Kevin O'Donnell 23/01/17 at 19:20:31

Re:Re:Re:Has anyone created a smartphone app that links back to a Dataease application

Yes and No.It will be part of the next release of DataEase.It is divided in two products.DataEase Development Server which is for developing and testing Web Solutions and then DataEase Deployment Server for Deploying and Publis...

Product: Dataease [{8}]FIVE. Written by DataEase 27/01/17 at 13:55:49

When I created a new database in DataEase 8.5.1.2674 version, I am getting BASIC as locking.

When I created a new database in DataEase 8.5.1.2674 version, I am getting BASIC as locking. See the screen shot below. How do...

Product: Dataease [{8}]FIVE. Written by arulj@naitcs.com 22/12/17 at 12:18:10

Re:When I created a new database in DataEase 8.5.1.2674 version, I am getting BASIC as locking.

When you create a new application from &lt;none&gt; (no Template) in 8.5 you get an application with the same settings as you have in PRISM.INI. Normally you crea...

Product: Dataease [{8}]FIVE. Written by DataEase 22/12/17 at 12:27:16

Save Form : unsuccessful create

Hi DataEase,when I open my database&nbsp;i receive this message :What does it means ?If I click OK the database seems to me works properly anyway.&nbsp;How c...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 12/02/18 at 12:38:43

Re:Save Form : unsuccessful create

This is due to a mix of versions.DataEase check the version of different system tables at startup and if they are not correct it will replace/update them.When one use different versions of 8.5 i.e. Develop in 2674 and then try to run i...

Product: Dataease [{8}]FIVE. Written by DataEase 12/02/18 at 12:50:25

Re:Re:Save Form : unsuccessful create

Thanks. I installed the last version, so now I have the&nbsp;8.5.1.2674 on both version (Developer and Player) but I'm still receiving the error message.I noted also that I have 2 applications inside the same directory&nbsp;<img src="/st...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 12/02/18 at 14:09:12

Re:Re:Re:Save Form : unsuccessful create

You have now most likely ended up with the double entry problem in your RDRR.You need to fix the RDRR manually or revert to a backup....

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

Re:Re:Re:Re:Save Form : unsuccessful create

Thanks but unfortunately all backups copy have the same problem.How can I fix&nbsp;the RDRR manually ?...

Product: Dataease [{8}]FIVE. Written by Marco Marchesi 13/02/18 at 12:39:12

Re:Re:Re:Re:Re:Save Form : unsuccessful create

http://www.dataease.com/DG3_ForumList/?ParentID=0000000521&amp;field1=0000000521...

Product: Dataease [{8}]FIVE. Written by DataEase 16/02/18 at 11:27:35

What does this message mean when I am trying to define a relationship ? How do I fix it ? Please specify the Bound Field when trying to create a Lookup Field

[@EOF@]...

Product: Dataease [{8}]FIVE. Written by peadar Kearney 26/02/19 at 13:57:27

Re:What does this message mean when I am trying to define a relationship ? How do I fix it ? Please specify the Bound Field when trying to create a Lookup Field

Hi.&nbsp; DataEase has been managed by several different teams over the years and not all of them have been to into the lingo. I remember myself whe...

Product: Dataease [{8}]FIVE. Written by DataEase 27/02/19 at 09:42:38

Re:Re:What does this message mean when I am trying to define a relationship ? How do I fix it ? Please specify the Bound Field when trying to create a Lookup Field

Excellent.Thank you for the explanation, It is appreciated.Best Regards,Peadar...

Product: Dataease [{8}]FIVE. Written by peadar Kearney 27/02/19 at 23:19:40

Unable to create field in DE9

Hi,I'm unable to create a field in DE9 (see attached movie). Does someone know what is wrong?&nbsp;Thanks in advanceSincerelyDaniel Kron...

Product: DataEase 9 Developer. Written by Daniel Kron 01/03/20 at 14:03:01

Re:Unable to create field in DE9

Hi Daniel.Is this always i.e. on all applications?If it is just one applications is this a migrated application?If it is an old application/migrated application we suspect it has something to do with Styles. Try to make a new f...

Product: DataEase 9 Developer. Written by DataEase 03/03/20 at 12:35:55

Re:Re:Unable to create field in DE9

Hi DataEase,This is for a totally new application I created in DE9. I also uninstalled and installed DE9 several times but it is still the same.Sincerely,Daniel...

Product: DataEase 9 Developer. Written by Daniel Kron 03/03/20 at 12:55:18

Re:Re:Re:Unable to create field in DE9

Has it worked before?What has changed?What version of DE9 is it?...

Product: DataEase 9 Developer. Written by DataEase 03/03/20 at 19:34:46

Re:Re:Re:Re:Unable to create field in DE9

Yes and No. In the beginning when I tried it out, It did not work, then I restarted the program and then it suddenly worked. It did also work when I used a DE6.53 Database which I migrated to DE9. I use the Beta version which can be downloaded from th...

Product: DataEase 9 Developer. Written by Daniel Kron 03/03/20 at 23:59:30

Re:Unable to create field in DE9

Hi again Daniel.We have identifed the problem. It has to do with Scaling in Windows.If you have a scaling other than 100% there is a problem with sizing of images in Dialogues like Fi...

Product: DataEase 9 Developer. Written by DataEase 10/03/20 at 12:14:40

Re:Re:Re:Unable to create field in DE9

DataEase solved it! Perfect ?? My computer (Laptop) is recommended to run on 125% scaling instead of 100%. Now when I run it on 100% it works!Thanks...

Product: DataEase 9 Developer. Written by Daniel Kron 10/03/20 at 13:16:41

How do I create separate applications and get them on to my actual C: drive from the b: created by leg easy dos

You can create a new application in any location on your computer.SImply add a name for your new application, browse to the location you want to use, and hit SAVE and the Session will be crea...

Product: LegEasy 4DOS. Written by Bill Gunther 01/04/20 at 20:36:07

Re:Re:How do I create separate applications and get them on to my actual C: drive from the b: created by leg easy dos

You can create a new application in any location on your computer. SImply add a name for your new application, browse to the location you want to use, and hit SAVE and the Session will be...

Product: LegEasy 4DOS. Written by DataEase 06/04/20 at 13:28:04

having a 1 choice field form the several other forms can use to populate or create a record including that choice.

[@EOF@]...

Product: LegEasy 4DOS. Written by Bill Gunther 13/04/20 at 22:50:23

Re:having a 1 choice field form the several other forms can use to populate or create a record including that choice.

What you want is a choice filed that is based on a table?That feature first appeared in DFW 6 so not available in DFD.The "feature" in DFD is CTRL-F10....

Product: LegEasy 4DOS. Written by DataEase 16/04/20 at 14:24:40

On the blog about Create

Changed Functionality in 8 - <New Relationship> can now create any relationship! (Ver. 8.0.0.1017)

Some times one is allowed to be egotistical...especially if one is in charge of DataEase Development...One thing that annoy me beyond belief is unnecessary restrictions and obstacles, and to be honest DFW have had its fair share of them....

Product: Dataease [{8}]FIVE. Written by DataEase 03/11/11 at 11:29:34

New Sample - How to create a text or HTML file for printing in DataEase 8 (Ver. 8.0.0.1308)

Download Sample DataEase for Windows has been a nightmare when it comes to exporting and printing. It seems that this basic need has eluded the high and mighty...

Product: Dataease [{8}]FIVE. Written by DataEase 20/06/13 at 17:51:52

How to create a new deployed version of a web application

In DG3 there are two methods of deploying a new web application:Local deploymentRemote deploymentThe local deployment is used if you are running DG3 development on the same computer as you deploy web application. The...

Product: DataEase Generation 3. Written by DG3 Development 14/08/13 at 15:17:10

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 DG3 Development 23/08/13 at 07:18:10

How easy it is to create JSON from DG3

A lot of web sites delivers data to it's users as a JSON object. The beauty of this format is that it can be parsed and used by almost any web developer framework and used directly in java-script without any extra work converting it. A DG3 user asked...

Product: DataEase Generation 3. Written by DG3 Development 12/12/13 at 08:55:29

How to: Create your own SpeelWeekday() and yes/no for language support

Download Sample The main problem with using an English version of DataEase is things like Spell functions and yes/no. These are functions that a lot of users have grown fo...

Product: Dataease [{8}]FIVE. Written by DataEase 30/09/14 at 22:25:27

DataEase 8.5 BETA1 - Create() ad-hoc table creation implemented (Ver. 8.5.0.1749)

We keep braking down the boundaries in DataEase and the latest is the addition of the function Create().This is a runtime function to create a table based on the structure of another table. The first implementation is limited to creating the ta...

Product: Dataease [{8}]FIVE. Written by DataEase 13/02/15 at 16:24:35

Developer Tips - How to create a datetime field in DataEase.

With different countries and different standards date and time is not straightforward. DataEase use the Windows Time and Date and that result in a lot of peculiarities.To insure that you have a correct sortable and indexable DataTime in your f...

Product: Dataease [{8}]FIVE. Written by DataEase 23/02/15 at 14:50:35

Sample! SimplePDF, learn how to use ExecDQL to create PDF quick and easy!

Download Sample! This sample might be a little out of "context" as we have had this feature in DE85 for "many" weeks alre...

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

Step by Step! How to create a new application

Let's get started and step by step create a new application with these quick and easy instructions: - Open DataEase and click on Create New&nbsp; - Create a new folder to...

Product: Dataease [{8}]FIVE. Written by Fatma Adel 06/04/16 at 08:22:31

LegEasy4DOS: How to create a new application and restore a backup

Here we show you how you can create a NEW application (DFD Application) in LegEasy4DOS and then restore a backup over it....

Product: LegEasy DOS. Written by DataEase 15/06/16 at 14:57:58

DataEase 8.5.0.2275 - Big DEOS Update Added DEOS function @zip, @unzip, @CopyDirectory, @CopyFile, @CreateDirectory, @DeleteDirectory, @DeleteFile, @DirectoryEmpty, @DirectoryExists, @FileExists, @BrowseForFile and @BrowseForFolder

There has been a number of CDFs etc for dealing with finding files etc in DFW.CDF's are well and good but important functions like this should be dealt&nbsp; with by&nbsp;DataEase directly.In 2275 we have included the following DEOS fu...

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

DataEase 8.5.0.2450 - Command to create shortcuts and pin/unpin them to Taskbar, Start Menu, Desktop added to DEOS

We made a pledge when we started redeveloping DataEase that we would use DataEase for everything including making DataEase in it. And we have stood by it. Where previous owners have used DataEase very little with the excuse that it didn't...

Product: Dataease [{8}]FIVE. Written by DataEase 05/08/16 at 20:54:28

New Sample - How to create your own type ahead search in DE85

Download Sample In this sample we will showcase s...

Product: Dataease [{8}]FIVE. Written by DataEase 22/06/17 at 16:13:16

DataEase 8.5 - How to create a subform that change style on scroll/value in row.

Download Sample The solution is to manipulate the entire Subform when there is a scroll.&nbs...

Product: Dataease [{8}]FIVE. Written by DataEase 29/05/18 at 12:43:25

L4D - How to manually create a shortcut to an Application

One much loved feature in L4D is the ability to pin an application to Desktop, Start-Menu or/and Taskbar.This is a feature that Microsoft is not too happy about and in the last update of Wind...

Product: LegEasy DOS. Written by DataEase 14/11/19 at 17:04:30

Re:L4D - How to manually create a shortcut to an Application

insert de16m.exe dbname username userpswd and some parameters needed through slashes in Your autoexec.bat&nbsp;then switch off and on Your deviceand You will get de453 OS instead of windows or dos. if You wanna them to be visited by You...

Product: LegEasy DOS. Written by Ihor Zakharchenko 15/11/19 at 06:49:11


dg3_HelpView