[DUG] Office Automation
Hi We are using the TWordDocument and TWordApplication components from D6. This works great with Office 2000, will these components work with other versions of word i.e Office XP or Word 97 so long as the methods we call are still available? p.s I notice an email I sent yesterday has not appeared on the list and it feels like I have missed other emails as well. Any one else notice this? Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Fancy (ish) emails
Hi all We allow email to be created and sent from within our software using a POP3 component. Currently our emails are all plain text but our users would like to be able to do simple formatting (bold / italic / centred / fonts etc). I could easily whip up a RichText component to handle the formatting but how do I send it? Do I have to convert rich text to HTML? What is the easiest way to do this? Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] AT command
Use the Windows HyperTerminal app. Setup a new connection as the comport your modem is on and connect. You can then issue AT commands at will. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: John [EMAIL PROTECTED] To: DUG [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:21 PM Subject: [DUG] AT command Hi all, Is there a simple way of sending an AT command to my build-in modem without having to buy any dedicated component or software? (However a free component is OK). TIA, John ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] solvethisproblem
I believe the help on threads has changed very little since D4 (and earlier). I suspect the OS has a lot to do with thread performance and the 16 limit sounds very much like a Windows 95 kind of thing. I know thread handling has been improved heaps in windows 2000 +. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 9:39 AM Subject: [DUG] solvethisproblem Hi Gajo, That's an interesting comment about the number of threads, because I have an application that runs 24x7 with between 30 and 50 threads (at the moment), and I haven't noticed any performance issues. In fact, it's even running on an old PII 400MHz machine! I think the number of threads vs performance issue really depends on what the software and threads are doing. If you really wanted to go down that path (for anything, not just the current project), I would put more emphasis on your own testing and observations than what might be in the Help files (who knows when that information was last updated?) BTW, it would be referring to 16 actively running threads, not necessarily 16 different thread objects. Regards, Bevan ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] [OFF-TOPIC] Fortran
I did COBOL at Polytechnic. It wasn't until after I had finished the course that I discovered you didn't have to use capitals all the time and that you could use * instead of writing MULTIPLY. The tutors said that's they way it had to be done (that was how they did it in the 60s before the * / + - symbols were added to COBOL is suspect). Talk about dinosaurs. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: James Sugrue [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Monday, January 19, 2004 8:37 AM Subject: RE: [DUG] [OFF-TOPIC] Fortran BWAHAHAHAHAHAHA. Almost p*ssed myself when I read that. I work with some COBOL heads. They are the worst kind of dinosaur, too stubborn to know they're dead and too belligerent to learn anything new. Things like, I can't really see anything different between COBOL and OO, or the classic, I can do that in COBOL -- yes you probably can, but the fact it takes a week to do, where it would take 2-3 hours in something else -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neven MacEwan Sent: Friday, 16 January 2004 10:59 p.m. To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List Subject: Re: [DUG] [OFF-TOPIC] Fortran and the fact that people still use Cobol (something something Business Oriented Language) and nobody uses Fortran is indicative of the fact that engineers are smarter than accountants (and therefore know when to move on) HTH Neven ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Replacement comperession component needed urgently
Hi Nahum We have used Lzh archiving with TCompLha from [EMAIL PROTECTED] who frequents these groups. It works great although I have not tried it on 9GB of data. Isn't there an OS issue in relation to 2GB + files (like you cant have them). Not sure if this is only applies to Win 9x or also the rest NT / 2000/ XP. My guess is your 9GB of data compresses to a 2+ GB file. You could try creating multiple archives with your current component (TCompLha can also do this). Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Nahum.Wild [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 11:27 AM Subject: [DUG] Replacement comperession component needed urgently Hi all, We are current using the latest version of DynaZip Max 5 and have started encountering major problems when trying to zip up 9GB of data. CRC errors and the like. We believe its the component set causing the problem so I'm urgently trying to find a replacement for it. Can anyone recomend a replacement component set that they think is fab and can handle 2GB plus compressed files? It doesn't have to be a zip based format, but does need to be generally accepted and viewable with thirdparty utils etc... Such as WinRar. Thanks in advance, Nahum Wild Software Innovator, Process Consultant IFE PayGlobal ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] [OFF-TOPIC] Delphi 8 and .net
Hi Richard I see that you are catching up with your emails at the moment. I just wondered if you could confirm that there is a bug in the BDE (all versions) that causes it to incorrectly report the amount of free disk space with drives that have over 2GB free space. We recently encountered this issue on a clients machine and found reference to a BDE bug caused by Borland using an obsolete API call (GetDiskSpace instead of GetDiskSpaceEX). Do you know if this is supposed to be fixed or if it remains unresolved? We believe it is causing a number of clients major problems (now that they have all upgraded their machines they are running out of drive space). If it has not been fixed is there an official (or un official) work around? Yes I have already searched Google groups etc. This is how I found reference to the problem. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Richard Vowles [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:24 PM Subject: RE: [DUG] [OFF-TOPIC] Delphi 8 and .net VB != VB.NET Or should that be VB VB.NET? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neven MacEwan Sent: Tuesday, 27 January 2004 12:25 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] [OFF-TOPIC] Delphi 8 and .net Richard One minute you say 400K use C#, I've had 6 Million as the number of VB Programmers, which make 6.7% if all C# programmers came from VB, I don't consider that a large number ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] BDE
Sorry for any confusion caused. The API calls are actually GetDiskFreeSpace GetDiskFreeSpaceEx Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Robert martin [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 3:50 PM Subject: Re: [DUG] [OFF-TOPIC] Delphi 8 and .net Hi Richard I see that you are catching up with your emails at the moment. I just wondered if you could confirm that there is a bug in the BDE (all versions) that causes it to incorrectly report the amount of free disk space with drives that have over 2GB free space. We recently encountered this issue on a clients machine and found reference to a BDE bug caused by Borland using an obsolete API call (GetDiskSpace instead of GetDiskSpaceEX). Do you know if this is supposed to be fixed or if it remains unresolved? We believe it is causing a number of clients major problems (now that they have all upgraded their machines they are running out of drive space). If it has not been fixed is there an official (or un official) work around? Yes I have already searched Google groups etc. This is how I found reference to the problem. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Richard Vowles [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 12:24 PM Subject: RE: [DUG] [OFF-TOPIC] Delphi 8 and .net VB != VB.NET Or should that be VB VB.NET? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Neven MacEwan Sent: Tuesday, 27 January 2004 12:25 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] [OFF-TOPIC] Delphi 8 and .net Richard One minute you say 400K use C#, I've had 6 Million as the number of VB Programmers, which make 6.7% if all C# programmers came from VB, I don't consider that a large number ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] [OFF-TOPIC] Delphi 8 and .net
Thanks Richard I had hoped you might have known more / been able to find out about it. I have already been to borland.com, which I find hard to find information on anything. I downloaded the app required to search Quality Central and bde isn't even a product. I searched and found some issues related to bde but the only search that returned any results was 'bde' so I would be forced to step through every fault currently reported 1 by 1. No thanks! I have now searched further and found it is a fault right through to BDE 5.2. Stunning ! ( it seems so simple to fix, want to send me the source :) ). Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Richard Vowles [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Tuesday, January 27, 2004 4:07 PM Subject: RE: [DUG] [OFF-TOPIC] Delphi 8 and .net I haven't gone anywhere near the BDE for at least two years now sorry. When confirming bugs and looking for official workarounds (if any) you should look at Quality Central - at community.borland.com. That is Borland's official Bug Database and the one it looks at when fixing things. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martin Sent: Tuesday, 27 January 2004 3:50 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] [OFF-TOPIC] Delphi 8 and .net Hi Richard I see that you are catching up with your emails at the moment. I just wondered if you could confirm that there is a bug in the BDE (all versions) that causes it to incorrectly report the amount of free disk space with drives that have over 2GB free space. We recently encountered this issue on a clients machine and found reference to a BDE bug caused by Borland using an obsolete API call (GetDiskSpace instead of GetDiskSpaceEX). Do you know if this is supposed to be fixed or if it remains unresolved? We believe it is causing a number of clients major problems (now that they have all upgraded their machines they are running out of drive space). If it has not been fixed is there an official (or un official) work around? Yes I have already searched Google groups etc. This is how I found reference to the problem. ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] display value of form1.txtbox in form2.txtbox
Come now people, what else did you expect.
1. Remember this isn't Delphi 8, it is Delphi .Net 1.0. It isn't the
expansion of a stable product but a complete new beast. There will be
issues.
2. It is a product rushed out the door in December 2003 to meet some
deadline Borland was facing. This explains the lack of Manuals /
documentation and features.
3. It is not a fully tested product. There was a bug marathon in AK just
before the release. This of course could not affect the product shipped in
December as that would have already been at the presses.
I suspect D8 .Net will be a good product, it just needs some more time. I
look forward to the promised D8 .net / Win32 package, although it might be
Delphi 9 :)
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: vss [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Monday, February 02, 2004 4:07 PM
Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox
I am just waiting for the first Sp for D8maybe that will contain a
help file or even a PDF that helps you get going ! or even usful
information !
-Original Message-
From: Tracey Maule [EMAIL PROTECTED]
To: [EMAIL PROTECTED], NZ Borland Developers Group - Delphi List
[EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 15:44:16 +1300
Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox
Refrains from publicly abusing Borland yet
haha well im not making any money Programming with it
- Original Message -
From: Leigh Wanstead
To: NZ Borland Developers Group - Delphi List
Sent: Monday, February 02, 2004 3:28 PM
Subject: RE: [DUG] display value of form1.txtbox in form2.txtbox
Has anyone figured out how to do this simple thing yet???
I guess give it another three months, you will be an expert on this,
and write a book how to develop .net in Delphi 8 and make money from
that. 8 )
Regards
Leigh
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tracey Maule
Sent: Monday, February 02, 2004 3:11 PM
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] display value of form1.txtbox in form2.txtbox
Delphi ASP.NET grrr
I have been trying to figure this one out since friday, and am still
not getting any joy.
form1 type=get contains html_text1
I simply want to display whatever the user types into form1.text1 in
the resulting web form (form2)'s html_text2
in form2.pas i am trying the following code:
txtSomething := Request.QueryString.Get('value');
but it doesnt work. Has anyone figured out how to do this simple
thing yet???
Tracey
Software Developer / Web Master
Logis
[EMAIL PROTECTED]
(027) 213-1065
---
-
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] display value of form1.txtbox in form2.txtbox
I think regardless of how many developers they have it is impossible. I
think there is something like a 1-2mth leadup to manufacturing bulk cds
(going gold or some such). Could be wrong but I think it would be
impossible to find a bug, fix it, regression test the entire product, then
get it to a manufactured point in 2-3 weeks.
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: vss [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Monday, February 02, 2004 4:59 PM
Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox
In reply to #3, I DID wonder about that. Maybe they developers work 24hrs
a day to fix the bugs...maybe not ;-)
-Original Message-
From: Robert martin [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 16:44:41 +1300
Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox
Come now people, what else did you expect.
1. Remember this isn't Delphi 8, it is Delphi .Net 1.0. It isn't the
expansion of a stable product but a complete new beast. There will be
issues.
2. It is a product rushed out the door in December 2003 to meet some
deadline Borland was facing. This explains the lack of Manuals /
documentation and features.
3. It is not a fully tested product. There was a bug marathon in AK
just
before the release. This of course could not affect the product
shipped in
December as that would have already been at the presses.
I suspect D8 .Net will be a good product, it just needs some more time.
I
look forward to the promised D8 .net / Win32 package, although it might
be
Delphi 9 :)
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: vss [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Monday, February 02, 2004 4:07 PM
Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox
I am just waiting for the first Sp for D8maybe that will contain
a
help file or even a PDF that helps you get going ! or even usful
information !
-Original Message-
From: Tracey Maule [EMAIL PROTECTED]
To: [EMAIL PROTECTED], NZ Borland Developers Group - Delphi
List
[EMAIL PROTECTED]
Date: Mon, 2 Feb 2004 15:44:16 +1300
Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox
Refrains from publicly abusing Borland yet
haha well im not making any money Programming with it
- Original Message -
From: Leigh Wanstead
To: NZ Borland Developers Group - Delphi List
Sent: Monday, February 02, 2004 3:28 PM
Subject: RE: [DUG] display value of form1.txtbox in form2.txtbox
Has anyone figured out how to do this simple thing yet???
I guess give it another three months, you will be an expert on
this,
and write a book how to develop .net in Delphi 8 and make money
from
that. 8 )
Regards
Leigh
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Tracey Maule
Sent: Monday, February 02, 2004 3:11 PM
To: NZ Borland Developers Group - Delphi List
Subject: [DUG] display value of form1.txtbox in form2.txtbox
Delphi ASP.NET grrr
I have been trying to figure this one out since friday, and am
still
not getting any joy.
form1 type=get contains html_text1
I simply want to display whatever the user types into form1.text1
in
the resulting web form (form2)'s html_text2
in form2.pas i am trying the following code:
txtSomething := Request.QueryString.Get('value');
but it doesnt work. Has anyone figured out how to do this
simple
thing yet???
Tracey
Software Developer / Web Master
Logis
[EMAIL PROTECTED]
(027) 213-1065
---
-
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] CSV
Hi all I have been working with the CommaText method of a stringlist to import a csv file. One of my test files does not use double quotes around fields containing spaces, the CommaText method splits the field into multiple fields. I thought double quotes were only required around fields containing commas. Does anyone know which format is the 'Official' format. If the CommaText method does not function correctly I will right my own (unless anyone has other suggestions). Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] display value of form1.txtbox in form2.txtbox
Sounds like my analysis might have been spot on (head expanding rapidly :) ). Im not sure if it would have been better to delay the product again or ship and fix the bugs. MS I believe has often gone for the later! Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: James Sugrue [EMAIL PROTECTED] To: [EMAIL PROTECTED]; 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Tuesday, February 03, 2004 8:13 AM Subject: RE: [DUG] display value of form1.txtbox in form2.txtbox I have read that there is a patch going to be posted this week to fix the worst of the issues, and a service pack early March (hopefully with ADO.NET for VCL), and an announcement around that time re Delphi for win32 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeremy Coulter Sent: Monday, 2 February 2004 7:46 p.m. To: 'NZ Borland Developers Group - Delphi List' Subject: RE: [DUG] display value of form1.txtbox in form2.txtbox Exactly. So are you saying the current D8 is really a flash Beta Rob? Hehehehehethat'll stir someone up...hehehe Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martin Sent: Monday, 2 February 2004 05:15 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox I think regardless of how many developers they have it is impossible. I think there is something like a 1-2mth leadup to manufacturing bulk cds (going gold or some such). Could be wrong but I think it would be impossible to find a bug, fix it, regression test the entire product, then get it to a manufactured point in 2-3 weeks. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: vss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Monday, February 02, 2004 4:59 PM Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox In reply to #3, I DID wonder about that. Maybe they developers work 24hrs a day to fix the bugs...maybe not ;-) -Original Message- From: Robert martin [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Date: Mon, 2 Feb 2004 16:44:41 +1300 Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox Come now people, what else did you expect. 1. Remember this isn't Delphi 8, it is Delphi .Net 1.0. It isn't the expansion of a stable product but a complete new beast. There will be issues. 2. It is a product rushed out the door in December 2003 to meet some deadline Borland was facing. This explains the lack of Manuals / documentation and features. 3. It is not a fully tested product. There was a bug marathon in AK just before the release. This of course could not affect the product shipped in December as that would have already been at the presses. I suspect D8 .Net will be a good product, it just needs some more time. I look forward to the promised D8 .net / Win32 package, although it might be Delphi 9 :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: vss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Monday, February 02, 2004 4:07 PM Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox I am just waiting for the first Sp for D8maybe that will contain a help file or even a PDF that helps you get going ! or even usful information ! -Original Message- From: Tracey Maule [EMAIL PROTECTED] To: [EMAIL PROTECTED], NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Date: Mon, 2 Feb 2004 15:44:16 +1300 Subject: Re: [DUG] display value of form1.txtbox in form2.txtbox Refrains from publicly abusing Borland yet haha well im not making any money Programming with it - Original Message - From: Leigh Wanstead To: NZ Borland Developers Group - Delphi List Sent: Monday, February 02, 2004 3:28 PM Subject: RE: [DUG] display value of form1.txtbox in form2.txtbox Has anyone figured out how to do this simple thing yet??? I guess give it another three months, you will be an expert on this, and write a book how to develop .net in Delphi 8 and make money from that. 8 ) Regards Leigh -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tracey Maule Sent: Monday, February 02, 2004 3:11 PM To: NZ Borland Developers Group - Delphi List Subject: [DUG] display value of form1.txtbox in form2.txtbox
Re: [DUG] CSV
Thanks Peter I already have the code to handle the display so I may just make it that the csv files need to have such fields enclosed in double quotes. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Monday, February 02, 2004 5:28 PM Subject: Re: [DUG] CSV Stringlist.Commatext definitely handles spaces as you describe, and always has. So you can't rely on it if your data is coming in in that format. An alternate process might be to associate a TClientDataset with your CSV file; though I haven't done it, I believe this will provide seamless DB-style access ok. (Personally, if I were generating a CSV file, I'd always quote any text field, as it *might* contain a comma. But I don't know of any black-and-white standard mandating that). Hi all I have been working with the CommaText method of a stringlist to import a csv file. One of my test files does not use double quotes around fields containing spaces, the CommaText method splits the field into multiple fields. I thought double quotes were only required around fields containing commas. Does anyone know which format is the 'Official' format. If the CommaText method does not function correctly I will right my own (unless anyone has other suggestions). Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com cheers, peter === Peter Hyde, Development Director, SPIS Ltd, Christchurch, New Zealand * TCompress/TCompLHA component sets for Delphi/Kylix/C++ * TurboNote+: http://TurboNote.com -- top-rated onscreen sticky notes Find all the above and MORE at http://spis.co.nz ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Action menus
Hi I am replacing a TToolBar and TActionList system with a TActionMainMenuBar + TActionManager combination. The TActionManager allows you to use existing TActionList components (which I really want to do) but for some reason the TActionMainMenuBar will not let me drop categories originally from my TActionList (now displayed in the TActionManager) on to it. I have made a dummy app with this same system and it works fine so it must be something unique to the application. Any suggestions. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] TToolDockObject
Does anyone know how to use this or examples? I have searched the web / help. In my code I do the following TToolDockObject.Create(ActionMainMenuBar1); TToolDockObject.Create(ActionToolBar1); TToolDockObject.Create(ActionToolBar2); This seems to handle docking better but has the side effect of initially undocking the controls. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Action Bars
I am using TActionToolbar and TActionMainMenuBar components. When a user customises these I don't want them to be able to change the main menu (for support reasons). When I change the 'ChangesAllowed' property of the mainmenu it disables correctly when the customize dialog is open however it fails to repopen when this screen is closed. Does anyone have some ideas (I have tried the default customize action and the TCustomizeDlg). Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Action Bars
Sorry, worked it out myself. Don't bother with the changesAllowed property, simply toggle the enabled property. Thought I had already tried that! Oh well its sort of Friday. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Robert martin To: [EMAIL PROTECTED] org. nz Sent: Thursday, February 05, 2004 2:18 PM Subject: [DUG] Action Bars I am using TActionToolbar and TActionMainMenuBar components. When a user customises these I don't want them to be able to change the main menu (for support reasons). When I change the 'ChangesAllowed' property of the mainmenu it disables correctly when the customize dialog is open however it fails to repopen when this screen is closed. Does anyone have some ideas (I have tried the default customize action and the TCustomizeDlg). Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Test - Please Ignore
Java was too slow. MS has something Java doesn't, a stick to force you to use it. Note even Borland are saying 32bit is dead you must use .Net. I agree with your comment on apps but MS has always used its OS to sell its apps. It could always integrate better with windows and use new features before the competition, it will use net in the future to do this to do this if its OS looses control. Re Nahums comments about open source etc. I think that is just an MS marketing thing, 'its a standard. Oh yes and its open source (some of the un important bits). Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Neven MacEwan [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, February 12, 2004 2:43 PM Subject: Re: [DUG] Test - Please Ignore Robert Personally I think its a reaction to Linux Nah can't agree, more a move on Java and the JVM, beefing up their image in the tech stakes .NET will be important, Its interesting to see how difficult M$ are finding it to kill 98, Its no longer supported, um yes it will be, but only for a few more months in best pythonesque voice, harder than NT We ship a 1 to 1 ratio 1 linux box to 1 terminal server, but i can't see linux making it onto the desktop soon. What will be scaring M$ is the cross over of OS software developed on linux onto rugged windows versions, Mozilla, Open Office, Thunderbird esp since M$ are giving windows away (Did anyone else see the HP, 36GB Server with 2003 SBS and 5 cals for $1099) Look for some agressive Office pricing coming soon Neven - Original Message - From: Robert martin [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, February 12, 2004 1:44 PM Subject: Re: [DUG] Test - Please Ignore Good reasons More easy to market your app ? Get access to latest windows functionality (MS may not provide APIs to new functionality) Why .Net? With Rant do begin Personally I think its a reaction to Linux. Its a backup plan. If MS looses its Windows monopoly and just becomes another OS then they can leverage .Net on other platforms. All of a sudden you can write .Net apps for multiple OS's with your windows skills in the language of your choice. MS would eventually start a licensing fee for .Net (MS wants to move to licensing anyway) and would once again be in control of the desktop, this time with the layer on top of the OS. This of course is exactly what MS was worried SUN and Netscape would do to it. If Windows doesn't loose its monopoly then they still control the market for development tools. After all whose tools do you think will be able to access new .Net features first? I believe the only time MS will truly support .Net on other OS's is when it has lost / loosing its Windows monopoly. end; Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Traci Sumpter To: NZ Borland Developers Group - Delphi List Sent: Thursday, February 12, 2004 12:19 PM Subject: RE: [DUG] Test - Please Ignore Thats right. Not too keen to jump on the M$ Bandwagon just yet. Can anyone tell me what the 'Future' of .NET is?? Give me some Good reasons to get involved with .NET and dont say it it the way of the future without justifying it with valod reasons. I may be too skeptical here but i am sure it is just another M$ Get you in before you realise it's too late bollicks.. Anyone want to prove me wrong??? :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of James Sugrue Sent: Thursday, 12 February 2004 11:54 a.m. To: 'NZ Borland Developers Group - Delphi List' Subject: RE: [DUG] Test - Please Ignore You obviously haven't got D8 yet then ;-) -- -- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Traci Sumpter Sent: Thursday, 12 February 2004 11:06 a.m. To: NZ Borland Developers Group - Delphi List Subject: RE: [DUG] Test - Please Ignore Just engrossed in the pleasure in programming in delphi and seeing results fast.. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Paul Mckenzie Sent: Thursday, 12 February 2004 10:41 a.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Test - Please Ignore Delphi is not dead - everyone is just asleep... Regards Paul McKenzie Analyst Programmer SMSS Ltd. - Original Message - From: Pedrocelli To: NZ Borland Developers Group - Delphi List Sent: Thursday, February 12, 2004 10:21 AM Subject: Re: [DUG] Test
[DUG] Interbase / Firbird
If you were going to move a large app to a Firebird database which connection method would you use, ADO, ADO.Net, ODBC, IBOjects, DBExpress etc? I liked the idea of ADO as it isn't a Borland onlyproduct but note that it has reached the end of its life and is being replaced by ADO.Net (which of course is far superior). Does ADO.Net actually require the .Net runtime environment or is this just a marketing thing? I thought the advantage of ADO over IBOjects etc was that if we later changed database the change would be fairly transparent. Your comments and suggestions would be welcomed :) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Firbird from Delphi
Title: Message One of the (many?) downsides to using the Delphi IB components is that newer release's will not support Firebird. Apparently Borland and the guys behind IBX have both stated that current support isincidental and will not be maintained. As Firebird is in direct competition with IB I suspect Borland would be happy for IBX to stop supporting Firebird. I have the IBObjects trial and they look really good so far. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Jeremy Coulter To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 7:36 AM Subject: [DUG] Firbird from Delphi HI all. Like Robert I have been looking at Firbird. I have found a couple of tools to increase my Database port time, and now have all my database converted over etc. But now comes the point where I want to start to use the db in Delphi. There was some discussion and I think someone said, as di Rob, that IBObjects looks good. What about the Interbase controls that are in Delphi 7? I have used these to connect to the DB already, so are they ok? They dont need the BDE installed too do they? How do they perform? Cheers, Jeremy Coulter All email scanned with Nortons Antivirus 2003 ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Firbird from Delphi
I know this isn't the proper place but... Rohit I am trying to set up a master detail using IBO and the VCL components. It is linking on the PK, not the key I want. Have I missed something? I am going to define a FK in my test DB to see if that fixes it. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Rohit Gupta [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 12:33 PM Subject: Re: [DUG] Firbird from Delphi We did initially and found IBO to be fastest of the three. Date sent: Thu, 19 Feb 2004 10:22:24 +1300 From: vss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Subject:Re: [DUG] Firbird from Delphi Send reply to: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] What about FIBPlus? anyone tried these? They are quite pricy (200 or so ?) Jeremy -Original Message- From: vss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Date: Thu, 19 Feb 2004 09:32:30 +1300 Subject: Re: [DUG] Firbird from Delphi Yeah I downloaded the demo of IBObjects too. I just wondered more than anythingsaves $$ where you can and all that :-) Jeremy -Original Message- From: Robert martin [EMAIL PROTECTED] To: [EMAIL PROTECTED], NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Date: Thu, 19 Feb 2004 08:39:30 +1300 Subject: Re: [DUG] Firbird from Delphi MessageOne of the (many?) downsides to using the Delphi IB components is that newer release's will not support Firebird. Apparently Borland and the guys behind IBX have both stated that current support is incidental and will not be maintained. As Firebird is in direct competition with IB I suspect Borland would be happy for IBX to stop supporting Firebird. I have the IBObjects trial and they look really good so far. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Jeremy Coulter To: [EMAIL PROTECTED] Sent: Thursday, February 19, 2004 7:36 AM Subject: [DUG] Firbird from Delphi HI all. Like Robert I have been looking at Firbird. I have found a couple of tools to increase my Database port time, and now have all my database converted over etc. But now comes the point where I want to start to use the db in Delphi. There was some discussion and I think someone said, as di Rob, that IBObjects looks good. What about the Interbase controls that are in Delphi 7? I have used these to connect to the DB already, so are they ok? They dont need the BDE installed too do they? How do they perform? Cheers, Jeremy Coulter --- - All email scanned with Nortons Antivirus 2003 --- - --- --- ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi Regards Rohit == CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH(649) 489-2280 FX(649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] == ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Auto Killing a Modal Form
Dodgy solution... Put a timer on the form, when your processing finishes enable the timer. The timer sets the modal result. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Paul Mckenzie To: Delphi List - Delphi Sent: Thursday, February 26, 2004 3:11 PM Subject: [DUG] Auto Killing a Modal Form How do I Auto-Kill a Modal Form ? I have a Form that I ShowModal OnActivate or OnShowI do a load of processing (updating a ProgressBar). Then I want the Form to automatically Close... How doI get it to Close - I have tried setting ModalResult - but it seems to just get ignored. If I set ModalResult in a Control the user activates it works - but I need it to automatically Close. RegardsPaul McKenzieAnalyst ProgrammerSMSS Ltd. ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Windows XP SP 2
That is my reading as well, although who knows what tricks the delphi compiler is using. I think the user has to manually configure the firewall to allow a TCP/IP server or the app can add itself using COM? calls. I couldn't find any help on the calls mentioned although it was only a quick search. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Myles Penlington To: 'NZ Borland Developers Group - Delphi List' ; [EMAIL PROTECTED] org. nz Sent: Thursday, March 11, 2004 10:33 AM Subject: RE: [DUG] Windows XP SP 2 For Delphi generally it will not be an issue. The memory security is an issue for JIT (Just in Time compilation environments) ie .NET and Java. This may also effect _javascript_ and VB Script - but that is a MS Issue. The TCP/IP issue may have an effect on mostof us. Thebiggest effect would be on the server side. If I read it correctly, If an application uses a port, then the firewall will dynamically open the port. Myles. -Original Message-From: Robert martin [mailto:[EMAIL PROTECTED]Sent: Thursday, 11 March 2004 10:10To: [EMAIL PROTECTED] org. nzSubject: [DUG] Windows XP SP 2 Hi all We have just received information about changes in SP 2 for XP that can / impact on applications. This is probably of interest to all developers here. Read the following link for an overview.. http://www.infoworld.com/article/04/03/04/HNwindowsxpsp2_1.html This link is MS training centre for developers and provides details of what will break.http://msdn.microsoft.com/security/productinfo/XPSP2/introduction.aspx A part from TCP/IP implications the memory protection stuff is interesting, MS says... Another product that Microsoft needs to update is the .Net Framework. The new memory protection features in SP2 require developers of certain applications to mark their code with memory execution permissions. If they don't, the protection features could interfere with the application, according to Microsoft. "The great bulk of applications will not be affected by memory protection. The number one that leaps to mind is execution environments with just-in-time code generation. The .Net Framework is one," Goodhew said. Interesting the implications of the above statement is that not many apps have been written in .Net. But after examining the docs it turns out that XP will detect and turn off this feature for all .Net applications. The new version of .Net will have the ability to add the above mentioned code blocks. Interestingly this seems to impact Java badly. Also who knows how the Delphi compiler works, will current and older versions of Delphi have problems? Currently all the APIs seem to be .Net only (the typical MS force you to use a product system). Other funny quotes If developers do find that SP2 breaks their applications, it most likely means that they were not following best practices in terms of security when writing their applications, according to Goodhew. later Microsoft's Visual Studio .Net is one of the applications affected by Windows XP SP2. The developer tool's remote debugging feature won't work because of the improved Windows Firewall, previously called Internet Connection Firewall, which will be turned on by default and will close all ports, Goodhew said. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Windows XP SP 2
Hi all We have just received information about changes in SP 2 for XP that can / impact on applications. This is probably of interest to all developers here. Read the following link for an overview.. http://www.infoworld.com/article/04/03/04/HNwindowsxpsp2_1.html This link is MS training centre for developers and provides details of what will break. http://msdn.microsoft.com/security/productinfo/XPSP2/introduction.aspx A part from TCP/IP implications the memory protection stuff is interesting, MS says... Another product that Microsoft needs to update is the .Net Framework. The new memory protection features in SP2 require developers of certain applications to mark their code with memory execution permissions. If they don't, the protection features could interfere with the application, according to Microsoft. "The great bulk of applications will not be affected by memory protection. The number one that leaps to mind is execution environments with just-in-time code generation. The .Net Framework is one," Goodhew said. Interesting the implications of the above statement is that not many apps have been written in .Net. But after examining the docs it turns out that XP will detect and turn off this feature for all .Net applications. The new version of .Net will have the ability to add the above mentioned code blocks. Interestingly this seems to impact Java badly. Also who knows how the Delphi compiler works, will current and older versions of Delphi have problems? Currently all the APIs seem to be .Net only (the typical MS force you to use a product system). Other funny quotes If developers do find that SP2 breaks their applications, it most likely means that they were not following best practices in terms of security when writing their applications, according to Goodhew. later Microsoft's Visual Studio .Net is one of the applications affected by Windows XP SP2. The developer tool's remote debugging feature won't work because of the improved Windows Firewall, previously called Internet Connection Firewall, which will be turned on by default and will close all ports, Goodhew said. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi News
Hi Alan You may be interested to note that in Quality Central (Borland's bugs and suggestions site) the most popular report / request is a 64bit compiler. However Borland has only just opened the request, after people complained it had been in the system for over a year and hadthe highest number of votes. Borland's comment was We will investigate the voting on this report as it is suspicious! Does that answer your question about Borland's intentions to go 64bit? Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, March 12, 2004 9:47 AM Subject: RE: [DUG] Delphi News The question that affects a few of us out there is does Borland intend to develop a native win64 compiler or is dot net Borland's only option for win64 development. My current view isunless there's pressure to do soit willonly be dot net. We do recognize that Win32 support continues to be important for many Delphi developers, particularly for maintaining existing applications but also for new application development. As such we also plan to continue supporting and developing new Delphi Win32 features for the foreseeable future. ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Programming in Delphi, but have a SQL question
Title: Message SELECT * FROM Subset LEFT JOIN Master ON Master.Pk = Subset.Pk WHERE Master.PK IS NULL; It might be a right join, I always get it mixed up. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Eric Tishler To: NZ Borland Developers Group - Delphi List Sent: Friday, March 19, 2004 9:46 AM Subject: [DUG] Programming in Delphi, but have a SQL question I am trying to implement a new report in Delphi, but I am having problems with the query. I know this is not a straight Delphi question, but I was hoping someone here could steer me in the right direction. I have two tables with transactions. One table contains ALL transactions, the second table is a subset of the first with only a specific set of transactions. The columns differ between the two tables, but there is enough relational information for me to match all of the subset transactions with the master transaction table.In some odd cases the subset transaction is inserted, but the corresponding entry is not added to the master transaction table.I need to write a query that shows which transactions in the subset table do not appear in the master table.Can someone help me with this?Thanks,Eric Eric Tishler Software Architect Resolute Partners, LLC Phone: 203.271.1122 Fax: 203.271.1460 [EMAIL PROTECTED] ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Programming in Delphi, but have a SQL question
Agreed. I think using a JOIN method is faster than doing a sub select (might be significant for a large data set). Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Paul Ritchie [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Friday, March 19, 2004 10:17 AM Subject: RE: [DUG] Programming in Delphi, but have a SQL question I would tend to use an outer join where the JOINed master column is NULL eg SELECT Subset.* FROM Subset LEFT OUTER JOIN Master ON Subset.ID = Master.ID WHERE Master.ID IS NULL cheers, Paul. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Eric Tishler Sent: Friday, 19 March 2004 9:46 a.m. To: NZ Borland Developers Group - Delphi List Subject: [DUG] Programming in Delphi, but have a SQL question I am trying to implement a new report in Delphi, but I am having problems with the query. I know this is not a straight Delphi question, but I was hoping someone here could steer me in the right direction. I have two tables with transactions. One table contains ALL transactions, the second table is a subset of the first with only a specific set of transactions. The columns differ between the two tables, but there is enough relational information for me to match all of the subset transactions with the master transaction table. In some odd cases the subset transaction is inserted, but the corresponding entry is not added to the master transaction table. I need to write a query that shows which transactions in the subset table do not appear in the master table. Can someone help me with this? Thanks, Eric Eric Tishler Software Architect Resolute Partners, LLC Phone: 203.271.1122 Fax: 203.271.1460 [EMAIL PROTECTED] ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Self Freeing
I don't believe that method works if you've already called... .PleaseDontGoOnMeNow (Pearl Jam) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Stephen Barker [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Friday, March 19, 2004 12:35 PM Subject: RE: [DUG] Self Freeing WRT forms however, what you can safely do is call Release (which is introduced on TCustomForm). This will free the form, but only when all event handlers, etc. have finished processing. then there's that old method named: .PleaseReleaseMeLetMeGoCosIDontLoveYouAnyMore but you have to set TObject.StartSinging := true; first Steve ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 8 media download?
Is it just me or isn't this all information Borland should have given you when they told you to download it? I would have thought giving you a link and instructions was something the guys at Borland should have done. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Myles Penlington [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 2:16 PM Subject: RE: [DUG] Delphi 8 media download? No. You can only download the Enterprise trial version. M. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 March 2004 14:16 To: [EMAIL PROTECTED] Subject: RE: [DUG] Delphi 8 media download? Ah okay. Well, a colleague has D8 Professional. Is it the case then that my Enterprise key will cause this to install as an Enterprise version? I wasn't sure, 'cos it has Professional stamped on the physical CD and also all over the installer pages/tabs/etc when you run it up. Thanks, C. -Original Message- From: Myles Penlington [mailto:[EMAIL PROTECTED] There is the trial downloads etc. I presume your key would make it into a full version rather than just a trial/time limited version. D8 comes with quite a few CD's (between 4+) and no printed manuals. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Hi all (or any Delphi 8 users specifically), We ordered a copy of Delphi 8 Enterprise well over a month ago. We've received the license information, but no media so far. A query by our IT staff to Borland told us we could download it from the Borland site, but given a quick check I can't see where. Can anybody point me in the direction of where to download D8 Enterprise from on the Borland site? It would save me waiting weeks to get my hands on the media. ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 8 media download?
Thanks I thought I was going mad :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 23, 2004 2:49 PM Subject: RE: [DUG] Delphi 8 media download? It ain't just you... ;-) I concur wholeheartedly. Cheers, C. -Original Message- From: Robert martin [mailto:[EMAIL PROTECTED] Is it just me or isn't this all information Borland should have given you when they told you to download it? I would have thought giving you a link and instructions was something the guys at Borland should have done. [snip] ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] .Net again
I had D1 years ago (alongside Visual basic) when they were 16Bit products. I used VB because I knew basic. I didn't start using Delphi seriously until D4. I suppose that makes me a newbie :)) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, March 30, 2004 5:12 PM Subject: RE: [DUG] .Net again ??? You weren't around for Delphi 1 then? ;-) Cheers, C. -Original Message- From: Robert martin [mailto:[EMAIL PROTECTED] In the past I have always found Borland's documentation to be rather good. ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Problem with table update using IBO
Maybe a silly question but ... Is there definitely a value in
txtEmail.Text?
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: Eric Tishler [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Friday, April 02, 2004 10:19 AM
Subject: [DUG] Problem with table update using IBO
I have some information I want to allow a user to update in a table.
First I read the data from the table and populate a dialog with the fields
I want to allow as editable.
When the user clicks the Save button I have an update query that gathers
data from the fields and performs an update in the table. This modified data
is used as parameters in the SQL statement.
The problem is that all the fields but one seem to update just fine. The
one field gets the updated information from the dialog, but for some reason
that particular field is not updated in the database table.
The code goes something like this ...
DaDataMod.qryUpdateUserInfo.ParamByName('UserID').asInteger :=
UserInfo.UserID; // This is just a data type with current user info
DaDataMod.qryUpdateUserInfo.ParamByName('FirstName').asString :=
txtFirstName.Text;
DaDataMod.qryUpdateUserInfo.ParamByName('LastName').asString :=
txtLastName.Text;
DaDataMod.qryUpdateUserInfo.ParamByName('EmailAddress').asString :=
txtEmail.Text;
DaDataMod.qryUpdateUserInfo.ExecSQL;
DaDataMod.qryUpdateUserInfo.IB_Transaction.CommitRetaining;
The qryUpdateUserInfo Query looks like this:
UPDATE UserInfo SET
FirstName = :FirstName,
LastName = :LastName,
EmailAddress = :EmailAddress
WHERE
UserID = :UserID
I have debugged this and can clearly see that ALL the fields have the new
data, but the Email field stubbornly refuses to take on a new value. I have
checked and in the database, the Email field is just a VARCHAR(50).
I have tried to look at the SQL statement submitted (using:
DaDataMod.qryUpdateUserInfo.ServerSQL), but this is what I see in my log
file:
4:56:12 PM 4/1/2004 SaveAccountInfo: SQL=
UPDATE UserInfo SET
FirstName = ? /* FirstName */ ,
LastName = ? /* LastName */ ,
EmailAddress = ? /* EmailAddress */
WHERE
UserID = ? /* userid */
I have two questions:
1) Is there something better than ServerSQL to use to see that actual SQL
string submitted? I have tried SQL.Text, but that only show the parameters
before the substitution
2) Why would all the fields be updated except the EmailAdress field?
I have been 'noodling' with this for the past 2 hours. Help!
Thanks,
Eric
Eric Tishler
Software Architect
Resolute Partners, LLC
Phone: 203.271.1122
Fax: 203.271.1460
[EMAIL PROTECTED]
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] IBObjects
Hi All We have Firebird with a table that is stupidly called TRANSACTION (for historical reasons). It was created using the " " syntax however although our IBOTable componentlists the table when we try and open it we get an error. Any ideas? Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Crystal reports
Hi I am working with an ODBC based crystal report. At runtime I want to be able to change the DB the report is looking at (without having multiple DSN's defined). The crystal Help suggests this is possible using the .connect properties however they seem to be ignored when I set them. var cr : TCrpe; cnt : Integer;begin cr := TCrpe.Create(Self); try cr.ReportName := 'C:\a.rpt'; cr.Connect.Clear; cr.Connect.DatabaseName := 'CRWDCDSQ=' + Edit1.Text; cr.Connect.Propagate := True; cr.Show; while (cr.ReportWindowHandle 0) do begin Application.ProcessMessages; end; finally cr.Free; end; I have also tried 'Database' instead of 'DSQ' as suggested in the help but to no avail. I am using Crystal 8.5 and the Firebird ODBC driver. Any suggestions? Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Crystal reports
Hi All
I now have my system up and running 100% . Thanks to all those who helped.
For anyone else who struggles with this issue in future their is a simple
problem (bug) in Crystal reports that stopped all my attempts to change the
DSN.
My software creates a file DSN on the fly for each DB and points crystal to
that file DSN. However the report seemed to ignore the settings. The
problem was the original file DSN was still on the system. It seems that if
the DSN the report was originally created with is still on the system then
any changes are ignored. I deleted the original file DSN and it all works
great now.
Crystal reports 8.5.
Interestingly I would report this to Crystal but you need to have a paid
support account to report bugs We know this from a previous attempt :)
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: Neven [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Friday, April 16, 2004 9:33 AM
Subject: RE: [DUG] Crystal reports
Rob
Easiest way is just setup a working file dsn and then
see what is in it, its usually just a string
ie server=192.168.1.1;database=test;uid=sa;pwd=
Neven
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Robert martin
Sent: Friday, 16 April 2004 9:01 a.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Crystal reports
Hi Neven
Sounds perfect and no problem as we have to change all our reports anyway.
I will try it as soon as I find the settings I need for my ODBC driver :)
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: Neven [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 5:31 PM
Subject: RE: [DUG] Crystal reports
Robert
What we do is use a file dsn and write it before
we launch the report, the only limit is that you
have to design thev report with a file dsn
HTH
Neven
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Behalf Of Robert martin
Sent: Thursday, 15 April 2004 4:28 p.m.
To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Crystal reports
Thanks Rohit
But.. your example works by changing between DSNs (my code also works
for
that:) ). I would have prefered not to have to create a DSN for every
database the software connects to. However it seems I may have to o(
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: Rohit Gupta [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED]
Sent: Thursday, April 15, 2004 4:00 PM
Subject: Re: [DUG] Crystal reports
Excerpt from ours - it works with 8.5 and ODBC. You do have to
have the ODBC alias setup correctly
Tables.Propagate := true;
Connect.Propagate := true;
{ Connect to Database }
if Connect.ServerName IB_Alias then
with Connect
do begin
ServerName := IB_Alias;
UserID := IBNrm_User;
Password := IBNrm_Pwd;
Propagate := true;
end;
Hi
I am working with an ODBC based crystal report. At runtime I want to
be
able to change the DB
the report is looking at (without having multiple DSN's defined).
The
crystal Help suggests this is
possible using the .connect properties however they seem to be
ignored
when I set them.
var
cr : TCrpe;
cnt : Integer;
begin
cr := TCrpe.Create(Self);
try
cr.ReportName := 'C:\a.rpt';
cr.Connect.Clear;
cr.Connect.DatabaseName := 'CRWDCDSQ=' + Edit1.Text;
cr.Connect.Propagate := True;
cr.Show;
while (cr.ReportWindowHandle 0) do begin
Application.ProcessMessages;
end;
finally
cr.Free;
end;
I have also tried 'Database' instead of 'DSQ' as suggested in the
help
but to no avail. I am using
Crystal 8.5 and the Firebird ODBC driver. Any suggestions?
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Regards
Rohit
==
CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand
PH(649) 489-2280
FX(649) 489-2290
email [EMAIL PROTECTED] or [EMAIL PROTECTED]
==
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Dumb question
Hi All
This may be a dumb question but...
How do I assign an Int64 variable to a Int64 field
in a DB. Usually we use FieldByName('sdf').AsInteger := xx to assign values.
What is the appropriate way to do this?
Rob MartinSoftware Engineerphone
03 377 0495fax 03 377 0496 web www.chreos.com
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Print a receipt
Hi Leo Don't know about Quick Reports but many POS printers have an option to Auto cut after any printing. Otherwise you need to send the control string to the printer after printing the report. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Leo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 21, 2004 11:22 AM Subject: [DUG] Print a receipt Hello, Does anyone know how to print a receipt (to a Thermal Printer) with Quick Report? Can I send paper cut command from Quick Report or not?Leo Software Developer CFL [EMAIL PROTECTED] http://www.cfl.co.nz ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] BDE - SQL DB
Hi All We are converting from Dbase / BDE to Firebird / IBObjects. In our app there are a number of instances where we create a dbase table based on an sql result set and create a newempty field used for editing. i,e. SELECT Name, Phone, "F" AS Selected FROM Person; The Selected field is edited in the resulting table and used for filtering etc. What is the best / simplest way of converting this functionality to Firebird. Bearing in mind that we are trying to make as few changes to code as is possible at this point (to avoid bugs). These results never need to be committed to the database and are only used for display. I have thought of using a TClientDataset (which works great) but cannot see an IBObjects equivalent. Any help or suggestions would be greatly appreciated :) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG]: quick report newbie...
Cant help with quick reports but it probably works similarly to Crystal reports. Try putting a box starting in your header, through your detail and ending in your footer. In the Detail section draw a line that touches both sides of the box. Hope that makes sense :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Chris Veale [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, May 04, 2004 2:36 PM Subject: [DUG]: quick report newbie... Hi. Im trying to create a simple table in quick reports that comes with Delphi 5 Pro. The only way I can see to do this is using the qrshape component, but I cant get both horizontal and vertical lines there. Is there a table component that will let me do this? Cheers Chris __ The contents of this e-mail are privileged and/or confidential to the named recipient and are not to be used by any other person and/or organisation. If you have received this e-mail in error, please notify the sender and delete all material pertaining to this e-mail. __ ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Large integers again
Hi All
We want to access Int64 fields in a DB. We
have code like
AcustomTable.FieldByName('Ref').AsInteger
:=111;
We can access Int64s by changing it to
(AcustomTable.FieldByName('Ref') as
TLargeintField).AsLargeInt := 111;
I would love not to have to change all our code to the above. What I
would like to do is override the asInteger stuff in a custom table component and
have it check to see if the integer is a large int and handle it as above.
Does this sound feasible ? Are there better options?
Rob MartinSoftware Engineerphone
03 377 0495fax 03 377 0496 web www.chreos.com
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Debugging problem
Hi Mark Try deleting all your dcu files and doing a complete rebuild, check search paths etc. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Mark Howard [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, April 28, 2004 3:25 PM Subject: [DUG] Debugging problem Hi All I'm trying to step through some code (in one of my QuickReports units) but kepp getting blocked by a message box that comes up on lines that are clearly not the cause of any errors, saying title: SourceFilenot found: qrctrls.pas message: Path to source file then a ComboBox with qrctrls.pas with a browse button at the side then a check box entitled Add directory to Debug Source Path followed by four buttons OK, Cancel Ignore and Help. If I click on any of the first 3 buttons I get a CPU wundow with lots of high powered looking address info. All this is preventing me from stepping to the line causing the real error I want to trck down. I don't have the qrctrls.pas file as I don't have QR source code. Any help wouyld be REALLY appreciated. TIA Mark ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] GetComputerName API and Windows TS
Hi All Our app has been displaying the NetBIOS name of each client computer in its log. However in a Terminal Server environment the GetComputerName API (that we use to get the name) always returns the TS Server computer and is therefore the same for all TS users. I have tried GetComputerNameEx but that does not seem to provide the desired information either. Does anybody have any suggestions as to how to achieve this? TIA Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] remote access options
Hi Terminal Services work well (Better than VNC) over a dial up, especially when graphics are cashed locally. It also handles the printing. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Stephen Barker [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Friday, May 28, 2004 1:04 PM Subject: [DUG] remote access options Hi all, I've got a request at present from a customer who has rapidly grown from a one-man tradesman company to employing a dozen or more staff, some in the office, some working from another office and some on site (construction). They need hardware and software to enable easy access to quotes, jobs, drawings, email etc from remote sites. Some of these sites will not have broadband, and they will need laptop/gprs or pda/gprs type solutions. Before I get started researching, does anyone have any ideas or opinions or know of any existing solutions on: 1. remote access using pcAnywhere, VNC etc (too slow to be feasible over dialup?) 2. Terminal Services - is it practical to use over dial-up or gprs? 3. Remote printing - they may need to print quotes/Invoices from the truck. 4. Redevelop a web interface to their software (or parts of it) so direct data entry can be done with a browser, and therefore a pda. 5. Laptop users with full software/data and a synchronisation method back to the office DB - preferably over dial-up. (Briefcase) 6. Develop PDA cut down version of their software with similar synchronisation. What does everyone else do for remote users of their software? thanks, Steve ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Temporary Tables Interbase / Firebird
Thanks to everyone who replied. There is certainly a lot to think about. We always try to use joins wherever possible and I agree that sub selects are as slow as the plague :). We are using Firebird and hoping to maintain IB compatibility if possible. This is our first major FB / IB application and as such are very much at the novice stage of things. Do you have recommended text or web site etc ? I have seen some people mention temptables in reference to IB / Firebird etc. Are these simply tables created in the DB, used and then deleted (Drop table ), or are they something else special? You (and others) mention using a stored procedure to work around this. I understand this might be useful if the temp table is for display purposes however in this specific case an empty table is created with a variable number of fields and used for entry /processing. Can a stored procedure be used in this case? Sorry if this topic should be in the DUG DB, I will subscribe shortly. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Trevor Jones To: NZ Borland Developers Group - Delphi List Sent: Monday, May 31, 2004 5:56 PM Subject: Re: [DUG] Temporary Tables Interbase / Firebird Robert, I think IB 7.1 supports temporary tables, but I have never found a good reason to use them in FB. A dBase app is necessarily going to be very different from one that works with either IB or FB, so you are going to find that you have to re-think alot of the things that you do. Stored procedures often help fill the void when you think that you need a temp table, but the FB/IB language is so rich that you can often get away without having to even think in terms of temp tables. I've converted a whole bunch of apps from Paradox/dBase to IB/FB, and have found that the best solution is to re-think the way that you want to access the data. A good tool that can show you not only query plans, but also number of reads is essential. Sometimes a full table scan in IB/FB is more efficient than trying to jump through hoops ensuring that the index that you think is the best is the one used. Stuff that looks like it would suck performance-wise in Paradox or dBase is often very fast when you let the server do all of the work. Also, if you brush up on using joins, you can make the server respond much faster than you could ever get a flat-file db to respond. Lots of people come unstuck when trying to use sub-selects in queries. These will always run slow, and can almost always be re-written as joins which run quickly, but the join syntax to avoid sub-selects is often not available in dbAccess methods like the BDE. There are some cool functions (such as coalesce) which are available in FB (but not IB) which can remove sub-selects make your query faster, but unfortunately they also tie you to a specific engine. I like to use the "break" keyword in my FB databases, but it doesn't work in IB. If you give us specific examples, I'm sure that members of the community can show you how to translate what you want to do in dBase to what you should ask a FireBird server to do. HTH Trevor - Original Message - From: Robert martin To: [EMAIL PROTECTED] org. nz Sent: Monday, May 31, 2004 4:25 PM Subject: [DUG] Temporary Tables Interbase / Firebird Hi As you may have gathered we are moving from Dbase to Firebird. An app we have makes some temporary (dbase) tables and after processing disposes of them. I know we can create tables in FB / IB on the fly but we are reluctant to risk polluting our database with these temporary tables. Any suggestions greatly appreciated :) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Temporary Tables Interbase / Firebird
Hi Colin We are using IBO as our connection method, the BDE is DEAD.I have subscribed to the Interbase user group and will see how that goes (do you know if Firebird is a dirty word there?) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: C Fraser To: 'NZ Borland Developers Group - Delphi List' Sent: Tuesday, June 01, 2004 9:29 AM Subject: RE: [DUG] Temporary Tables Interbase / Firebird Main web sites for FB are www.firebirdsql.com and http://www.ibphoenix.com/. The lists and news groups (see the firebirdsql site) are very busy... almost to much to take in... 50-150 messages a day, but there is a lot of expert knowledge there. One of the first things to look at is how are you accessing the DB, BDE, IBO, IBX etc... Everyone seems to try and avoid the BDE (even Borland now a days I believe...). Regards Colin From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martinSent: Tuesday, 1 June 2004 9:05 a.m.To: Trevor Jones; NZ Borland Developers Group -Delphi ListSubject: Re: [DUG] Temporary Tables Interbase / Firebird Thanks to everyone who replied. There is certainly a lot to think about. We always try to use joins wherever possible and I agree that sub selects are as slow as the plague :). We are using Firebird and hoping to maintain IB compatibility if possible. This is our first major FB / IB application and as such are very much at the novice stage of things. Do you have recommended text or web site etc ? I have seen some people mention temptables in reference to IB / Firebird etc. Are these simply tables created in the DB, used and then deleted (Drop table ), or are they something else special? You (and others) mention using a stored procedure to work around this. I understand this might be useful if the temp table is for display purposes however in this specific case an empty table is created with a variable number of fields and used for entry /processing. Can a stored procedure be used in this case? Sorry if this topic should be in the DUG DB, I will subscribe shortly. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Trevor Jones To: NZ Borland Developers Group - Delphi List Sent: Monday, May 31, 2004 5:56 PM Subject: Re: [DUG] Temporary Tables Interbase / Firebird Robert, I think IB 7.1 supports temporary tables, but I have never found a good reason to use them in FB. A dBase app is necessarily going to be very different from one that works with either IB or FB, so you are going to find that you have to re-think alot of the things that you do. Stored procedures often help fill the void when you think that you need a temp table, but the FB/IB language is so rich that you can often get away without having to even think in terms of temp tables. I've converted a whole bunch of apps from Paradox/dBase to IB/FB, and have found that the best solution is to re-think the way that you want to access the data. A good tool that can show you not only query plans, but also number of reads is essential. Sometimes a full table scan in IB/FB is more efficient than trying to jump through hoops ensuring that the index that you think is the best is the one used. Stuff that looks like it would suck performance-wise in Paradox or dBase is often very fast when you let the server do all of the work. Also, if you brush up on using joins, you can make the server respond much faster than you could ever get a flat-file db to respond. Lots of people come unstuck when trying to use sub-selects in queries. These will always run slow, and can almost always be re-written as joins which run quickly, but the join syntax to avoid sub-selects is often not available in dbAccess methods like the BDE. There are some cool functions (such as coalesce) which are available in FB (but not IB) which can remove sub-selects make your query faster, but unfortunately they also tie you to a specific engine. I like to use the "break" keyword in my FB databases, but it doesn't work in IB. If you give us specific examples, I'm sure that members of the community can show you how to translate what you want to do in dBase to what you should ask a FireBird server to do. HTH Trevor - Original Message - From: Robert martin To: [EMAIL PROTECTED] org. nz Sent: Monday, May 31, 2004 4:25 PM Subject: [DUG] Temporary Tables Interbase / Firebird Hi As you may hav
Re: [DUG] ADO Connectionstring
Title: Message Hi Jeremy, its something like Uses ADODB; ConnectionStr := PromptDataSource (0, ''); ADOConnection.ConnectionString := ConnectionStr; Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Jeremy Coulter To: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 8:17 AM Subject: [DUG] ADO Connectionstring Hi All. Is there a way to invoke the ConnectionString wizard that gets called when you dbl click on the connection string property insay anADO Table? Not sure if this has been asked before or not, so sorry if it has been. Cheers, Jeremy Coulter All email scanned with Nortons Antivirus 2003 ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] ADO Connectionstring
Yup, its really simple to use and a good 'user' experience :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: vss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 9:03 AM Subject: Re: [DUG] ADO Connectionstring great thanks Robert. I was only taking a punt that it was availible at runtime, but this will make my life a bit easier. Save me a heap of unnessacery work re-inventing the wheel ;-) Jeremy -Original Message- From: Robert martin [EMAIL PROTECTED] To: [EMAIL PROTECTED], NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Date: Wed, 9 Jun 2004 08:38:16 +1200 Subject: Re: [DUG] ADO Connectionstring MessageHi Jeremy, its something like Uses ADODB; ConnectionStr := PromptDataSource (0, ''); ADOConnection.ConnectionString := ConnectionStr; Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Jeremy Coulter To: [EMAIL PROTECTED] Sent: Wednesday, June 09, 2004 8:17 AM Subject: [DUG] ADO Connectionstring Hi All. Is there a way to invoke the ConnectionString wizard that gets called when you dbl click on the connection string property in say an ADO Table? Not sure if this has been asked before or not, so sorry if it has been. Cheers, Jeremy Coulter --- - All email scanned with Nortons Antivirus 2003 --- - --- --- ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Windows 98 problems
Isn't there some exe size limit (10mb ?) on Windows 9x? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Nahum.Wild [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Friday, June 11, 2004 11:54 AM Subject: [DUG] Windows 98 problems Hi all, We recently made some changes to our largest delphi 4 application and now it does not work under Windows 98. When I say does not work I literrly mean that, it won't run any more windows just says 'There is not enough memory to start x' or something similiar and suggests 'Quit some running programs, and then try again. The problem is that it happens as soon as you double click on the app or run it from the delphi ide. I've put a break point on the begin in the dpr and it doesn't even get there. It's like win98 is looking at the exe and deciding it can't run it - and doesn't give a particullarly helpfull message. Memory is not the issue as there is 512mb of it and nothing else running. So I was just wondering if anyone else had encountered this problem and/or maybe had some ideas to diagonse the situation. I can provide more info if you want. Cheers, Nahum Wild Software Innovator Process Consultant PayGlobal ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] WinXp Problem
I think this is a win NT codebase problem. Under some circumstances it takes a long time to create a new folder, this may apply to anything? I recall it was related to the number of files/ folders in a directory. Might just be waffling so Ill give up now :) I apologise for any time spent reading this! Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Jeremy Coulter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, June 11, 2004 1:39 PM Subject: [DUG] WinXp Problem I donthave a Win98 problem , BUT I DO have a windows Xp problem thats come to light. Basically, Xp functions ok, BUT, when ever I try to open say a 1kb txt file it takes ages and ages to open. its take 45 seconds because I just timed it. The same happend if Itry to delete it, and even when I right click on the file !!! BTW this is on a local PC too !! I have search the net but nothing seems to come back. I have removed Office, turned off Virus scanner, end-tasked stuff in task Manger, and it still happens ! You can imagin this is NOT very productive ! Anyone heard of this before? or know how to resulve it? I pretty much have run out of ideas, and think my next port of call will be a pac rebuildafter just getting it. Its brand new :( well 2weeks old now. jeremy ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] PDF's and form filling.
I find it hard to reply to emails as I am in a time warp. Messages range from instant to days old, so whenever I see a question I cant be sure if it hasn't already been answered. Most of the time I see answers before the original question (which can be confusing). I know its UDP email and all that but normally everything works sweet, this problem seems to only happen when xtra is having difficulties (as they did a while ago). Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: James Sugrue To: 'NZ Borland Developers Group - Delphi List' Sent: Thursday, June 17, 2004 1:38 PM Subject: RE: [DUG] PDF's and form filling. Starting to look that way. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Myles PenlingtonSent: Thursday, 17 June 2004 1:00 p.m.To: 'NZ Borland Developers Group - Delphi List'Subject: RE: [DUG] PDF's and form filling. I noticed there was no replies ... Has everybody left this list for the dotnet lists instead? ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi applications on mulitprocessor machines
I have a client server application written in Delphi 6. The server portion runs on a fairly 'beefed up' machine with 2 Xeon processors running at 2GHz each. I also have 2GB of RAM and a lot of other server class hardware. When I bring up my task manager window and look at processor performance, I actually see 4 separate processor windows. The 4CPU windows shown is a Windows thing, there are 2 hypertreaded cpus in the system, each acts to the OS as a 2 separate CPUs. My guess is CPU windows 1 and 2 are the first CPU and 3 and 4 are the second CPU. Can anyone tell me how to read this window? Am I actually utilizing the second processor at all? Is there something I have to do specifically in my Delphi code (or linker/compiler) to make my server application more fully utilize the system hardware. I to would like to know this. Our server app is fully threaded, on multiprocessor machines is there anything else we need to do or will Windows gracefully scale our app so that threads run on different CPUs? I am also running Firebird 1.0.3 on this system too. Yes, my server application does connect to the database. Firebird can only take advantage of multi processor machines in 'classic' mode, the 'super server' version currently does not take advantage of multiple CPUs. However you may be able to 'force' it to use a particular CPU, so if your app is only running on processor 1 the database could run on processor 3. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Eric Tishler [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Wednesday, June 23, 2004 9:01 AM Subject: [DUG] Delphi applications on mulitprocessor machines Hi All, I have a client server application written in Delphi 6. The server portion runs on a fairly 'beefed up' machine with 2 Xeon processors running at 2GHz each. I also have 2GB of RAM and a lot of other server class hardware. When I bring up my task manager window and look at processor performance, I actually see 4 separate processor windows. Processor window 1 shows 25% most of the time. Processor window 2 and 4 show 0%. While processor window 3 very occasionally shows 5 or 10%, but most often it just shows 0%. Can anyone tell me how to read this window? Am I actually utilizing the second processor at all? Is there something I have to do specifically in my Delphi code (or linker/compiler) to make my server application more fully utilize the system hardware. I am also running Firebird 1.0.3 on this system too. Yes, my server application does connect to the database. Any help would be greatly appreciated. Thank you, Eric Eric Tishler Software Architect Resolute Partners, LLC Phone: 203.271.1122 Fax: 203.271.1460 [EMAIL PROTECTED] ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi applications on mulitprocessor machines
Hi Conor Thanks for the thought :) If I had thought a little harder I would have probably remembered to correct phrase as well. Am I right in suggesting that a multithreaded app will automatically make use of multiple processors if they exist / right version of windows? I wonder because I often read about developers needing to re code applications to make use of multiple processors. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, June 24, 2004 8:25 AM Subject: RE: [DUG] Delphi applications on mulitprocessor machines Sure. As you say, I just thought it might be useful to you and/or Robert. As he suggested, we've used it to run a database process exclusively on one processor and our app on another. We were trying to do some performance testing, and thought that would provide us with a environment that would be a bit easier to profile. Cheers, C. -Original Message- From: Eric Tishler [mailto:[EMAIL PROTECTED] I am not sure I want to permanently set the processor affinity. I want to let the applications used the processors in the most efficient way. This is still interesting an potentially useful information anyway. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] FYI the term you are looking for in terms of forcing apps onto particular processors is 'processor affinity'. Here's an article on it: http://www.jsiinc.com/SUBH/TIP3500/rh3542.htm ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Windows services
Hi Phil The application is a TCP server application that has some minimal windows interface (that need not be displayed). We have a client who wants it to run without a user logging on. We were kind of hoping for a simple way of running a standard app as a service. We are currently porting the application (client and server) from Dbase to Firebird so we really don't have the time to do major changes to the current version. I found http://www.activeplus.com/us/products/smill/ which looks good but seems very expensive for what we want. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Phil Scadden [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, July 01, 2004 4:20 PM Subject: Re: [DUG] Windows services We have a large existing application (server) that one of our users would like to run as a service. Is there an easy way to achieve this? Depends. if it is an application without user interfaces, that will move happily into a services Execute thread, then yes. You need to consider things like privileges required, and make sure it can run from local hard drive (getting services to see network devices is fun - NOT). If there is a user-interface component, then really need to separate that out into separate app that can communicate with the server. Not so simple. -- Phil Scadden, Senior Scientist. Institute of Geological and Nuclear Sciences 764 Cumberland St, Private Bag 1930, Dunedin, New Zealand Ph +64 3 4799663, fax +64 3 477 5232 ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Windows services
GREAT !!! Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Stacey Verner [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, July 02, 2004 8:50 AM Subject: RE: [DUG] Windows services You specify a username and password in the scheduled task so you can make it whatever you like. Stacey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martin Sent: Friday, 2 July 2004 8:45 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Windows services Sounds great Stacey !! What security mode does the application run under (we would like Administrator). Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Stacey Verner [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, July 02, 2004 8:10 AM Subject: RE: [DUG] Windows services You can do this without creating a service. Create a new scheduled task and set it to start when the machine is started. We do this with a few of our apps and it works fine. One trap for young players is that sheduled tasks have an option to stop the process after 73 hours which is on by default. Make sure you switch this off. Stacey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Robert martin Sent: Thursday, 1 July 2004 16:48 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Windows services Hi Phil The application is a TCP server application that has some minimal windows interface (that need not be displayed). We have a client who wants it to run without a user logging on. We were kind of hoping for a simple way of running a standard app as a service. We are currently porting the application (client and server) from Dbase to Firebird so we really don't have the time to do major changes to the current version. I found http://www.activeplus.com/us/products/smill/ which looks good but seems very expensive for what we want. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Phil Scadden [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, July 01, 2004 4:20 PM Subject: Re: [DUG] Windows services We have a large existing application (server) that one of our users would like to run as a service. Is there an easy way to achieve this? Depends. if it is an application without user interfaces, that will move happily into a services Execute thread, then yes. You need to consider things like privileges required, and make sure it can run from local hard drive (getting services to see network devices is fun - NOT). If there is a user-interface component, then really need to separate that out into separate app that can communicate with the server. Not so simple. -- Phil Scadden, Senior Scientist. Institute of Geological and Nuclear Sciences 764 Cumberland St, Private Bag 1930, Dunedin, New Zealand Ph +64 3 4799663, fax +64 3 477 5232 ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 9 and beyond
Not so sure if a pub as a great place to talk about stuff that requires signing a non disclosure agreement ! However I do like the idea of a beer with my Delpi :) I would go shooters / loaded hogover the grumpy mole. And would try for an after lunch time slot rather than later afternoon / evening if we use a pub. I like the location (nice and central, about two blocks from us :) ) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Traci Sumpter To: NZ Borland Developers Group - Delphi List Sent: Monday, July 05, 2004 3:20 PM Subject: RE: [DUG] Delphi 9 and beyond Grumpy Mole is quite FridayAfternoons. Shooters has a small nook.. Both cnr Manchester and Cashel Streets -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Richard VowlesSent: Monday, 5 July 2004 2:53 p.m.To: NZ Borland Developers Group - Delphi ListSubject: RE: [DUG] Delphi 9 and beyond Would you like to nominate one then? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Traci SumpterSent: Monday, 5 July 2004 2:49 p.m.To: NZ Borland Developers Group - Delphi ListSubject: RE: [DUG] Delphi 9 and beyond Pubs are good round here Some even have little nooks and crannys to fit a small number of folk in... We are a social lot down here... ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 9 and beyond
Wow some really appalling typos / grammar in that one. My apologies :) 'evening if we use a pub' should have been 'if we use a pub' Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Robert martin To: NZ Borland Developers Group - Delphi List Sent: Monday, July 05, 2004 4:19 PM Subject: Re: [DUG] Delphi 9 and beyond Not so sure if a pub as a great place to talk about stuff that requires signing a non disclosure agreement ! However I do like the idea of a beer with my Delpi :) I would go shooters / loaded hogover the grumpy mole. And would try for an after lunch time slot rather than later afternoon / evening if we use a pub. I like the location (nice and central, about two blocks from us :) ) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Traci Sumpter To: NZ Borland Developers Group - Delphi List Sent: Monday, July 05, 2004 3:20 PM Subject: RE: [DUG] Delphi 9 and beyond Grumpy Mole is quite FridayAfternoons. Shooters has a small nook.. Both cnr Manchester and Cashel Streets -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Richard VowlesSent: Monday, 5 July 2004 2:53 p.m.To: NZ Borland Developers Group - Delphi ListSubject: RE: [DUG] Delphi 9 and beyond Would you like to nominate one then? From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Traci SumpterSent: Monday, 5 July 2004 2:49 p.m.To: NZ Borland Developers Group - Delphi ListSubject: RE: [DUG] Delphi 9 and beyond Pubs are good round here Some even have little nooks and crannys to fit a small number of folk in... We are a social lot down here... ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] TThread.Destrpy
Not normal. Have you remembered to override the destructor? In your execute method are you checking the terminated property? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Rohit @cfl.co.nz To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, July 23, 2004 4:12 PM Subject: [DUG] TThread.Destrpy When I have a threads freeonterminate set and terminate is invoked in the mainforms formclose the threads destroy is not called. Is this normal ? How do I get around it ?Regards Rohit == CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH(649) 489-2280 FX(649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] == ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Displayformat
Is your source database table actually able to store more than 2dp ? Sounds to me like your entries are being truncated when they are posted to the DB. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Leo [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 11:57 AM Subject: [DUG] Displayformat I have a problem with DisplayFormat. I put both the EditFormat and DisplayFormat as '#.#' or '0.#' for a numeric field. If the number is = 0.01, there is no problem. But if the number is less than 0.01, say 0.00523, it does not display (It does not print on report as well) but it did show on edit mode properly. Any advice appreciate. Leo Software Developer CFL [EMAIL PROTECTED] http://www.cfl.co.nz ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Welcome back problem
Hi Deiter Im not sure I follow your logic here. door 1, you get some new information only about door 1 and door 3. This is What new information do you ahve about door 3 that you do not have about door 2? for door 3 is the sum of the probabilities of door 1 and 3 minus the probability of door 1, it follows that the probability of door 3 is 2/3 mins 0 equal to 2/3. Isn't the probability of Door two 2/3 minus 0 ... 2/3 as well? I think the probability of door 2 is the same as door three. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Dieter Köhler [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 12:35 PM Subject: RE: [DUG] Welcome back problem Doors 1 2 3 I choose 2 - probability of Car = 1/3 Host opens 1 = Goat - probability of: 2 = car is 1/2. 3 = car is 1/2. The probability of door 2 (1/3) does not change, and the sum of the probabilities of door 1 and 3 (2/3) do not change. When the host opens door 1, you get some new information only about door 1 and door 3. This is the reason, why the probability for door 2 remains the same. For door 1 you get the information that the probability is 0. Since the probability for door 3 is the sum of the probabilities of door 1 and 3 minus the probability of door 1, it follows that the probability of door 3 is 2/3 mins 0 equal to 2/3. Dieter ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Welcome back problem
Glad someone else sees it that way :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Paul M - ProSouth [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 2:00 PM Subject: Re: [DUG] Welcome back problem I choose 2, host opens 1 to reveal goat. Well, to start with, there is an equal probability that each door has the car (1/3). However, once Door 1 has been opened to reveal the goat, the probability equation changes to: P[2=car] GIVEN THAT (P[door1] = 0) which gives us a 50/50 scenario. All other conflicting scenarios presented ignores the GIVEN THAT clause. The original probability of 1/3 is no longer valid, as we have additional information. The logic is as simple as the stats. There are now two doors. There is now a goat and a car. It's a 50/50 scenario. Regards, Paul Matthews ProSouth Technology Solutions Phone: +64 3 470 1321 DDI: +64 3 470 1324 0800 PROSOUTH (0800 776 768) 249 Cumberland Street, Dunedin, New Zealand Visit us at www.prosouth.co.nz - Original Message - From: Neven MacEwan [EMAIL PROTECTED] To: DUG [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 10:20 AM Subject: [DUG] Welcome back problem Hi Guys This is a little off-topic but what the hell A small problem for all of you, You are on a game show and are shown 3 doors behind 1 is a car and the other 2 goats. You are asked to choose a door and you do (but don't open it), The host then opens one of the other doors and shows you a goat Do you change your choice or stick with your original door? (assuming you don't want to win a goat) I'll post the answer this afternoon -- Neven MacEwan (B.E. EE) Ph. 09 621 0001 Mob. 0274 749062 ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Welcome back problem
Title: RE: [DUG] Welcome back problem No. There is no such thing as 'Greater value'. Whatever door is initially chosen leaves 1 door with a car and one with a goat. If you have to choose again you are choosing which of two doors has a car, a 1/2 (50%) chance. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Marshall, Paul To: NZ Borland Developers Group - Delphi List Sent: Thursday, August 05, 2004 2:23 PM Subject: RE: [DUG] Welcome back problem That would be true if he always opened door 1. But he may choose door 1 or door 3, and he deliberately chooses the one of least value. The remaining door therefore is likely to have greater value. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul M - ProSouthSent: Thursday,August,05,2004 2:18 p.m.To: NZ Borland Developers Group - Delphi ListSubject: Re: [DUG] Welcome back problem Or both. We didn't know which other one, or possibly other two. The additional information is that we now know that one of the doors, door 1, DEFINATELY has the goat. This leaves two doors (one with a goat, one with a car), and a 50/50 choice over which to pick (stay with original pick or change). Regards, Paul MatthewsProSouth Technology SolutionsPhone: +64 3 470 1321DDI: +64 3 470 13240800 PROSOUTH (0800 776 768)249 Cumberland Street, Dunedin, New ZealandVisit us at www.prosouth.co.nz - Original Message - From: Marshall, Paul To: NZ Borland Developers Group - Delphi List Sent: Thursday, August 05, 2004 2:09 PM Subject: RE: [DUG] Welcome back problem But there is _no_ additional information - you already knew that one of the other doors had a goat. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Paul M - ProSouth Sent: Thursday,August,05,2004 2:01 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Welcome back problem I choose 2, host opens 1 to reveal goat. Well, to start with, there is an equal probability that each door has the car (1/3). However, once Door 1 has been opened to reveal the goat, the probability equation changes to: P[2=car] GIVEN THAT (P[door1] = 0) which gives us a 50/50 scenario. All other conflicting scenarios presented ignores the "GIVEN THAT" clause. The original probability of 1/3 is no longer valid, as we have additional information. The logic is as simple as the stats. There are now two doors. There is now a goat and a car. It's a 50/50 scenario. Regards, Paul Matthews ProSouth Technology Solutions Phone: +64 3 470 1321 DDI: +64 3 470 1324 0800 PROSOUTH (0800 776 768) 249 Cumberland Street, Dunedin, New Zealand Visit us at www.prosouth.co.nz - Original Message - From: "Neven MacEwan" [EMAIL PROTECTED] To: "DUG" [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 10:20 AM Subject: [DUG] Welcome back problem Hi Guys This is a little off-topic but what the hell A small problem for all of you, You are on a game show and are shown 3 doors behind 1 is a car and the other 2 goats. You are asked to choose a door and you do (but don't open it), The host then opens one of the other doors and shows you a goat Do you change your choice or stick with your original door? (assuming you don't want to win a goat) I'll post the answer this afternoon -- Neven MacEwan (B.E. EE) Ph. 09 621 0001 Mob. 0274 749062 ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi Attention: The information contained in this message and/or attachments from AgResearch Limited is intended only for the persons or entities to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipients is prohibited by AgResearch Limited. If you have received this message in error, please notify the sender immediately. ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi Attention: The information contained in this message and/or attachments from AgResearch Limited is intended only for the persons or entities to which it is
Re: [DUG] Welcome back problem
To realise the new 1/2 probability, you need to change your choice. YES ! You need to choose either your original door (50%) or the other door (50%) so you have equal odds even if you choose to stick with your original door. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Allan, Samuel [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 2:34 PM Subject: RE: [DUG] Welcome back problem I could still be wrong, but this is how you get my 1/2. But you must take advantage of it. When you chose your first door, your chances were 1/3. So if you stay with your first pick, your chances remain 1/3, because it was made when you could pick from 3 doors. You have more information now (one of the doors is definitely goat), but you have not acted on it. Your choice is still from the original three doors. To realise the new 1/2 probability, you need to change your choice. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul M - ProSouth Sent: Thursday, August 05 2004 2:21 p.m. To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Welcome back problem Ok, if he opens door 2 to reveal the goat, we now know that option B (GCG) is incorrect, leaving: A: G G C C: C G G Again, a 50/50 scenario. Regards, Paul Matthews ProSouth Technology Solutions Phone: +64 3 470 1321 DDI: +64 3 470 1324 0800 PROSOUTH (0800 776 768) 249 Cumberland Street, Dunedin, New Zealand Visit us at www.prosouth.co.nz - Original Message - From: Stacey Verner [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 2:11 PM Subject: RE: [DUG] Welcome back problem We aren't assuming that he opens door 3. He will open a door with a goat, which in case A is door 2. Stacey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul M - ProSouth Sent: Thursday, 5 August 2004 14:03 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Welcome back problem What you are ignoring is the additional information. Using your matrix, the host opens door 3 to reveal a goat. This now removes Option A, G G C, as being a possibility, leaving: B: G C G C: C G G There is now a 50% chance that the car is behind door 1 or 2. Regards, Paul Matthews ProSouth Technology Solutions Phone: +64 3 470 1321 DDI: +64 3 470 1324 0800 PROSOUTH (0800 776 768) 249 Cumberland Street, Dunedin, New Zealand Visit us at www.prosouth.co.nz - Original Message - From: Alister Christie [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 1:36 PM Subject: Re: [DUG] Welcome back problem There are 3 possible arrangements A: G G C B: G C G C: C G G if we assume that we choose door number 1 each time in both A B we have choosen incorrectly and switching will give us the correct answer (presuming the presenter always reveals a goat) In C we have choosen correctly and if we switch we loose. So 2 out of 3 times if we switch we win, so I think switching is our best bet. Alister ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Welcome back problem
I humbly admit defeat at the hand of Delphi. I should have paid closer attention to the sample apps (like running them). I think you explanation is good Alister but than what would I know :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Alister Christie [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 3:18 PM Subject: Re: [DUG] Welcome back problem I thought I had a good explination Here is my table again A: G G C B: G C G C: C G G A: represents Goat behind doors 1 2 and Car behind Door 3 Lets continue to assume that we still always pick door number 1 A: We've chosen a goat (however we don't know this). The presenter will now tell us that there is a goat behind door 2. What happens if we stay or swap? Stay - Goat Swap - Car B: Still chosen a goat, the presenter shows us that there is a goat behind door number 3. And again here is what happens if we stay or swap. Stay - Goat Swap - Car C: Got the car this time, the presenter shows that there is a goat behind door 2 (or 3) Stay - Car Swap - Goat So if we stay we get Goat, Goat, Car, thus 1 out of 3 times we get the car. If we swap we get Car, Car, Goat - 2 out of 3 times we get the car. The same arguments apply if we initially chose door 2 or door 3. I hope this explination makes things clearer. I think the main confusion is from trying to assign probabilities. If I've missed something and am wrong then will somebody explain my confusion in language simple enough so that I can understand it ;-) However I think that the test applications also show that the answer is correct even if my reasoning is wrong. Alister Paul M - ProSouth wrote: Ok, if he opens door 2 to reveal the goat, we now know that option B (GCG) is incorrect, leaving: A: G G C C: C G G Again, a 50/50 scenario. Regards, Paul Matthews ProSouth Technology Solutions Phone: +64 3 470 1321 DDI: +64 3 470 1324 0800 PROSOUTH (0800 776 768) 249 Cumberland Street, Dunedin, New Zealand Visit us at www.prosouth.co.nz - Original Message - From: Stacey Verner [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 2:11 PM Subject: RE: [DUG] Welcome back problem We aren't assuming that he opens door 3. He will open a door with a goat, which in case A is door 2. Stacey -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Paul M - ProSouth Sent: Thursday, 5 August 2004 14:03 To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Welcome back problem What you are ignoring is the additional information. Using your matrix, the host opens door 3 to reveal a goat. This now removes Option A, G G C, as being a possibility, leaving: B: G C G C: C G G There is now a 50% chance that the car is behind door 1 or 2. Regards, Paul Matthews ProSouth Technology Solutions Phone: +64 3 470 1321 DDI: +64 3 470 1324 0800 PROSOUTH (0800 776 768) 249 Cumberland Street, Dunedin, New Zealand Visit us at www.prosouth.co.nz - Original Message - From: Alister Christie [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 05, 2004 1:36 PM Subject: Re: [DUG] Welcome back problem There are 3 possible arrangements A: G G C B: G C G C: C G G if we assume that we choose door number 1 each time in both A B we have choosen incorrectly and switching will give us the correct answer (presuming the presenter always reveals a goat) In C we have choosen correctly and if we switch we loose. So 2 out of 3 times if we switch we win, so I think switching is our best bet. Alister ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] email, fax and text
I know very little about sms (I don't even own a cell phone !!!)but I think the newer Telecom phones can be set to report back when a sms has been received. So they would probably work great with the solution Jeremy has outlined (if it works with CDMA phones). Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.com - Original Message - From: Matt Comb To: NZ Borland Developers Group - Delphi List Sent: Tuesday, August 10, 2004 3:44 PM Subject: Re: [DUG] email, fax and text Thanks, yer I think this basically means that it has gone from your phone to vodaphone, but you have no guarantee (although most likely) that it has gone on to the other person. I remember a company that transported people from auckland to the Mt, and they used to have a head office that would sms the driver. They would do door to door, but they had to also phone up after the sms because some times the sms would either arrive late because he was out of coverage or not at all on rare occasions. This meant that the customer was left standing at the door. There is a NZ crowd that run an sms server as such, I can't remember their name, but because they programmed the mechanism, they are able to report when the message has gone on to be received by the end person in the chain. In cases like the above, you would be able to realise that there has been a delay so therefore try to contact either him in another way or the customer. Thanks for the link, Matt. - Original Message - From: Jeremy Coulter To: NZ Borland Developers Group - Delphi List Sent: Monday, August 09, 2004 3:37 PM Subject: Re: [DUG] email, fax and text The phone does respond with "Message Successfully Sent" and the code fires an event, but not sure wether this means its entered the ether successfully, enter the vodaphone network successfully, or actually arrived ok. The code is availible, its found at http://www.softwarecave.nl Jeremy -Original Message-From: "Matt Comb" [EMAIL PROTECTED]To: "NZ Borland Developers Group - Delphi List" [EMAIL PROTECTED]Date: Tue, 10 Aug 2004 15:07:47 +1200Subject: Re: [DUG] email, fax and text Oh yer, I remember hearing about someone who had done that. Thats pretty cool. Correct me if I'm wrong, but if you do it this way, you don't have any control on whether the sms has arrived at the recipient ? I dont know if you do with the vodaphone solution either? I remember that there was a crowd at the computer expo a couple of years ago that did have a mechanism that could guarantee the delivery of an sms. Is your VCL available Jeremy? and what about the dll? Matt.- Original Message - From: "Jeremy Coulter" [EMAIL PROTECTED] To: "NZ Borland Developers Group - Delphi List" [EMAIL PROTECTED] Sent: Monday, August 09, 2004 2:01 PM Subject: Re: [DUG] email, fax and textalso for SMS there is an option where you can get an old say Nokia 5110 which are as cheap as chips on trademe, and get a datacable and there is a DLL that will connect to your nokia phone that I wrote the VCL Wrappers for the developers of the DLL, and that will send SMS's thru the phone. But also, the AsyncPro stuff is best for faxing, even when it wasnt free it was the best around. Jeremy -Original Message- From: "Matt Comb" [EMAIL PROTECTED] To: "NZ Borland Developers Group - Delphi List" [EMAIL PROTECTED] Date: Tue, 10 Aug 2004 13:41:56 +1200 Subject: Re: [DUG] email, fax and textHi Alister... Sending sms messages are pretty simple, you can open up a socket connection with the provider, but the most important thing is that you require a sms provider e.g. Vodaphone, and Vodaphone actually have a webtotext engine that you can license. You get slightly cheaper sms' from memory, and their engine basically provides you with an interface to send the sms through. Note, to the best of my knowledge, you cannot send sms' without having an account such as this. There are some freebies around the world, but assuming that you need something reliable and don't want half your sms' to go missing, you are better off choosing one of the local solutions. Also interested to know if you get the mechanism working from within delphi. If you need any help, let me know. Regards, Matt. - Original Message - From: "Alister Christie" [EMAIL PROTECTED] To: "NZ Borland Developers Group - Delphi List" [EMAIL PROTECTED] Sent: Monday, August 09, 2004 1:33 PM Subject: Re: [DUG] email, fax and text For faxing you
Re: [DUG]: Threads...
Yes, most likely. Threads cannot / should not access the main VCL thread
without being synchronised. You could try passing the data from your grid
as some sort of structure that the thread then works on.
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: Chris Veale [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Thursday, August 12, 2004 3:43 PM
Subject: [DUG]: Threads...
Hi Again.
Im trying to write an autosave function for a stringgrid ising threads (so
it can happen in the background)
I have the following code to test it
the first TAutosave.execute procedure just hangs the application, but the
second one (commented out) works fine.
Is this because Im trying to access components on the calling form?
Any thoughts?
Chris
***
procedure TForm2.ToolButton14Click(Sender: TObject);
var
mythread:TAutosave;
begin
mythread := TAutosave.Create(false);
end;
**
and in the thread itself
procedure TAutosave.Execute;
begin
if exportfilename '' then
begin
//just re-save to the existing filename chosen by the user
try
{export from string grid}
form2.SMExportToXLS1.ColumnSource := csDataEngine;
form2.SMExportToXLS1.FileName := exportfilename;
form2.SMExportToXLS1.Execute;
//let them know the save was successful
saved := true;
synchronize(showresult);
except on e:exception do
end;
end;
end;
{procedure TAutosave.Execute;
var
i:integer;
begin
for i := 1 to 200 do
begin
inc(answer, round(abs(sin(sqrt(i);
synchronize(showresult);
end;
end;
}
procedure TAutosave.Showresult;
begin
form2.RzMarqueeStatus1.Caption := 'Autosave Complete';
end;
**
__
The contents of this e-mail are privileged and/or confidential to the
named recipient and are not to be used by any other person and/or
organisation. If you have received this e-mail in error, please notify
the sender and delete all material pertaining to this e-mail.
__
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Anyone put xp Sp2 on yet?
We have been testing XP SP2 all week and had no problems so far. What BDE bug is being fixed? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, August 13, 2004 1:30 PM Subject: RE: [DUG] Anyone put xp Sp2 on yet? its in the released version. -Original Message- From: Paul A Norman [mailto:[EMAIL PROTECTED] Sent: 13 August 2004 11:25 AM To: NZ Borland Developers Group - Delphi List Subject: Re: [DUG] Anyone put xp Sp2 on yet? Thanks for that, Does any one know if the BDE fix is in the SP2 as released now, or do we need to get a patch as well? Paul - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, 13 August 2004 1:19 p.m. Subject: RE: [DUG] Anyone put xp Sp2 on yet? I haven't installed it yet but I know that MS fixed the bug with the BDE and know of people running delphi and delphi apps happily under it. I'd try it on one machine first though ;-) -Original Message- From: Paul A Norman [mailto:[EMAIL PROTECTED] Sent: 13 August 2004 11:14 AM To: NZ Borland Developers Group - Delphi List Subject: [DUG] Anyone put xp Sp2 on yet? Any one aware of any thing (Delphi generated or otherwise) that gets broken by SP2 Xp? I'm just finishing the download of it and wondered if any one had experience of it beofer I put it on various machines? Paul A Norman ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] XP Wndow Update
We have a Slow machine (celeron 400, 512MB Ram, 7200rpm HDD, on board video) that we could sit and watch it draw on components. Upgrading the video card to a GeForce II improved redraw considerably. Interestingly we have a duplicate machine (sans Ge Force II) running Windows 2000 that is about 300% faster than the XP professional machine. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com - Original Message - From: Rohit Gupta [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Thursday, August 19, 2004 1:35 PM Subject: [DUG] XP Wndow Update What different about XPs window updating. A particular shceduling component works fine everywhere else. But on th XP, it takes a long time as each control is seen being painted slowly. Using LockWIndowUpdate does not work, infact it is more messy... I guess that the VCL might itlself be using this Regards Rohit == CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH(649) 489-2280 FX(649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] == ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Threads
Are you sure you are not accidentally creating two instances of your Thread? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Phil Middlemiss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Wednesday, August 25, 2004 8:46 AM Subject: [DUG] Threads Hi all, I have a thread object that, for some reason, the destructor is being called twice. I've stripped the app down to a fairly simple shell around the thread and all I am doing is creating the object that holds onto the thread, and then freeing it. The containing object creates the thread in it's consctructor and frees it in its destructor. Any one know what is causing this? Cheers, Phil. ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Thread causing whole computer to crash
Guess - That's the cause. Suggestion - Try running the app on another machine / OS. It may give an error message. I have seen code that crashes one machine but gives an error on others. Worth a try :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Phil Middlemiss [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Wednesday, September 01, 2004 4:41 PM Subject: [DUG] Thread causing whole computer to crash I have a thread that listens to a COM port and then alerts the main app thread of new data (by sending a windows message), which then asks for that data from the thread and updates the GUI. Somewhere along the line something is going horribly wrong. The program appears to be going fine then all of a sudden - the whole thing reboots. This is proving extremely hard to debug due to the fact that it is happening in a thread and the app doesn't just produce an exception - it crashes the whole machine. My suspicion is that some code that accesses the VCL components is ending up being called in the COM port listener's thread - but before I head down a nasty detailed code inspection to work out if that is the case, can anyone remember if they have had that happen to them - and if so was it because of VCL code being called in a separate thread? or something else? Hints or guesses welcome. Cheers, Phil. ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Slow updates
I know very little about ADO but I think Rohit is right about reading the whole table in, probably not good (and should be fixed). However doesn't ADO have a async / synchronous option that allows program execution to flow on while a query executes? You could try this. p.s. Why are you Still using ADO, that is such a dated, at the end of its life, product. You should be using ADO.Net surely :)) (Says the man who is just moving from Dbase to Firebird !) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Rohit Gupta [EMAIL PROTECTED] To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, September 17, 2004 9:40 AM Subject: Re: [DUG] Slow updates I havent used ADO, but one possible cause could be that it is reading the whole table in after an update. There may be a property to turn this behaviour off. Hi All. I have a DB Grid (an InfoPower one) that is linked to a TADOQuery. I have made it so one of the cells can be edited to update a value or add one. This all works fine, UNTIL, it tries to do an update. If you enter in a value then press teh enter key or down arrow, it induces a delay while it updates the DB. As you can imagin, for a data entry person, its too slow. Is there a way to speed it up? Jeremy Regards Rohit == CFL - Computer Fanatics Ltd. 21 Barry's Point Road, AKL, New Zealand PH(649) 489-2280 FX(649) 489-2290 email [EMAIL PROTECTED] or [EMAIL PROTECTED] == ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] TStringList.FList
No its not possible to access private members without being in the same pas. umm couldn't you just store an array of stringlist positions instead or pointers to a string (not knowing what you are trying to do). I would look for other ways to implement your functionalityor build your own TStringList by copying the source out. Don't change classes. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.comWild Software Ltd - Original Message - From: Ross Levis To: NZ Borland Developers Group - Delphi List Sent: Friday, September 17, 2004 2:02 PM Subject: [DUG] TStringList.FList Is it possible to make visible a private variable in an ancestor class? I needto obtain the pointer to the FList record array in a TStringList so I can store the pointer to each string in the array. If not thenImay be faced with modifying the Classes unit or taking a copy of the TStringList code from theunit and making my own TStringList. Any ideas? Cheers,Ross. ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] TStringList.FList
I am happy to be wrong. I believe the manual says it can / shouldn't be done. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Dennis Chuah [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, September 17, 2004 3:18 PM Subject: Re: [DUG] TStringList.FList Then I'm afraid RM is incorrect! This technique works on the principle that the new class declares a memory footprint that is identical to TStringList. What we are doing is casting the reference to the TStringList as the new class and in the process, fooling the compiler into thinking that we are accessing a genuine public member. DCTHackedStringList = class(TStrings) public FList: PStringItemList; end; According to RM, this is not possible. I had already coded it this way assuming it would work, but apparently only Protected members can be made visible, not Private. - Original Message - From: Ross Levis [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, September 17, 2004 2:44 PM Subject: Re: [DUG] TStringList.FList RM No its not possible to access private members without being in the same pas. umm couldn't you just store an array of stringlist positions instead or pointers to a string I can't store the Index positions because it's a sorted list and they will change as more items are added. DC Why can't you use at the Objects property? The Objects property is already being used, and anyway, this is referencing in the wrong direction. I need a pointer to the string list not the other way around. It's a plan I came up with to reduce memory requirements and provide fast retrieval for upwards of 50,000 strings. DCTHackedStringList = class(TStrings) public FList: PStringItemList; end; According to RM, this is not possible. I had already coded it this way assuming it would work, but apparently only Protected members can be made visible, not Private. Cheers, Ross. - Original Message - From: Robert martin To: NZ Borland Developers Group - Delphi List Sent: Friday, September 17, 2004 2:20 PM Subject: Re: [DUG] TStringList.FList No its not possible to access private members without being in the same pas. umm couldn't you just store an array of stringlist positions instead or pointers to a string (not knowing what you are trying to do). I would look for other ways to implement your functionality or build your own TStringList by copying the source out. Don't change classes. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Ross Levis To: NZ Borland Developers Group - Delphi List Sent: Friday, September 17, 2004 2:02 PM Subject: [DUG] TStringList.FList Is it possible to make visible a private variable in an ancestor class? I need to obtain the pointer to the FList record array in a TStringList so I can store the pointer to each string in the array. If not then I may be faced with modifying the Classes unit or taking a copy of the TStringList code from the unit and making my own TStringList. Any ideas? Cheers, Ross. -- -- ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi -- -- -- ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi -- -- ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Thread processes
Hi Phil Why don't you suspend your thread when processing has completed. Whenever data is received from the comport, call resume. Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.comWild Software Ltd - Original Message - From: Phil Middlemiss To: NZ Borland Developers Group - Delphi List Sent: Friday, October 15, 2004 12:09 PM Subject: Re: [DUG] Thread processes Thanks to all who replied. I will have a play - I don't think I can get away with not calling ProcessMessages tho, since the COM port component I use uses Timer messages to poll the COM port. I'll let you know anyway. Cheers, Phil. - Original Message - From: Stephen Bertram To: NZ Borland Developers Group - Delphi List Sent: Friday, October 15, 2004 11:28 AM Subject: Re: [DUG] Thread processes Sorry that should have been Sleep(), not Wait() Must be Friday J Phil IMO you should not call ProcessMessages in a thread that should be handled in the Main thread only. To avoid 100% CPU usage try: while not terminated do begin if MyTest then DoMyProcess; Sleep(1); end; Even using Sleep(0) avoids the thread hogging resources. HTH Stephen From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil MiddlemissSent: Friday, 15 October 2004 11:16 a.m.To: NZ Borland Developers Group - Delphi ListSubject: [DUG] Thread processes I have a thread that sits in the background waiting for input froma COM port. the execute method simple has these two lines: while not Terminated do Application.ProcessMessages; The problem with this is that the processor usage is very high, even if the thread is doing nothing but sitting there calling processmessages. The main application thread doesn't have this problem, yet it also has a message handling routine. Is there a way to avoid this problem in threads? Cheers, Phil. ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Thread processes
Is it just me or is [EMAIL PROTECTED] adding a lot to this discussion :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 15, 2004 12:18 PM Subject: RE: [DUG] Thread processes ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] ODBC
Hi All I want to create an app to test an ODBC connection (which is used for reporting purposes only, we use IBObjects for application testing). I simply want to access the DB and select something from a table to prove the connection string etc is working. I was going to use ADO components but am I right in saying ADO requires an install on some windows versions / not running certain ms apps? I don't want to install anything, what should I use? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] TDBLookupCombo
Hi All We are running a query based on the selection in a DBlookupCombo (dbl) , this works fine. However when a user is incrementally searching through the list by typing the query is re run every time the combo finds a new partial match. Is there any way of setting the onClick event to not occur until the user has not typed a key for a certain period of time? I guess not but is there another event / way of achieving this effect? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] TDBLookupCombo
No. The issue is with the incremental search while typing, closeUp only occurs when the combo is closed after been dropped down. Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Paul McKenzie [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Tuesday, October 26, 2004 8:36 AM Subject: Re: [DUG] TDBLookupCombo If you are using the DBLookupComboBox - could use the OnCloseup Event ? Regards Paul McKenzie SMSS Ltd. Wellington New Zealand - Original Message - From: Robert martin [EMAIL PROTECTED] To: [EMAIL PROTECTED] org. nz [EMAIL PROTECTED] Sent: Friday, October 22, 2004 4:57 PM Subject: [DUG] TDBLookupCombo Hi All We are running a query based on the selection in a DBlookupCombo (dbl) , this works fine. However when a user is incrementally searching through the list by typing the query is re run every time the combo finds a new partial match. Is there any way of setting the onClick event to not occur until the user has not typed a key for a certain period of time? I guess not but is there another event / way of achieving this effect? Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] TDBLookupCombo
Not ideal but I will look into this option. Thanks :) Rob Martin Software Engineer phone 03 377 0495 fax 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: kj nz [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Friday, October 22, 2004 11:41 PM Subject: Re: [DUG] TDBLookupCombo Is there any way of setting the onClick event to not occur until the user has not typed a key for a certain period of time? I guess not but is there another event / way of achieving this effect? You'll have to put a timer on the form. Set it disabled to begin with and with whatever interval you think is appropriate to wait before activating the query. In the event OnTimer fire your query and then disable the timer eg procedure TForm1.Timer1Timer(Sender: TObject); begin DoQuery; Timer1.Enabled := false; end; Which event are you currently using to fire the query? I'd set Timer1.Enabled := true in the OnKeyDown event and in the OnClick event of the ComboBox. OnKeyPress may be Ok for you but won't respond to the arrow keys as the user moves up and down the drop down list so may not be so good. Kit Jackson ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Tracing runtime errors of threads
Hi All
We are having problems with a threaded app on a particular machine. The
machine is not a development machine. We are tracing progress through the
application using the following function...
var
ErrorFile : TStringList;
FilePath: String;
begin
ErrorFile := TStringList.Create;
try
try
FilePath := ExtractFilePath(ParamStr(0)) +
'ServerInformation.inf';
if (FileExists(FilePath) = True) then begin
// file exists, open and load data
ErrorFile.LoadFromFile(FilePath);
end;
ErrorFile.Add('[' + DateToStr(DateTimeOfError) + ' ' +
TimeToStr(DateTimeOfError) + '] Company- ' + CompanyName + ' Procedure- ' +
ProcedureName + ' BlockNo- ' + IntToStr(BlockNo) + 'Exception Message -
' + ExceptionText);
ErrorFile.SaveToFile(FilePath);
except
//Ignore file creation errors
end;
finally
ErrorFile.Free;
end;
The problem is that as our app is threaded the function is called multiple
times and the text file misses some entries. This is a problem as you can
imagine. Does anybody have any, simple / quick , suggestions of how to
track where the code is dying on a runtime machine?
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
Wild Software Ltd
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 7 Delays
Title: Message All the time. AFAIK it is Delphi compiling the pas you are using for the first time (this session). Code completion requires a compile before working. So each time you open a new pas and edit it the first thing the system does is a compile, once this is complete the system is very speedy. Your system sounds a bit low spec ( :) ) my AMD 2400 machine compiles files quicker than that ! (about to 36000 files in one case) Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.comWild Software Ltd - Original Message - From: Jeremy Coulter To: [EMAIL PROTECTED] Sent: Tuesday, November 09, 2004 10:05 AM Subject: [DUG] Delphi 7 Delays Hi All. Been meaning to bring this up for ages, but never seem to remember. I have been experiencing delays with the D7 IDE. Things like, when I open a project, then go to a section of code, press enter, and try to type, I cant, because Delphi goes off and starts reading madly off my HD. OR for instance, I just went back to my D7 IDE that has been open all night, pressed CTRL+HOME and took, oh 2-3 seconds to actually process the command ! It does this, then its fine. Then there are occasions when it takes ages for the code complete popup to popup. Once again reading of the HD madly. So you might be thingking...ah he has a low spec machine ! But not really. Its an Intel 3GHz (hyper threading) with a 160GB SATA drive (nice and fast) with 100GB free (and a big sawp file) and 1GB of Ram. So thats why I am puzzled at the delays I get. It seems to do it once, then its ok. Its strange. Anyone else experenced these sorts of issues? Jeremy ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] FW: Pre-ordering Delphi 2005
Umm Nahum. I believe your dad could sell you this ! Rob MartinSoftware Engineerphone 03 377 0495fax 03 377 0496 web www.chreos.comWild Software Ltd - Original Message - From: Nahum.Wild To: 'NZ Borland Developers Group - Delphi List' Sent: Thursday, November 18, 2004 3:31 PM Subject: [DUG] FW: Pre-ordering Delphi 2005 I sent the below email to Richard on Wednesday last week straight after an email from him appeared on this list and I have received absolutely no response - good company representation. Can anyone on this list help me with what I ask below? I would prefer to buy 14 copies of Delphi 2005 from someonein NZ and line their pocket rather someone elsewhere.I want to be able to ring them up and talk to them about it. A yellowpages.co.nz search for 'Borland' in 'Auckland' revels no contact details for them. Have they gone under here in NZ? If someone from Borland sees this email, my DDI is listed below - your website is useless for NZ contact info. Cheers, Nahum. From: Nahum.Wild [mailto:[EMAIL PROTECTED] Sent: Wednesday, 10 November 2004 11:07 a.m.To: 'Richard Vowles'Subject: Pre-ordering Delphi 2005 Richard, The online shop is down at the moment and the borland.co.nz contact information shows Australian info only. We want to get one copy initially to verify our software will work with it, we like it etc... then follow that up with 12-13 more copies including a couple of upgrades. As I understand itBorland NZ does not sell to the public. So how do I go about doing this, do I actually ring up aussy and talk to them or is there somewhere here in NZ I can go. Cheers, Nahum Wild:: Development Group Leader PAYGLOBAL LIMITED Level 1, 8 Nelson StreetPO Box 8198Riccarton, ChristchurchNew Zealand Direct: +643 963 8545 Helpdesk NZ:0508 104 357Fax: +643 343 3953 Helpdesk AU:1800 129 181* [EMAIL PROTECTED]ü www.payglobal.com-This email is privileged, confidential and intended for the addressee only. If you are not the addressee, you must not peruse, use, disseminate, distribute or copy this email or attachments. If received in error, please delete this email and contact the sender.© Copyright 2002-2004 PayGlobal Limited. All rights reserved.- ___Delphi mailing list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi Architect trial
Hi Nahum / other D2005 users
We are using D6. Don't know if this in D7 but
does D2005 have all / any of the following...
FieldByName('sdfd').AsLargeInt. D6 does
not directly support this.
DBLookupCombos that support largeInt
fields.
Rob MartinSoftware Engineerphone +64 03 377 0495fax
+64 03 377 0496 web www.chreos.comWild Software Ltd
- Original Message -
From:
Nahum.Wild
To: 'NZ Borland Developers Group - Delphi
List'
Sent: Friday, November 26, 2004 10:43
AM
Subject: RE: [DUG] Delphi Architect
trial
I'd recomend people give it a look as it's pretty fab - and
stable! We have a heap of D4 legacy code that is going to benefit
greatly from the refactoring tools. :o)
Nahum
Wild::
Development Group Leader
PAYGLOBAL
LIMITED
Level
1, 8 Nelson StreetPO Box 8198Riccarton, ChristchurchNew
Zealand
Direct:
+643 963 8545
Helpdesk NZ:0508 104 357Fax: +643 343
3953 Helpdesk
AU:1800 129 181*
[EMAIL PROTECTED]ü
www.payglobal.com-This
email is privileged, confidential and intended for the addressee only. If
you are not the addressee, you must not peruse, use, disseminate,
distribute or copy this email or attachments. If received in error, please
delete this email and contact the sender.© Copyright 2002-2004 PayGlobal
Limited. All rights
reserved.-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Richard
VowlesSent: Friday, 26 November 2004 10:24 a.m.To: NZ
Borland Developers Group - Delphi ListSubject: [DUG] Delphi
Architect trial
I'm sucking down
the Architect trial, its around 350Mb, if that is a problem for anyone to
d/l and they want it, please let me know and I can burn it and send it or
put it up locally for you to download (faster transfer/nz only
traffic)
Richard
___Delphi mailing
list[EMAIL PROTECTED]http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
[EMAIL PROTECTED]
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 2005 and very large projects type libraryproblem/bug
Sounds like really high productivity software ! Talk about RAD, although in this case it might stand for 'Ridiculous Application Development' :) Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd - Original Message - From: Paul McKenzie [EMAIL PROTECTED] To: [EMAIL PROTECTED]; NZ Borland Developers Group - Delphi List [EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 2:33 PM Subject: Re: [DUG] Delphi 2005 and very large projects type libraryproblem/bug Sounds like you will be fine - so long as you never open any projects, or if you do just make sure you never save your work ... :-)) Regards Paul McKenzie SMSS Ltd. Wellington New Zealand - Original Message - From: Max Nilson [EMAIL PROTECTED] To: 'NZ Borland Developers Group - Delphi List' [EMAIL PROTECTED] Sent: Tuesday, December 14, 2004 2:11 PM Subject: RE: [DUG] Delphi 2005 and very large projects type libraryproblem/bug Nahum asked: Thanks heaps for that Max, I'm going thru exactly the same process that you have just gone thru for exactly the same reasons - except that we have over 1200 forms in our main app. I expect that we will be encountering this problem. :o( So is it only a problem when you close all/save all? It seems that any action that trigegrs save of the type library can cause this problem. So Close All, Save All, Exit, Open Project all have the possibility of triggering the behaviour. Cheers, Max. ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list [EMAIL PROTECTED] http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] speex
Hi Has anybody used the Adobe acrobat reader as an ActiveX ? I have it going OK but When I close my screen and free the component it comes up with a message saying a document is still open, do I want to close it. Usefully this box is hidden behind my application so it appears it has locked up. How do I close a document before freeing the component. I have looked but cant see any useful properties / methods. TIA Rob ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Delphi 2005 DB end user licenses
Hi Paul I thought that all the Database connection components included with delphi were license free and only the license issue relates to the database you are connecting to, i.e SQL server $per connection, MSDE free but restriced to 5, Firebird Free etc. Disclaimer... Not that we actually use these these compontents :) Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Paul A Norman wrote: I didn't see this appear so I am reposting it: Can any one please tell me (apart from the BDE stuff) which of the DB components can be used in Delphi 2005 without the end user client requiring to buy another site license or whatever. I went into one of those round in circle things you go into in your head when you read the license files . . . like MS ones that say someting then say it may or may not apply in that or some other form depending on many things ,,, ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Odd-ball question
Im obviously a 'Stone age' developer. I automatically thought pen and paper, seems like everyone else automatically thought of phone cam! I think I'll go back to coding my latest Abacus :) Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Dave Jollie wrote: Why bother to use pen and paper, just pull out your mobile phone and take a pic! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Allan, Samuel Sent: Wednesday, 16 February 2005 1:41 p.m. To: NZ Borland Developers Group - Delphi List Subject: RE: [DUG] Odd-ball question Can't you get software that records everything that is printed to the screen as a movie? So they could get it that way? Like if they really wanted it? People used to use it for recording themselves playing computer games before there were action replays. And for writing demo movies and stuff. So you turn it on, and then open up your software? I just did a google for screenshot movies and came back with FrontCam as the first result. Looks like they could use that easy enough. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Dave Jollie Sent: Wednesday, February 16 2005 1:17 p.m. To: NZ Borland Developers Group - Delphi List Subject: RE: [DUG] Odd-ball question Display the confidential info, then trap ANY mouse move or key press. You'd have to get in front of these events (on before mouse move, on before key press) and clear the confidential info (which could include a comment at the end of it - This message will self-destruct on any keyboard or mouse activity. :-) I'm sure there's still a way around that, but it might be harder. Dave -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Wednesday, 16 February 2005 1:07 p.m. To: NZ Borland Developers Group - Delphi List Subject: RE: [DUG] Odd-ball question There are still tools such as SnagIt that can copy anything on the screen as a bitmap, even the online e-Books, and I imagine you could feed them through OCR to get the text. Bob Osborn Check out the keyboard hook facility in the Windows API, as you may be able to disable the printscreen button (or any other key combination) while your app has focus. I've seen it done by the people who have online e-Books, where you can read the book onscreen, but not print or copy it in any way. cheers Gary At 09:55 on 16/02/2005 you wrote To : delphi@ns3.123.co.nz CC : From: John Bird, [EMAIL PROTECTED] Content Type: text/html Attached: Is there a way to display confidential information on a screen in such a way that it can be seen but cannot be copied - eg via copy and paste. For instance putting text in labels does not allow normal select and copy, but one can still do a printscreen and capture the screen as an image. The only way I have thought of is to put text in a pop-up hint, as these normally disappear when a key such as printscreen is pressed. It is not however that easy to put many lines of text in a hint. Any suggestions? John B === ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi === No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005 Ref#: 41006 No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.300 / Virus Database: 265.8.8 - Release Date: 14/02/2005 ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] DBNavigator behaviour
Please send special coffee ASAP ! Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd tracey wrote: you are actually automatically posting the record when you press the down arrow Odd, yesterday it wasn't posting, today it is... must have been something in the coffee. =) ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Forms resolution problem
Hi The problem you have is that the user has set their DPI setting to 120 (Large). You can either get them to change it back to 96 or use some scaling technology. We use elastic form (which seems to work pretty well). Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Alistair George wrote: Hi All. I have a modal forms resolution/fonts problem. The mainform calls a modal form, which is an Options form for the program. Several users have complained of squeezed graphics/text and one has sent me a view of his screen capture: www.alistairgeorge.com/spamdelbad.jpg What it should look like is here: www.alistairgeorge.com/spamdelgood.jpg I have tried MPSautosize component, and a few other tricks, but the user says the visual remains the same. Most odd, because he is using WinXP and same resolution/fonts settings and myself. I have Arial as the font for this form. Have tried both scaled/true/false Any suggestions please? Tks, Alistair+ ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Forms resolution problem
Hi Alistair. Sure. We have had this problem before and it was tricky to trace. Right Click the XP desktop, select properties. Select the 'Settings' tab, click the 'advanced' button. On the 'General' tab check the DPI setting combo. It is probably set to 'large size (120 DPI)'. Hope this is the problem. Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Alistair George wrote: HI Robert. Can you give me an example how to change the dpi in Win XP, as I thought I had tried all options to check that course of error (thats if u use XP). As I mentioned, he copied my properties settings in WinXP. Appreciate. Robert martin wrote: Hi The problem you have is that the user has set their DPI setting to 120 (Large). You can either get them to change it back to 96 or use some scaling technology. We use elastic form (which seems to work pretty well). Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Alistair George wrote: Hi All. I have a modal forms resolution/fonts problem. The mainform calls a modal form, which is an Options form for the program. Several users have complained of squeezed graphics/text and one has sent me a view of his screen capture: www.alistairgeorge.com/spamdelbad.jpg What it should look like is here: www.alistairgeorge.com/spamdelgood.jpg I have tried MPSautosize component, and a few other tricks, but the user says the visual remains the same. Most odd, because he is using WinXP and same resolution/fonts settings and myself. I have Arial as the font for this form. Have tried both scaled/true/false Any suggestions please? Tks, Alistair+ ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Invalid Pointer Operation
Hi Ross What version of Delphi are you using? Anything less than Version 7 has a bug in the listview component when using XP Themes and in list mode. There is a hack available. Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Ross Levis wrote: It's one of those problems that's going to be hard to track down I think. A beta tester of mine is getting this occasionally in my software, and I have seen it once or twice over the last couple of months myself while testing, but I wasn't able to duplicate it. It's causing a ListView on my main form to stop updating and it goes blank, even though the program still functions correctly while the error is displayed. This is due to the fact that this application uses a timer for it's main operation, and the Timer still functions while the error is displayed. You can see the errors below sent to me by the user. The Access Violation occurs immediately after the Invalid Pointer Operation. The Access Violation is not a 40 address so I can't use this to pinpoint a line in my code. I can't duplicate the error so can't step through code to track it down. I'm rather stumped. Does anyone have any ideas what it could be. Since the ListView is going blank, does that point to some problem in the ListView VCL code, which I must be causing somehow? Many thanks, Ross Levis ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Getting number of records in an Interbase Table
I don't know about Interbase but in Firebird the syntax is Select First 30 * from atable For the initial select then Select First 30 Skip 30 * From aTable for the next 30. I had assumed this syntax was supported by interbase also. I would give it a try. Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Phil Middlemiss wrote: Hmmm, I tried that query using EMS Interbase/Firebird Manager and it didn't like the ROWS keyword (didn't even highlight it as a keyword). Richard Vowles wrote: Have we missed out why you can't just use the ROWS keyword in the SELECT statement? This is InterBase right? Firebird 1.5 is slightly different. SELECT * FROM TABLE ROWS 15 TO 25 or something like that. I use it for paging through forums. Richard ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Invalid Pointer Operation
Ahhh I guessed it would be. I actually replied to your original post but you probably missed it. The problem is the TListView code in versions of Delphi 7 when using Windows XP themes. If the component is used in List mode tan you get AV's. There is a small patch that can be make to Delphi source to fix this. Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Ross Levis wrote: Sorry, it's D5. - Original Message - From: Robert martin [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List delphi@ns3.123.co.nz Sent: Tuesday, April 12, 2005 1:45 PM Subject: Re: [DUG] Invalid Pointer Operation Hi Ross What version of Delphi are you using? ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Invalid Pointer Operation
Nice to be of help :) Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Ross Levis wrote: Hi Robert Ahhh for be too. I actually patched the source myself years ago but recently had a hard drive crash and reinstalled Delphi. I'll need to reapply the patch. That'll be it. Thanks, Ross. - Original Message - From: Robert martin [EMAIL PROTECTED] To: NZ Borland Developers Group - Delphi List delphi@ns3.123.co.nz Sent: Tuesday, April 12, 2005 4:04 PM Subject: Re: [DUG] Invalid Pointer Operation Ahhh I guessed it would be. I actually replied to your original post but you probably missed it. The problem is the TListView code in versions of Delphi 7 when using Windows XP themes. If the component is used in List mode tan you get AV's. There is a small patch that can be make to Delphi source to fix this. Rob Martin Software Engineer ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] casting a number as a char in IB SQL
Hi Phil I can't guarantee it but Char() is probably in one of the add on dlls for Firebird. I can post your question on the Firebird support group if you are not a member :) I don't know If I have asked this, but do you have a sister called Janet? Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Phil Middlemiss wrote: That was the first thing I tried too, unfortunately illegal in Firebird. Phil. Paul Ritchie wrote: Not sure about FireBird but in SQL Server that would be INSERT INTO MYTABLE VALUES (1, Char(34)) Does that help? Cheers, Paul. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Middlemiss Sent: Tuesday, 19 April 2005 11:28 a.m. To: NZ Borland Developers Group - Delphi List Subject: [DUG] casting a number as a char in IB SQL I'm running into difficulty trying to convert the number 34 into a CHAR (length 1) in an INSERT statement using Firebird/Interbase. This is the query as I'm trying it: INSERT INTO MYTABLE VALUES(1, Cast(34 as CHAR)) which it doesn't like - it seems to be trying to convert 34 into the string '34' which is 2 characters instead of #34. Am I trying to do the impossible? The Character Set for the relevant field is 'WIN1251' does that make a difference? Cheers, Phil. ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] casting a number as a char in IB SQL
Hi Thats good, Janet was rather infamous in CHCH. I will post it on your behalf. Try this link to join http://groups.yahoo.com/group/firebird-support/ Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Phil Middlemiss wrote: Heh, no sister - only brothers. I'm not a member of the Firebird support group. Yes, please post it, but could you also point me to where to join? Cheers, Phil. Robert martin wrote: Hi Phil I can't guarantee it but Char() is probably in one of the add on dlls for Firebird. I can post your question on the Firebird support group if you are not a member :) I don't know If I have asked this, but do you have a sister called Janet? Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Phil Middlemiss wrote: That was the first thing I tried too, unfortunately illegal in Firebird. Phil. Paul Ritchie wrote: Not sure about FireBird but in SQL Server that would be INSERT INTO MYTABLE VALUES (1, Char(34)) Does that help? Cheers, Paul. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Phil Middlemiss Sent: Tuesday, 19 April 2005 11:28 a.m. To: NZ Borland Developers Group - Delphi List Subject: [DUG] casting a number as a char in IB SQL I'm running into difficulty trying to convert the number 34 into a CHAR (length 1) in an INSERT statement using Firebird/Interbase. This is the query as I'm trying it: INSERT INTO MYTABLE VALUES(1, Cast(34 as CHAR)) which it doesn't like - it seems to be trying to convert 34 into the string '34' which is 2 characters instead of #34. Am I trying to do the impossible? The Character Set for the relevant field is 'WIN1251' does that make a difference? Cheers, Phil. ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] One for the ADO guys
Hi
I am trying to use ADO to access an ACCESS database. This is all
working fine. However all my SQLs up until now have been
unparameterized. I want to use the following query because
ClientAddress can contain 's. However I am struggling to fill in the
parameteres.
UpdateADOQuery.SQL.Text := 'UPDATE ClientInfo ' +
'SET ClientName =
:ClientName, ' +
'ClientAddress =
:ClientAddress, ' +
'WHERE EntityRef = :EntityRef;';
In my IBObjects / Firebird stuff I would go
Query.ParamByName('ClientAddress').AsString := 'asdfsdfdsf'; How do I
do this in ADO?
Feeling really stupid today (not aided by the fact I cant test it on my
dev machine and have to run it each time to find I have used the wrong
property !!)
Help please :)
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
___
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] One for the ADO guys
Hi
Tried that and got errors. Will have another go and investigate further
when I can access the testing machine again !. What a pain.
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
Stephen Bertram wrote:
Hi Rob
Not Access, but I use ADOQuery.Parameters.ParamByName('pName').Value
:= xx;
Value is a variant property, so there is no typecasting till runtime
:-(, but it works in all the ADO environments that I have used. There
is no .AsString, AsInteger, ... with a TParameter.
HTH
Stephen
- Original Message - From: Robert martin [EMAIL PROTECTED]
To: NZ Borland Developers Group - Delphi List delphi@ns3.123.co.nz
Sent: Wednesday, April 20, 2005 3:11 PM
Subject: [DUG] One for the ADO guys
Hi
I am trying to use ADO to access an ACCESS database. This is all
working fine. However all my SQLs up until now have been
unparameterized. I want to use the following query because
ClientAddress can contain 's. However I am struggling to fill in the
parameteres.
UpdateADOQuery.SQL.Text := 'UPDATE ClientInfo ' +
'SET ClientName =
:ClientName, ' +
'ClientAddress =
:ClientAddress, ' +
'WHERE EntityRef =
:EntityRef;';
In my IBObjects / Firebird stuff I would go
Query.ParamByName('ClientAddress').AsString := 'asdfsdfdsf'; How do
I do this in ADO?
Feeling really stupid today (not aided by the fact I cant test it on
my dev machine and have to run it each time to find I have used the
wrong property !!)
Help please :)
--
Rob Martin
Software Engineer
phone +64 03 377 0495
fax +64 03 377 0496
web www.chreos.com
Wild Software Ltd
___
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
___
Delphi mailing list
Delphi@ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi
[DUG] Windows Server 2003 SP1
Hi all We have an application that was producing the following error on 2003 SP 1 'Exception EReadError in module Install.dll as 0023213' I have traced it to a problem with TRichedit. By removing the Richedit from one of the screens in this app the problem disappears. Is this a version issue with riched20.dll (or whatever its called) ? If so what can I do about the issue? The problem does not occur on Windows 2003 (no SP). I think both clients are using 'Standard Edition'. -- Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
Re: [DUG] Windows Server 2003 SP1
Hi Alister Are you saying the .rtf file being displayed might be the culprit? Will look into it when the client gets back from holiday :) Thanks Rob Martin Software Engineer phone +64 03 377 0495 fax +64 03 377 0496 web www.chreos.com Wild Software Ltd Alister Christie wrote: I've occasionally had problems with riched20.dll with highly corrupted rich text causing a similar exception to the one described - could this be the issue? Alister Christie Computers for People Ph: 04 471 1849 Fax: 04 471 1266 http://www.salespartner.co.nz PO Box 13085 Johnsonville Wellington Robert martin wrote: Hi all We have an application that was producing the following error on 2003 SP 1 'Exception EReadError in module Install.dll as 0023213' I have traced it to a problem with TRichedit. By removing the Richedit from one of the screens in this app the problem disappears. Is this a version issue with riched20.dll (or whatever its called) ? If so what can I do about the issue? The problem does not occur on Windows 2003 (no SP). I think both clients are using 'Standard Edition'. ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi ___ Delphi mailing list Delphi@ns3.123.co.nz http://ns3.123.co.nz/mailman/listinfo/delphi
