Re: save edit

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

Article #808

Back to borland.public.vdbase.data.sql Previous Next

#808

From: Geoff Wass
Date: Wed, 22 Jul 1998 00:00

33 lines
1855 bytes

Christopher,

SQL does not offer a "rowcount() type option". If your SQL is fetching
13000+ records it might be time for a rethink of that you are doing.
:-)  How about one of these options?

1 ) Execute your SQL. Then COPY TO workFile. Then alter your .QBE so
that it links now to the workFile. The SQL will then have finished
executing and you will not have to be fetching so much data in your
forms.

2 ) Find another way to alter your .QBE so that it gets the info that is
currently provided by your SQL query. This would eliminate the SQL
altogether and may result in the fastest response time since in option
(1) above you have to fetch all the records /and/ copy them.

3 ) fudge things with GO TOP (etc.) as you have been trying so far.

I hope this helps.

--
Geoff Wass
Kuala Lumpur, Malaysia


=============================================================
Please respond to a newsgroup posting by posting a reply (not e-mail).
In this way, all can help and all can learn!

Report Inprise/Borland bugs!
http://www.inprise.com/devsupport/bugs/bug_reports.html
=============================================================
Triumph is in the first syllable.

Technical Details

Message-ID: <35B577D2.9C8F9D9@ibm.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References:

<6p0aii$imb1@forums.borland.com> <35B40F11.8585C319@ibm.net> <6p2a1l$k6k8@forums.borland.com> <6p2ldo$k7225@forums.borland.com> <6p2oo2$kpr2@forums.borland.com> <6p2qpb$kq46@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,c364cf3d28110e2f
X-Google-Attributes: gidff5a1,public
From: Geoff Wass <gswass@ibm.net>
Subject: Re: save edit
Date: 1998/07/22
Message-ID: <35B577D2.9C8F9D9@ibm.net>
X-Deja-AN: 373742681
Content-Transfer-Encoding: 7bit
References: <6p0aii$imb1@forums.borland.com> <35B40F11.8585C319@ibm.net> <6p2a1l$k6k8@forums.borland.com> <6p2ldo$k7225@forums.borland.com> <6p2oo2$kpr2@forums.borland.com> <6p2qpb$kq46@forums.borland.com>
Content-Type: text/plain; charset=us-ascii
Organization: Noordindarus Consultancy Sdn. Bhd.
Mime-Version: 1.0
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message