Begrænsninger i tabeller og forespørgsler

Der er mig bekendt de samme begrænsninger i antallet af felter som kan returneres i en forespørgsel :o(

Grænsen er 255 for at være helt præcis

>jensen 363. Undskyld hvad er det lige du siger til mig der?

Ok, kan du henvise til dokumentation?

Jeg fortæller dig, hvor mange felter/kolonner der kan være bag en forespørgsel, er det ikke det du efterspørger ????

http://office.microsoft.com/da-dk/assistance/HP051868081030.aspx

Trine, if you need more than 255 field son one form then I have a feeling that you have a design problem. If the database is normalized then this very likley would leed to a main form with one or more sub forms. In all my 20+ years as a programmer I havnet yet hit the limit.

If for some reason you do need more than 255 then make a related table and then have two suub forms on your main form so that it just looks like one form

>Jensen363, Tak for hjælpen, det var lige det link, jeg skulle bruge.
>Terry, Hi Terry, I started up with af TabControl, dividing up into tabs with subforms on, but I couldn't get it to work, with my "search form", so now I'm back to a main form with a query behind that covers all data. I would be very happy if you could look at it sometime. Maybe I should make a new question. Mvh. Trine

Anytime :o)

Jeg står også gerne til rådighed for hjælp med normalisering

I can take a look and make some suggestions. If you have a requirement specification then that could help too.

>Terry, I would appreciate that, but I will of course try to work some more on it myself first. Requirement specification, yeah right, when I took my Datamatiker uddannelse I worked with them, but the few times I have seen them in real life, they have been insufficient and not worth the paper they were written on. (Maybe if I ever reach to your knees in knowledge I will be so lucky to see some good ones). It's as if the users make up new demands and fields and tables as we get along. Not that it bothers me at all. I just try to solve it along the way, and it's quite exciting too. This db I think it's quite normalized, it's just there are really many informations that hangs directly together with the "Project Number", so the way I see it I have to divide up into one to one relations for the sake of "overskuelighed".I will try the model with a TabControl with subforms connected to the different tabs once more and if it doesn't work out I will haunt you again, I presume you've got the same email adress as earlier. Best regards Trine

Hi Trine
I agree that its not very often one see's good documentation and I must admit that its not always something I've been very good at either. But over the years I've found that having one does have a number of advantages.

Yes I still have the same email. I'de better warn you though, that I'm rather busty so I may not be able to respond promptly, but I can promise that I will.

mvh
Terry

"I'm rather busty"!!!

Sorry, better change that to "I'm rather busy" :o)