populate datatable

ďťż

Pokrewne:

Cytat:

populate datatable

Wiaz - Pią Paź 05, 2007 8:33 am
" />it would be nice to have dialog that gives possibility to populate datatable.
for example i have table created:
CREATE TABLE dostawca (
d_id INTEGER primary key autoincrement,
d_nazwa VARCHAR(100),
d_pelna_nazwa TEXT,
d_nip VARCHAR (20),
d_telefon VARCHAR (20),
d_fax VARCHAR (20),
d_ulica VARCHAR (100),
d_nr_domu VARCHAR (20),
d_kod VARCHAR (20),
d_miasto VARCHAR (100),
d_uwagi TEXT
)

and sqlitestudio after click to 'populate table'
show me dialog with names of columns and checkboxes together. i choose what column to populate with random values.
e.g. i checked d_fax and d_nip, then
sqlitestudio creates populating query like:
insert into 'dostawca' (d_fax, d_nip) values ('xxx','yyy')
how many times? give me textbox to write this:) on the same form:)

of course if any constraints will accour then exit populating to give chance to change definition of columns set:)

Googie - Pią Paź 05, 2007 6:39 pm
" />aha, noted...

Wiaz - Pon Paź 08, 2007 8:24 am
" />maybe not exactly random, maybe numerated? for example: if ciolumn name is "telephon" then populate this column with:
telephon1
telephon2
... etc ?
cause random maybe wrong idea if i have something like: 'jsdhbgudfhbv' instead of 'telephone342'.
Hmm dont know what about integer and float values? maybe numerated too? dont know, really, but populate tool will be very usefull if i've gopt new app i'm working on, and would like to check functionality of it.

Wiaz - Pon Paź 08, 2007 8:39 am
" />one more thought:
with every column add one textbox to give possibility write value to populate with, if someone doesn't want automatic populate this column, for example if i have some reference field and want to fill it with known value but the other columns can be automatic/random/enumarated.

e.g. one row at form would have:
---name fo column, checkbox, textbox

name of column it is known what for,
checkbox to include this column with populating query (INSERT)
textbox if null or "" then populate with autovalue if not then populate with given value in textbox.

Googie - Czw Paź 11, 2007 7:40 am
" />Ok, but this feature goes to 1.1, since currently I'm working to stabilize 1.0 and release final version.

Wiaz - Czw Paź 11, 2007 8:11 am
" />Thanx! it would be a very helpful feature for me!

Googie - Wto Lis 04, 2008 11:03 pm
" />Done (in version 1.1, which I'm still developing).

It's done using quiet simple plugins engine, with few plugins included by default (random characters, words from file, numeric sequences, random numbers, constant-defined value).

Writting plugin will be described in documentation.

Wiaz - Wto Gru 23, 2008 10:09 pm
" />Wow!
Thanx!
It was long long time, i had to leave using sqlite for long time, cause i changed job, but i'm still looking.... still looking... and interested in it
lots of things have changed:) my job, lack of time and now i'm a linux user:) learning now tcl/tk but it is only hobby, my new job is totally different from programming and far far away from that pity but real life

Googie - Wto Gru 23, 2008 11:58 pm
" />Congratulations on your new jub, I hope it satisfies you.

Feel free to ask anything about tcl/tk (but please to ask on Patches or Chat forum).

If you learn Tcl some more, you could write Populating or SQL Code Formatting plugins by yourself

Darmowy hosting zapewnia PRV.PL