Hi Paul. EOUtilities.rawRowsForSQL( EOEditingContext, String, String, NSArray ) ?
Cheers, - hugi On 7.4.2014, at 04:23, Paul Hoadley <[email protected]> wrote: > Hello, > > I'm using PostgreSQL. As part of a migration, I want to add a column to an > existing table, create a sequence, populate the column from elsewhere, and > then set the sequence to start at the maximum of the initial values just used > to populate that column. (The sequence will then be used to provide future > values for that column.) To set the sequence, I need to execute: > > SELECT setval('job_our_ref_seq', (SELECT max(our_ref) FROM job)); > > ERXJDBCUtilities.executeUpdate() doesn't seem happy about executing a SELECT > (and getting a result). This is the best I could come up with: > > ERXJDBCUtilities.executeQuery(database.adaptorChannel(), > "SELECT setval('" + Job.OUR_REF_SEQ_NAME > + "', (SELECT max(our_ref) FROM job))", > new ERXJDBCUtilities.IResultSetDelegate() { > @Override > public void processResultSet( > EOAdaptorChannel adaptorChannel, ResultSet rs) > throws Exception { > return; > } > }); > > While that works, it seems unwieldy—I just want to discard the result. Is > there a better way? > > > -- > Paul Hoadley > http://logicsquad.net/ > > > _______________________________________________ > Do not post admin requests to the list. They will be ignored. > Webobjects-dev mailing list ([email protected]) > Help/Unsubscribe/Update your Subscription: > https://lists.apple.com/mailman/options/webobjects-dev/hugi%40karlmenn.is > > This email sent to [email protected]
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: https://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
