Re: [Treebase-devel] [Treebase-guts] SF.net SVN: treebase:[687] trunk/treebase-core/db/cleaning

[Hilmar L. <hl...@ne...>]

On Apr 15, 2010, at 12:04 PM, William Piel wrote:

> Absolutely -- however in some cases we use the new ID as FK for  
> another insert or update. So those cases would have be be filtered  
> out, and perhaps put in a perl script where "get last id" can be  
> stored in a scalar for use in subsequent statements.  (So... yet  
> another advantage of Navicat is that I get to see the autogenerated  
> id right away for use in subsequent edits).

Bill - this can all be scripted in SQL only. No Perl needed. We can  
talk about how.

	-hilmar

-- 
===========================================================
: Hilmar Lapp  -:- Durham, NC -:- informatics.nescent.org :
===========================================================