Re: [DUG]: PDF Components
Hi Jeremy I looked a the component. It is far too primitive for my needs, which are to print Report Builder pages to PDFs. If you want to "print anything printable to a PDF" there are two options I am aware of. Adobe Acrobat or Amyuni's PDF Converter development kit. www.amyuni.com. Both are expensive. Regards Russell - Original Message - From: "vss" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Wednesday, October 24, 2001 10:04 AM Subject: [DUG]: PDF Components > Hi all. > For those of you hwo have downloaded that PDF component and have looked > at it, what did you think ? > > Cheers,Jeremy Coulter > > > -- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ > > --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi" Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
Re: [DUG]: Interbase Desktop
Hello Ian
I also use IBadmin and every problem I have seen with it has been repaired
withing 3 days by Pavel Kutakov. The issues you refer to sound very serious.
("ocassional it lets you do changes to triggers and procedures it shouldnt
and can corupt the DB" ) Have you informed [EMAIL PROTECTED]
of these errors?
Are you using the latest build? (build 3.2.12.470)
I find IBAdmin excellent, and wish I had known of it earlier. It would have
saved me many days.
Regards
Russell Belding
- Original Message -
From: "Ian Fear" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Friday, September 14, 2001 9:58 AM
Subject: Re: [DUG]: Interbase Desktop
> On 14 Sep 2001, at 9:33, James Sugrue wrote:
> We use a Program called IBAdmin for this stuff , lets us do lots of cool
stuff but we are
> verycautious not to use it on a live database as ocassional it lets you do
changes to triggers and
> procedures it shouldnt and can corupt the DB but it includes visual table
buildes, and can take
> metadata and create a relationship diagram etc on the Whole Well worth it.
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
D6 Timestamp Error: was [DUG]: Delphi 5 & 6...
On the D6 Timestamp error. The following is a quote from a posting by Jeff Overcash of "TeamB": " D6 has a problem with MSecsToTimeStamp in that if you have MSecs less than a days worth the returned TimeStamp is invalid and TimeStampToDateTime will raise an EConvertError on the returned TimeStamp. ..." Perhaps a Borland staff member can elaborate? One would guess Borland will issue a caution and workaround soon. Regards Russell - Original Message - From: Trevor Jones To: Multiple recipients of list delphi Sent: Friday, July 20, 2001 1:53 PM Subject: Re: [DUG]: Delphi 5 & 6... I have 4, 5, and 6 all installed on the same machine. The only problem I have is with D6 itself: BEWARE if you use TTimeFields in your database you may run into problems. Certainly with IBXpress TTimeFields are currently broken. There is a workaround but not if you use packages.
Re: [DUG]: Delphi and IBX vs IBO
Hello Sandeep Gary has pointed out that Interbase Objects with its TIBOxxx components support Delphi TDataset / TDatasource controls. At www.kylecordes.com/bag/sol/ibobjects.html is a partial list of controls IBObjects supports. These include Report Builder (Digital-Metaphors), ReportPrinter (Nevrona), InfoPower, Orpheus. Regards Russell - Original Message - From: Sandeep <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Sent: Friday, November 24, 2000 3:24 PM Subject: Re: [DUG]: Delphi and IBX vs IBO > I don't think IBX is good enough yet to do some serious > development. IBO on other hand has a proven track record and has > a lot of components to go with it. But they don't work with standard > controls. > You also have option of using FIB components. > > I think the best option will be to stick to IBX as it will improve, and > it doesn't require specific controls work to work with. > > Sandeep > > -- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > > --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
[DUG]: Delphi and IBX vs IBO
Hello Team Delphi I am moving a Delphi - BDE - Paradox application to another level. I hope to replace the BDE and with Interbase and some connection components, particularly now IB6 incurs no license fees. The way the application and its controls connect to IB is the first issue I want to settle. Borland is developing IBX and Jason Wharton has Interbase Objects (IBO) in use in many applications. IBO seems to be well ahead of IBX today. The paper www.interbase2000.org/WhitePaper/connectivity.htm indicates this is gap. Are there other established connectivity options? I have not found any example of best practice code using IBX. There seem to be no examples in the Borland sites. Probably I have missed them. Your comments would be appreciated. Regards Russell Belding --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
Re: [DUG]: Shared BDE installation on network
Hello Patrick I am using the same idea for two projects. One a forms package for making various NZ forms, the other for an Engine Trending program for the US Navy's P3 Orion and C130 Hercules planes. Each package has a server and a client installation described on half a page each. On the server the BDE, the Pdox files and the Applications are placed. On the client lines are put into the registry for the BDE parameters. Disk space consumed on the client is about 2K. I also take care to ensure no existing BDEs are overwritten. Alias installation is also handled. My reason for doing this is when either package is used in a multi-user place there is only one serious installation required, that of the server installation. The client side is installed easily by running a program residing on the server at the client pc. Making the installation as simple as possible is important. The software for handling this BDE installation for each client was taken from some unsupported software at Borland, and modified, corrected as I recall. Regards Russell - Original Message - From: Patrick Dunford <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Sent: Tuesday, August 29, 2000 12:23 AM Subject: [DUG]: Shared BDE installation on network > > On the net at http://www.dbginc.com/whats_new/BDENet.html there is an > article about sharing the BDE from a network file server (no local > installs). Has anyone tried this technique? > > > Patrick Dunford, Christchurch, NZ > http://patrick.dunford.com/ > http://www.trainweb.org/enzedrail/ > > -- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > To UnSub, send email to: [EMAIL PROTECTED] > with body of "unsubscribe delphi" > --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of "unsubscribe delphi"
Re: [DUG]: Running D4 Professional on Win2000
I'm been running D5.01 Pro on Win 2000, Pro for many months. No problems. rb - Original Message - From: Myles Penlington <[EMAIL PROTECTED]> To: Multiple recipients of list delphi <[EMAIL PROTECTED]> Sent: Thursday, August 24, 2000 3:14 PM Subject: [DUG]: Running D4 Professional on Win2000 > Has anybody done this okay?? > > One of our developers is changing machines, and IT want to install Win2000 - > has anybody run in this configuration? Problems? > > Regards, > > Myles Penlington > Software Engineer > Advanced Management Systems Ltd > DDI 4885514 > > > > -- - > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Fw: D5.01 MDI child behaviour
Hi Patrick I once had some fish and got ill. But I still love fish 'n chips. > > Not use MDI. Have they fixed that nasty bug whereupon child windows are > minimised when not focused, and when activated the window can be seen > maximising itself? That has put me off MDI permanently. > Never seen this. Have seen other minor glitches. My App is naturally and MDI app. Russell --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
[DUG]: Fw: D5.01 MDI child behaviour
One way to solve this is upon opening the child check its Height and Width and if below the intended min values reset the min and Wd, Ht to min values. Any better ways? Russell - Original Message - From: Belding@belding To: [EMAIL PROTECTED] Sent: Thursday, August 24, 2000 11:11 PM Subject: D5.01 MDI child behaviour Anyone "been there and solved that" for this problem? I have an MDI app and the main form has TsizeConstraints all 0, so no constraints. An MDIChild window has constraints for Max/Min/Ht/Wd. When the child form is opened and the main form is large enough to accomodate the opening size of the child the child's constraints are respected during resizing. When the child form is opened and the main form has width and height smaller than the childs Min Ht, Wd constraints the childs original Min constraints are not respected. It appears the child's Min constraints were lowered. I can check this. I would like the child's original Min constraints to remain and for scroll bars to appear in the main form when a child opens if its Min constraints are larger than the main form's dimensions. At present a user would be justified in saying the child window looks awful when opened in case two. Any solutions? Thanks Russell
[DUG]: D5.01 MDI child behaviour
Anyone "been there and solved that" for this problem? I have an MDI app and the main form has TsizeConstraints all 0, so no constraints. An MDIChild window has constraints for Max/Min/Ht/Wd. When the child form is opened and the main form is large enough to accomodate the opening size of the child the child's constraints are respected during resizing. When the child form is opened and the main form has width and height smaller than the childs Min Ht, Wd constraints the childs original Min constraints are not respected. It appears the child's Min constraints were lowered. I can check this. I would like the child's original Min constraints to remain and for scroll bars to appear in the main form when a child opens if its Min constraints are larger than the main form's dimensions. At present a user would be justified in saying the child window looks awful when opened in case two. Any solutions? Thanks Russell
Re: [DUG]: Report on Auckland User Group Meeting
Max wrote > If there are any more questions about any of this stuff, or folks who > wants to discuss some of the design philosophy, just post on the group > here and Paul and I will do our best to explain what we did and why we did > it. And if any one in interested to download a demonstration of the > ProfaxWin Accounting product (research, interest or industrial espionage > all acceptable 8-) just ask and I find out where its currently hiding on > our web page. > Max, that is a kind offer! I would appreciate having a demo copy of your excellent product, specifically so I could refer to it from time to time searching for good UI ideas. Best wishes Russell Belding --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: IB6 for new IB users? Thanks.
Thanks to those who responded to my request for insight into IB6. Thanks Nic for the references. Thanks Max for the reference to Nevrona's Report Printer Pro. I did not know about this. Currently I'm using Report Builder Pro. Thanks Richard for comments. Do you know of a "Best Practice Using IB" type book? And thanks for the other comments. Russell Belding --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Report Builder
Jeremy The problem I refer to is the total report height is greater than the paper height. So yes the paper selection can cause this. Try it. The problem is easily manufacured at your development station using Preview only, no need to waste paper. Russell - Original Message - From: Jerermy Coulter To: Multiple recipients of list delphi Sent: Thursday, July 27, 2000 3:27 PM Subject: RE: [DUG]: Report Builder just a thought on your reply, would the paper type cause this overflow error ?? Jeremy -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jerermy CoulterSent: Thursday, July 27, 2000 3:22 PMTo: Multiple recipients of list delphiSubject: RE: [DUG]: Report Builder wellI am not sure, but sounds like the problem. We will alter and send another exe and see what happens. Thanks, Jeremy Coulter -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Belding ComputingSent: Thursday, July 27, 2000 2:50 PMTo: Multiple recipients of list delphiSubject: Re: [DUG]: Report Builder Jeremy This sort of behaviour can happen with RB when the report overflows its page. Not repeating a report but in the same report multiple pages are produced. The fault I describe is repaired by adjusting, typically shrinking, the band height. This is more of a page design fault than a bug. Is this the problem you see? A bug with RB is this. Drop a component onto the report. Rename the component. Then immediately click on the component before performing another operation. Crash. (RBPro v5.x). - Original Message - From: Jeremy Coulter To: Multiple recipients of list delphi Sent: Thursday, July 27, 2000 2:24 PM Subject: [DUG]: Report Builder HI all. Has anyome had any issues with Report Builder Pro when printing a number of documents, one document after another ? We have an issue in out auckland branch where our CEO prints one report, then another then another then another etc. and the report goes COMPLETELY mental. Its not a driver problem we have established that, but just ondered if anyone else has had this problem ? Cheers, Jeremy Coulter (Software Development Team Leader) Triton Commercial Systems 6A Burdale Street Riccarton Christchurch ( +64 3 3483973 Fax +64 3 3431613 http://www.tritoncomsys.com
Re: [DUG]: Report Builder
Jeremy This sort of behaviour can happen with RB when the report overflows its page. Not repeating a report but in the same report multiple pages are produced. The fault I describe is repaired by adjusting, typically shrinking, the band height. This is more of a page design fault than a bug. Is this the problem you see? A bug with RB is this. Drop a component onto the report. Rename the component. Then immediately click on the component before performing another operation. Crash. (RBPro v5.x). - Original Message - From: Jeremy Coulter To: Multiple recipients of list delphi Sent: Thursday, July 27, 2000 2:24 PM Subject: [DUG]: Report Builder HI all. Has anyome had any issues with Report Builder Pro when printing a number of documents, one document after another ? We have an issue in out auckland branch where our CEO prints one report, then another then another then another etc. and the report goes COMPLETELY mental. Its not a driver problem we have established that, but just ondered if anyone else has had this problem ? Cheers, Jeremy Coulter (Software Development Team Leader) Triton Commercial Systems 6A Burdale Street Riccarton Christchurch ( +64 3 3483973 Fax +64 3 3431613 http://www.tritoncomsys.com
[DUG]: IB6 for new IB users?
I am encouraged to look at IB now for modest size database applications and would value constructive comments on the following questions. What is the best source of information about IB6? A technical overview or detailed white paper would be helpful. (I opened the help file IB32.HLP with the IB6 ZIP download but stopped reading when I saw it was labelled IB ver 5.0.) Are there any fees to pay at any stage of development and deployment with an application using IB6? The published Borland Interbase Public License does not mention any explicitly. Can an IB6 application for a modest number of users (say 25 max) be developed and deployed using D5 professional, or is the D5 C/S version required? What report writer gets your vote for "best to use with IB6"? Best wishes Russell Belding --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Paradox repair
Hello Paradox users Here is one example of handling Paradox table maintenance and repair. The utility DLL supplied by Borland, TUtil32.DLL, (ver 5.??) supplies basic functionality. Alec Bergamini of O&A (www.o2a.com) supplies excellent software using TUtility and his documentation is the best I have seen describing Paradox features, problems and quirks. Using his DLL allows me to use the functionality without having to understand the details of TUtil32.DLL. (Why reinvent ...?) To use Alec's DLL you need a clean copy of your database files to serve as a reference. This is easily handled by keeping a copy of your database in a separate directory which is used only as a reference. I have written a TableFix program which uses Alec's work and requires one to supply three items: the name of a text file listing the tables of your active database, and alias' pointing to the working database and the reference copy of the database. Tablefix can be run to repair all the Paradox table errors I have seen. I am happy to give away copies of TableFix to anyone who has purchased Alec's package. Email me if interested. The last time I checked the TUtil32 DLL did not correctly handle Paradox field types of "Formatted Memo". If you are not using "paradox the development tool" you can bypass these types and use "Memo" for your Rich Text fields. Running a program to rebuild indices at the start of a program seems to be an unwise idea as rebuilding index files correctly usually requires exclusive use of database files by the repairing program. I would suggest running a repair program only when necessary. Regards > At 13:43 9/06/2000 +1200, Patrick wrote: >Quoting Mark Howard <[EMAIL PROTECTED]>: > > > Hi > > > > My users have had the occaisional problem with Paradox table and > > or index corruption - normally caused by a power outage or > > someone running a backup with the databse open. > > > > In the past I have been able to fix things most of the time by > > deleting the index files and then redefining the primary and > > secondary index's, using the DBD. > > > > This hasn't always worked - and hasn't in the current case. What > > is the best way of dealing with this problem? > >Basically you have 3 options: > >1. Buy a commercial product like TV which is done by Wade A. From memory it's >about $300. > >2. Use the freebie table repair utility on Borland's web site. > >3. Develop your own, preferably using components like the TTUtility component >set from Out & About www.o2a.com > >It may still be of course that the problem that your client has had can't be >repaired - and that is when backups are important. > > > > > Also, on a similar topic, would it be good, bad or indifferent > > practice to programatically delete and rebuild the index's each > > time the application opens, to keep them clean. (Or is that a > > dumb question?) > >I believe some people here do it, like Russell Belding. > > > > Can you repack tables programatically? How? > >You can use the TTutility components to do all sorts of things. >--- > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz Russell Belding Belding Computing http://www.belding.co.nz --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Read Only Aliases
At 20:37 15/07/1999 +1200, you wrote: > >We have had problems in some machines recently where BDE 3.5 has been >installed and then BDE 4.51 has been installed over it. > >In every case, the alias that was installed with BDE 3.5 appears to have >become "Read Only", that is to say the path (and possibly other settings) >cannot be changed. > >The only fix appears to be to remove and reinstall the BDE. Anyone have >knowledge of this? > Hello Patrick Are you looking at the old alias using the BDEADMINISTRATOR for the newer BDE? I have seen this problem before and here are a couple of comments. If the path to the old alias is not currently available try 1. enabling the path (turning on the pc the path points to) 2. deleting the entire path (yes sometime I've done this but been unable to delete the last char of the path) Try right clicking on the path and first opening the bdeadmin cfg file first. After doing this a read only alias has lost its read only status and allowed me to change it. Hope this helps. Russell Belding --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)
>> 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 any one of those table has >lets say 1 million rows, and Crystal returns T1 X T2 X T3..X T8 Rows in >the result set. > >I'd really like to know how you do this. > >I'd also like to know how you manage to stuff 900MB into access tables with >reliability, but thats another issue. Ah to hell with it, it's not worth the >argument. It may not be worth an argument but it is, I think, worth discussing. It would seem using CR6 with MS SQL 6.5 there is server side filtering, not client side filtering. >From Paul's description we don't know if the Access table has many records or large objects per record. Or the average peak number of concurrent users per week. Regards Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)
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 clients to get to your >data in any format they want. And you can also limit what they can see >(i.e. hide table names and give them end-user descriptions making things >very nice :) > That would be nice for some clients. >Russell wrote: > >> www.digital-metaphors.com and liked what I saw. > >On the downside, Report Builder Pro is quite sore on the wallet, about >NZ$500 from memory, but imho worth it. > The current price of RBPro is US$495 with source. See their WWW site. >> Exporting reports is not as simple as you indicate. I'm thinking about >> exporting reports to MSWord. CR can export to RTF faily well but it cannot >> export correctly to MS Word preserving all the formatting, for documents >> whose complexity is beyond that of RTF documents, but within Word 97 scope. >> Perhaps CR 6 and 7 have been improved; the CR tech team once told me >> something like "exporting 100% correctly to Word is in our too hard basket". > >For exporting to RTF/XLS/HTML with Report Builder, check out >http://www.waler.com. A simple third-party "output device". > This is a worry. Some add on third party things don't keep up with the play. Mark didn't you say earlier you couldn't get this to install? >> 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. > >Eeek :( Not very elegant, but needs must I guess. There is a time to be pragmatic and a time to be elegant. "Everything should be as simple as possible but not simpler." A.E. Russell B. Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)
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 requirement of report writers? > No it is not. It is a bonus. The "export to Word" task is v difficult. My apology to the CR people if I implied it was a defect in their product! Russell B. Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)
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 filtering. If there >is a smarter way to use the CRPE I'd would welcome insight. > >There are many areas to evaluate something like CR. Examples: prior >investment, cost of changing, export ability, ease of installation (my >problem at present using it on NT4 boxes), ability to subreport, and others. > >For example, CR's exporting ability suits my requirements well. Reports can >be exported to Excel, HTML, Lotus, RTF, Word files (mostly), into exchange >folders and more. (I'm mixing CR32 and CR16 capabilities here) > > Tony wrote >[] I appreciate your comments Russell. (Not sure I understand your first para too well. I think you are agreeing with us???) > >I am happy with QR (Despite all the bugs) but Customers KEEP on wanting stuff done in Crystal thanks to the MS marketing lies. I'd like to have a 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 your DB is anything larger than small (say 50MB) then Crystal is useless. No chance of geting them to change their thinking I suppose? IMO it is essential to be able to build the report around your own SQL. > >I don't consider your last Para a good reason. All of these can be done easily using QR or writing your own Delphi Components anyway. > >Of course there is allways Report Smith!!! > Russell Replies: In my first para I was thinking how nice it would be to speed up one report I have in CR which takes too long because CR brings all records back to the client for filtering. I could move up to Crystal Info, but that adds cost to Winlaw and achieves only a five min saving per day for my clients. I could also do filtering using the bde before invoking CR on a temporary table. This then makes my report a one user at a time report - which is OK in this case. Someone earlier said CR7 does server side filtering. I'm still on CR5. The table record counts Winlaw deals with now are manageable. Based on the good words spoken here about Report Builder Pro I looked at the RBPro site www.digital-metaphors.com and liked what I saw. Exporting reports is not as simple as you indicate. I'm thinking about exporting reports to MSWord. CR can export to RTF faily well but it cannot export correctly to MS Word preserving all the formatting, for documents whose complexity is beyond that of RTF documents, but within Word 97 scope. Perhaps CR 6 and 7 have been improved; the CR tech team once told me something like "exporting 100% correctly to Word is in our too hard basket". Regarding my problem with CR5.0.1.108 (16bit) on NT4. I have almost concluded this verion of CR will not run under NT4. It installs on NT4 but will not run. The 32 bit version will run on NT4 (at least I can export a report and the exported package will run on NT). I'm waiting for comments from the CR tech support team, when they return tomorrow. From this team I've received one or two replies per working day. 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. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Report Builder Pro (was Delphi and Crystal on NT4)
At 22:45 12/03/99 +1300, Tony wrote: > >The question I asked on my last mail was directed to the chap, who obviously >new Crystal very well, but unfortunatly I haven't had a reply. To refresh >your memory, the question was "Does Crystal still create real dumb SQL which >can not be modified and which brings all columns back to the workstation >where they are filterd locally???" Take a slow boat to china... > 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 filtering. If there is a smarter way to use the CRPE I'd would welcome insight. There are many areas to evaluate something like CR. Examples: prior investment, cost of changing, export ability, ease of installation (my problem at present using it on NT4 boxes), ability to subreport, and others. For example, CR's exporting ability suits my requirements well. Reports can be exported to Excel, HTML, Lotus, RTF, Word files (mostly), into exchange folders and more. (I'm mixing CR32 and CR16 capabilities here) Regards Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Delphi and Crystal on NT4
At 10:08 11/03/99 +1300, you wrote: > >And for Russel, I would strongly recommend you use the 32-bit crystal report >engine. We still have 16-bit exes, and these call a 32-bit exe to do the >reporting. There is much you can do with the 32-bit print engine. >Furthermore, you can use the report distribution expert to setup the print >engines on your client's machine. > >I also suggest that you use the version 6 runtime as the version 5 runtime >has a few bugs. Version 5 reports are compatible with version 6 runtime. >Haven't used version 7, so I cannot comment on that. Version 6 also has a >COM interface that allows you to easily write user defined functions in >Delphi, VB, etc. > >The only thing I would like to see in the VCL that is available in the VB >control is the ability to create adhoc reports from a datasource. This will >round up a great product. > Hi Dennis Thanks for your comments. I have run RPTCHK16 and DSX diagnostic programs from Seagate/CR and I am confident I have all the DLL's loaded in the right places as far as RPTCHK16 is concerned but none of my reports get past error message "unable to load database". How to interpret the DSX comparison results is a bit of a puzzle to me, because I don't have an NT4 box on which the reports run. So I may have to install CRW an a client's NT4 box. I may wrap all the reports into a D4 program using CRW32 ver 5.0.1.108. I hope this task will be as simple as I think. Russell Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
At 09:13 11/03/99, you wrote: >Russel, > >I use Crystal with Delphi. I have had absolutely no help from their >support email address. I finally complained to the president after >two weeks of continual email. That produced the help that I needed. >It turns out that if you mis-fill their forms, they are just junked. etc Hello Rohit I've been using Crystal for several years and my problem with NT4 is the first one I haven't solved in a day. Seagate-Crystal Reports is great otherwise as far as I am concerned. I'm still looking for a solution to my NT4 WS problem. Regards Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Delphi and Crystal on NT4
Thanks Steve for your comments. I'm using the 16bit Dlls from CR ver 5.0.1.108. CR help replied within an hour to a request made at their WWW site with several things to try. Particularly doing a comparison of DLLs loaded on a PC when the reports run OK and on an NTWS4 box where the repoarts all fail. The tool to use for this is their DSX.EXE (16bit). The most likely cause is a missing DLL, I think. Would you agree? At worst I could strip all the reports out into a D4 program, even if that meant installing two BDEs on a server. RB At 23:15 10/03/99 +1300, you wrote: > >-Original Message----- >From: Belding <[EMAIL PROTECTED]> >To: Multiple recipients of list delphi <[EMAIL PROTECTED]> >Date: Wednesday, March 10, 1999 5:26 PM >Subject: [DUG]: Delphi and Crystal on NT4 > > >>Hello team >> >>Anyone using Delphi with Crystal Reports on NT4? >> > >32 bit Works well. If you have 16 bit tools Seagate Software will not help >you if you are a Delphi developer either. You will likely have little joy >with versions prior to 5.x.108 and anything other than 32 bit Delphi. The >Seagate developed VCL wrapper around crpe32.dll for v5, 6 or 7 is more >powerful than the COM/VB equivalents. > >>With NT 4 (sp?) the reports won't run and I get an error "cannot open >>database" from the Crystal DLL. > >You will have to specify the database type, database version, >Crystal Reports type, version, platform and the method you are using to >interface with the Crystal Reports Print Engine DLL i.e OCX, CRPExx.dll >imports, VCL (D2,3,4, CB1,3 with source) or the Automation Server, as well >as the version of the BDE, ODBC, ADO, or native connection you are trying to >hook up to Crystal Reports. > >Sounds like a configuration issue."Unable To Open Database File" is an OCX >error which implies a Database verify may be required or the pathname is too >long esp wih Access, or maybe some UNC pathing problems. If you are using an >ActiveX bridge to Crystal Reports then there are a host of OS and Microsft >DLL redistributables to factor in. > >> >>Any insight would be hugely welcome. >> > > >ftp.img.seagatesoftware.com/pub/crystal and /pub/seagate_crystal_reports is >full of software samples, fixes, extensions etc. Http access gives you some >of this: http://www.img.seagatesoftware.com/crystalreports/techsupp/ You >may find benefit by consulting the newsgroups hosted at www.cogniza.com or >the alternative Crystal Report VCL at www.suprasoft.com or end user info @ >www.crystaluser.com > >ftp://ftp.img.seagatesoftware.com/pub/seagate_crystal_reports/delphi/crvclap >p.exe >is a handy test tool written in Delphi with source. > >Cheers, >Steve Cooney >Pacific Windows > >--- >New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > > > Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
[DUG]: Delphi and Crystal on NT4
Hello team Anyone using Delphi with Crystal Reports on NT4? I'm using Crystal reports with a D1 app on Win95, 98, NTWS5(beta 2), Novell (ver ?) without problems. The data tables are Paradox BDE 2.52. With NT 4 (sp?) the reports won't run and I get an error "cannot open database" from the Crystal DLL. Any insight would be hugely welcome. Thanks Russell Belding Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Re: Paradox - Corrupt file / Databases
At 16:58 05/03/99 +1300, you wrote: >Hi guys >Thanks for all the replie ti question over the last few days. They are all >printed and will be read carefully when I get time. > >On this suggestion below. Would it be considered to be a reasonable practice >then,. on starting the program, to remove all indexes and re-index, as a matter >of course? Or would that be a bad idea for some other reasons? I guess if you >are going to do this you need to make sure that no other copies of the >programme are running on the network. I wouldn't know how to go about this. > >Mark Hello Mark To remove index files and reindex requires exclusive access to table files. To repair a table using a TUtility based program also requires exclusive access but you need only do this when you have a known error. Regulary scanning can be done in a read only mode where you do not need exclusive access. Correcting could be done later. Regular delete and reindexing is in my judgement a less attractive solution than regularly scanning all tables using a TUtility type program and repairing them only when they need it. Reindexing only does not repair all types of errors. TUtility based scan and repair programs can also compare the table structure to the structure of a known good table and repair the working table if required. You could, for example regularly scan when you know the files can be exclusively accessed and repair on need. All this can be done automatically with a TUtility type scan and repair program. I have one using the last TUtility and IDAPI 2.52 for D1. It required only a text file list of table names and a companion directory containing a known good copy of the database. It is kept in a good state because it is only used when the scan and repair program does its comparison. Email me privately if interested. Other scan and repair programs exist for later BDE versions. Search on "TUtility". Regards Russell Belding Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Paradox Table Structure Printer
Hello Patrick STP v1.02 does not use aliases whereas dbUtil32 does. As an alias is a second way to get a directory this is not important for me, but could be for some. Wade A. has a new program named TV on the way. Regards At 18:49 13/02/99 +1300, you wrote: >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >> Behalf Of Belding >> Sent: Saturday, 13 February 1999 17:22 >> To: Multiple recipients of list delphi >> Subject: Re: [DUG]: Paradox Table Structure Printer > > >> STP v1.02 from Wade Achterlonie >> 1. Is a 16 bit program and uses the default handling for long file names. > >If it uses the 16 bit BDE can it read the 32 bit alias file, or is it not >handling aliases? > >snip > > >Patrick Dunford, ChristChurch, NZ >http://patrick.dunford.com/ > >--- >New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > > > Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Paradox Table Structure Printer
At 08:50 12/02/99 +1300, Patrich Sheehan wrote: >Try "DB Utilities " by Robert F Fabiszak [EMAIL PROTECTED] >available on Delphi Super Page as "dbutil32.zip" about 350kb I have a copy >if you need it > Here is a quick comparison of dbutil32 and Superior Table Printer ver 1.02 from Wade A. 1. This dbutil32 table printer is a 32 bit program so I assmume it handles long file names. 2. If a table has more than 50 fields it prints a faulty second page, using the default font. (didn't try other fonts) and some fonts overflow their allocated page space. 3. It does not print time and date of printing. 4. It allows you to choose the font for printing. 5. It prominently features the table name on the printed page. 6. It is free. STP v1.02 from Wade Achterlonie 1. Is a 16 bit program and uses the default handling for long file names. 2. Correctly prints second pages 3. Nicely prints date and time per page 4. Has one fixed font which it seems to handle well 5. Is not free. 6. Has options for more or less detail per page. 7. Generally has more details than dbutil32 Topics 2 and 3 (especially) are highly valued so STP 1.02 is my preferred choice of these two programs. Regards Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Paradox Table Structure Printer
At 11:16 11/02/99 +1300, you wrote: >On Thu, 11 Feb 1999, Belding wrote: > >> Wade Achterlonie has one which I've been using. Written for an early BDE >> but excellent. > >Hi Russell, long time no hear :) Would you be able to send me a copy of >this program? Use the addy [EMAIL PROTECTED] thanks. > Wade sells it for a modest sum. You'll need to ask him. His address is in these files somewhere. Russell Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: Paradox Table Structure Printer
Wade Achterlonie has one which I've been using. Written for an early BDE but excellent. Russell Belding At 10:23 11/02/99 +1300, you wrote: >Hiya - does anyone have a little utility that prints out the structure of a >table to an ascii text file/memo etc. etc.? > >If so - urls? send me? > > >Attachment Converted: "C:\ATTACH\Mark Derricutt7.vcf" > Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
RE: [DUG]: Detecting Zip Drives
Jeremy Use GetDriveType to show the drive is removable. Use DiskSize to see if its size is about 100MB If both at true you have an approx 100 Mb zip drive. If you need more detailed info why not contact ZIP directly? I'd bet they would give you S/W. Regards Russell At 14:14 01/02/99 +1100, you wrote: >Did a bit of a dig on "Developers.href.com" and someone said that they used >"DiskSize" function to find the zipdrive. >Not sure HOW you get on if there is a 100mb drive on the system...not that I >have, but.. > >Also, a disk has to be in the drive for it to work too. > >Been looking in the registtry too, and nothing of significance gets >returned > >will try what has been suggested > >Cheers, Jeremy Coulter > >-Original Message- >From: Patrick Dunford [mailto:[EMAIL PROTECTED]] >Sent: Monday, February 01, 1999 15:58 >To: Multiple recipients of list delphi >Subject: RE: [DUG]: Detecting Zip Drives > > >GetDriveType will detect different types but not specifically a zip drive > > >Views contained in this post are my personal opinions and unless otherwise >stated not those of any organisation I am associated with. > >-- >Patrick Dunford, ChristChurch, NZ >http://patrick.dunford.com/ > >> -Original Message- >> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On >> Behalf Of Jeremy Coulter >> Sent: Monday, 1 February 1999 15:04 >> To: Multiple recipients of list delphi > >--- >New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz >----------- >New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > > > Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: memory leaks??
Hello Steven We need a dbase pro commenting here but as one hasn't come forward I suggest the following as an experiment, as I do not know if the dBase block sizes affect file accessibility as they do in Pdox, D1 BDE access. Option Best: Look on the internet for a utility which changes the block size of Pdox/dBase tables in place. I have used PXRest.exe for Pdox files, which is available on the Delphi Developer Info Lib (DIL) Aug 98 CD. This program does not appear to handle dBase files. Option Second Best: 1. Take the dbase block sizes up to 4096 in your bde settings. 2. Make new tables replicating the tables you need for the experiment. 3. Suggest you not copy the structure from the old tables as this may (not sure) copy block sizes. 4. Write a program to copy records to the newer tables which exactly match your existing tables. 5. Save the older tables. 6. Overwrite the older with the newer tables and try your test. Regards Russell At 15:21 27/01/99 +, you wrote: >All right so let me explore BDE settings: In my DBF tables I only >use Number, Character, Date, and Logical field types. There are no >memo fields so no DBT files. I use standard MDX production index >files. The indexes involved in this prolem are all field rather than >expression indexes. > >The configuration of the DBASE native driver in the BDE (5.01) is as >follows: > >Version: 4.0 >Type: File >LangDriver: dbase ENU cp437 >Level 5 >MDX Block size: 1024 >Memo file block size: 1024 > >I can't necessarily justify any of these settings and am prepared to >experiment if someone can give some direction! > >Steven > >> Steven >> >> Here is a possibility. Someone more familiar with dBase files than me may >> be able to give you better information. >> >> First by way of analogy ... >> >> In the BDE version used with D1 the block size in effect (use bdecfg.exe to >> look at it for Pdox tables) when you create Pdox tables limits the size of >> the Pdox tables. One can have up to 65K blocks in a Pdox table (I hope this >> is the right number). >> >> For dBase files when you create a dBase file, if the bdecfg.exe settings >> for the dBase MDX and DBT block sizes affect the size or performance of >> your dBase files this could cause problems. I am guessing about this as you >> have linked your problem to file size. >> >> >> If your files have neither MDX not DBT files attached my suggestion may be >> useless. Otherwise could you experiment with large files created with MDX, >> DBT files made with larger block size settings? >> >> >> At 16:16 24/01/99 +, you wrote: >> >I have a Delphi 4 app that uses .dbf files via the BDE. Normally it >> >works fine but for a select group of clients with larger than normal >> >data tables I have discovered a probelm. Their Item table has about >> >90,000 thousand records and if they use the app to add items it >> >crashes after about 15 records have been added. >> > >> >Adding items also causes several other tables to have records added >> >as well. The table are not closed between each addition >> > >> >The error I get is >> > "Read failure >> > (Path and name of Item table) >> > >> >(Note that I don't get this problem with tables with 12,000 records >> >dispite adding 100s of records in one session but have not worked >> >out at what point it does start!) >> > >> >Following sound advise that my code was at fault I searched it for >> >errors. Then I ran Memory Sleuth over it. Interestingly enough, >> >after adding each entry, Sleuth returns that there is 517,824 bytes >> >in uses and 7119 pointers active. I read this as no problems! >> > >> >However after entering about the right number of records for the >> >fault to occur - it did (showing figures of 518,188 & 7125 at the >> >actual instance). >> > >> >Changing the database isn't an option. Is it the BDE or something >> >else completely?? What other tests should I mount? >> > >> >Steven >> > >> > >> >Wild Software Ltd >> >P O Box 33-216 >> >Christchurch >> >NEW ZEALAND >> > >> >= >> >I haven't lost my mind; it's backed up on tape somewhere. >> >= >> >--
Re: [DUG]: memory leaks??
Steven Here is a possibility. Someone more familiar with dBase files than me may be able to give you better information. First by way of analogy ... In the BDE version used with D1 the block size in effect (use bdecfg.exe to look at it for Pdox tables) when you create Pdox tables limits the size of the Pdox tables. One can have up to 65K blocks in a Pdox table (I hope this is the right number). For dBase files when you create a dBase file, if the bdecfg.exe settings for the dBase MDX and DBT block sizes affect the size or performance of your dBase files this could cause problems. I am guessing about this as you have linked your problem to file size. If your files have neither MDX not DBT files attached my suggestion may be useless. Otherwise could you experiment with large files created with MDX, DBT files made with larger block size settings? At 16:16 24/01/99 +, you wrote: >I have a Delphi 4 app that uses .dbf files via the BDE. Normally it >works fine but for a select group of clients with larger than normal >data tables I have discovered a probelm. Their Item table has about >90,000 thousand records and if they use the app to add items it >crashes after about 15 records have been added. > >Adding items also causes several other tables to have records added >as well. The table are not closed between each addition > >The error I get is > "Read failure > (Path and name of Item table) > >(Note that I don't get this problem with tables with 12,000 records >dispite adding 100s of records in one session but have not worked >out at what point it does start!) > >Following sound advise that my code was at fault I searched it for >errors. Then I ran Memory Sleuth over it. Interestingly enough, >after adding each entry, Sleuth returns that there is 517,824 bytes >in uses and 7119 pointers active. I read this as no problems! > >However after entering about the right number of records for the >fault to occur - it did (showing figures of 518,188 & 7125 at the >actual instance). > >Changing the database isn't an option. Is it the BDE or something >else completely?? What other tests should I mount? > >Steven > > >Wild Software Ltd >P O Box 33-216 >Christchurch >NEW ZEALAND > >= >I haven't lost my mind; it's backed up on tape somewhere. >= >------- >New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] > Website: http://www.delphi.org.nz > > > Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
Re: [DUG]: InstallShield Express - datapump.exe missing
John I have had the same experience. It is safe to remove it and any other datapump files IEX4 tries to insert. Russell Belding At 11:28 03/02/99 +1300, you wrote: >>>> I'm setting up my first install routine for a Delphi 4 program using InstallShield Express. When I run the Disk Builder, I get an error message telling me that c:\program files\common\..\bde\datapump.exe cannot be found. I can't find this file on my computer, nor on the Delphi4 CD. Is it safe to remove this file from the installation, or is it needed? John Mason Kingston Morrison <<<< Russell Belding Belding Computing Devices WINLAW, BIZXWORD, ENGPER. --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz
