Sign in to follow this  
Followers 0
michaelslamet

Read data and allow user edit them

5 posts in this topic

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??) :ermm:

Share this post


Link to post
Share on other sites



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

 

small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt....

Share this post


Link to post
Share on other sites

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 :*

Share this post


Link to post
Share on other sites

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.

 


small minds discuss people average minds discuss events great minds discuss ideas.... and use AutoIt....

Share this post


Link to post
Share on other sites

@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)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now
Sign in to follow this  
Followers 0