Quote:
>First I am relitively new to VB. I have a small database of names
>address and other misc stuff. Within this table I have 60 fields
>downline1-downline60. My SQL works within Access 2.0 (Compatibility done
>suscessfuly) but with VB my SQLStatement will not fit on one row.
>"SELECT DISTINCTROW TableA.IDName, TableA.Downline1 /stuff cut
>out/TableA.Downline60 FROM TableA WHERE TableA.IDName ='" text1.text "'"
>Also what would be the best way to put these (downlines) into a list?
RE: your sql statement - try: "SELECT DISTINCTROW * FROM TableA WHERE
TableA.IDName ='" text1.text "'"
RE: your database design & need for the downlines in a list - what are you
going to do when you need to add downline61 (change _everything_ that refers
to downlines)? how are you going to search for IDNames with a particular
downline (select * from tablea where downline1 = x or downline2 = x or
downline3 = x...)?
THIS CALLS FOR NORMALIZING YOUR DATA!
Try adding a new table, with primary key of: IDName, IDDownline (counter) and
data of: Downline_data
________________________________________________________________________
Ayn Shipley, Toronto, Ontario | Prevent computer viruses... |
SELECT DISTINCTROW?