Re: [DUG]: Copying Chars

2001-01-14 Thread Neven MacEwan
James This may be obvios but why don't you iterate thru the array using chr() to compile your string or use a stream s := '' for i := 10 to 40 do s := s+chr(array[i]); - Original Message - From: James Sugrue [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED]

Re: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Neven MacEwan
Paul Sorry I wasn't quite clear I meant @@Identity ie If the statement fires one or more triggers that perform inserts that generate identity values, calling @@IDENTITY immediately after the statement returns the last identity value generated by the triggers. And as I understand it is only

Re: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Neven MacEwan
Paul But your second point does concern me. Basically you're saying that under stress and with multiple connections, an identity column may return the same value twice. Can you point me to a link that confirms that? I understood they were pretty much bullet proof. Unfortunately not - I

Re: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Neven MacEwan
Stephen think about it last night why do you 1/ Code the 'generator' using a global table with an identity column ie create proc GetID as begin declare @NewID int insert into GenTable (InUse) values ('Y') set @NewID = @@identitiy return @NewID end then call this outside your

Re: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Neven MacEwan
quick way out :( I will continue to mull this over. Thanks for all the input Stephen -Original Message----- From: Neven MacEwan [mailto:[EMAIL PROTECTED]] Sent: Friday, 12 January 2001 9:54 a.m. To: Multiple recipients of list delphi Subject: Re: [DUG]: [DUG-DB]: Unique IDs Steph

Re: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-11 Thread Neven MacEwan
Nic Yes, So you had the cascaded insert problem, I was more worried about connection sharing and not using batches Neven --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website:

Re: [DUG]: ADO

2001-01-10 Thread Neven MacEwan
Stephen Is this using MDAC 2.6 'cause I think its a known bug (there is a fix out for it) or you could go back to 2.5 Neven - Original Message - From: Stephen Bertram [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 11 January 2001 09:56

Re: [DUG]: ADO

2001-01-10 Thread Neven MacEwan
:44 Subject: RE: [DUG]: ADO Thanks Neven Can you point me to where I can find the fix or any other info? Stephen -Original Message- From: Neven MacEwan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 11 January 2001 10:48 a.m. To: Multiple recipients of list delphi Subject: Re: [DUG

Re: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Neven MacEwan
Stephen Code your own 'generator' as a stored proc using a UniqueIdentifier (GUID) datatype and the NEWID() function Neven - Original Message - From: Stephen Bertram [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 11 January 2001 15:31

Re: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Neven MacEwan
Stephen I assume that one of the advantages of NewID() is that it is fast (or should be) So you could use NewID() to generate the ID and then just use the top 4 bytes (these are sequential) in your stored proc (in SQL2000 can a user defined procedure be called as a default?) ie Create Table test

Re: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Neven MacEwan
Re The problem is : Process 1 generates 11 Process 2 generates 12 Process 3 generates 13 Process 1 issues a rollback - ID 11 is now unused Process 4 generates 11 - based on rolledback seed value. Process 5 generates 12 !! Duplicate Process 6 generates 13 !! Duplicate more like

Re: RE: [DUG]: [DUG-DB]: Unique IDs

2001-01-10 Thread Neven MacEwan
Paul The two probs with "identity columns" are a/ They are only unique to a connection and b/ They are only held for the last action (ie if your insert fires a trigger and the trigger insert and idenity) you are stuffed PS Did I note that Gary had posted this discussion to DUG tut tut

Re: [DUG]: MDI

2001-01-09 Thread Neven MacEwan
Matt Rather than trad MDI - I use a panel on the main form with child forms and a tree navigator to make them visible (sort of like outlook) After all who ever wants to Cascade or Tile MDI app Neven - Original Message - From: Matthew Comb [EMAIL PROTECTED] To: Multiple recipients of

Re: [DUG]: Is Delphi dead?

2001-01-07 Thread Neven MacEwan
Nic Re swing - its 100% java - it uses (pretty much) 3 functions of the OS: draw pixel draw line display text This is the main advantage C# will have over Java, M$ will tout it as portable whilst highly targeting it to the Windows Graphics Model, they are never inconvenienced by actually

Re: [DUG]: Is Delphi dead?

2001-01-07 Thread Neven MacEwan
Nic Re C# problem is, it aint portable if you can't _actually_ run it on other platforms. Define Run! - It would be to much of a risk for M$ to make C# Windows Only (would be like arming the DOJ) but you can bet that they will be spending as much effort making .NET run nicely on their

Re: [DUG]: Is Delphi dead?

2001-01-07 Thread Neven MacEwan
Is .Net an application or an operating system? Is a JVM a application or an OS? Consider this the App/OS distinction was easy when all apps and OS were distinct (2 tier so to speak) But in these days where OS are becoming more complex (complete?) it is hard to say - it's an n-tier world out

Re: [DUG]: Is Delphi dead?

2001-01-03 Thread Neven MacEwan
Martin "Are they trying to sucker us to C++ so we miss the VB - C# Stampede?" You probably missed the intended sarcasm in that remark. One of the "features" of C# is platform independence with M$ recent history on this topic (the J++ windowising) would you trust these people. Delphi/Kylix is

Re: [DUG]: Is Delphi dead?

2001-01-03 Thread Neven MacEwan
Max As always a clear head - Delphi is at such a critical mass now that it would probably survive (a la Lazarus?) and it not like your've gone out and tatooed "Borland Rule OK" on your forheads have you? No..but I was considering a Penguin Neven

Re: [DUG]: Is Delphi dead?

2001-01-03 Thread Neven MacEwan
Mark John (also known as Man in Black - serious linux guru - looking over my shoulder) quipped that you have to change the default run level from 5 to 3 (in the /etc/inittab file) HTH Neven - Original Message - From: Mark Derricutt [EMAIL PROTECTED] To: Multiple recipients of list

Re: [DUG]: Lazarus vs Kylix

2001-01-02 Thread Neven MacEwan
Corey I figure it's more likely that they simply ripped the whole VCL source and started changing it to work with their compiler platform. That is, after all, the Linux Way. This is a little cruel, inaccurate and bigoted Neven

Re: [DUG]: Lazarus vs Kylix

2001-01-02 Thread Neven MacEwan
Corey I hope you're not going to accuse me of being a linux hater. No That would be an assumption. However "Open Source" does not mean violate others rights to license their software how they choose. I don't see that simply because the VCL has a partially open source you would rip it off Also

Re: [DUG]: VB Beats Delphi in 'independant' review

2001-01-02 Thread Neven MacEwan
Hi Guys Felt I had to comment on this one (the delay has been due to being offline as my father died on the 19th of Dec) - Why use D4? - Stored Proc debugging? only on MS SQL I assume - ADOExpress evens the database access score - They hammer the BDE even after Borland have said it's "end of

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Willie Three things 1/ My Name is Neven 2/ In my limited circle of developer friends I know of 2 (probably 3 actually - none of which are called Nevan or Nic) that have worked with both and they all prefer IB after their experiences. This is totally heresay, when you have some knowledge

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Sandeep Yes you could use pessimistic locking however I wouldn't suggest it. especially not in the application. As i have said before I you'd be better off accepting that SQL servers are not ISAM's and embrace the changes it will require, not fight them "To the man with a hammer all the world

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Carl I'm enjoying this thread. :-) It was getting a bit quiet there for a while I used to say "an SQL language stands or falls on the strength of it's optimiser". But since Interbase's optimiser is a steaming heap of dung, but I'm confused..what part of IB did you enjoy? :-) I do think

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Cory If you are any way suggesting I'm an braindead M$ sycophant then you Whoa, chill Neven. He was (as he pointed out) stating his opinion of MSSQL, NOT slamming you. Calm down and read the message again. You'll note I did say IF Neven

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Myles (Only your data - we have had about 6 MS SQL7 DB corruptions since starting using MS SQL7 last year ... Thankfully they were only development DB's. Maybe i'm blessed but I've only ever had one (and that was because I hadn't loaded sp1) Neven

Re: [DUG]: Combo Box List Index

2000-12-18 Thread Neven MacEwan
Mark instead of DocEntryDestCB.ItemIndex := DocEntryDestCB.Items.IndexOf(ImpDestCode); for a csDropDown you can DocEntryDestCB.Text := ImpDestCode; a csDropDown doesn't enforce existance of the item - Original Message - From: Mark Howard [EMAIL PROTECTED] To: Multiple recipients of

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Carl isn't postgreSQL *nix only? see http://www.postgresql.org/docs/admin/supported-platforms.htm Neven --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website:

Re: [DUG]: Interbase

2000-12-18 Thread Neven MacEwan
Carl Read the bottom - Original Message - From: Carl Reynolds [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, 19 December 2000 15:29 Subject: RE: [DUG]: Interbase isn't postgreSQL *nix only? see

Re: [DUG]: Interbase

2000-12-17 Thread Neven MacEwan
going to be released on Linux? Probably never -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Neven MacEwan Sent: Saturday, 16 December 2000 17:14 To: Multiple recipients of list delphi Subject: Re: [DUG]

Re: [DUG]: Interbase

2000-12-17 Thread Neven MacEwan
Nic Fun next week getting our first 1Gig Athalon your actually _buying_ one? Personally, I wouldn't bother - you'll be running windows 2000 or nt on it, right? so get a dual CPU machine instead - a dual 700 should outperform a 1gig in _most_ multi-tasking situations, without the ability

Re: [DUG]: Interbase

2000-12-15 Thread Neven MacEwan
Patrick BUT... MS-SQL doesn't support triggers as well as Interbase... You don't think nesting and recursion are good? Or are you just so stuck on the before and after trigger paradigm that anything else is not as good? Lets list a few things interbase can't do 1/ Replication 2/ CASE,

Re: [DUG]: Interbase

2000-12-15 Thread Neven MacEwan
Nic Good to see you working on the weekend - hah well, can you do "proper" cascade deletes? ie, delete from the master table, remove the children automatically? Declaritively not in 6.5 but in 2000 yes - but I use triggers to enforce RI anyway so yes 2/ CASE, COALESCE and NULLIF (also

Re: [DUG]: Interbase

2000-12-15 Thread Neven MacEwan
Mark Last time I tried installed MSDE I -had- to install Access 2000 first, that doesn't seem much of a small footprint to me.. Don't see why? you prob just need MDAC Re PostgreSQL returning a result set I've heard of some sort cludgey solutions (which I'll track down) but I think it is the

Re: [DUG]: Interbase

2000-12-14 Thread Neven MacEwan
Patrick Re Don't rush to learn Postgre, it has a more limited implementation than MySQL (for example, doesn't support INNER JOIN :( The only reason I'm using it is because it's the database that my ISP chose to install. Spit..splutter..cough..choke PostgreSQL may not have full join syntax

Re: [DUG]: Locking Records

2000-12-14 Thread Neven MacEwan
Sandeep You don't, SQL Servers have no exposed concept of a lock If you want the easiest port from an ISAM to SQL I'd recommend you use ADOExpress (tho i've never used it with IB). ADO would give you your filters and locates and then the only change you would have to add would be confict

Re: [DUG]: Locking Records

2000-12-14 Thread Neven MacEwan
Sandeep It is possible to lock a record using FIB TDataset. Table.LockRecord is used to lock a record. When the LockRecord function is called an update query is executed. And what does this 'update query' do? All I was stating was that SQL does not expose the concept of record locking

Re: [DUG]: Interbase

2000-12-14 Thread Neven MacEwan
Pat Maybe true...but both of them seem to be a long way behind Interbase. Interbase is a fine database but way behind Oracle and MS SQL Did I get the impression somewhere that GENERATOR is part of the SQL-92 standard and only Interbase supports it. And I thought the whole SQL-92 standard

Re: [DUG]: Kylix Demo

2000-12-11 Thread Neven MacEwan
Nic (if you're awake) although I was interested in the lack of a bidirectional cursor for the queries - Nic - any chance you could explain what was happening there? I assume dbExpress is designed differently... Could you please elucidate Neven

Re: [DUG]: Component Draging

2000-12-06 Thread Neven MacEwan
Chrissy Also select a group of comps and right click to get the 'Align' menu you can then align to the first item selected (Visio on the other hand aligns to the last item selected - VC) HTH Neven - Original Message - From: Chrissy R [EMAIL PROTECTED] To: Multiple recipients of list

Re: [DUG]: Component Draging

2000-12-06 Thread Neven MacEwan
]: Component Draging That is not what I was talking about - I simply want to see the outline of the component when I drag it and did not what to change every display property until I found the right one. Chrissy. - Original Message - From: Neven MacEwan [EMAIL PROTECTED] To: Multiple

Re: [DUG]: Compile 16bit applications

2000-12-05 Thread Neven MacEwan
Dave We could ignore your posts. I would think we should ignore his posts! This list is dedicated to the ongoing use and development of delphi and support of immoral prirates. Neven --- New Zealand Delphi Users

Re: [DUG]: Compile 16bit applications

2000-12-05 Thread Neven MacEwan
C'mon Nello - we couldn't exclude you (just post a proof of purchase!) Neven - Original Message - From: Nello Sestini [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Wednesday, 6 December 2000 12:56 Subject: Re: [DUG]: Compile 16bit applications

Re: [DUG]: Component Creation 101

2000-11-29 Thread Neven MacEwan
keep using that memory until some other event - if so, when would that be - reboot/shutdown/next Delphi app started ? I'm aware this is not a nice way of doing things, but just wondered the official reason. Cheers, Kurt. Neven MacEwan wrote: Chrissy Just a few basics 1

Re: [DUG]: embedded database.

2000-11-28 Thread Neven MacEwan
Hi guys Had a thought about this I woder if there is a syntax for this TsqlObject = class (TsqlPersistentObject) private MainEntTable: TsqlTable DetailEntTable: TsqlTable relatedby MainEntTable.PK = DetailEntTable.FK public attribute: string read MainEntTable.Column published

Re: [DUG]: Procedure Problem

2000-11-28 Thread Neven MacEwan
Joel nil if you want to - You would normal pass the Instance that the event applied to ie Form3.ListBox1Click(ListBox1) but if you don't make reference to the sender then nil is fine If you use the same proc for several list boxes then you pass the listbox as sender - make sense Neven -

Re: [DUG]: Creating A Class

2000-11-28 Thread Neven MacEwan
Stephen I've normally kept a list of components created on the fly and specifically freed them - maybe I don't need to. Depends on wether you pass and owner to the constructor or not, Some people use Create(nil) in which case you clean up yourself or Create(Form1) in which case the form

[DUG]: Component Creation 101

2000-11-28 Thread Neven MacEwan
Chrissy Just a few basics 1/ In Delphi you almost never have to use pointers and new() is really for non-object use 2/ A TComponent derived class can own other TComponents (which may own other...) See TComponent.Components array TComponent.ComponentCount (simarly TWinControl implement

Re: [DUG]: XML Parser

2000-11-27 Thread Neven MacEwan
Joel For Windows you really can't beat the old ini file format For Linux gnome have a new Config file Library that is worth a look HTH Neven - Original Message - From: Joel van Velden [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Monday, November 27,

Re: [DUG]: embedded database.

2000-11-27 Thread Neven MacEwan
David Re I'm also not sold on triggers. Maybe I've just never seen a good implementation, but in my experience they tend to cause performance problems and are vastly more difficult to debug than stored procedures. One of their biggest benefits is consistency of updates True, Triggers are

Re: [DUG]: embedded database.

2000-11-27 Thread Neven MacEwan
Paul The fact that they operate on the same tables is not in itself an indication that the "wheels have fallen off" - IMHO of course. You'll note that I said 'loose' not 'fall off'! Essentially you are embedding data integrity logic in two places - which opens the door to inconsistency. It

Re: [DUG]: embedded database.

2000-11-27 Thread Neven MacEwan
Paul It is clear I am looking at this from a different perspective to you, and as such these generalisations aren't going to achieve much. I'll therefore leave you to it. Fun tho aint it :-) Neven --- New

Re: [DUG]: embedded database.

2000-11-27 Thread Neven MacEwan
Paul And stored procedures as normal standard methods. I agree. Updating via stored procs (without triggers) is then analagous to writing delphi progs only using RTTI I withdraw the RTTI Comment - I was being too flippant The analogy of SP as methods is quite valid if you abstract out a

Re: [DUG]: embedded database.

2000-11-26 Thread Neven MacEwan
Myles If ADO Supports this (if only for MS SQL and Access) is this part of the ADO Provider Spec (ie could other OLE DB Providers support this) Neven - Original Message - From: Myles Penlington [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Monday, 27

Re: [DUG]: embedded database.

2000-11-26 Thread Neven MacEwan
Re This approach seems to becoming increasingly common and is one which we are also taking. It works very well for updates and allows you to do very nice things (such as update stored procs which update multiple tables, create an audit trail, check the validity of the change, not to mention

Re: [DUG]: Planner component

2000-11-22 Thread Neven MacEwan
Pat TMS TPlanner is cheap $50 USD (if not good) I'm using it now (with DB Enhancement for a Timesheet) However I'd be interested to see what Jeremy Coulter has produced (taunt taunt) Neven - Original Message - From: Pat Sheehan [EMAIL PROTECTED] To: Multiple recipients of list delphi

Re: [DUG]: Is Everyone dead or something ?

2000-11-21 Thread Neven MacEwan
Sandeep If you are saying that the fact that the platform must have the JVM then by your definition 'platform independance' cannot exist. Unless you use the Henry Ford/Microsoft version which is 'it runs on all plarforms as long as they are Windows (TM)' Neven - Original Message -

Re: [DUG]: ADO and Remote Datasets

2000-11-21 Thread Neven MacEwan
Alan Then dont bother using RDSconnection (it is only useful if you want a middle layer) Just use an ADOConnection and a ClientSide dataset HTH Neven - Original Message - From: Alan Rose [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, 21

[DUG]: Offtopic (Sort of)

2000-11-21 Thread Neven MacEwan
Hi All Since the list police seem to be all asleep and lively discussion is the order of the day then give the spec of a clients requirement for a database (sql) app (and ignoring middleware requirements) would you on the client side use 1/ Delphi/Kylix (and limit your target clients to

Re: [DUG]: Is Everyone dead or something ?

2000-11-21 Thread Neven MacEwan
Sandeep You mean to say if I just copy the byte codes to target machine it will know what to do. I'm a little confused what 'byte codes' for which 'target machine' Neven --- New Zealand Delphi Users group -

Re: [DUG]: Is Everyone dead or something ?

2000-11-21 Thread Neven MacEwan
Nic I was confused by Sandeep comments not by the concept of 'Byte Codes' and 'Target Machines' re Java compiles to a virtual CPU (call it JCPU) - Delphi compiles to a real one (intel IA32). Not quite correct Java compiles to a Virtual Machine, Delphi compiles to an Intel CPU and a series

Re: Re: [DUG]: ADO and Remote Datasets

2000-11-21 Thread Neven MacEwan
So do you want to 'pass thru' the middle tier in this case? Its prob not a problem with ADOExpress per se what you prob need to do is access properties of the ResordSet directly I'll do some research and get back Neven - Original Message - From: [EMAIL PROTECTED] To: Multiple

Re: [DUG]: Offtopic (Sort of)

2000-11-21 Thread Neven MacEwan
Nic What does the app do?! GUI Database App ie a booking system etc I'd not touch 2 with a 50 foot barge pole. Now this is interesting the 'Java Man' bagging Java Can you eludidate as to why? Neven --- New

Re: [DUG]: Is Everyone dead or something ?

2000-11-21 Thread Neven MacEwan
Nic Nope, Delphi compiles to a set of Intel CPU byte codes. The windows API has _nothing_ to do it with, except for the format of the EXE and the occasional JMP or CALL statement to strange and far off places. you lost the argument when you said 'except' though you could have got me by

Re: [DUG]: Offtopic (Sort of)

2000-11-21 Thread Neven MacEwan
Nic Thanks for that, based on this maybe I should thow in another option 4/ Kylix frontend running on a Gnome Desktop on Linux App Server x-client using VNC xserver and VNC clients has the following 1/ Portable to any client that VNC Supports 2/ Client is Thin (less than 1mb) 3/ Less noisy

Re: [DUG]: Offtopic (Sort of)

2000-11-21 Thread Neven MacEwan
Nic Or a standard Delphi app running on NT Terminal Server. Same result. And I think they have a Linux client (there is a Java one, anyway), and ICA does ones for most other platforms. Difference is that Terminal Services is a kludge, x isn't 3/ Less noisy than X Lower Bandwidth

Re: [DUG]: Is Everyone dead or something ?

2000-11-21 Thread Neven MacEwan
Sandeep And it is not to be forgotten that VB was designed by same person who designed Delphi. Huh? To say VB was 'designed' is a stretch. Poor Mr Wurth I hope he is dead rather than hear this Neven --- New Zealand

Re: [DUG]: Passing the Time

2000-11-20 Thread Neven MacEwan
Bevan Interbase or ADO (I won't use ADO simply 'cos it's M$). Good to see a bit of late afternoon bigotry Interbase is prob a good choice when it brings out replication (though that wont be free) MS SQL Supports 'merge replication' though it is not free either but they are probably the best

Re: [DUG]: Passing the Time

2000-11-20 Thread Neven MacEwan
ADO's data shaping is LOTS of fun. Had aplay when it first came out (even did some training with it). Its nice, and worth a look, IMO - tho I think you need MSSQL 7 to get it... Don't think so (tho I was wrong once.14th Feb 1974) Think is ships with MDAC and is prob in 2000 (Someone can

Re: [DUG]: Problems with CloneCursor

2000-11-20 Thread Neven MacEwan
Dave Is this and ADO ClientDataSet? If so there is an informal fix out for this - the closing the cloned record/dataset caused the original to close BTW this is how TADODataset implements 'locate' HTH Neven - Original Message - From: David Brennan [EMAIL PROTECTED] To: Multiple

[DUG]: Re: So do you usually surcome to temptation this easily?

2000-11-20 Thread Neven MacEwan
Chrissy I'll accept a bit of humour - but flirtatious behaviour is out (unless it's directed at me!) Neven - Original Message - From: Chrissy [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, 21 November 2000 16:51 Subject: Re: [DUG]: Is Everyone

Re: [DUG]: Problems with CloneCursor

2000-11-20 Thread Neven MacEwan
Myles Almost makes ADO attractive. I was hoping that the new D6 (DBExpress) was going to be the panacea Neven - Original Message - From: Myles Penlington [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, 21 November 2000 17:23 Subject: RE:

Re: [DUG]: Problems with CloneCursor

2000-11-20 Thread Neven MacEwan
Myles I will be more thoughtful about my ADO Gripes! try this for a Editable/Live dataset SELECT a.TMTimeSheetEntryID, a.Notes, a.HRStaffID, a.JSJobID, a.ARAccountID, a.TMOverheadID, a.Started, a.Finished, a.Chargeable, a.Booking, COALESCE(b.Name, c.Description, d.WorkRequested) as

Re: [DUG]: [Q] ADO / MDAC 2.6 / SQL7 Strangeness....

2000-11-19 Thread Neven MacEwan
Myles I understand the mechanisms - I just don't understand why the it says it is 'finished' (probably even fires an event to say as such) and the object appears to continue changing asynchronously is it (choose from the list) 1/ M$ Crap Coding 2/ M$ Crap Specification 3/ M$ Crap Documentation

Re: [DUG]: [Q] ADO / MDAC 2.6 / SQL7 Strangeness....

2000-11-17 Thread Neven MacEwan
D, I some times think with ADO (and COM for that matter) in VCL type wrappers there are strange timing issues. I have a db panel component that builds its editor on Active LayoutChanged and Close then Open of the ADODataSet caused all sorts of strange behaviour (like TFields transmogrifying mid

Re: [DUG]: incredible and horrible. (the Code)

2000-11-13 Thread Neven MacEwan
Juan This should be constructor TSpIterator.Create(InitCount: Integer); begin inherited Create; if ( InitCount 0 ) then try Reset(InitCount); except on E: EOutOfMemory do MessageDlg(E.Message, mtError, [mbOk], 0); end end; (not sure of the effect of

Re: [DUG]: Web Stuff

2000-11-12 Thread Neven MacEwan
Sandeep What Web Server? - For NT Delphi is prob as good as anything But if it's relatively simple have you considered PHP, Also look at ZOPE HTH Neven - Original Message - From: Sandeep [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Monday, 13

Re: [DUG]: Object Construction

2000-11-06 Thread Neven MacEwan
Tony Yes - you can overload constructors - I use it all the time - Look at TObjectList Creates and initializes a TObjectList. constructor Create; overload; constructor Create(AOwnsObjects: Boolean); overload; Description Create creates a TObjectList instance. If no parameter is specified, or

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

2000-11-05 Thread Neven MacEwan
Nello Firstly Tables are braindread - In fact in ADO a Table type command simply inserts 'select * from' in front of the table name. They have no place in an SQL based CS solution - they were an archaism perpetuated for those diehard ISAM programmers, Use exclusively TQuery type components

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 Neven MacEwan
- From: "Neven MacEwan" [EMAIL PROTECTED] To: "Multiple recipients of list delphi" [EMAIL PROTECTED] Sent: Friday, November 03, 2000 9:57 AM Subject: Re: [DUG]: Best way to copy data from one database to another database using ADO Leigh Q 1/ Is this a one off or a s

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]: [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]: Timeout Expired

2000-11-01 Thread Neven MacEwan
Moises I think from memory the TADOQuery component hides CommandTimeout so you have to use TADODataSet. If you look at the imp of a TADOQuery all it really does is change the property CommandText to SQL HTH - Original Message - From: Moises Lopez [EMAIL PROTECTED] To: Multiple

Re: [DUG]: Previous record in dataset...

2000-11-01 Thread Neven MacEwan
Mark Any clues? (database, connection method etc) Neven - Original Message - From: Mark Derricutt [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 2 November 2000 14:11 Subject: [DUG]: Previous record in dataset... Hiya, is there anyone to

Re: [DUG]: Previous record in dataset...

2000-11-01 Thread Neven MacEwan
recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 2 November 2000 14:50 Subject: Re: [DUG]: Previous record in dataset... On Thu, 2 Nov 2000, Neven MacEwan wrote: Any clues? (database, connection method etc) Ewps, was hoping for a generic dataset method :P Its a memory table from

Re: [DUG]: Access to Standard Input in a non console app

2000-10-29 Thread Neven MacEwan
recipients of list delphi [EMAIL PROTECTED] Sent: Sunday, 29 October 2000 18:23 Subject: Re: [DUG]: Access to Standard Input in a non console app Neven MacEwan wrote: Cory Found two interesting functions -- AllocConsole and FreeConsole on Delphi3000 http://www.delphi3000.com/article.asp?id=568

Re: [DUG]: Access to Standard Input in a non console app

2000-10-26 Thread Neven MacEwan
PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 26 October 2000 19:13 Subject: Re: [DUG]: Access to Standard Input in a non console app Neven MacEwan wrote: Nello Thanks - but why can't a graphical app take standard input? It's the way windows works. Under

Re: [DUG]: Access to Standard Input in a non console app

2000-10-25 Thread Neven MacEwan
security issues related to this - for example the console app could be running on a different box under different authentication blah blah blah ... If you're interested and can't find it give a shout back and i'll see if i can find it again. -ns -Original Message- From: Neven MacEwan

Re: [DUG]: Outlook Address Book

2000-10-25 Thread Neven MacEwan
From: Patrick Dunford [EMAIL PROTECTED] Do you mean address book or contacts in outlook Both ideally Neven --- New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED] Website:

Re: [DUG]: Rebooting a computer in Pascal

2000-10-24 Thread Neven MacEwan
J, I've lost my msdos progrmmers manual but there was a BDOS call which did a soft boot have a look around the archives we found a boot.exe which rebooted (an more) Hey do you remember cpm where the fist thing you did was make a zero length executable called @.com? Loading @ put you back in

[DUG]: Outlook Address Book

2000-10-24 Thread Neven MacEwan
Hi all Does anyone have any example code on how to get access to the outlook/express address book? TIA Regards Neven N.K. MacEwan B.E. EE Ph 649 574 0027 Fax 649 570 2706 "A truth denied the light of action will wither to a promise, propaganda and then a lie"

Re: [DUG]: Rebooting a computer in Pascal

2000-10-24 Thread Neven MacEwan
J I remember now - the prog we found booted the pc at a predetermined time A quick net-trawl could save you re-inventing the wheel Neven - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 26 October 2000 02:58 Subject:

[DUG]: Access to Standard Input in a non console app

2000-10-24 Thread Neven MacEwan
Hi All Is there any way that a graphical app can read standard input? I want to write an app write uses redmon to direct Postsciprt output to a fax server (on linux) TIA Regards Neven N.K. MacEwan B.E. EE Ph 649 574 0027 Fax 649 570 2706 "A truth denied the light of action will wither to a

Re: [DUG]: Last Active Control on a form

2000-10-23 Thread Neven MacEwan
Nello My project started as modal forms and therefore 'embedding' them seemed to be the way to go I've played with frames as well and am wary of porting the whole project to frames after Alans comments (Also I read a 'subtext' that frames were there for reusability and tho they support

Re: [DUG]: Last Active Control on a form

2000-10-23 Thread Neven MacEwan
change. Hope this helps. Cheers. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Neven MacEwan Sent: Friday, October 20, 2000 5:11 PM To: Multiple recipients of list delphi Subject: Re: [DUG]: Last Active Control on a form Nello I prob should have

[DUG]: Last Active Control on a form

2000-10-19 Thread Neven MacEwan
Hi all I'm trying to save the last focused control on a form so when I reactivate it This control has focus Can anyone gove me a pointer? TIA Regards Neven N.K. MacEwan B.E. EE Ph 649 574 0027 Fax 649 570 2706 "A truth denied the light of action will wither to a promise, propaganda and then

Re: [DUG]: Last Active Control on a form

2000-10-19 Thread Neven MacEwan
JED Tried that but the form is not being deactivated it is only moving down in the Z-Order Thanks Neven - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Friday, 20 October 2000 14:48 Subject: Re: [DUG]: Last Active Control on a

<    1   2   3   4   5   6   7   8   9   10   >