Read data and allow user edit them

[michaelslamet]

I'm not sure how to say this, but...

Instead of using local INI file, I plan to put those INI setting on MySQL database on the cloud,

so my scripts no matter where it's physically, as long as it has a internet connection,

could read that global INI setting through internet.

I am planning this because those ini files are updated regulary and need to be distributed

to many locations.

Is this a good idea?

The field type to holding that INI file is memo/text.

I plan to create a simple MySQL data editor to let user edit the config file, but no need to

hand over the MySQL credentials to him.

I have no problem reading MySQL data using MySQL UDF, but I have no idea how to

display them (in a grid view??) and how to let user edit and save them.

Please guide me.

Or ...

I'm over thinking (again??)

[Gianni]

Hi michaelslamet

...just an approximate suggestion...

you could load the data into an array,
then use this ready to use ">array editor module" for easily edit them in a grid,
finally rewrite the changed data in the database

bye

 

[michaelslamet]

Hi michaelslamet

...just an approximate suggestion...

you could load the data into an array,

then use this ready to use ">array editor module" for easily edit them in a grid,

finally rewrite the changed data in the database

bye

 

Pincopanco,

Seems great What is the different with Melba's GUIListViewEX?

Also, is it possible to edit multiline 1D array using array editor module?

The element can consist of many many lines!

Anyway, dont "bye", please come back

[Gianni]

sorry michaelslamet, but I am not an editgrid expert...

I did not know GUIListViewEx (sorry mr. Melba23), I took a look to the examples, and it seems really feature-rich, while "array module editor" seems to be simply an "as is" edit grid (however, easy to use), maybe the best way to chose is to try both and follow your feel.

however I do not think that them can be used for edit multi-line (memo/text) "fields".

maybe is a better choice if you build your own custom edit form showing few (or better just one) records at a time? it depends on the nature and form of your data.

... good luck ...

p.s.

if testing the ">array editor module", if you get some "variable used before declaration" errors from the ArrayEdit.au3,
just add this statement:

#AutoIt3Wrapper_Add_Constants=y

at the beggining of the listing to solve those errors.

 

[michaelslamet]

@Pincopanco: thank you very much for your explanation and hints

This seems more complicated than I think before

Is there any ready to use tool for this? (not like mysql workbench or HeidiSQL that has a lot of features, i only need features to edit those data)