RE: Re: [DUG]: Bring an App to the front

2000-11-02 Thread Jason Coley
Thanks for that code, but how do I get the HWND, when I create the Word App by WordApp := CreateOLEObject('Word.Application'); Regards Jason Coley Manawatu Software Solutions http://www.software-solutions.co.nz/ -Original Message- From: Corey Murtagh [mailto:[EMAIL PROTECTED]]

Re: [DUG]: Printing TChart Titles

2000-11-02 Thread Deepak Shenoy
This is kinda undocumented, so I'm not sure if this will continue to work. I don't have the TChart source either, but I found this using the object browser. Use TeePrevi.ChartPreview(OwnerForm,Chart); and include TeePrevi in the uses clause. This is in D5, btw. Deepak Shenoy Agni Software

RE: Re: [DUG]: Bring an App to the front

2000-11-02 Thread Patrick Dunford
try WordApp.Activate -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jason Coley Sent: Thursday, 2 November 2000 23:11 To: Multiple recipients of list delphi Subject: RE: Re: [DUG]: Bring an App to the front Thanks for that code, but how do I

RE: Re: [DUG]: Bring an App to the front

2000-11-02 Thread Cheng Wei
WordApp.Visible := True; WordApp.Activate; Regards Cheng -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jason Coley Sent: Thursday, 2 November 2000 23:11 To: Multiple recipients of list delphi Subject: RE: Re: [DUG]: Bring an App to the front Thanks

[DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Leigh Wanstead
Hello everyone, What is the best way to copy data from one database to another database using ADO? Database backend could be Interbase, MS SQL 7.0 or Oracle. I use the following code from book Mastering Delphi 5 P572 from Marco Cantu. procedure TForm1.Button1Click(Sender: TObject); var I:

Re: [DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Neven MacEwan
Leigh Q 1/ Is this a one off or a synch process 2/ Do you want it to be generic i.e from any of (Interbase, MS SQL 7.0, Oracle) to any of (Interbase, MS SQL 7.0, Oracle) 3/ Are you over-writing or appending - Original Message - From: Leigh Wanstead [EMAIL PROTECTED] To: Multiple

Re: [DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Leigh Wanstead
Dear Neven, 1/ Is this a one off or a synch process One off process 2/ Do you want it to be generic i.e from any of (Interbase, MS SQL 7.0, Oracle) to any of (Interbase, MS SQL 7.0, Oracle) Currently Source Interbase, Destination any of (Interbase, MS SQL 7.0, Oracle) 3/ Are you

Re: [DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Neven MacEwan
Leigh OK then for a One Off I'd not even attempt to do it programmatically For MS SQL the process would be as follows 1/ Create tables in target db with limited constraint (no RI self ref or other) 2/ Use dts to tx data in 3/ script fix ups 4/ establish constraints The only process you could

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Myles Penlington
Why don't you use Interbase 6 (Embedd it in the product), then can use either IBX, IBO, FreeIBPlus to access it. Myles. -Original Message- From: Donovan J. Edye [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 11:58 AM To: Multiple recipients of list delphi Subject: [DUG]: [Q]

Re: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread patrick . dunford
Quoting "Donovan J. Edye" [EMAIL PROTECTED]: G'Day, It is time for us to do the next incarnation of our products and as part of that we are looking to ditch the BDE (/ ADO). Essentially our operating environment is as follows: - Extremely hostile and remote. ie. Applications are running

Re: [DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Leigh Wanstead
Dear Neven, Thank you for your reply. OK then for a One Off I'd not even attempt to do it programmatically I am sorry that I have not made it clear. One off means that user do copy procedure, not developer, and this application is a product offer to our customers. By the way, I tried dts,

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Nic Wise
Donovan, have you considered interbase? (what did anyone else expect me to say!?) It fits almost all of the criteria: - Extremely hostile and remote. ie. Applications are running on machines that are very difficult to access either physically or with remote access. fine. - Machines are

[DUG]: procedures within procedures... and scope...

2000-11-02 Thread Mark Derricutt
'llo, got a wee question on scope and procedures within procedures... Take the following code: procedure TformMain.Delete2Click(Sender: TObject); var cs: TCommaSplitter; sSQL: string; sWhere: string; i: integer; procedure DeleteTestFromTable(sTable, sWhere: string); begin with

Re: [DUG]: procedures within procedures... and scope...

2000-11-02 Thread Aaron Scott-Boddendijk
'llo, got a wee question on scope and procedures within procedures... Now, I'm declaring sWhere in the Delete2Click routine, I was thinking that it would be available to the DeleteTestFromTable() routine but it's not, so I have to pass it in, or is there a way to reference that variable

RE: Re: [DUG]: Bring an App to the front

2000-11-02 Thread Jason Coley
Title: RE: Re: [DUG]: Bring an App to the front Thanks Chen, how long has the Activate procedure been in Word, 95, 97 or 2000? Jason -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Cheng Wei Sent: Friday, 3 November 2000 8:04 a.m. To: Multiple

Re: [DUG]: procedures within procedures... and scope...

2000-11-02 Thread Mark Derricutt
On Fri, 3 Nov 2000, Aaron Scott-Boddendijk wrote: Works here... D4 Update 3 Ok, thats annoying, went for a drink, came back, read this email, looked at my code, did a recompile, and it worked... its friday isn't it? -- "We don't guarantee anything except that it will take up disk space..."

Re: [DUG]: procedures within procedures... and scope...

2000-11-02 Thread Leigh Wanstead
I have to say that this kind of local function require special stack setup for call which can not be optimized by Delphi compiler. I thought that it would be good just declare it as private function, and pass parameters around. - Original Message - From: "Aaron Scott-Boddendijk" [EMAIL

Re: [DUG]: procedures within procedures... and scope...

2000-11-02 Thread Mark Derricutt
On Fri, 3 Nov 2000, Leigh Wanstead wrote: I have to say that this kind of local function require special stack setup for call which can not be optimized by Delphi compiler. I thought that it would be good just declare it as private function, and pass parameters around. Mmm, good point, this

RE: [DUG]: procedures within procedures... and scope...

2000-11-02 Thread David O'Brien
Definately works. Always has in Pascal, thats one of the points (scope). Dave. -Original Message- From: Mark Derricutt [mailto:[EMAIL PROTECTED]] Sent: Friday, 3 November 2000 14:41 To: Multiple recipients of list delphi Subject: [DUG]: procedures within procedures... and scope...

Re: [DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Neven MacEwan
Leigh Blobs are going to be a problem and so is RI (esp self referencing) If you use ADO you can still use the logic I outlined 1/ Drop Target tables if they exist* 2/ Create Target Tables without RI, PK, Triggers or Indexes* 3/ Use ADO (Cantu type algorithm) to copy in data 4/ Create PK's,

Re: [DUG]: procedures within procedures... and scope...

2000-11-02 Thread Neven MacEwan
Mark As an aside There was something on delphi direct about passing strings as Const it being far more efficient. But as a matter of style I use local funcs and procs to stop the main routine suffering indentititus can't be that ineff to call (esp with no param) can it? Wouldn't be surprised if

Re: [DUG]: Best way to copy data from one database to another database using ADO

2000-11-02 Thread Leigh Wanstead
Dear Neven, Thanks. I will try it. Best Regards Leigh - Original Message - From: "Neven MacEwan" [EMAIL PROTECTED] To: "Multiple recipients of list delphi" [EMAIL PROTECTED] Sent: Friday, November 03, 2000 4:41 PM Subject: Re: [DUG]: Best way to copy data from one database to another

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Donovan J. Edye
N, dataaware is a nightmare with C/S databases - avoid it like the plague. IT does work tho, its just not that quick. If you switch from paradox, you _have_ to get out of the locate/findkey/next/prev etc mentality REALLY quickly. Yeah I realise that. We use ADO / SQL2000 for some other

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Nic Wise
N, dataaware is a nightmare with C/S databases - avoid it like the plague. IT does work tho, its just not that quick. If you switch from paradox, you _have_ to get out of the locate/findkey/next/prev etc mentality REALLY quickly. Yeah I realise that. We use ADO / SQL2000 for some

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Mark Derricutt
On Fri, 3 Nov 2000, Nic Wise wrote: well, either way, I'd still avoid it :) there are lots of other, better ways to do it, eg load it all into objects (OR-mapping) or someting like that Whats the best way to map to an object? At the moment I've got a wee class that has properties for

Re: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Steve Peacocke
At 09:58 am 3/11/00 +1100, Donovan J. Edye said: Now having said all of that it appears that DBISAM from ElevateSoft fits the bill exactly. Yes, and from what I have seend and used of this product, it is excellent. There you have it - no installation hassles, robust, easily program auto-fix

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Myles Penlington
We are now using the MIDAS 3 (TclientDataSet) stuff heavily inplace of cached updates etc. It gives us master detail (N levels) etc without a line of code having to be written (Okay so we have a DB aware form that provides the additional required support -works well). Myles. -Original

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Myles Penlington
You can use RTTI to do the mapping, there was on DSP/torries some examples of this (Spider classes??) -Original Message- From: Mark Derricutt [mailto:[EMAIL PROTECTED]] Sent: Friday, November 03, 2000 5:08 PM To: Multiple recipients of list delphi Subject: RE: [DUG]: [Q] Lightweight

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Nic Wise
that would be it currently, unless you wanna do "introspection" (ie, RTTI) and get a list of properties by looking at the class N -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Derricutt Sent: Friday, 3 November 2000 17:08 To: Multiple

Re: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Neven MacEwan
Nick dataaware is a nightmare with C/S databases - avoid it like the plague. IT does work tho, its just not that quick. If you switch from paradox, you _have_ to get out of the locate/findkey/next/prev etc mentality REALLY quickly. I must say that with ADO Client Datasets in BatchUpdate

RE: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Nic Wise
No, but using TTable (or similar) or a lot of master-detail queries makes performance suck, and as most people tend to use them. :) Fair call tho - but it is friday avo. Wh! The Weekend Has Landed! N -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On

Re: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Nello Sestini
Neven said: the trick is to restrict your dataset - "select * from table" just wont cut it I'm following this "data-aware awareness" thread with interest. What's the "restriction" issue here - cutting down the number of rows, or limiting the number of columns? Rows, right? But if

Re: [DUG]: [Q] Lightweight DBMS....

2000-11-02 Thread Nic Wise
But if you're presenting data in a scrolling grid doesn't your underlying query result have to contain all the rows? first rule of C/S: dont use tables. second rule: dont use grids. They are an exceptionally bad UI component with anything but paradox-type things. throw MIDAS in there and it