RE: [DUG]: Coping with large datasets

1999-03-14 Thread Carl Reynolds
Hi Greg. Have you tried using a ClientDataSet? If you're not familiar with them then I recommend looking at the Demos/MIDAS/Aggregate project as an initial training session. The PacketRecords property enables navigating exactly as you describe (records are supplied on demand, you dictate the

Re: [DUG]: COM and DCOM

1999-03-14 Thread Paul Lowman
Thanks very much - it seems to be just the job. By the way URL is http://www.execpc.com/~dmiser ... -Original Message-From: [EMAIL PROTECTED] [EMAIL PROTECTED]To: Multiple recipients of list delphi [EMAIL PROTECTED]Date: Friday, 12 March 1999 13:01Subject:

RE: [DUG]: SQL Query...

1999-03-14 Thread BJ Wilson
The syntax you gave is almost correct. You have to make sure that the query is going to return a matching number of fields (with matching types for the table). It's a good idea to explicitly name the fields. e.g. INSERT INTO MY_TABLE (MY_FIELD1, MY_FIELD2) SELECT MY_FIELD3, MY_FIELD4 FROM

RE: [DUG]: SQL Query...

1999-03-14 Thread Struan Judd
Mark, Yes. The Syntax is INSERT INTO table1 SELECT * FROM table2 This assumes that the two tables have the same number of fields and compatible types. If not you need to specify either a field list in the insert, ie: INSERT INTO table1 ( field1, field2, ... ) SELECT * FROM table2

RE: [DUG]: dbf indexes

1999-03-14 Thread Duane Atkins
It's been a while since I used Clipper or dBase files but I seem to remember that you can use xBase functions in the expression to build the index. ie 'fld1 + str(fld2,5) + fld3' should work if you create the index in database desktop. Cheers Duane. -Original Message- From: Stephen

RE: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Belding
Russell wrote This reply is from a pragmatic Crystal Reports user not from someone who knows Crystal internals well. I'm using the Crystal Reports Print Engine 16 from a D1 application and some reports requiring a date range or name of person it brings back all records to the client pc for

RE: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Paul Ritchie
Someone earlier said CR7 does server side filtering. The manual says this is new to CR7. CR can export to RTF faily well but it cannot export correctly to MS Word preserving all the formatting... Is that generally a requirement of report writers?

RE: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Belding
At 13:36 15/03/99 +1300, you wrote: Someone earlier said CR7 does server side filtering. The manual says this is new to CR7. CR can export to RTF faily well but it cannot export correctly to MS Word preserving all the formatting... Is that generally a

Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Mark Derricutt
Tony wrote: nice simple report builder to hand on to my customers instead of Crystal, but there does not appear to be much out there. As Steve points out, if Report Builder Pro provides a very nice royalty free end-user report designer. Report formats can be stored in BLOB fields inside a

Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Tony Blomfield
Fair enough... So I'm preparing to shift my 16 bit apps report package into a D4 program and this will mean having two bde's installed on each clients server. One for the app and one for its reporting package. Regards Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER.

Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Belding
At 13:46 15/03/99 +1300, you wrote: Report Builder Pro provides a very nice royalty free end-user report designer. Report formats can be stored in BLOB fields inside a database which is very handy, or also saved to disk. The report designer has -full- query-by-example editors so that you're

Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)

1999-03-14 Thread Belding
We are using CR6 on Access (900 MB) and MS SQL Server 6.5 databases up to 1.2Gb with no problems. So can you please let us in on the secret, How do you get a report to run in a reasonable time where you have a join involving say 8 tables (not an unreasonable number) accross a 900MB DB, where

[DUG]: resource hungry ComboBox

1999-03-14 Thread Neil Anderson
Hi Does anyone know why the TCombox component is so resource hungry and what the solution is ? I monitored the system resources and created forms witth 100 controls and received the following results : 100 TCombobox used53% of user resources 100 TListboxes used33%

RE: [DUG]: resource hungry ComboBox

1999-03-14 Thread Myles Penlington
What was the Delphi version and Platform (NT/Win95/Win98/3.1)?? Hope you are talking about Win3.1 D1? -Original Message- From: Neil Anderson [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 15, 1999 4:45 PM To: Multiple recipients of list delphi Subject:[DUG]: resource

RE: [DUG]: resource hungry ComboBox

1999-03-14 Thread Neil Anderson
These results were on Win 98 and D3.02, I was running the resource meter from Dr Bob's web site. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, March 15, 1999 5:22 PM To: '[EMAIL PROTECTED]' Subject: RE: [DUG]: resource hungry ComboBox