🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.vdbase.data.sql
Article #1268

Re: Displaying only certain records in a SQL

#1268
From: David McCullough
Date: Thu, 26 Mar 1998 00:00
24 lines
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-mail
References: <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