"Simple" SQL on Openbase problem
"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.