Re: [prog] Objet RowSet vs ResultSet - François Breizh - org.openoffice.fr.prog

2 messages in org.openoffice.fr.progRe: [prog] Objet RowSet vs ResultSet

From	Sent On	Attachments
Thibault Vataire	Jul 31, 2009 2:47 am
François Breizh	Jul 31, 2009 4:37 am

	Permalink for this message Paste this link in email or IM:
	Permalink for this thread Paste this link in email or IM:
	Atom feed for this thread Paste this URL into your reader:

Subject:	Re: [prog] Objet RowSet vs ResultSet	Actions...
From:	François Breizh (fran...@orange.fr)
Date:	Jul 31, 2009 4:37:20 am
List:	org.openoffice.fr.prog

Thibault Vataire a écrit :

Bonjour,

Voici un exemple de mise à jour d'une table à partir d'un RowSet :

sub testRowset()

dim rowSet as object

rowSet = createUnoService("com.sun.star.sdb.RowSet") rowSet.DataSourceName = "fournisseurs_fruits" rowSet.commandType = com.sun.star.sdb.CommandType.COMMAND rowSet.command = "SELECT * FROM soc_prod" rowSet.execute() rowSet.moveToInsertRow() rowSet.updateString(rowSet.findColumn("id_societe"), 6) rowSet.updateString(rowSet.findColumn("id_produit"), 3) rowSet.insertRow()

end sub

Je me suis inspiré d'un exemple en Java du Developer's Guide trouvé à cette
adresse :

http://wiki.services.openoffice.org/wiki/Documentation/DevGuide/Database/Example:_Querying_the_Bibliography_Database

Cordialement,

T. Vataire

Trugare mad Merci beaucoup

	Start a set with this search
	Include this search in one of my sets
	Exclude this search from one of my sets
	Permalink to these results Paste this link in email or IM:
	Atom feed for tracking future search results Paste this URL into your reader: