Thanks a lot......Re: Can I insert into beginning of Table than end of Table

[Vasanta <vtanna1@...>]

Thanks a lot. I drop idea of merging new log.

 

 

On Fri, Feb 5, 2010 at 11:41 AM, Vasanta <vtanna1@gmail.com> wrote:

Thanks, this may be simple thing, may be my explanation not clear.

 eventLog saved into flash file, board gets reboots, then saved file gets imported into database table, I have ROWID from 1 to 1000, because of board boot, I have new eventLog, again for this new ne, ROWID starts from 1 to 100, this new one overwrites all those first 100 which are from imported file, can I appnd instead overwrite?.

 

On Fri, Feb 5, 2010 at 10:43 AM, dcharno <dcharno@comcast.net> wrote:

Vasanta wrote:

I found this string in sql file, does lua accepts "AFTER" instead "BEFORE"?
 CREATE TRIGGER "fk_eventLog_component_ins_on_eventLog" BEFORE INSERT ON eventLog FOR EACH ROW

As several people have politely pointed out your questions have to do with SQL not Lua.  Try asking people in your company who might know something about SQL, look for a friendly SQL forum or consider hiring a consultant to help you.