franc,ais/esperanto/english
le code suivant me permet d'ajouter des lignes nouvelles dans une table/
la sekvonta kodo aldonas linioj en tablo/
the following code effectively adds lines in a table
/#ecrire les valeurs dans le fichier etiquettes/
de.enable()
de.setmode_insertrow()
de.column_by_name("susg").set_asstring(susg)
de.column_by_name("adr1g").set_asstring(adr1g)
de.column_by_name("adr2g").set_asstring(adr2g)
de.column_by_name("ccg").set_asstring(ccg)
de.column_by_name("pag").set_asstring(pag)
de.column_by_name("expg").set_asstring(expg)
de.column_by_name("susd").set_asstring(susd)
de.column_by_name("adr1d").set_asstring(adr1d)
de.column_by_name("adr2d").set_asstring(adr2d)
de.column_by_name("ccd").set_asstring(ccd)
de.column_by_name("pad").set_asstring(pad)
de.column_by_name("expd").set_asstring(expd)
de.disable()
demandez-moi plus de de'tails au besoin
petu min pli etaj^ojn se necesas
ask me for further information if requested.
Robert Wood skribis :
Hi all,
I've learned lots now, including how to insert data into a table from a
form. I can now click a button on a form which writes data in some
linedits and comboboxes on a form into a table. However, unless I put a
second button on the form and assign insert row, the SQL just overwrites
the first row in the table I'm writing to.
As a very simple example I have a form with a lineditfield whose
datasource is author_table (0) and column is author_name.I launch the
form, the lineeditfield has the first entry in author_table. I put the
following code into the button press for the inserting data into the table.
db=hk_thisform.database()
sourcetable=db.new_table("author_table")
sourcetable.enable()
sourcetable.setmode_insertrow()
(For sake of completeness, the following code does write data to the
table, but just overwrites the first line of the table.)
filtervalue1=hk_thisform.get_pyvisible("author_name_input").value()
sqlstring = "INSERT INTO author_table (author_name) VALUES (" +
filtervalue1 + ");"
db=hk_thisform.database()
query=db.new_actionquery()
query.set_sql(sqlstring)
status=query.execute()
I realise you can click the button at the bottom of the form to insert
new row, but this will be for non-computer people to use, so I need to
make it foolproof.
Is there something I can put in before the script that inserts the data,
to insert a new row before writing the data into the table and
overwriting existing data?
Many thanks,
Rob
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2008.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Hk-classes-discuss mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/hk-classes-discuss
