As i am working alot with this tool lately i want to give you some feedback:

thanks

Patrick

Thanks much for the feedback... I really appreciate it!

1) Sorting by numbers - I am using components made by others and since their components do not support this neither do I...sorry... I will look into the ability to designate some columns as numbers rather than strings when you create a column... this might fix the issue.

2) I will work on some tutorials showing how to use the sample CRUD functions. The "C2 Data Editor Demo.capx" that comes with the package shows these functions being used so you can look at that code to see what it is doing.

3) The next update will include the ability to search for and replace empty fields!

4) I tried to overwrite data by dragging and dropping rows many times and I could not reproduce what you are describing. If you can explain the exact steps of how you can get this to happen I will look at it again.. I will look at adding a copy row feature soon.

Thanks again!

ggibson1

thank you very much for the clarification, just bought it, even i will have no time to use it till next week. this sounds so awesome, cant wait to try it!

thanks again

regards

joschi

edit: also some more tutorials or examples would be awesome, maybe you can demonstrate how to make use of the c2 data editor in a simple economy game and include the vidiotutorial with the purchase? that would be really great

Good idea.

Who knows maybe I took voice lessons to learn how to make my voice sound like that...

Hey ggibson1

the tool looks very interesting for me, but i am just a beginner in costruct so i have a few questions:

did i understand it correctly that with the c2 data editor it is possible to use arrays like a database? i have some knowledge in mysql, and currently i am creating a game which simulates an economy. it its a real **** ** *** *** to do all this with arrays. the thing is, in my game new production facilitys get created all the time, each facility has its own recauces, needs to make orders and so on. just working with instance variables isnt enought here. so i need different arrays which i can handle like a mysql database...

- is this possible with this tool?

- are there any more examples or tutorials out there?

thank you

Joschi

Yes you can use the Arrays like a database with the C2 Data Editor. It comes with several methods built from C2 Function objects that implement different kinds of queries against the data in a C2 Array. These functions treat a C2 Array like a database Table. The names of these methods are meant be more user friendly rather than matching SQL standards.

There is a CAPX that comes with the C2 Data Editor that shows these methods being used. There is also extensive comments above each method. You can either copy these methods out of the CAPX or you can use the injection feature in the tool to inject these functions into an Eventsheet within your application.

You can do things like lookup a row in an Array (Table) by one column (e.g. ID) and return the value of a different column (e.g. DollarAmount) from that same matching row.

The names of the columns on the table results in Instance Variables on the C2 Array when it is injected into your application where each column name is assigned the index of the column in the table so that you can use the built in C2 intellisense to select which column to search on or return from the function by name.

I have worked with databases extensively over the past 25 years and so I made C2 Data Editor to make C2 feel as close as possible to that way of handling data for the same reasons you mentioned.

A new version was just uploaded.

This fix takes care of an issue where a user enters invalid characters into an array's column names and then injects into a C2 project.

From the Changes.txt:

* Adds the same filtering to array column names as is applied to array and dictionary names. Some characters (e.g. spaces) are not allowed in some C2 object names.

*** Don't forget to rate and review C2 Data Editor in the Scirra App Store!!!

I have tried the OR and the ones that came out in the 1990s... they are basically the same thing.

The ones from the 1990s became so popular that people today think the OR is something new because they never heard of the same technology already being tried out well over 15 years ago. e.g. "cyber 3d visor"

The resolution on the OR is no better than back then... some day they got to get it right...but then again some day the holodeck type experience will be here also.

It would be helpful if there was a utility function or two to ease accessing the nested structures

Ok so I went and did a test and saw exactly what you were seeing. At some point I modified my code from using "" to ""

I do not remember why I did this and hopefully there was no good reason for it. I just uploaded a new version of C2 Data Editor and an email will go out with download instructions once that has been approved by Scirra.

I tested this in a sample project and was able to load up a nested Dictionary and get its values out without needing to do any additional handling of the quotes.

[attachment=0:2uu8n9fr][/attachment:2uu8n9fr]

*** If anyone sees this change causing a problem in your projects let me know ASAP.

From the Changes.txt file:

* Modified the formatting of Data Object values so that instead of "" being generated "" is instead which works in C2 event sheets also AND makes it so that it can load via the JSON load method easily.

*** Don't forget to rate and review C2 Data Editor in the Scirra App Store!!!

It would be helpful if there was a utility function or two to ease accessing the nested structures

In order to help me better understand what you are asking for please detail if this is from the JSON generation feature? Or the Injection feature? etc... also screenshots would be very helpful...

Thanks.

A new update has just been uploaded. Everyone should receive an email in the next 24 hours with download instructions.

From the Changes.txt file:

* Bug fixes

* Changed the preview browser in the sample capx from "custom" to "default"

* Added the ability to drag and drop rows in the Array Editor to rearrange their order

* Added the name of the object being edited to the title bar of each window

*** Don't forget to rate and review C2 Data Editor in the Scirra App Store!!!

The picking system seems somewhat complicated and I think that it might be context sensitive. I got tired of trying to use picking in different ways and now I use UIDs for everything. So I really cannot answer your question about how picking works in every situation. I just know if you standardize on UIDs it always works (Except when you forget to pick an object by UID before using it)

Also please remember to rate and review C2 Data Editor in the store!

Ok look at this CAPX and pay special attention to how

1) I created a Dictionary

2) Saved the UID for the Dictionary

3) Re-"picked " that same Dictionary by UID later on and got its data

There are other ways of doing things but this is how I always do it... basically in my mind the UID is a pointer to a specific instance like in C++ coding.

https://dl.dropboxusercontent.com/u/277541264/ShowDictionaryWorking.capx

[attachment=0:3g9god6e][/attachment:3g9god6e]

I am reading over this thread now... I want to start off though by mentioning the functions that come with C2 Data Editor are for searching DataSets which are C2 Arrays that are setup in a specific way. Dictionaries only have a key/value so they do not need all those CRUD functions.