[DUG]: dynamic series on a chart, and clearing them?
Hi. I have a tchart that at runtime I create dynamic series as required, now when the user changes something (a radio button) I want to remove all those previously added series and re-add them (the radiobutton is a sort method) Can someone please tell me how to do this? Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.532 / Virus Database: 326 - Release Date: 27/10/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: SSH?
ssh = secure shell - unix protocol ssl = secure socket layer = web secure protocol (https) Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Rohit Gupta Sent: Wednesday, 15 October 2003 3:32 p.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: SSH? Pardon my ignorance here... but what is SSH ? any relation to SSL ? To: Multiple recipients of list delphi [EMAIL PROTECTED] Send reply to:[EMAIL PROTECTED] From: Chris Veale [EMAIL PROTECTED] Subject: [DUG]: SSH? Date sent:Wed, 15 Oct 2003 13:18:54 +1300 Hi. has anyone had any experience implementing ssh in delphi? what components are out there to achieve this? I have a idftp component that I want to put a username/password on (not too difficult granted) but our unix person (bless him ;) ) would prefer access through ssh not through our ftp server. Any thoughts or should I just tell him to pull his head in and just do what I want? :) Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 9/10/03 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ 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] == -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 9/10/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 9/10/03 --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: SSH?
Hi. has anyone had any experience implementing ssh in delphi? what components are out there to achieve this? I have a idftp component that I want to put a username/password on (not too difficult granted) but our unix person (bless him ;) ) would prefer access through ssh not through our ftp server. Any thoughts or should I just tell him to pull his head in and just do what I want? :) Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.525 / Virus Database: 322 - Release Date: 9/10/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: [off topic] CD Printing
checkout amstore in wellington www.amstore.com I believe also www.stebbing.co.nz or? http://www.softwareimages.com I think amstore is the better otption though it depends on the run count and artwork that has to be done. Check them out. HTH Chris Veale -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of vss Sent: Monday, 6 October 2003 12:58 p.m. To: Multiple recipients of list delphi Subject: [DUG]: [off topic] CD Printing Hi All. Slightly off topic, but then someone who is not part of the off topic list might know this one. Does anyone know where I can get CD's printed with a logo etc. that I will design? I dont mean print as in produce CDs with my program etc on it, I mean print as the logo that goes on the top of a CD. Pref. here in CHCH if poss. but I will go entertain Auckland if I really have too :-) Jeremy -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.522 / Virus Database: 320 - Release Date: 29/09/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: How do I create a Delphi executable which has no GUI?
Title: How do I create a Delphi executable which has no GUI? create a console application. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, 3 October 2003 10:38 a.m.To: Multiple recipients of list delphiSubject: [DUG]: How do I create a Delphi executable which has no GUI? Hi all I want to call a Delphi executable by shelling out to DOS from a telnet session (in Universe). Since it's a telnet connection, and character based, it won't handle any Windows GUI. I'm wanting to execute a Report Builder report, which normally has the components dropped on a form. How do I stop a form displaying period - not even for an instant (when executing)? I wonder if a data module would do it? But then Report Builder design is all graphical, with the components on a form... If any GUI info is received on the Telnet connection, it then just ignores my exe. Am I trying to accomplish the impossible? (There are good reasons for wanting to run a report this way - i.e. not having to do a ton of coding to move a legacy app into Delphi). Cheers Dave Jollie Developer, TOWER NZ IT (: 09 368 4259 Ê: 09 306 6801 *: [EMAIL PROTECTED] .: 46 Parnell Rd, Parnell, Auckland ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03 __ 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. __ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03
[DUG]: anyone heard more about newsgroups and when they will be available again?
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: Form size changing/scrolling?
Hi all. I have created a program that runs fine on desktop computers but when it is run on laptops the forms do something weird and the user now has to scroll them to see the full screen. the first form I display is only 400 x 200 pixels but no matter what resolution the laptop is set to the user has to scroll, even if its 1400 x 1080 resolution and the form is small in the center of the screen - without having a need (technically) to scroll. Can anyone suggest a solution to this? I've never come across this before. Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.518 / Virus Database: 316 - Release Date: 11/09/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: SImple smtp agent
indy works for me Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Neven MacEwan Sent: Thursday, 11 September 2003 3:05 p.m. To: Multiple recipients of list delphi Subject: [DUG]: SImple smtp agent Hi Can anyone recommend a component for sending emails via an SMTP server? Simple (non HTML) with attachments TIA Regards Neven N.K. MacEwan B.E. EE Ph 649 621 0001 Fax 649 621 0400 [EMAIL PROTECTED] -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 1/09/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.516 / Virus Database: 313 - Release Date: 1/09/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: Silly question but...
Hi. Can someone please tell me how to add to a richedit the following? the html tags are just to say what I want to doactually text bsomething/b something else all I can seem to get is bsomething/b something else please help Chris PS I have tried the add and append properties only --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 1/09/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: memo lines?
Hi. after loading a memo box with strings I want to return to the top of the memo (as the amount of strings causes it to scroll). How can I do this? Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 4/08/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: Play Sounds
not inherently, but there is a component out there called pcspk that allows a specific pitch of note and duration. I have the component here if ya want me to send it, else I think I got it from torry. Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of vss Sent: Tuesday, 5 August 2003 10:17 a.m. To: Multiple recipients of list delphi Subject: [DUG]: Play Sounds Hi all. Does Delphi have a function that lets you play sounds at specific Notes and Durations etc. ? Cheers, Jeremy -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 4/08/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.507 / Virus Database: 304 - Release Date: 4/08/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: ShellExecute(Application.Handle, nil, 'MailTo:
dont suppose ya want to go to a thirt party bug tracking tool like the
madshi set of components do ya?
they provide a set like this...
date/time : 2003-07-30 09:39
computer name : H138FHGZ00TY
operating system : Windows 2000 Service Pack 1
free disk space : 4,26 GB
executable: hip_dst.exe
exec. date/time : 2003-07-29 16:51
version : 1.0.0.11
exception class : EInOutError
exception message : I/O error 103.
main thread ($49C):
$004F45D6 hip_dst.exe Main675 Load_Array
$004F624F hip_dst.exe Main 1215 TForm1.crop_comboboxChange
$0047024C hip_dst.exe LookUpComboBox 490 TLookUpComboBox.Change
$0046F9A1 hip_dst.exe LookUpComboBox 267 TCustomComboBox97.CNCommand
$004F7A10 hip_dst.exe hip_dst 21 hip_dst
thread $774:
$77F82230 ntdll.dll
created by main thread ($49C) at:
$004E9BFB hip_dst.exe madExcept 2339 ThreadExceptFrame
modules:
$0040 hip_dst.exe 1.0.0.11J:\HIP-DST
$1000 LgMousHk.dll 9.1.0.0 C:\PROGRA~1\MOUSEW~1\SYSTEM
$691D CLBCATQ.DLL 2000.2.3449.0 C:\WINNT\System32
$695E olepro32.dll 5.0.4514.1 C:\WINNT\System32
$6980 shell32.dll 5.0.3103.1000 C:\WINNT\system32
$7020 WININET.dll 6.0.2800.1106 C:\WINNT\system32
not sure if you can hook in your own error messages tho, but still hugely
useful I think
HTH
Chris Veale
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Alistair George
Sent: Monday, 4 August 2003 8:46 a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: ShellExecute(Application.Handle, nil, 'MailTo:
Hi all.
I want to send bug reports from my app, which includes the
users system details.
Can anyone advise:
a) how I can complete the following to include contents eg
Report?Contents+contentsString',nil.
b) what to use to provide contents info of users system (pref
freeware)
Thanks!
if msgbox('Please read the helpfile thoroughly before
sending email' + #13 +
'as most information is within' + #13 +
' Do you still want to send an email?', 'Bug Report',
true, MB_YESNO)
= IDYES then
ShellExecute(Application.Handle, nil,
'MailTo:[EMAIL PROTECTED])_Bug_Report', nil,
nil, SW_SHOWNOACTIVATE);
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.505 / Virus Database: 302 - Release Date: 30/07/03
__
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.
__
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: tstringgrid sorting.
thanks for that Warren it works like a charm...except. I am trying to sort float values (in scientific notation) and consequently the sort doesnt work. for instance 1.0E-13 is sorted before 5.0E2 is sorted before 7.83E-28 ie dont based on string value of the cell contents and not the float... I tried converting it to a float format of 0.0234 but this still doesnt work. Is it because Im using them as strings? is there another way to quickly sort a tstringgrid contents based on a float value? or would I be better to load an ayyar with the stringgrid contents. Is there a way to walk the array and load a second (sorted) array? Cheers Chris Veale -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Warren Slater (ASL) Sent: Thursday, 24 July 2003 5:15 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: tstringgrid sorting. Hi I have used the code below to allow sorting a stringgrid by clicking on the column header. Clicking again alternates between ascending and descending. The current sorted column is stored in the tag field of the stringgrid. I have deleted a few lines that are not required but should compile as below. Warren procedure TForm1.StringGrid1(Sender: TObject; Button: TMouseButton; Shift: TShiftState; X, Y: Integer); var r,SortCol : Integer; begin with TStringGrid(Sender) do begin MouseToCell(x,y,SortCol,r); if r=0 then begin if (SortCol+1)=Tag then Tag:=-(SortCol+1) else Tag:=(SortCol+1); SortStringGrid(Sender); end; end; end; procedure SortStringGrid(Sender: TObject); var r,c,SortCol,rc,cc : Integer; sl : TStringList; s : array of array of String; begin with TStringGrid(Sender) do if Tag0 then begin // ignore blank lines rc:=RowCount; cc:=ColCount; while (rc1) and (Cells[0,rc-1]='') do Dec(rc); SortCol:=Abs(Tag)-1; SetLength(s,cc,rc); SetLength(b,rc); // copy cells to sort to stringlist sl:=TStringList.Create; for r:=1 to rc-1 do sl.AddObject(UpperCase(Cells[SortCol,r]+' '+Cells[0,r]),TObject(r)); sl.Sort; // copy stringgrid data to temporary array for r:=1 to rc-1 do for c:=0 to cc-1 do s[c,r]:=Cells[c,r]; // copy data back in sorted order if Tag0 then begin for r:=1 to rc-1 do for c:=0 to cc-1 do Cells[c,rc-r]:=s[c,Integer(sl.Objects[r-1])]; end else begin for r:=1 to rc-1 do for c:=0 to cc-1 do Cells[c,r]:=s[c,Integer(sl.Objects[r-1])]; end; sl.Free; end; end; -Original Message- From: Chris Veale [mailto:[EMAIL PROTECTED] Sent: Thursday, 24 July 2003 02:43 p.m. To: Multiple recipients of list delphi Subject: [DUG]: tstringgrid sorting. Hi all. I want to sort a tstringgrid in ascending order of one column but want to also order the rest of the columns also (change the order of the rows) Is there a function or something to do this or will I have to write a custom sort tool myself? Id prefer something like the tlistbox sort procedure but the difficulty comes when I want to organise the remainder of the columns also. Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ ## ### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal For more information please visit www.marshalsoftware.com ## ### -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG
RE: [DUG]: Integer conversion
how about a two step process function pad(value:string); begin if length(value=1 then begin result := '0' + value; end else begin result = value; end; end; pad(inttostr(value)); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Leigh Wanstead Sent: Monday, 28 July 2003 10:49 a.m. To: Multiple recipients of list delphi Subject: [DUG]: Integer conversion Hello everyone, I want to convert integer to string. Here is the rule Integer String 1 '01' 2 '02' 3 '03' 4 '04' 5 '05' 6 '06' 11'11' 12'12' It convert int to string, if width less than 1, put '0' in front of String. I checked help file about format and can not find the right one I want. TIA Regards Leigh -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: tstringgrid column width.
Hi. Is there any way to adjust the column width of a tstringgrid based on the longest string entered in the column? Im getting text cut off that id like to display but cant see any place of changing it aside from defaultcolwidth property which changes all columns. Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: tstringgrid sorting.
Hi all. I want to sort a tstringgrid in ascending order of one column but want to also order the rest of the columns also (change the order of the rows) Is there a function or something to do this or will I have to write a custom sort tool myself? Id prefer something like the tlistbox sort procedure but the difficulty comes when I want to organise the remainder of the columns also. Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: readln?
I was trying both readln and read for this (as I thought the readln would work a little differently), but the read also didnt work. I have a comma delimited string that I want to expload from a text file into an array. Ill have a liook at the commatext property now, that sounds like what I want to use. Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Boyd, Conor Sent: Wednesday, 23 July 2003 1:37 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: readln? Hi Chris, Surely if you've got one line of strings (i.e. there is only one CR or LF/CR pair) then the behaviour is as expected? If you only have one line of strings, how are they delimited? If they're comma separated, you could look at the CommaText property of a TStringList IIRC, which would then give you each of your separate strings as an entry in the stringlist. If you still want separate variables, then I think you're going to have to parse the line yourself, e.g. reading it character by character, and choosing when to break it yourself. Otherwise, I don't quite understand what you're trying to achieve. HTH, Conor -Original Message- From: Chris Veale [mailto:[EMAIL PROTECTED] I want to read in a line of strings into seperate variables and Im trying to use readln(file,var1,var2,var3); but the data for the line gets put into var1 and then the rest of the vars are empty. I know you can do this I just cant seem to get it. Can anyone help please? -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: tregistry...
Hi. I just thought that if I am going to be having to process these regularly, would it be better to store information in the system registry? there is going to be lots of data, but I know tregistry replaces the old 16 bit tinifile. would this be an option if I have about 5000 lines of variables I want to retain? plus the same number for approximately 20 other files I need to reference, or is this complete overkill? I have never played around with the registry before and Im not sure of the load or proper procedure for doing something like this. essentially the files I'm referencing are lookup files that, when the user selects a certain combination of variables in the program, we graph the vars read in from the file. Hope that makes sence. Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: readln?
Hi. I want to read in a line of strings into seperate variables and Im trying to use readln(file,var1,var2,var3); but the data for the line gets put into var1 and then the rest of the vars are empty. I know you can do this I just cant seem to get it. Can anyone help please? Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.502 / Virus Database: 300 - Release Date: 18/07/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: TChart Set LeftAxis Labels
its
bloody stupid actually, but what you have to do is set "any old string" to a var
name
const
tmp:string="any old string";
begin
getaxislabel(LeftAxis, HorizBarSeries,
1,tmp);
end;
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of Tracey
MauleSent: Thursday, 10 July 2003 2:08 p.m.To: Multiple
recipients of list delphiSubject: [DUG]: TChart Set LeftAxis
Labels
Hi
I have dynamically created a Chart,
with 3 HorizBarSeries which are mbStacked.
What I now need to figure out is how
to set the Left Axis labels to display the contents of another field returned
by my query for that record.
does anyone know how to do this
without affecting the data values?
The closest i have come to success so
far is:
procedure GetAxisLabel(Sender:
TChartAxis; Series:
TChartSeries; ValueIndex: Integer; var LabelText:
string);
begin if Sender =
FChart.LeftAxis
then if
ValueIndex 1
then
LabelText :=
''
else
LabelText := IBQuery1.FieldByName('system').AsString;
end;
WebActionWhatever;
begin
stuff
GetAxisLabel(LeftAxis, HorizBarSeries,
1,
'any old string');
end;
But I keep getting a compile error :
constant object cannot be passed as a var parameter.
Anyone here know how to acheive
this??
TraceySoftware Developer / Web
MasterLogis[EMAIL PROTECTED](025)
213-1065
---Incoming mail is certified Virus Free.Checked by
AVG anti-virus system (http://www.grisoft.com).Version: 6.0.498 / Virus
Database: 297 - Release Date: 8/07/03
__
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.
__
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.498 / Virus Database: 297 - Release Date: 8/07/03
RE: [DUG]: Wildcard match of strings
probably not the best option, but you could use pos and check the result HTH Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allan, Samuel Sent: Tuesday, 1 July 2003 4:40 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Wildcard match of strings Does anyone know how to match two strings with wildcards? eg '*Roger*' = 'I am Roger' -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.495 / Virus Database: 294 - Release Date: 30/06/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.495 / Virus Database: 294 - Release Date: 30/06/03 __ 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. __ attachment: winmail.dat
RE: Re: [DUG]: Virus Alert: Someone has a BugBear...
my sever virus checker said its from [EMAIL PROTECTED], not that that means anything Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Jason Coley Sent: Wednesday, 11 June 2003 1:47 p.m. To: Multiple recipients of list delphi Subject: RE: Re: [DUG]: Virus Alert: Someone has a BugBear... I have checked my PC, home and work and neither has the virus? I also checked the Nortons site and read the info on the virus and checked the registry entries also, so I don't think I have it. Regards Jason Coley Manawatu Software Solutions email: [EMAIL PROTECTED] web: http://www.software-solutions.co.nz -Original Message- From: Tracey Maule [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 June 2003 12:57 p.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: Virus Alert: Someone has a BugBear... I received it at home BEFORE it was announced... lucky I delete all suspect mails cause my antivir didnt pick it up - Original Message - From: Myles Penlington [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 12:28 PM Subject: RE: [DUG]: Virus Alert: Someone has a BugBear... Yep they sure do. Bubear-B has it's own SMTP server built in according to our admins - amoung other things, it's also polymorhic. We had the first Bugbear-B email appear 4 hours after it's discovery was announced - last thursday morning. Myles. -Original Message- From: Corey Murtagh [mailto:[EMAIL PROTECTED] Sent: Wednesday, 11 June 2003 12:21 To: Multiple recipients of list delphi Subject: [DUG]: Virus Alert: Someone has a BugBear... -- -- --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- -- --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.488 / Virus Database: 287 - Release Date: 5/06/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.488 / Virus Database: 287 - Release Date: 5/06/03 __ 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. __ attachment: winmail.dat
RE: [DUG]: Setting Windows Scheme Colours from Delphi - how?
can it be done with the screen class? not sure about screen.color := ??? other than this windows api calls? HTH Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Moretti, Giovanni Sent: Monday, 9 June 2003 3:53 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Setting Windows Scheme Colours from Delphi - how? Hi Undoubtably it's possible to change the colours Windows uses for the desktop background, (in)active window header ... from delphi. I want to be able the SET these colours, not just access their current values, but from Delphi, not the usual Control Panel/Display property applet. Anyone know how? Thanks Giovanni == = Giovanni Moretti | Institute of Information Sciences and Technology Senior Lecturer | Massey University, Palmerston North, New Zealand Computer Science | Ph 64-6-3505799x2474 == Fax 64-6-3502259 == ZL2BOI -- - http://www-ist.massey.ac.nz/moretti mailto:[EMAIL PROTECTED] -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.488 / Virus Database: 287 - Release Date: 5/06/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.488 / Virus Database: 287 - Release Date: 5/06/03 __ 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. __ attachment: winmail.dat
RE: [DUG]: Case Insensitive POS
how about converting both to uppercase first? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Neven MacEwan Sent: Wednesday, 2 April 2003 4:05 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Case Insensitive POS Yo all Anyone OTTOTH know is there is a std case insesitive vserion of pos() TIa Regards Neven N.K. MacEwan B.E. EE Ph 649 621 0001 Fax 649 621 0400 [EMAIL PROTECTED] -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]:has anyone had any experience programming in Delphi and integrating to SAP?
Hi. I am managing a project that is going to extract information out of out sap system, has anyone had any experience in this or can direct me to components or documents discussing this? Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.465 / Virus Database: 263 - Release Date: 25/03/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: Tip for sore eyes
what brand of moniter are these? all 17" lcd monitors I have seen are still about $1000 -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Leigh WansteadSent: Thursday, 13 March 2003 10:21 a.m.To: Multiple recipients of list delphiSubject: RE: [DUG]: Tip for sore eyes Just think about for a normal programmer who has to sit in front of a CRTmonitor which will generate radio activity for 8 hours a day, 5 days a week. It is not simply sore eyes issue. I got my PhilipsLCD 17 inch monitor at home 9 months ago and atwork 4 months ago. Now I feel that I do not need to expose to these sorts of radio activity any more. I don't know how these radio activity will effect human beings. I believe less is better than more.Actually I sit in front of monitor for more than 12 hours a day, so I must look after myself and the company.(If I take sick leave, that will cost more to the company than a monitor pricein some sense). At the time I bought my monitor, a brand new LCD 17 inch monitor cost $2000+gst. Company bought same brand for $1200+GST. And now I see same brand 17inch LCD monitor cost $809+GST. Compare to Delphi professional/enterprise edition price, it would be quitereasonable to get a LCD monitor for your health. 15 inch LCD monitoris quite small anyway. Just consider as an investment to your health. Cheers Leigh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Wednesday, March 12, 2003 12:23 PMTo: Multiple recipients of list delphiSubject: [DUG]: Tip for sore eyes My screen has flickered at the corners quite badly for quite some time. I tried swapping to another screen on an empty desk, and it was worse! But problem solved today. My screen's refresh rate was set far too low (60 Hertz). I've increased it to 85 Hertz (my monitor can handle it) and now I have a perfectly still screen. Awesome! So if you have a flickering / shaky screen, and haven't checked your refresh rate, it might help. Guess everyone knows this but me! Dave Jollie Tower NZ IT 09 368 4259 ---Incoming mail is certified Virus Free.Checked by AVG anti-virus system (http://www.grisoft.com).Version: 6.0.461 / Virus Database: 260 - Release Date: 10/03/03 __ 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. __ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.461 / Virus Database: 260 - Release Date: 10/03/03
RE: [DUG]: What is ^J ?
^-J - linefeed ^-M - Carriage return ^-l - tab some ascii charts have these representations on... Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Howard Sent: Tuesday, 4 March 2003 10:52 a.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: What is ^J ? Further, I seem to remember Ctrl-J was Line Feed Mark On 4 Mar 2003 at 10:38, Steve Peacocke wrote: Leigh Wanstead said: Hello everyone, I read following piece of code. I don't understand ^J, ^M, ^I meaning. Can anyone explain to me? I guess it is like #13. case ch of ' ', ^J, ^M, ^I, ',': begin In this case ^J means [Ctrl]-J, ^M is [Ctrl]-M (or return) and ^I is [Ctrl]- I or TAB. My guess is you are looking at some old DOS code. Steve -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.459 / Virus Database: 258 - Release Date: 25/02/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: Can anyone tell me how to automatically detect proxy information?
Hi. I want to use wininet to detect proxy information from a local computer, now I know there is a function internetqueryoptions, is this the way I should go? Can anyone supply proper syntax for calling this method? Is there any other way to access the proxy information? I was initially retrieving this information form the registry but I think that will fail when the computer has ceveral connections on the machine, I will not know twhich is currently active. I think this internetqueryoptions is my best bet. Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: Looking for a decent book...
Hi. Can anyone recommend a decent book explaining the use of wininet/windows api programming in delphi context? I have a few delphi books and essential wininet from aaron skonnard but there are no linkages between them. can anyone please suggest a decent book here? Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.449 / Virus Database: 251 - Release Date: 27/01/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]:stringtodate problem?
Hi.
I am trying to do a strtodate('01/01/1900');
This is used simply to determine an order of a sequence of dates so I do
this to set the earliest date.
Now on almost all computers this is no problem, but on ONE computer this
dies with an unknown exception and I can capture the following
information...
There is also a problem where the computers system date format was
mm/dd/ and this caused another problem, but I think ive fixed that one
with a formatdate call, but this one is really baffling me.
The OS is the same as I am running so I cant see an issue there, and the
system shortdateformat is now correct also.
Can anyone think what this could be? I know datetime is from 13/12/1899
could this be a problem? should I change it to strtodate('01/01/1970');
cheers
Chris Veale
=
date/time : 2003-01-24 16:51
computer name : SERVER
operating system : Windows 2000
free disk space : 14,34 GB
executable: kiwiload.exe
exec. date/time : 2002-12-20 12:01
exception class : Exception
exception message : Unknown Exception.
thread $2A0:
$004F115F kiwiload.exe madExcept 2067 CreateBugReport
$004EDE87 kiwiload.exe madExcept 1072 SendShellMail
$004EF1F8 kiwiload.exe madExcept 1474 TExceptionBox.DialogWndMethod
$004F02B1 kiwiload.exe madExcept 1695 ShowException
$004F0499 kiwiload.exe madExcept 1747 ReceiveHandleException
$004EB75D kiwiload.exe madTools 390 MsgHandlerWindowProc
$004F05FD kiwiload.exe madExcept 1782 HandleExceptionThread
main thread ($454):
$77E1484C user32.dll
$004F0719 kiwiload.exe madExcept 1829 HandleException
$004F1635 kiwiload.exe madExcept 2129 InterceptAHandleExcept
$00521D84 kiwiload.exe main 2291 validatebudflow
$00522B39 kiwiload.exe main 2868 process_bud_flow
$005282EC kiwiload.exe main 4535 TForm1.Button2Click
$0052A732 kiwiload.exe KiwiLoad22 KiwiLoad
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
__
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.
__
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]:stringtodate problem?
well the issue only happens on this one line, so ive changed that line to
encodedate but
Ive noticed that previously the user has run another process and performs
EXACTLY the same line (though the 01/01/1900' is stored as a variable not
hardcoded), but the user gets through this fine.
:( hmmm
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Donovan Broad
Sent: Monday, 27 January 2003 8:47 a.m.
To: Multiple recipients of list delphi
Subject: RE: [DUG]:stringtodate problem?
Hi Chris
I find that it safer to use DecodeDate and EncodeDate when
dealing with
TDateTime - this way you don't have to be concerned with
which date format
is being considered by the conversion routine.
HTH
Donovan
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Chris Veale
Sent: Monday, January 27, 2003 8:35 AM
To: Multiple recipients of list delphi
Subject: [DUG]:stringtodate problem?
Hi.
I am trying to do a strtodate('01/01/1900');
This is used simply to determine an order of a sequence of
dates so I do
this to set the earliest date.
Now on almost all computers this is no problem, but on ONE
computer this
dies with an unknown exception and I can capture the following
information...
There is also a problem where the computers system date format was
mm/dd/ and this caused another problem, but I think ive
fixed that one
with a formatdate call, but this one is really baffling me.
The OS is the same as I am running so I cant see an issue
there, and the
system shortdateformat is now correct also.
Can anyone think what this could be? I know datetime is from
13/12/1899
could this be a problem? should I change it to
strtodate('01/01/1970');
cheers
Chris Veale
=
date/time : 2003-01-24 16:51
computer name : SERVER
operating system : Windows 2000
free disk space : 14,34 GB
executable: kiwiload.exe
exec. date/time : 2002-12-20 12:01
exception class : Exception
exception message : Unknown Exception.
thread $2A0:
$004F115F kiwiload.exe madExcept 2067 CreateBugReport
$004EDE87 kiwiload.exe madExcept 1072 SendShellMail
$004EF1F8 kiwiload.exe madExcept 1474 TExceptionBox.DialogWndMethod
$004F02B1 kiwiload.exe madExcept 1695 ShowException
$004F0499 kiwiload.exe madExcept 1747 ReceiveHandleException
$004EB75D kiwiload.exe madTools 390 MsgHandlerWindowProc
$004F05FD kiwiload.exe madExcept 1782 HandleExceptionThread
main thread ($454):
$77E1484C user32.dll
$004F0719 kiwiload.exe madExcept 1829 HandleException
$004F1635 kiwiload.exe madExcept 2129 InterceptAHandleExcept
$00521D84 kiwiload.exe main 2291 validatebudflow
$00522B39 kiwiload.exe main 2868 process_bud_flow
$005282EC kiwiload.exe main 4535 TForm1.Button2Click
$0052A732 kiwiload.exe KiwiLoad22 KiwiLoad
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
__
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.
__
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]:stringtodate problem?
im sorry I cant have made myself clear (not surptising)...
I mean I enforce columns in an f1book component to be entered in ascending
date format where the book looks like...
date1 date2 date3 date4
col1col2col3col4
and the dates are ascending so I set this var earlier than the first date
could ever be so I didnt have to write a special case for the first col.
and it still dies on strtodate('01/01/1900');
Ive just changed this to encodedate(01,01,1970); to see if this helps, but
as the computer is in Auckland I cant check any fixes till tomorrow, so Im
kinda flying blind at the moment...
Thanks all for your advice.
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Chris Milham
Sent: Monday, 27 January 2003 9:50 a.m.
To: Multiple recipients of list delphi
Subject: Re: [DUG]:stringtodate problem?
Hi,
If I am understanding what you are trying to do correctly, by
earliest
date you mean you are trying to get the earliest date possible that
Delphi can store. Is this correct?
If so, why not just set your TDate/TDateTime var to zero.
This will set
your datetime var to the earliest value that can be stored, namely
30/12/1899 12:00 am
HTH,
Chris
Chris Veale wrote:
Hi.
I am trying to do a strtodate('01/01/1900');
This is used simply to determine an order of a sequence of
dates so I do
this to set the earliest date.
Now on almost all computers this is no problem, but on ONE
computer this
dies with an unknown exception and I can capture the following
information...
There is also a problem where the computers system date format was
mm/dd/ and this caused another problem, but I think ive
fixed that one
with a formatdate call, but this one is really baffling me.
The OS is the same as I am running so I cant see an issue
there, and the
system shortdateformat is now correct also.
Can anyone think what this could be? I know datetime is
from 13/12/1899
could this be a problem? should I change it to
strtodate('01/01/1970');
cheers
Chris Veale
=
date/time : 2003-01-24 16:51
computer name : SERVER
operating system : Windows 2000
free disk space : 14,34 GB
executable: kiwiload.exe
exec. date/time : 2002-12-20 12:01
exception class : Exception
exception message : Unknown Exception.
thread $2A0:
$004F115F kiwiload.exe madExcept 2067 CreateBugReport
$004EDE87 kiwiload.exe madExcept 1072 SendShellMail
$004EF1F8 kiwiload.exe madExcept 1474 TExceptionBox.DialogWndMethod
$004F02B1 kiwiload.exe madExcept 1695 ShowException
$004F0499 kiwiload.exe madExcept 1747 ReceiveHandleException
$004EB75D kiwiload.exe madTools 390 MsgHandlerWindowProc
$004F05FD kiwiload.exe madExcept 1782 HandleExceptionThread
main thread ($454):
$77E1484C user32.dll
$004F0719 kiwiload.exe madExcept 1829 HandleException
$004F1635 kiwiload.exe madExcept 2129 InterceptAHandleExcept
$00521D84 kiwiload.exe main 2291 validatebudflow
$00522B39 kiwiload.exe main 2868 process_bud_flow
$005282EC kiwiload.exe main 4535 TForm1.Button2Click
$0052A732 kiwiload.exe KiwiLoad22 KiwiLoad
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
__
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.
__
-
--
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.445 / Virus Database: 250 - Release Date: 21/01/03
__
The contents of this e-mail are privileged and/or confidential to the
named
[DUG]: seem to remember...autoincrement version number
Hi all. I seem to remember a topic in here about automatically updating version numbers as builds progress, can anyone please point me to the right place or can anyone please tell me if this can be done? Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: seem to remember...autoincrement version number
yeah Im after a version number like 1.84.0036 any ideas? Conor would your code work with this? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Mckenzie Sent: Wednesday, 22 January 2003 3:05 p.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: seem to remember...autoincrement version number Note: It is incremented for every single Build of the Project and does not allow leading 0's. We do not use it because of this... Other than that - it is v useful. Regards Paul McKenzie Analyst Programmer SMSS ltd. - Original Message - From: Conor Boyd [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 2:52 PM Subject: RE: [DUG]: seem to remember...autoincrement version number Project, Options, Version Info tab, Include Version Info, Auto-increment build number. I've also got a bit of code somewhere to allow you to read the number from e.g. an About box, if it's any use to you... HTH, C. -Original Message- From: Chris Veale [mailto:[EMAIL PROTECTED]] I seem to remember a topic in here about automatically updating version numbers as builds progress, can anyone please point me to the right place or can anyone please tell me if this can be done? -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: seem to remember...autoincrement version number
how do you update it? by hand? I have a string in the code detailing the version number, but I wanted to increment this automatically when I recompile... sounds like this key-value is effectively the same as when Im doing except for the external access...? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Mckenzie Sent: Wednesday, 22 January 2003 3:21 p.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: seem to remember...autoincrement version number What we used is to create our oun Key/Value pair in the VersionInfo tab and manually update (increment) the version numbering ie Key VersionNumber Value: 1.84.0036 - That way the string can be anything you like (eg our current version 06.10.00) Regards Paul McKenzie Analyst Programmer SMSS ltd. - Original Message - From: Chris Veale [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 3:06 PM Subject: RE: [DUG]: seem to remember...autoincrement version number yeah Im after a version number like 1.84.0036 any ideas? Conor would your code work with this? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Paul Mckenzie Sent: Wednesday, 22 January 2003 3:05 p.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: seem to remember...autoincrement version number Note: It is incremented for every single Build of the Project and does not allow leading 0's. We do not use it because of this... Other than that - it is v useful. Regards Paul McKenzie Analyst Programmer SMSS ltd. - Original Message - From: Conor Boyd [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Wednesday, January 22, 2003 2:52 PM Subject: RE: [DUG]: seem to remember...autoincrement version number Project, Options, Version Info tab, Include Version Info, Auto-increment build number. I've also got a bit of code somewhere to allow you to read the number from e.g. an About box, if it's any use to you... HTH, C. -Original Message- From: Chris Veale [mailto:[EMAIL PROTECTED]] I seem to remember a topic in here about automatically updating version numbers as builds progress, can anyone please point me to the right place or can anyone please tell me if this can be done? -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.443 / Virus Database: 248 - Release
RE: [DUG]: SQL Help
I thought delphi could only handle single sql queries, not multiples?
Please correct me if Im wrong...
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mark Howard
Sent: Friday, 17 January 2003 10:54 a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: SQL Help
Hello
I am trying to get a two part SQL query to work (D5, DBISAM)
If I run the two parts in Steve Peacock's 20 Queries, I get
a result set:
but if I run them in my app as follows there is no result set.
What am I doing wrong?
TIA Mark
SQL.Clear;
SQL.Add('Select d.LogCode, d.ForCode, d.DockType, d.Comp,');
SQL.Add('d.SpeciesCode, sum(TruckLoad) SpecTot');
SQL.Add('into t1');
SQL.Add('from dockets d');
SQL.Add('where DocketDate between :StartDate and :EndDate');
SQL.Add('group by LogCode, ForCode, DockType, Comp,
SpeciesCode;');
SQL.Add('Select l.Logname, f.ForName,');
SQL.Add('d.LogCode, d.ForCode, d.DockType, d.Comp,
d.SpeciesCode,');
SQL.Add('d.Grade, sum(d.TruckLoad) GradeTot, t1.SpecTot');
SQL.Add('from Dockets d');
SQL.Add('join Logger l on d.LogCode = l.LogCode');
SQL.Add('join Forest f on d.ForCode = f.ForCode');
SQL.Add('join t1 on d.LogCode = t1.LogCode');
SQL.Add('and d.ForCode = t1.ForCode');
SQL.Add('and d.DockType = t1.DockType');
SQL.Add('and d.Comp = t1.Comp');
SQL.Add('and d.SpeciesCode = t1.SpeciesCode');
SQL.Add('where DocketDate between :StartDate and :EndDate');
SQL.Add('group by LogCode, ForCode, DockType, Comp,
SpeciesCode, Grade');
ParamByName('StartDate').AsDate := Date1;
ParamByName('EndDate').AsDate := Date2;
Open;
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03
__
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.
__
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: SQL Help
hmmm from memory also I dont think delphi sql handles joins.
I believe when I was doing stuff like this I had to take the result set from
the first and load these into variables and then pass these to a seperate
query...
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Mark Howard
Sent: Friday, 17 January 2003 11:16 a.m.
To: Multiple recipients of list delphi
Subject: RE: [DUG]: SQL Help
OK. I guess that's what I was asking.
So...Can I do
SELECT (blah, blah) into MEMORY t1
.
ParamByName('StartDate').AsDate := Date1;
ParamByName('EndDate').AsDate := Date2;
Open;
followed by
SELECT (blah, blah)
JOIN MEMORY t1 on d.LogCode = t1.LogCode
.
ParamByName('StartDate').AsDate := Date1;
ParamByName('EndDate').AsDate := Date2;
Open;
Do I have to tidy up the Memory table when I've finished? and how?
Mark
On 17 Jan 2003 at 10:59, Chris Veale wrote:
I thought delphi could only handle single sql queries, not
multiples?
Please correct me if Im wrong...
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mark Howard Sent:
Friday, 17 January 2003 10:54 a.m. To: Multiple recipients of list
delphi Subject: [DUG]: SQL Help
Hello
I am trying to get a two part SQL query to work (D5, DBISAM)
If I run the two parts in Steve Peacock's 20 Queries, I get
a result set:
but if I run them in my app as follows there is no result set.
What am I doing wrong?
TIA Mark
SQL.Clear;
SQL.Add('Select d.LogCode, d.ForCode, d.DockType, d.Comp,');
SQL.Add('d.SpeciesCode, sum(TruckLoad) SpecTot');
SQL.Add('into
t1'); SQL.Add('from dockets d'); SQL.Add('where DocketDate
between :StartDate and :EndDate'); SQL.Add('group by LogCode,
ForCode, DockType, Comp,
SpeciesCode;');
SQL.Add('Select l.Logname, f.ForName,');
SQL.Add('d.LogCode, d.ForCode, d.DockType, d.Comp,
d.SpeciesCode,');
SQL.Add('d.Grade, sum(d.TruckLoad) GradeTot, t1.SpecTot');
SQL.Add('from Dockets d');
SQL.Add('join Logger l on d.LogCode = l.LogCode');
SQL.Add('join Forest f on d.ForCode = f.ForCode');
SQL.Add('join t1 on d.LogCode = t1.LogCode');
SQL.Add('and d.ForCode = t1.ForCode');
SQL.Add('and d.DockType = t1.DockType');
SQL.Add('and d.Comp = t1.Comp');
SQL.Add('and d.SpeciesCode = t1.SpeciesCode');
SQL.Add('where DocketDate between :StartDate and :EndDate');
SQL.Add('group by LogCode, ForCode, DockType, Comp,
SpeciesCode, Grade');
ParamByName('StartDate').AsDate := Date1;
ParamByName('EndDate').AsDate := Date2;
Open;
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at:
http://www.mail-archive.com/delphi%40delphi.org.nz/
--- Incoming mail is certified Virus Free. Checked by AVG anti-virus
system (http://www.grisoft.com). Version: 6.0.443 / Virus Database:
248 - Release Date: 10/01/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03
__
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.
__
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.443 / Virus Database: 248 - Release Date: 10/01/03
---
New Zealand Delphi Users group - Delphi List
[DUG]: Indy component no longer working, but....
Hi all. I am using an indy idhttp component in my app and it has never failed me...till yesterday. Yesterday morning I made some changes to the app and compiled and tested and shipped out for beta testing (all working fine) and when the tester got it at 1pm it died... I then tried to recompile and test and it now dies on my system also (which it didnt do previously). In the meantime I wasnt working in delphi at all so Im certain I didnt do anything to stuff this up. I am getting a estringlist error with the message string list out of bounds (1) this is happening on a simple get command and is generated when it tries to deletefoldedlines? like I say Ive never had this happen before. Now the interesting thing for me is that I ran previously compiled versions of the app and they work fine, but when I take the code for these previously compiled versions and recompile in the ide they now die with the same error message. below is the debug...captured from the error event = date/time : 2002-12-17 14:10 computer name : THE-BEAST operating system : Windows 2000 Service Pack 2 free disk space : 12,66 GB executable: KiwiLoad.exe exec. date/time : 2002-12-17 14:10 exception class : EStringListError exception message : List index out of bounds (1). main thread ($4E4): $00414719 KiwiLoad.exe Classes TStringList.Get $004D255B KiwiLoad.exe IdHeaderList 194 TIdHeaderList.DeleteFoldedLines $004D2B27 KiwiLoad.exe IdHeaderList 343 TIdHeaderList.SetValue $004D50C2 KiwiLoad.exe IdHTTPHeaderInfo 280 TIdEntityHeaderInfo.SetHeaders $004D58A5 KiwiLoad.exe IdHTTPHeaderInfo 469 TIdRequestHeaderInfo.SetHeaders $004DBA1D KiwiLoad.exe IdHTTP 1372 TIdHTTPProtocol.BuildAndSendRequest $004DAA07 KiwiLoad.exe IdHTTP873 TIdCustomHTTP.ConnectToHost $004DABA1 KiwiLoad.exe IdHTTP906 TIdCustomHTTP.DoRequest $004D9BBB KiwiLoad.exe IdHTTP395 TIdCustomHTTP.Get $004D9CBA KiwiLoad.exe IdHTTP529 TIdCustomHTTP.Get $004F42A5 KiwiLoad.exe login 942 get_crop $004F455E KiwiLoad.exe login1048 TForm2.Button1Click $0052A65E KiwiLoad.exe KiwiLoad 22 KiwiLoad = does this sound like a corrupt file or something? what else could it be? I tried deleting exe and dcus and recompiling but it is still happening... Im starting to think a reinstall of delphi may be the ticket here...if anyone has some words of wisdon for a baffeled programmer it would be gratefully appreciated. Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: Indy component no longer working, but....
never mind Ive fixed it now, not sure of the exact problem, but I suspect it was a corrupt file somewhere (be it indy or delphi), a reinstall kicked the problem to the curb. Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chris Veale Sent: Wednesday, 18 December 2002 8:29 a.m. To: Multiple recipients of list delphi Subject: [DUG]: Indy component no longer working, but Hi all. I am using an indy idhttp component in my app and it has never failed me...till yesterday. Yesterday morning I made some changes to the app and compiled and tested and shipped out for beta testing (all working fine) and when the tester got it at 1pm it died... I then tried to recompile and test and it now dies on my system also (which it didnt do previously). In the meantime I wasnt working in delphi at all so Im certain I didnt do anything to stuff this up. I am getting a estringlist error with the message string list out of bounds (1) this is happening on a simple get command and is generated when it tries to deletefoldedlines? like I say Ive never had this happen before. Now the interesting thing for me is that I ran previously compiled versions of the app and they work fine, but when I take the code for these previously compiled versions and recompile in the ide they now die with the same error message. below is the debug...captured from the error event == == = date/time : 2002-12-17 14:10 computer name : THE-BEAST operating system : Windows 2000 Service Pack 2 free disk space : 12,66 GB executable: KiwiLoad.exe exec. date/time : 2002-12-17 14:10 exception class : EStringListError exception message : List index out of bounds (1). main thread ($4E4): $00414719 KiwiLoad.exe Classes TStringList.Get $004D255B KiwiLoad.exe IdHeaderList 194 TIdHeaderList.DeleteFoldedLines $004D2B27 KiwiLoad.exe IdHeaderList 343 TIdHeaderList.SetValue $004D50C2 KiwiLoad.exe IdHTTPHeaderInfo 280 TIdEntityHeaderInfo.SetHeaders $004D58A5 KiwiLoad.exe IdHTTPHeaderInfo 469 TIdRequestHeaderInfo.SetHeaders $004DBA1D KiwiLoad.exe IdHTTP 1372 TIdHTTPProtocol.BuildAndSendRequest $004DAA07 KiwiLoad.exe IdHTTP873 TIdCustomHTTP.ConnectToHost $004DABA1 KiwiLoad.exe IdHTTP906 TIdCustomHTTP.DoRequest $004D9BBB KiwiLoad.exe IdHTTP395 TIdCustomHTTP.Get $004D9CBA KiwiLoad.exe IdHTTP529 TIdCustomHTTP.Get $004F42A5 KiwiLoad.exe login 942 get_crop $004F455E KiwiLoad.exe login1048 TForm2.Button1Click $0052A65E KiwiLoad.exe KiwiLoad 22 KiwiLoad == == = does this sound like a corrupt file or something? what else could it be? I tried deleting exe and dcus and recompiling but it is still happening... Im starting to think a reinstall of delphi may be the ticket here...if anyone has some words of wisdon for a baffeled programmer it would be gratefully appreciated. Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/02 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.427 / Virus Database: 240 - Release Date: 6/12/02 --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]:changing compile conditions at runtime...
Hi I want to implement something like a passcode that when entered allows the user to do something different than a user without that passcode. I have all the functionality already in the code with compile conditions but from all the help Ive looked through, I cant change this on the fly - it takes a full recompile. Is there any way of allowing this change at runtime using compile conditions or am I going to have to rebuild the functionality with if statements? Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.426 / Virus Database: 239 - Release Date: 2/12/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: Anyone know how to verify a string conversion to float is successful without needing a try except?
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.419 / Virus Database: 235 - Release Date: 13/11/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: anyone had any experience with delphi and LDAP connectivity? recomment any components if I need any?
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.417 / Virus Database: 233 - Release Date: 8/11/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: EInvalidOp - what is it and why am I getting it?
Hi. I am getting an EInvalidOp exception in a section of code I have that has previously worked and I am certain I havent changed anything in that area for months...this code is now not working and Im at a loss to explain why... basically I am getting the error raised on this line s_thedate := format_date_2_mysql(trunc(e_mymean),s_yearname); the format_date_2_mysql just takes a float and reformats the value to a mysql date as follows and s_yearname is a string 2002 There are two functions that are called repeatedly initially that calculate e_mymean but the result is 37500.63 function format_date_2_mysql(s_val:float;s_year:string): string; var w_year,w_month,w_day:word; begin //format the date to what we want decodedate(strtodate(formatdatetime(s_date_format,s_val)),w_year,w_month,w_d ay); if s_year = s_empty then begin result := inttostr(w_year) + '-' + inttostr(w_month) + '-' + inttostr(w_day); end else begin result := s_year + '-' + inttostr(w_month) + '-' + inttostr(w_day); end; end; can anyone please tell me what this error is (I looked at the help file and it could be one of three things but how can I tell which?) also can anyone please suggest a process to follow to sort it out? I think it has something to do with the data type I am using (extended) but on the other hand I cant see this being an issue as this is the most significant datatype for real anyway... Hoping and praying for advice Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.408 / Virus Database: 230 - Release Date: 24/10/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: Anyone know an easy way to sort an array alphabetically?
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]:can anyone please tell me why I keep getting the cpu window all the time now, its a pain in the backside all the time...
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.401 / Virus Database: 226 - Release Date: 9/10/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: problem with bordbk.dll - is it me or a reinstall required?
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: problem with bordbk.dll - is it me or a reinstall required?
Im not getting that error, rather an access violation which makes me think it is something Im doing nope that didnt work, getting eaccess violation and a read of address. thanks for the info though, Ill just bookmark that link as Im sure Ill need it sometime! Chris -Original Message- From: [EMAIL PROTECTED] [mailto:owner-delphi;delphi.org.nz]On Behalf Of Eion McIntosh (Christchurch) Sent: Tuesday, 22 October 2002 3:39 p.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: problem with bordbk.dll - is it me or a reinstall required? This has happened to me a couple of times, it indicates that the registry entry for the debugger kernel has disappeared. I don't know why this happens every so often. Follow this path which will hopefully help you fix you problem http://community.borland.com/article/0,1410,21585,00.html Eion McIntosh PPCS Ltd -Original Message- From: Chris Veale [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, 22 October 2002 3:33 p.m. To: Multiple recipients of list delphi Subject:[DUG]: problem with bordbk.dll - is it me or a reinstall required? --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/02 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ ## ### This e-mail message has been scanned and cleared ## ### -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.404 / Virus Database: 228 - Release Date: 15/10/02 --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]:urgent...Can someone please explain debugging a log file
I have an error log created by drwatson and have to debug the app, can anyone please tell me how I am supposed to do this and what has to be done. I can see where the fault is (drwatson says fault-) in the log, but it is represented in hex and I have no idea where to start. I get no error in my app, seems to be windows related...also get no error on my development machine so possibly library related? Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.399 / Virus Database: 226 - Release Date: 9/10/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: oh the log also has assembler code in there too if that helps
--- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.399 / Virus Database: 226 - Release Date: 9/10/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: Please help
try newstring := uppercase(string); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Vince Jones Sent: Wednesday, 2 October 2002 2:55 p.m. To: Multiple recipients of list delphi Subject: [DUG]: Please help I'm a Java programmer, in the process of changing to Delphi. I'm trying to write some simple programs, but I'm running into a raft of problems. My first problem is, I can't seem to get Strings to work. eg. myString.toUpperCase produces a compiler error, and I can't find a list of available methods. I can't believe strings wouldn't be available in Delphi Personal edition! Can anyone help? Thanks, Vince. http://mobile.yahoo.com.au - Yahoo! Messenger for SMS - Always be connected to your Messenger Friends -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.393 / Virus Database: 223 - Release Date: 30/09/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.393 / Virus Database: 223 - Release Date: 30/09/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: executing another application in yours?
Hi. Can anyone please tell me what the procedure is for executing an application in your code? I know it used to be winexec for win 311 systems, but what has it become? is it the create process procedure? Cheers Chris --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: formula one crashing through loop - was what does this error mean
the count is the sheet i am trying to reference, so that just means that Im not doing anything with the first sheet or the last couple, but thanks for the effort. I have decided to use internal cell references so that when the cell is changed, the others I want are also changed.. Cheers Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David O'Brien Sent: Monday, 30 September 2002 11:33 a.m. To: Multiple recipients of list delphi Subject: RE: [DUG]: formula one crashing through loop - was what does this error mean I don't know this component, but most use zero based counts, not 1 based. Would this work? for i_count := 2 to Form1.F1Book1.NumSheets - 1 do begin form1.F1Book1.Sheet := i_count; form1.F1Book1.SetActiveCell(1,1); form1.F1Book1.Text := s_variable; end; Dave. -Original Message- From: Chris Veale [mailto:[EMAIL PROTECTED]] Sent: Thursday, 26 September 2002 2:22 p.m. To: Multiple recipients of list delphi Subject: [DUG]: formula one crashing through loop - was what does this error mean Hi. I am using a formula one component that has multiple sheets on the first I have a dropdown box that when changed I want to update cells in the other sheets with the selection. doesnt sound too hard does it? when I put this into practice the application dies with an access violation in user32.dll I can update cells in the current sheet no problem but when I try to do the following the error occurs: for i_count := 3 to Form1.F1Book1.NumSheets do begin form1.F1Book1.Sheet := i_count; form1.F1Book1.SetActiveCell(1,1); form1.F1Book1.Text := s_variable; end; now the error doesnt happen here (inside f1book1objectchange procedure) it happens when that procedure exits so the above code executes fine until the procedure exits. if I take out the sheet assignment and just update the current sheet, it works fine and doesnt die on me, as follows: form1.F1Book1.SetActiveCell(1,1); form1.F1Book1.Text := s_variable; anyone got any ideas? Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: formula one crashing through loop - was what does this error mean
Hi. I am using a formula one component that has multiple sheets on the first I have a dropdown box that when changed I want to update cells in the other sheets with the selection. doesnt sound too hard does it? when I put this into practice the application dies with an access violation in user32.dll I can update cells in the current sheet no problem but when I try to do the following the error occurs: for i_count := 3 to Form1.F1Book1.NumSheets do begin form1.F1Book1.Sheet := i_count; form1.F1Book1.SetActiveCell(1,1); form1.F1Book1.Text := s_variable; end; now the error doesnt happen here (inside f1book1objectchange procedure) it happens when that procedure exits so the above code executes fine until the procedure exits. if I take out the sheet assignment and just update the current sheet, it works fine and doesnt die on me, as follows: form1.F1Book1.SetActiveCell(1,1); form1.F1Book1.Text := s_variable; anyone got any ideas? Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: what does this error mean?
Hi. I am looping through some sheets in the f1book component, and after I complete the looping I get this error Exception EAccessViolation in module user32.dll at 47CF Access Violation at address 77E147CF in module 'user32.dll'. Read of Address . Can anyone tell me what this means, and preferably how to fix it? I have tried stepping through the code, and it all seems to be working ok, though it dies on me. Please help if you can. Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: what does this error mean?
actually Im using win2k and not doing anything with a printer (during this operation), sounds like it might pay for me to reinstall delphi tho. Do you know if I have extra components installed, do I need to reinstall all these after delphi or will delphi pick these up if I install over the top of the existing delphi install? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ian Shere Sent: Wednesday, 25 September 2002 10:22 a.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: what does this error mean? I presume you're using XP?? I had the same problem (almost exactly) with my CADD program 2 days ago. Someone on the CADD forum suggested that it's a problem that is caused when the default printer is not present or can't be found. In the end, I did a System Restore to the day before (when I had done some major changes) and that fixed it. No idea what actually caused the problem. Ian Shere Tarzan Design Ltd www.tarzandesign.co.nz Award winning architecture - Original Message - From: Chris Veale [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Wednesday, September 25, 2002 9:45 AM Subject: [DUG]: what does this error mean? Hi. I am looping through some sheets in the f1book component, and after I complete the looping I get this error Exception EAccessViolation in module user32.dll at 47CF Access Violation at address 77E147CF in module 'user32.dll'. Read of Address . Can anyone tell me what this means, and preferably how to fix it? I have tried stepping through the code, and it all seems to be working ok, though it dies on me. Please help if you can. Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02 --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: what does this error mean?
I have done a little more research in this and the code is fine till I reach
the end of the procedure Im executing
procedure TForm1.F1Book1ObjValueChanged(Sender: TObject;
var ObjName: WideString; ObjID: Integer);
var
..
begin
..
end;{TForm1.F1Book1ObjValueChanged} *this is the line that
when it executes causes the application error
now this code worked yesterday, and I didnt change anything overnight it
just stopped working, that is why Im at a little bit of a loss.
I havent tried rebooting yet, just restarting delphi, the reboot happens now
to see if that fixes the problem, and if not then a delphi reinstall
Thanks for the advice tho Conor
Chris Veale
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Conor Boyd
Sent: Wednesday, 25 September 2002 10:44 a.m.
To: Multiple recipients of list delphi
Subject: RE: [DUG]: what does this error mean?
Hi Chris,
Tell me if I'm teaching you to suck eggs, but it's quite easy
to get AVs in
your code by e.g. referring to an object that doesn't exist
any more etc.
Even though the error message lists a Windows DLL (user32),
this doesn't
mean that it's not a bit of your code causing the AV.
E.g., if you have two variables referring to the same object, and you
destroy the object using one of the variables, you would
still be able to
call methods on the other variable, but you would be likely
to get an AV,
'cos the memory that the object resided at has been reclaimed
by the OS.
If it's not a problem with your code, it might be a bug in
the component
you're using.
Again, I might have missed the point of your original email,
but I hope this
helps...
Cheers,
Conor
-Original Message-
From: Chris Veale [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, September 25, 2002 9:45 AM
Subject: [DUG]: what does this error mean?
Hi.
I am looping through some sheets in the f1book component,
and after I
complete the looping I get this error
Exception EAccessViolation in module user32.dll at 47CF
Access Violation at address 77E147CF in module
'user32.dll'. Read of
Address .
Can anyone tell me what this means, and preferably how to fix it?
I have tried stepping through the code, and it all seems to
be working ok,
though it dies on me.
Please help if you can.
Chris Veale
--
-
New Zealand Delphi Users group - Delphi List -
[EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.391 / Virus Database: 222 - Release Date: 19/09/02
__
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.
__
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of unsubscribe delphi
Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: indy components and idhttp file upload
Hi. I am trying to upload a file through indy to our https webserver and am having trouble, I want to automatically load the file (so there is no user interaction) when I try though I get cannot open file and cant seem to get around it. I am still using a opendialog bok at the moment Can anyone point me in the right direction for examples, articles or help? I have read the articles in the indy website and posted now to the newsgroups. Cheers Chris Veale --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.389 / Virus Database: 220 - Release Date: 16/09/02 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: help with convert of dates?
Hi.
I am trying to check
if a date is valid without raising a runtime error, but I cant seem to work it
out.
This is the code I
am trying
try strtodate(s_value);
except on EConvertError do
begin showmessage('The date "' + s_value + '"
must be entered in the format dd/mm/yy'); b_ok
:= false; end; end;
however this raises
a runtime error when the date is invalid as well as displaying my error
message.
Is there any way to
lose the runtime error message and solely display my error
message?
Cheers
Chris
Veale
__
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.
__
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 4/09/02
RE: [DUG]: help with convert of dates?
Title: Message
yes Im
in debug mode, so I guess ive wasted a day...thanks for the info tho, only make
a mistake once (hopefully)
Chris
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Kyley
HarrisSent: Thursday, 12 September 2002 4:39 p.m.To:
Multiple recipients of list delphiSubject: RE: [DUG]: help with
convert of dates?
you
will only see the runtime error while debugging in delphi? are you testing in
or out of the IDE
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf
Of Chris VealeSent: Thursday, 12 September 2002 4:32
p.m.To: Multiple recipients of list delphiSubject:
[DUG]: help with convert of dates?
Hi.
I am trying to
check if a date is valid without raising a runtime error, but I cant seem to
work it out.
This is the code
I am trying
try strtodate(s_value);
except on EConvertError do
begin showmessage('The date "' + s_value +
'" must be entered in the format
dd/mm/yy'); b_ok :=
false; end; end;
however this
raises a runtime error when the date is invalid as well as displaying my
error message.
Is there any way
to lose the runtime error message and solely display my error
message?
Cheers
Chris
Veale__The
contents of this e-mail are privileged and/or confidential to thenamed
recipient and are not to be used by any other person and/ororganisation.
If you have received this e-mail in error, please notify the sender and
delete all material pertaining to this
e-mail.__
---Outgoing mail is certified Virus Free.Checked by
AVG anti-virus system (http://www.grisoft.com).Version: 6.0.385 / Virus
Database: 217 - Release Date: 4/09/02
---Incoming mail is certified Virus Free.Checked by
AVG anti-virus system (http://www.grisoft.com).Version: 6.0.385 / Virus
Database: 217 - Release Date: 4/09/02
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.385 / Virus Database: 217 - Release Date: 4/09/02
[DUG]: printing text in a tchart
Hi. I have created a chart with tchart and added the series in. I performed some calculations during this process and want to display the results to the user in something wthat will also print out when I do a tchart.printlandscape. I want to try and avoid the footer type stuff as these get put in specific locations and I want to place the data manually. Does anyone know of an attribute of tchart that will allow me to 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. __ --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.381 / Virus Database: 214 - Release Date: 2/08/02
[DUG]: Retrieving data from XML streams
Can anyone tell me how to retrieve data returned from an XML stream? We are making a http request to a MySQL database and have configured the system so that an XML stream is returned to the application. I can display this resultset fine.but want to be able to retrieve the data from the stream so that we can perform some number crunching on it and provide other solutions for the user based on the retrieved data. Any ideas? Cheers Chris Veale Chris Veale HortResearch Private Bag 11030 Palmerston North +6463568080 __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
RE: [DUG]: Retrieving data from XML streams
I only have delphi5 professional (archaic huh?) The whole point of me looking for other ways of doing this is because of the cost of D6 Enterprise Will these parsers still work? Cheers Chris Veale -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Nic Wise Sent: Tuesday, November 13, 2001 12:30 PM To: Multiple recipients of list delphi Subject: Re: [DUG]: Retrieving data from XML streams Get an XML Parser. There is the microsoft one, an IBM one, I think there are a few free ones, www.nothingbutnet.co.nz rings bells (PETER!!!), the Delphi-Jedi site - etc etc etc. Basically, if you have D6 enterprise, you can load it in from a string or file, and it puts it all nicely into a tree structure for you (you need a sample or XSD/DTD first tho). I dont know how the other ones work, but I'd guess its similar. Nic. - Original Message - From: Chris Veale [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, November 13, 2001 9:28 AM Subject: [DUG]: Retrieving data from XML streams Can anyone tell me how to retrieve data returned from an XML stream? We are making a http request to a MySQL database and have configured the system so that an XML stream is returned to the application. I can display this resultset fine.but want to be able to retrieve the data from the stream so that we can perform some number crunching on it and provide other solutions for the user based on the retrieved data. Any ideas? Cheers Chris Veale Chris Veale HortResearch Private Bag 11030 Palmerston North +6463568080 __ 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. __ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ -- - New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
[DUG]: TMonthCalenhdar and bolddays.
Hi. Can anyone tell me how to use the bolddays attribute of the tmonthcalender component Cheers Chris Veale __ 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. __ --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send email to: [EMAIL PROTECTED] with body of unsubscribe delphi Web Archive at: http://www.mail-archive.com/delphi%40delphi.org.nz/
