Re: [DUG]: Date portion of MSSQL datetime data type

Alex SQL 2000 is in beta now avail go to http://www.microsoft.com/sql/productinfo/sql2kover.htm MSDE is rolling along they are talking about SQL2000 for windows CE! Regards Neven N.K. MacEwan B.E. E&E [EMAIL PROTECTED] - Original Message - From: Alex Kouznetsov <[EMAIL PROTECTED]> To:

Re: [DUG]: Date portion of MSSQL datetime data type

Thanks Neven Do you know when SQL2000 is due ? Also what is going to happen with MSDN concept ? There used to be rumors while ago about building SQL server into Windows in some form. Is it happenning ? Or it will be once again add-on for MS developers. Or something else ? Alex - Original M

[DUG]: A-Z order of constant declare const in Delphi type library

Hello everyone, Because I create enumerated const in random order in Delphi type library, so the order is random. I want to know how to order it to make it A to Z without delete and insert manually. Delphi Version: Delphi 5.01 Enterprise Thanks in advance. I look forward to hearing from you.

Re: [DUG]: Date portion of MSSQL datetime data type

Alex Roll on SQL 2000 with user defined functions The DatePart function will the first written re > Say I want records from 1/05/2000 to 30/05/2000 and my logged column is of > datetime type. > SELECT * FROM mytable WHERE logged >= '2000-05-01' AND logged < '2000-06-01' will work (prob a b

[DUG]: Date portion of MSSQL datetime data type

Hi I could not find any simple DatePart function in MSSQL to extract date portion from datetime columns. What is the best way to compare dates with the values in the datetime column ignoring its time portion ? I found this working but a bit ugly: Say I want records from 1/05/2000 to 30/05/2000

Re: [DUG]: Building formatted strings

Thanks Donovan That works fine. Thought that it wasn't working for a while until I realised that you have to used a monospaced font! Appreciate you help Mark "Donovan J. Edye" wrote: > M, > > Have a look at the Format() function. Try these out > > ShowMessage('|' + Format('%-10s', ['123']) +

RE: [DUG]: JPEG to Bitmap

It's OK, I was using the same code that I was using for printing, that wasn't needed, I just use stretchdraw for the screen, which works fine. Thanks again Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jason Coley Sent: Thursday, 1 June 2000 3:2

RE: [DUG]: JPEG to Bitmap

Thanks, that worked like a charm, another question i have had, is, when I view the bitmap on my screen canvas, using a TImage, the bitmaps don't usually look very good, why is this. The colours dont look right, but when I print its fine. Jason -Original Message- From: [EMAIL PROTECTED] [

[DUG]: Re: ADO

Funnily enough D so was I I have a couple of outstanding issues 1/ Parameters do funny things if you don't set the connection first 2/ ParamCheck = true causes an integer overflow if there are no parameters I've posted on the ADOExpress Site but it's so full of ADO v BDE bs its hard to get a res

Re: [DUG]: Table update

Thanks for those responses. I'll check them out now. No book suggestions though? Mark Bevan Edwards wrote: > Hi Mark, > > This should work: > > update dockets > set logprice = (select logprice from temp > where temp.docketno = dockets.docketno) > where docketno in (select dock

[DUG]:

G'Day All, I have been out of the "news loop" for a while and was wondering if there had been an update patch (subsequent to 5.01) to the ADODB.pas that was hinted at on the newsgroups? I am running my application against SQL7 with MDAC 2.50.4403.12. I also have NOT applied SP2 to SQL7. Is that a

Re: [DUG]: Object Repository

Figured it out myself - I was adding the entire project into the repository rather than a form. In case anyone is wondering what the difference is. Projects can only be copied not inherited. Makes sense really doesn't it :-) If you want to add a project into the repository , go to the project me

Re: [DUG]: Table update

I Dont know if Paradox supports it (I think COALESCE is part of the ANSI standard) but you could try update dockets set LogPrice = COALESCE((select LogPrice from Temp where temp.docketno = dockets.docketno),0) This will update all dockets whereas: UPDATE Dockets SET LogPrice = ( SELECT LogPric

RE: [DUG]: JPEG to Bitmap

Jason Coley asked: > So is there a way to convert the JPEG to a BMP in Delphi, > I'm using D3. The code I used (in Delphi 5) is: Bitmap := TBitmap.Create; Bitmap.PixelFormat := pf24Bit; Bitmap.HandleType := bmDIB; Bitmap.Width := Picture.Width; Bitmap.Height := Picture.Height; Bitma

RE: [DUG]: ToolWnds - where is it?

Ta. In the end I wrote a new PropertyEditor for my collection. Cheers, Carl -Original Message- From: Neven MacEwan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 31 May 2000 5:24 PM To: Multiple recipients of list delphi Subject: Re: [DUG]: ToolWnds - where is it? Carl If all else fails

[DUG]: Object Repository

Does anyone know what determines whether a form is available for inheritance, copy or uses within the object repository. The reason is , I am trying to add a form into the repository and inherit from it into a different project, but unfortunately the repository doesn't allow me to do this as onl

[DUG]: Object Repository

Does anyone know what determines whether a form is available for inheritance, copy or uses within the object repository. The reason is , I am trying to add a form into the repository and inherit from it into a different project, but unfortunately the repository doesn't allow me to do this as onl

RE: [DUG]: Delphi demo with Screen Cam

I use SnagIt 32 for capturing AVI.  The MS screen cam produced strange AVI files that didn't always work right.  see www.techsmith.com (no I don't have shares)  Oh and I just checked that link and saw they have something called "dubit" for editing the sound on an AVI... -Original Mess

RE: [DUG]: Temp File Management

Neven MacEwan asked: > Does anyone have a component/code to deal with temp files > (creating and cleaning up) The easiest way to do this is to create an appropiate wrapper about the Win32 call CreateFile using the FILE_FLAG_DELETE_ON_CLOSE flag. Combining this with the GetTempFileName API call a

Re: [DUG]: Table update

> When I run the following > > update dockets set LogPrice = (select LogPrice from Temp > where temp.docketno = dockets.docketno) UPDATE Dockets SET LogPrice = ( SELECT LogPrice FROM Temp WHERE Temp.DocketNo=Dockets.DocketNo ) WHERE EXISTS ( SELECT 'X' FROM Temp WHERE Temp.DocketNo=Dockets.Dock

Re: [DUG]: Table update

Hi Mark, This should work: update dockets set logprice = (select logprice from temp where temp.docketno = dockets.docketno) where docketno in (select docketno from temp) Regards, Bevan > When I run the following > > update dockets set LogPrice = (select LogPrice from Temp >

[DUG]: Table update

Hi When I run the following update dockets set LogPrice = (select LogPrice from Temp where temp.docketno = dockets.docketno) all of dockets that are not found in the select statement have LogPrice set to Null. This was NOT my intention. What do I have to do so that only those dockets that ar

[DUG]: Temp File Management

Hiya All   Does anyone have a component/code to deal with temp files (creating and cleaning up)   TIA   Regards Neven  

RE: [DUG]: Building formatted strings

M, I don't know of a function offhand, but this should do the trick for you function Pad(const s : string;n : SmallInt) : string; begin result:=s; if n<0 then begin while length(result)mailto:[EMAIL PROTECTED]]On Behalf Of Mark Howard Sent: Wednesday, 31 May 2000 15:11 To: Multiple

RE: [DUG]: Building formatted strings

M, Have a look at the Format() function. Try these out ShowMessage('|' + Format('%-10s', ['123']) + '|'); ShowMessage('|' + Format('%10s', ['123']) + '|'); --Donovan Donovan J. Edye [www.edye.wattle.id.au] Namadgi Syst