Hello Dan/Jim, > On Thursday May 31 2007 11:58 pm, Jim Suttie wrote: >> After searching all the OO documentation I can get my hands on I >> cannot find any reference to my problem. I have programmed in >> dBase2 and up, Basic, VB, and can do this with no problem. >> >> In Base what I need to do is to read a db field, put the data into >> a variable (using a user defined macro with basic I presume), >> manipulate (concatenate info) the variable then place it back down >> into a field. Is it possible? I'm at wits end. >> Thanks Anyone, >> jim
not sure if this has been answered in [EMAIL PROTECTED] (which I don't read) already ... Not sure which background you already have with StarBasic and UNO ... Something along those lines should do: oRowSet = createUnoService( "com.sun.star.sdb.RowSet" ) oRowset.DataSource = "Bibliography" ' note that this might also be a file:// URL to the .odb file oRowSet.Command = "biblio" oRowSet.CommandType = com.sun.star.sdb.CommandType.TABLE On Error Goto cleanup oRowSet.execute() oRowSet.next ' now on the first record nColumnPos = oRowSet.findColumn( "Identifier" ) sSomeValue = oRowSet.getString( nColumnPos ) oRowSet.updateString( nColumnPos, "SomeNewIdent" ) oRowSet.updateRow cleanup: oRowSet.dispose() For more details, more detailed questions are needed :) (in [EMAIL PROTECTED], preferrably) Ciao Frank -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]