[DUG]: help please RE Thankyou

2001-05-29 Thread angelices
thanx a lot to all those who replied to my help message ! all ur info was useful. ...From Kristy and Brendon --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www

Re: [DUG]: 256 colour bitmap

2001-05-29 Thread jnorth
create a text file. call it bitmaps.rc (for examples sake) add the following MYBITMAP BITMAP c:\mybitmap.bmp Where MYBITMAP will be the name to reference to load the bitmap in your app and c:\mybitmap.bmp is the location of the bitmap file. compile your bitmaps.rc file with brcc32.exe (found in

Re: [DUG]: 256 colour bitmap

2001-05-29 Thread Corey Murtagh
"Roser, Wayne" <[EMAIL PROTECTED]> wrote on 30/05/2001 16:51:44: > >I've got a nice bitmap that I want to include in my res file (Delphi >4). > I paste it into image editor, blink twice, and the palette is > suddenly rubbish >and the bitmap is suddenly not so nice. Can anyone help me with this

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Bevan Edwards
Hi Neven, As for your comment about a function to format the string, in BCB you can use: Now().FormatString("dd/MM/") In Delphi I assume it would be something like: Now.FormatString('dd/MM/') Regards, Bevan Neven MacEwan wrote: > > Mark > > Sorry called you "Mike" is the last

RE: [DUG]: SQL and Parameters

2001-05-29 Thread James Low
Seems you don't - but am sure that at one stage I did just that, create a parameter, add it to the query object, set it parameters and it worked. If you trace through your code and check the paramcount before and after prepare and its zero then the parameter isn't being created behind the sc

Re: [DUG]: 256 colour bitmap

2001-05-29 Thread Mark Howard
Wayne Had a problem a bit like this when I put my app on laptop. It was eventually fixed by downloading the latest video driver for the screen. Does reducing the colors and / or screen resolution (in Display/Settings) have any effect? Mark - Original Message - From: "Roser, Wayne" <[EMAIL

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Neven MacEwan
Forget that use DateTimeToString Neven --- 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 "u

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Neven MacEwan
Mark Sorry called you "Mike" is the last email, You don't have to create the param It sounds like the error you are getting is from the BDE, so I'll be interested to see if my suggestions work If you want to do a 'static' param do SQL.Text := 'select * from table where date = '''%s; SQL.Te

[DUG]: 256 colour bitmap

2001-05-29 Thread Roser, Wayne
I've got a nice bitmap that I want to include in my res file (Delphi 4). I paste it into image editor, blink twice, and the palette is suddenly rubbish and the bitmap is suddenly not so nice. Can anyone help me with this? ---

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
You were right.  I had no idea that I had to specifically add parameter objects to the TQuery.  I can't find any mention of this in any of my 4 Delphi books. My procedure is now as follows, but I still get "Could not find object".  Is the code that I have used to add the parameter correct?

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Neven MacEwan
James/Mike The parameter is created when the onchange event of the SQL property fires and if parses the SQL, The advantages of using parameters (over just embedding them in the SQL Text) is that is is more efficient if you execute the query multiple times as the BDE et al compile the query and le

Re: Re:[DUG]: help please

2001-05-29 Thread Mark Howard
Corey said > > Mark already beat me to the punch with the simplest answer, so I > thought I'd try to point out a few things instead... ...and much more usefully too. I was just so delighted that I knew the answer to a question! Mark --

RE: [DUG]: SQL and Parameters

2001-05-29 Thread James Low
Maybe it cannot find an object because the query has NO parameters (I cannot see where your code creates one). So maybe you need to add (using CreateParam or otherwise)  a Param Object to the datsets Params (with the name "SaveDate", type Output (I think), ftdate) - before you call prepare.

Re:[DUG]: help please

2001-05-29 Thread Corey Murtagh
[EMAIL PROTECTED] wrote on 30/05/2001 15:36:48: > >i am need of help with my project, i am trying to save the lines in my >memo1 box to a text file can some one please help me out here. Mark already beat me to the punch with the simplest answer, so I thought I'd try to point out a few things in

RE: [DUG]: help please

2001-05-29 Thread James Low
Let the Memo do all the work with Memo1.Lines.SavetoFile('path and filename'). ps each line of a Memo is an item so if you wanted to do the same manually you would loop through all of them (from 0 to Lines.count - 1). -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Se

Re: [DUG]: help please

2001-05-29 Thread jnorth
procedure TForm1.BitBtn1Click(Sender: TObject); begin Memo1.Lines.SaveToFile('data.txt'); end; ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to wh

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
Mike Have tried this change, now.  No better.  I assume the question about Short Date Format is only relevant while I am using the DateToStr format? I think there must be something quitye fundamental, that I have not passed on to you guys. I assume that I can use a vanilla TQuery with no prop

Re: [DUG]: help please

2001-05-29 Thread Mark Howard
How about Memo.Lines.SaveToFile('data.txt') Mark - Original Message - From: <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 3:36 PM Subject: [DUG]: help please i am need of help with my project, i am trying to save the li

[DUG]: help please

2001-05-29 Thread angelices
i am need of help with my project, i am trying to save the lines in my memo1 box to a text file can some one please help me out here. procedure TForm1.BitBtn1Click(Sender: TObject); var sav:textfile; dat:string; begin dat:='data.txt'; assignfile(sav,dat); rewrite(sav); writeln(dat,me

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mike Osborne
Mark Have you tried - ParamByName('SaveDate').AsDate := CurrentDate; as opposed to ParamByName('SaveDate').AsString := DateToStr(CurrentDate);   What is your Short Date Format - dd/mm/yy or mm/dd/yy? DateToStr may not be giving you a valid date for SQL Why you would get "could not find ob

[DUG]: Delphi Component Creation Courses

2001-05-29 Thread GARY T BENNER
Delphi Component Creation Courses FYI. More details are on the User Group Web Site: http://www.delphi.org.nz = Date: Wed 6th June – Fri 8th June Location: Allfields Training Centre, 2 - 6 Gilmore Tce, Wellington Cost: $1500 + g

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Craig Goodall
Hi Mark, > should the parameter have been substituted, in the file that is written? Not sure. Like I said, I only use it to check my work when I'm modifying query lines at runtime. What about the settings in the TParams of the query's Params property, as I mentioned in my post? Are they ok? Can

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
OK. So I should expect the SQL.txt written out to still have the ":SaveDate" rather than the date itself? Is what I am trying to do common, or is it more normal to build up the SQL by adding lines in the code? Mark - Original Message - From: "Dennis Chuah" <[EMAIL PROTECTED]> To: "Multiple

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
Dennis Have just tried that and got exactly the same result, both in terms of the File written out and the Error message. Mark - Original Message - From: "Dennis Chuah" <[EMAIL PROTECTED]> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]> Sent: Wednesday, May 30, 2001 2:36 PM Su

RE: [DUG]: SQL and Parameters

2001-05-29 Thread Dennis Chuah
BTW, I was meant to say that the SQL is not modified by parameters. When the query is executed, the parameters sent along with the query. Regards, Dennis. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 30 May 2001 14:16 > To: Multiple recip

RE: [DUG]: SQL and Parameters

2001-05-29 Thread Dennis Chuah
Type preparing the query before you set the parameter. Regards, Dennis. > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 30 May 2001 14:16 > To: Multiple recipients of list delphi > Subject: Re: [DUG]: SQL and Parameters > > > Thanks for the r

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
Thanks for the response Craig. When I set the SaveDate parameter specifically (as below) and then do the SaveToFile immediately before the SQL code is executed, the code written out still has the ":SaveDate" parameter - rather than the '01/03/2001'. Is this right? or should the parameter have bee

[DUG]: more on kylix pricing

2001-05-29 Thread Nic Wise
on theregister.co.uk, no less. http://www.theregister.co.uk/content/4/19283.html --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website: http://www.delphi.org.nz To UnSub, send e

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Craig Goodall
Hi Mark, Could it be a problem in the settings of the Params property? For a date I use Datatype ftDate ParamType ptInput Maybe try putting a date into the Params Value property (it can stay there forever as you are always overwriting it) and see what happens? I've also used things like qryMyQuer

[DUG]: enhanced tchecklist?

2001-05-29 Thread Matthew Comb
Does anyone know of a tchecklistbox that also has expansion like in attree view? So that you can group tickable items?Matt. - Original Message - From: Mark Howard To: Multiple recipients of list delphi Sent: Wednesday, May 30, 2001 12:55 PM Subject: Re: [DUG]:

Re: [DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
Okay - Too vague?   Further to my post below:   The error is and EDBEngineError "Could not find object' and it occurs on the line that opens the query.   Is there any way to get more specific information about the error?   What sort of things would cause an error of this nature?   Any help wo

RE: [DUG]: Interbase/Delphi Stored Procedure

2001-05-29 Thread James Low
I had thought the ID_SLPRTY was the Parameter, but can see also that it is a return value so will try getting at it via fields[0].asIniteger. Thanks all for your help/suggestions. -Original Message- From: Sandeep [mailto:[EMAIL PROTECTED]] Sent: 30 May 2001 09:35 To: Multiple recipients

[DUG]: SQL and Parameters

2001-05-29 Thread Mark Howard
Hi   Using Paradox.   When I run the following SQL code (DocNos.Sql) using the LoadFromFile method, things work fine;   Delete from DocketNos Where DocketNo in (Select DocketNo from DocketsWhere ForCode not in (Select distinct forcode from docketswhere docketdate > '03/31/2001'))   But when

Re: Re: [DUG]: Interbase/Delphi Stored Procedure

2001-05-29 Thread Corey Murtagh
"Nic Wise" <[EMAIL PROTECTED]> wrote on 30/05/2001 09:46:33: > >> > CREATE PROCEDURE PRO_GETSLPRTY >> > RETURNS (ID_SLPRTY INTEGER) >> > AS >> > BEGIN >> > ID_SLPRTY = gen_id(GEN_SLPRTY, 1); > >um, dont you need a > >SUSPEND; > >right about here? Or is that just for ones you execute with > >selec

Re: [DUG]: Interbase/Delphi Stored Procedure

2001-05-29 Thread Nic Wise
> > CREATE PROCEDURE PRO_GETSLPRTY > > RETURNS (ID_SLPRTY INTEGER) > > AS > > BEGIN > > ID_SLPRTY = gen_id(GEN_SLPRTY, 1); um, dont you need a SUSPEND; right about here? Or is that just for ones you execute with select * from PRO_GETSLPRTY ?? > Thats because u r trying to pass a input para

RE: [DUG]: Interbase/Delphi Stored Procedure

2001-05-29 Thread Cheng Wei
HTH Cheng > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On > Behalf Of James Low > Sent: Wednesday, 30 May 2001 09:21 > To: Multiple recipients of list delphi > Subject: [DUG]: Interbase/Delphi Stored Procedure > > > My stored procedure (below) wont work. When I

Re: [DUG]: Interbase/Delphi Stored Procedure

2001-05-29 Thread Sandeep
On 30 May 2001, at 9:21, James Low wrote: > My stored procedure (below) wont work. When I call execproc I get either a > parameter or type mismatch or I am told there is no Params[0] - the return > value. The generator it uses has not incremented. > > I have an IB Insert TRigger that correctly u

[DUG]: Interbase/Delphi Stored Procedure

2001-05-29 Thread James Low
My stored procedure (below) wont work. When I call execproc I get either a parameter or type mismatch or I am told there is no Params[0] - the return value. The generator it uses has not incremented. I have an IB Insert TRigger that correctly uses the generator to fill in a Null field value when

Re: [DUG]: I/O Error 82

2001-05-29 Thread Corey Murtagh
[EMAIL PROTECTED] wrote: > > Anyone able to tell me what this error is about? According to the PSDK: 82 ERROR_CANNOT_MAKE The directory or file cannot be created. As to why... have you checked the drive for errors? Is it a pre-FAT32 volume with too many entries in the root directory

[DUG]: I/O Error 82

2001-05-29 Thread sjg
Anyone able to tell me what this error is about? The system runs on about 500 machines and this error arises consistently on only one with the following specs: -OS: Windows 95 -Disk Space: 31,256kb 78% free -Machine Type: Phillips 48X -RAM: 32MB Thanks in advance Steve Galyer --