Lattice.SPGen is a stored procedure generator that supports Microsoft SQL Server, Oracle and IBM DB2 UDB. Lattice.SPGen will process each table and view in the database which you selected and created stored procedures to insert, update, delete, select (single or multiple records) using the fields you choose as well as using stored procedure’s name you desire. Below is how it works:
1. Collect metadata from different datasource(Oracle, DB2, SQL Server)
2. Build xml metadata input definition file
3. Generate stored procedures using xslt with different xsl stlysheet.
Features added in version 1.3
* Option to generate business entity class per table
* Option to generate one big sql script file or each file per table
* Option to generate XML metadata definition file
Main features:
* Control output stored procedures format in runtime by modifying XSL style sheet.
* Change stored procedure’s name, exclude stored procedure’s columns on the fly.
* Auto-generate package header and body for Oracle.
* Auto-generate stored procedures to insert data rows and return identity id for SQL server and sequence number for Oracle.
* Auto-generate stored procedures to select, update, delete single data row based on primary key definitions.
* Auto-generate stored procedures to select all rows based on foreign key definitions.
* Auto-generate stored procedures to select all rows of tables and views.
* Support composite primary key
Lattice.SPGen 1.3 supports the following RDBMS:
* MS SQL Server 2000 and 7, MSDE 2000.
* Oracle 8i and 9i.
* IBM DB2 UDB
Below is the link to download the software:
http://www.latticesoft.com/DesktopDefault.aspx?tabindex=4&tabid=13
Lattice Business Software
http://www.latticesoft.com
Most downloaded programs from this category:
-Cutter 1.42 (203)
Cutter v.1.42 does the calculation and making of the patterns of waistline garments, namely skirts,skirt-pants, lady's and men's pants and jeans, men's loose-fitting pants according to custom measurements with the following printout of the patterns. -lingo script editor 0.42 (139)
lingo scriptEditor is an external authoring tool for macromedia lingo -4TOPS Excel Import to Access XP/03 6.0 (136)
4TOPS Excel Import Assistant is an MS Access add-in which helps import Excel to Access in a controlled way. -Java Help 2.0 (120)
Java Help 2.0 -KernelCAD .NET v1.2 (119)
Displays and modifies 3D models as an embedded component of Windows application -exeJ 1.01 (114)
Create a batch-like executable (.exe file) for your java application. -Shareware Name Analyzer 1.0 (110)
Shareware name analysis tool to help you don't name duplicate name as another software. Easy to find if there is existed / duplicate software name in 30000 software library. Also offers word frequency of your software name in all the 30000 software. -KernelCAD Pro v1.2.2229 (110)
Displays and modifies 3D models as an embedded component of Windows application -KernelCAD Software v1.2.2229 (110)
Displays and modifies 3D models as an embedded component of Windows application -GetFramework.Net 1.0 (108)
GetFramework.Net was created to fill a void for application developers that build for the Microsoft .Net Framework.
Download most popular:
-Macromedia Flash Player 8 (1895)
Flash plays small, fast multimedia buttons, as well as interactive animations, flying logos, and graphics created in Macromedia Flash -Invincible 1.0 by Xtry (1891)
Invincible Script (First Public Release) by Xtry is using mIRC 6.12. The Best ALL AROUND Script you'll ever see -Macromedia Dreamweaver 8.0 (990)
The best HTML editor for professionals web design. -Ebless ScripT v8 by Ebless (685)
Stop Flood, Kicks Clones, Repeating, Mass Join, Adversising, Text Flood, Action Flood, Notice Flood, Swearing, Open Proxy, Black List, Fliter Kick, Join Part, Phone Numbers, Ban Protection. ControL lmits +l , DALnet Commands, BLocked Advertising. -ClanBoT v1 by dAc^Murderer (430)
Channel Bot This is an mirc bot made specifically for clans. -GodFather 3.0 by Kenzo (406)
it have many dialogs,war mode,fun mode,scanners,checkers and alot of things check it out. -PHPTriad 2.2.1 (401)
A complete PHP development and server environment for Windows -K.I.T.T. 2005 2.05f by Dmonn (392)
With many protections and tons of entertainment. Now With NEW Trivia! Over 4000 Trivia Questions Built In! -Macromedia Flash MX 2004 (366)
Macromedia Flash MX is a robust environment for developing online advertising, user interfaces, and multimedia content. -DreamBot IRC Bot 5.1 by MrZipen (335)
DreamBot IRC Bot is a cool mIRC based IRC bot
