• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
"Simple" SQL on Openbase problem
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

"Simple" SQL on Openbase problem


  • Subject: "Simple" SQL on Openbase problem
  • From: Ray Ackland <email@hidden>
  • Date: Fri, 18 Apr 2003 17:47:24 +1200

I have what should be a simple query I wish to perform. I prefer to do it as a SQL query rather than using Enterprise objects due to the large number of records involved and the simple nature of the operation.

My goal is to take a single table which has one field used as a counter (ie groups of records in this table share a common value in this counter field).

Occasionally I wish to duplicate the group of records with a certain (highest) counter value and increment the counter value for the newly created records.

The only problem is I can't figure out how to do it. Many times I have read the OpenBase_7.0.pdf document from OpenBase's web site, but find the documentation to be somewhat substandard.

Can anyone provide suggestions to what should be a straight forward query? I do not need the query to automatically find the highest value as I am only having the problem with the inserting part of the command.

Ray.
_______________________________________________
webobjects-dev mailing list | email@hidden
Help/Unsubscribe/Archives: http://www.lists.apple.com/mailman/listinfo/webobjects-dev
Do not post admin requests to the list. They will be ignored.

  • Prev by Date: packages and WOBuilder keys
  • Next by Date: Re: packages and WOBuilder keys
  • Previous by thread: Re: packages and WOBuilder keys
  • Next by thread: Populating a WOPopUpButton
  • Index(es):
    • Date
    • Thread