[DUG]: ClientDataSet field of type 'Money'?

2003-07-17 Thread Ben none
Hi there I have a clientdataset and am trying to create a field where I can hold dollars in it. eg. $20.00 I normally have a string which is like this 50.00 which I convert to float to use basic aritmetic. Instead of using strings, how can I set up a field which holds money values. Do i use

RE: [DUG]: ClientDataSet field of type 'Money'?

2003-07-17 Thread Traci Sumpter
. To: Multiple recipients of list delphi Subject: [DUG]: ClientDataSet field of type 'Money'? Hi there I have a clientdataset and am trying to create a field where I can hold dollars in it. eg. $20.00 I normally have a string which is like this 50.00 which I convert to float to use basic aritmetic

[DUG]: ClientDataset inserts with MSSQL Identity column problem

2003-07-01 Thread Edwin Das
hi... I have a client dataset / MSSQL Server problem with Identities.. For Example: I have the following table definition CREATE TABLE GROUPTABLE ( SEQNO INTEGER IDENTITY(1,1) PRIMARY KEY, GROUPNAME VARCHAR(30) NULL) Note : This table has a trigger which

Re: [DUG]: ClientDataset inserts with MSSQL Identity column problem

2003-07-01 Thread Craig Goodall
Hi Edwin, Sorry I don't have experience with MSSQL, but in InterBase, you have to have a TDataSetProvider with PropogateChanges set for both a 2 and 3 tier app to have the ClientDataSet refresh with generated PK's etc. HTH, Craig. Edwin Das wrote: hi... I have a client dataset / MSSQL Server

Re: [DUG]: ClientDataset inserts with MSSQL Identity column problem

2003-07-01 Thread Bevan Edwards
, and return the original @@IDENTITY value. Regards, Bevan - Original Message - From: Edwin Das [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 6:57 PM Subject: [DUG]: ClientDataset inserts with MSSQL Identity column problem hi... I

RE: [DUG]: ClientDataset inserts with MSSQL Identity column problem

2003-07-01 Thread Jeremy Coulter
Yeah, I would go with this suggestion too. Jeremy -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bevan Edwards Sent: Tuesday, 1 July 2003 21:11 To: Multiple recipients of list delphi Subject: Re: [DUG]: ClientDataset inserts with MSSQL Identity column

RE: [DUG]: ClientDataset inserts with MSSQL Identity column problem

2003-07-01 Thread Aaron Wood
for me within stored procedures... Aaron From: Jeremy Coulter [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Subject: RE: [DUG]: ClientDataset inserts with MSSQL Identity column problem Date: Tue, 1 Jul 2003 22:26:56 +1200 Yeah, I would go

Re: [DUG]: ClientDataset inserts with MSSQL Identity column problem

2003-07-01 Thread Neven MacEwan
recipients of list delphi [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 6:57 PM Subject: [DUG]: ClientDataset inserts with MSSQL Identity column problem hi... I have a client dataset / MSSQL Server problem with Identities.. For Example: I have the following table definition CREATE TABLE

[DUG]: Clientdataset

2001-04-04 Thread James Sugrue
G'day all, We have an app which sits on top of another Dos app. At the moment there is two sets of data files, the dos apps data files and Our apps data files. The contents of the files are identical, except that the Delphi apps are in Paradox, whereas the Dos apps are a flat file format.

Re: [DUG]: Clientdataset

2001-04-04 Thread Neven MacEwan
[EMAIL PROTECTED] To: Multiple recipients of list delphi [EMAIL PROTECTED] Sent: Thursday, 5 April 2001 14:41 Subject: [DUG]: Clientdataset G'day all, We have an app which sits on top of another Dos app. At the moment there is two sets of data files, the dos apps data files and Our apps data

Re: [DUG]: Clientdataset

2001-04-04 Thread Nello Sestini
Basically I want to eliminate the Paradox files, and just use the flat files. I am considering deriving ClientDataSets to read the flat files and allow our app to stil use DBComponents etc. We don't need to write back to the flat files, just read from them. Are there any sites or articles

RE: [DUG]: Clientdataset

2001-04-04 Thread James Sugrue
I was sort of hoping to get rid of the BDE -Original Message- From: Nello Sestini [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 15:08 To: Multiple recipients of list delphi Subject: Re: [DUG]: Clientdataset Basically I want to eliminate the Paradox files, and just use

Re: [DUG]: Clientdataset

2001-04-04 Thread Nello Sestini
I was sort of hoping to get rid of the BDE understandable. i suppose i should have guessed that as reason you want to get rid of the pdox stuff -ns --- New Zealand Delphi Users group - Delphi List - [EMAIL

RE: [DUG]: Clientdataset

2001-04-04 Thread James Sugrue
recipients of list delphi Subject: Re: [DUG]: Clientdataset James There are prob quite a few 'in memory' datasets you could use I found this article interesting http://www.delphi3000.com/articles/article_1871.asp seemed a relatively simple solution (and could be altered to buffer a single record

Re: [DUG]: Clientdataset

2001-04-04 Thread Neven MacEwan
delphi [EMAIL PROTECTED] Sent: Thursday, 5 April 2001 15:30 Subject: RE: [DUG]: Clientdataset Neven, Looks sort of what I was after. This seems to only deal with Text Files however. The Flat Files are Binary data. Haven't had a major look at it though. Cheers Jim -Original Message

Re: [DUG]: Clientdataset

2001-04-04 Thread Paul Spain
Hi, Graham Pitson gave a presentation to ADUG on implementing a TDataSet descendant. I imagine subclassing TClientDataSet covers most of the same ground: http://www.adug.org.au/PastMeetings/Presentations/GPitsonFeb99/default.htm Graham's MiniBase TDataset derivative: http://www.unleytools.com/

RE: [DUG]: Clientdataset

2001-04-04 Thread James Sugrue
Neven What I was thinking of doing, but didn't know 100% how to go about it. Cheers -Original Message- From: Neven MacEwan [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 15:50 To: Multiple recipients of list delphi Subject: Re: [DUG]: Clientdataset James Well its a little

Re: [DUG]: Clientdataset

2001-04-04 Thread Mark Derricutt
Would not a standard TClientDataset and a TProvider work? Then have the provider retreive the data via your own code to the dataset? --On Thursday, April 05, 2001 1:49 PM +1000 Paul Spain [EMAIL PROTECTED] wrote: Hi, Graham Pitson gave a presentation to ADUG on implementing a TDataSet

RE: [DUG]: Clientdataset

2001-04-04 Thread James Sugrue
recipients of list delphi Subject: Re: [DUG]: Clientdataset Would not a standard TClientDataset and a TProvider work? Then have the provider retreive the data via your own code to the dataset? --On Thursday, April 05, 2001 1:49 PM +1000 Paul Spain [EMAIL PROTECTED] wrote: Hi, Graham Pitson