Re: Adding a blank row to a datatable

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Roy,

Thats doesn;t really make sense. One of the primary tenants of a relational
databases is the the order of the rows is unimportant. Secondly why would
you want to store NOTHING?

If this is for some kind of output/report then you'd be better of telling
us what you're doing so we can advise with a another code based strategy.
If you want to stick with your blank row then you'll be relying on
inserting NULLs /and or white space. This will not be possible however if
your Id column is autonumbered/incrementing.

This will still not get you around any sorting however because this null
row will be placed at either the top or the bottom when sorted.

Richard

"Roy" <Roy@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:A3B8E9FC-4CEA-412F-8E11-02BE696C5668@xxxxxxxxxxxxxxxx
> Hi all,
> I do have a datatable that looks like:
> id Number Description
> 1 1 Desc1
> 2 1 Desc2
> 3 2 Desc3
> I need this datatable looks like (with 4 rows which the third one is
blank):
> id Number Description
> 1 1 Desc1
> 2 1 Desc2
>
> 3 2 Desc3
> Any suggestions would be appreciated.
> Roy
>


.

Relevant Pages

  • Project help
    ... as possible but thats my headache but i really want to put databases. ... PS - i'd considered making a pseudo-firewall but thats not a good ... option in Java. ...
    (comp.lang.java.help)
  • Re: How to start mysql at boot time?
    ... oh yes thats official around here:)) ... Unless you want to risk corruption of your databases. ...
    (comp.unix.bsd.openbsd.misc)