Re: Joining 2 DataTables



On May 12, 11:29 pm, GroupReader <newsgroups...@xxxxxxxxxxx> wrote:
I agree w/ George... and doing it on the DB side is the better
option. If using "UNION", be careful... you probably want "UNION ALL"
instead.

The union would not work unfortunately because it is using the same
database.
It is completely dependant on what the user actually inputs into the
screen as to what I am adding to the grid.
Basically there are 2 distinct types on data for the grid, and they
can't be mixed up. So I was just going to create separate datatables
and then merge them together.
It seems like I will have to just try the looping or the merge
method , because I don't think that it will work any other way
really.
Thanks guys!

.



Relevant Pages

  • Re: CursorAdapter, MySQL - View definition has been changed.
    ... table that still cause this error message. ... a memo field in a grid. ... I am doing a union of 2 tables where not all of the fields are common ... In my MySQL database the Comment ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Grids... simple, but I dont know...
    ... again and re-created the grid. ... The vehicle they enter on ... In the command window, open your database (but not your view, ... putting "myview" in the data environment, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Grids... simple, but I dont know...
    ... had to be something fundamental in the grid setup... ... The vehicle they enter on the ... order of the fields I want, using MYVIEW as the table, and also to ... In the command window, open your database (but not your view, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Grids... simple, but I dont know...
    ... That's all a grid is. ... Since your view works in the command window but not in your form, ... With vehicle 120, I should have 3 records worth of data. ... In the command window, open your database (but not your view, ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Grids... simple, but I dont know...
    ... I'm not sure where "the report" comes in, but we're talking about a grid on ... First formasks for vehicle number. ... In the command window, open your database. ... I created it putting "myview" ...
    (microsoft.public.fox.programmer.exchange)