Article View: borland.public.vdbase.data.sql
Article #1268Re: Displaying only certain records in a SQL
From: David McCullough
Date: Thu, 26 Mar 1998 00:00
Date: Thu, 26 Mar 1998 00:00
24 lines
1618 bytes
1618 bytes
Thanks Bowen I'll try doing a temp. file. However I don't know if one table is enough. I read where a table can have 1,024 fields. However when I tried adding fileds to one large table the last few fields would always end up with 0 characters. The only way to get the field on the database was to shorten some of the other fields. How many BYTES can one record have? Bowen Moursund < wrote in message <6fclqs$jm819@forums.borland.com>... >>I have a report I am trying to pull from a query but I can not get it to >>work. I used the SQL wizard but it takes forever and includes everything. > >Yea, joins of local tables can be agonizingly slow. You should consider >linking the tables via indexName, masterRowset, and masterFields, rather >than joining them, or perhaps even building a temporary table if the set of >records is limited. >____ >Bowen Moursund (TeamB) >bowenNOSPAM@nerds.com >http://www.mindspring.com/~bowenm/datatech.htm >Try these help resources: > http://forumsearch.borland.com:88 > http://www.dejanews.com/home_ps.shtml >
Technical Details
Message-ID:
<6fe7jb$l8v12@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<6f9cnm$gj03@forums.borland.com> <6fclqs$jm819@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ff5a1,c1e1fa092e4d4c4d X-Google-Attributes: gidff5a1,public From: "David McCullough" <72223.2320@compuserve.com> Subject: Re: Displaying only certain records in a SQL Date: 1998/03/26 Message-ID: <6fe7jb$l8v12@forums.borland.com> X-Deja-AN: 337978974 References: <6f9cnm$gj03@forums.borland.com> <6fclqs$jm819@forums.borland.com> X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4 Organization: Another Netscape Collabra Server User Newsgroups: borland.public.vdbase.data.sql