I want to build an app that can talk toany
SQL DB dependant on driver availability. My initial thought is
touseADO as this can link to any OLEDB orODBC driver.
(1) Would ADO be the best option?
Assuming ADO is the best option. In design
mode when creating a connection string a wizard
of list delphi [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 12:46 PM
Subject: Re: [DUG]: ADO
[EMAIL PROTECTED] wrote on 23/07/2003 10:38:54 AM:
(1) Would ADO be the best option?
Is your only target platform windows?
Assuming ADO is the best option. In design mode when creating
[EMAIL PROTECTED] wrote on 23/07/2003 10:38:54 AM:
(1) Would ADO be the best option?
Is your only target platform windows?
Assuming ADO is the best option. In design mode when creating a
connection string a wizard appears that allows simple creation of
the string based on the
The function is sConnectionStr := PromptDataSource (0,
sDefaultConnectionStr);
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Robert martin
Sent: Wednesday, 23 July 2003 12:58 p.m.
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO
Thanks JED
.
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO
Thanks JED.
Is your only target platform windows?
Yes, primary platform is Windows, but we had thought we may
be able to access the DB on a Linux server (mySQL, Postrgress
etc) with appropriate drivers?
Can't
Thanks Tracy
Rob Martin
Software Engineer
phone 03 377 0495
fax 03 377 0496
web www.chreos.com
- Original Message -
From: Traci Sumpter [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 1:05 PM
Subject: RE: [DUG]: ADO
delphi [EMAIL PROTECTED]
Sent: Wednesday, July 23, 2003 12:46 PM
Subject: Re: [DUG]: ADO
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
.
To: Multiple recipients of list delphi
Subject: [DUG]: ADO funny
Hi All
A strange occurrence which I am unable to explain, but I feel that I have
seen before. This is with Delphi 5 and SQL Server 2000.
We have a thread which updates a SQL Server database via a stored procedure
when monitored
Hi All
A strange occurrence which I am unable to explain, but I feel that I have seen before.
This is with Delphi 5 and SQL Server 2000.
We have a thread which updates a SQL Server database via a stored procedure when
monitored data in the application is changed or added. The thread
Have you applied the ADO Update 2 from Borland to your Delphi 5?
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Behalf Of Stephen Bertram
Sent: Wednesday, 28 May 2003 8:53 a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: ADO funny
Hi All
A strange
Definitely - you don't get far without it :-)
Stephen
-Original Message-
From: David at McNeill Computers [mailto:[EMAIL PROTECTED]
Sent: Wednesday, 28 May 2003 11:39 a.m.
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO funny
Have you applied the ADO Update 2 from
Title: ADO components (D5)
A zillion years ago when I purchased D5 Pro it came sans ADO components. I would now like to test some of my code (which theoretically will run against most DB backends) against ADO.
Does anyone know of where/ how I can get hold of the standard Delphi(5) ADO
Hi all.
I have been getting some strange problems reported to me by users of my
app.
I am trying to figure out if its somethig I have wrong with my ADO
connection or if its something else.
Basically 98% of the time, the app. functions normally, but every now
and then, it seems to drop the
Hi All
I've just discovered that SQL Server allows stored procedures to return multiple
result sets, as in
CREATE PROC Multi AS
SELECT * FROM Debtors
SELECT * FROM Creditors
Return 0
GO
In a quick test with D5 the 2nd result set is ignored - all I can see is Debtors. Has
this been catered
recipients of list delphi
Subject: [DUG]: ADO and SQL Server Multiple result sets
Hi All
I've just discovered that SQL Server allows stored procedures to return
multiple result sets, as in
CREATE PROC Multi AS
SELECT * FROM Debtors
SELECT * FROM Creditors
Return 0
GO
In a quick test with D5
Thanks Myles - yes, it is in D5 - didn't spot it.
Bob
From: Myles Penlington [EMAIL PROTECTED]
Date: 2003/02/28 Fri AM 11:14:26 GMT+13:00
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Subject: RE: [DUG]: ADO and SQL Server Multiple result sets
Use (This is in D6 - don't know
Hi all
I know I have seen this before and fixed it, but I can't remember how. This is
connecting to Ingres via ODBC with a TADOConnection. The failure is on a simple select
statement.
Error message : The requested operation cannot be performed with active queries
There are no current
To: Multiple recipients of list delphi
Sent: Wednesday, 21 August 2002
12:24
Subject: [DUG]: ADO MSSQL7
ANSI_PADDING
Hi all
Slightly off topic but does anyone know how to
set ANSI_PADDING OFF
using ADOExpress (connecting via the OLEDB
Driver)
I've got it out
Hi all
Slightly off topic but does anyone know how to set
ANSI_PADDING OFF
using ADOExpress (connecting via the OLEDB
Driver)
I've got it out of the tables but seem to still
have trailing spaces coming back
TIA
Regards NevenN.K. MacEwan B.E.
EEPh 649 621 0001Fax 649 621 0400[EMAIL
I was just reorganizing some of my database routines yesterday and I noticed
that after my 'improvements', there was a phenomenal increase in SQL Server
activity.
As now I understand it (maybe), if you have a TADOQuery with a connection,
then every time you programmatically change the SQL
EndUpdate;
end;
hth
Neven
- Original Message -
From: Chris Reynolds [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, November 01, 2001 10:11 AM
Subject: [DUG]: ADO-SQL Server metadata frenzy
I was just reorganizing some of my database routines
a.m.
To: Multiple recipients of list delphi
Subject: [DUG]: ADO-SQL Server metadata frenzy
I was just reorganizing some of my database routines yesterday and I noticed
that after my 'improvements', there was a phenomenal increase in SQL Server
activity.
As now I understand it (maybe), if you have
Hi All,
Two of our students have experienced problems with ADO datasets connected to
Access tables on their home P.C.s, but not here on the college computers.
The data and source code are identical in both locations.
The problem: if an attempt is made to close the dataset while the cursor is
Osborn
Sent: Wednesday, 12 September 2001 15:06
To: Multiple recipients of list delphi
Subject: [DUG]: ADO Datasets
Hi All,
Two of our students have experienced problems with ADO datasets connected to
Access tables on their home P.C.s, but not here on the college computers.
The data and source
Bob,
Two of our students have experienced problems with ADO
datasets connected to Access tables on their home P.C.s,
but not here on the college computers.
The data and source code are identical in both locations.
You might want to check the ADO version is the same on both machines.
(One
When my application starts, it connects to MS SQL2000 server, does some job
and then disconnects from the server.
Application stays connected to DB anyway somehow. It can be seen using
sp_who stored procedure.
Here is an example.
Application has a single form with TADOConnection on it and
What about ADO/ODBC connection pooling holding the connection open for a
period of time?
-Original Message-
From: Alex Kouznetsov [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 22 August 2001 3:24 p.m.
To: Multiple recipients of list delphi
Subject: [DUG]: ADO Connection does not seem
way to force an immidiate disconnection ?
Thanks
Alex
- Original Message -
From: Myles Penlington [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, August 22, 2001 1:26 PM
Subject: RE: [DUG]: ADO Connection does not seem to disconnect
What about
I might be just right !
Of course it is Myles who is right, not me. Typing mistake.
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub,
I'm working with ADO via the 2.6 Type Library that I imported into Delphi,
and have the following code to call a stored proc, but its not working :(
It returns with Procedure 'tp_next_tdcontrol' expects parameter '@entity',
which was not supplied, does anyone know what I'm doing wrong?
var
Mark
Why not
Cmd.CommandText := 'exec tp_next_tdcontrol ''Worktrans'', 0';
- Original Message -
From: Mark Derricutt [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Friday, 27 July 2001 15:11
Subject: [DUG]: ADO TLB and Stored Procs...
I'm working
Hiya, mmm, that works for executing, but its not returning the outward
parameter to the parameters collection.
I was wanting to use the CreateParameter method cause as its easier in some
places where I want to use date params, or params that change depending on
code (mainly avoiding resetting
hi there..
does any one know what files are modified when
installing the ADO Express Update Pack 2?
sometimes i keep getting the BOF EOF error
and i have to reinstall the pack once again
oh , i already checked that i didnt have empty
datasets, because i only reinstall the update ,
recompile
G'Day All,
I want to figure out the amount of data sent between my application and a
SQL2K database using ADO. The query analyser gives the following:
Network Statistics
Number of server roundtrips 1 1
Number of TDS packets sent1 1
Number of TDS packets received2
: Wednesday, 13 June 2001 7:47 PM
To: Multiple recipients of list delphi
Subject: [DUG]: ADO components and SQL 2K
Hi all.
I just went to use the ADO components in Delphi 5 with SQL 2K server,
and got an OLE error when I tried to connect.
I am ruunin gth update for MDAC 2.6 or whatever
delphi
Subject: RE: [DUG]: ADO components and SQL 2K
Jeremy,
You should also be aware of the following when upgrading to MDAC 2.6
Q279760 in Microsoft knowledge base re fixing MDAC 2.6 error message
returns
Regards
Stuart Wheeldon
-Original Message-
From: [EMAIL PROTECTED] [mailto
To: Multiple recipients of list delphi
Subject: [DUG]: ADO components and SQL 2K
Hi all.
I just went to use the ADO components in Delphi 5 with SQL 2K
server, and got an OLE error when I tried to connect.
I am ruunin gth update for MDAC 2.6 or whatever that is on
the Borland website
Hi all.
I just went to use the ADO components in Delphi 5 with SQL 2K server, and got an OLE
error when I tried to connect.
I am ruunin gth update for MDAC 2.6 or whatever that is on the Borland website, but
still no luck.
The error is OLE Error 80040E37
Has anyone seen this problem ? is
PROTECTED]]
Sent: Wednesday, 13 June 2001 10:13
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO components and SQL 2K
hmm...thats weiredI am LOOKING at the table I am doing the Query
onmight be an access right thing then...
Thanks, Jeremy Coulter
-Original Message
hi guys..
i'm using ADO 2.5 in MS SQL Server 7.0 (MIDAS on D5
Enterprise), and i'm experiencing quite a few problems
regarding performance, it just seems too slow.
i've seen a few post every now and then regarding the
issue..
any one has any tips?
TIA
Moises Lopez
Moises
Make sure you are using static/client datasets (work like a BDE cached
dataset)
HTH
Neven
- Original Message -
From: Moises Lopez [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, 17 May 2001 14:06
Subject: [DUG]: ADO Performance
hi
I am struggling to get ADO working with WIN2000/SQL2000 Client and MSSQL7.0
server. The problem surfaces mainly accessing stored procedures returning
more than 1 row.
Can anyone point me to any good papers on using the ADO components
effectively and any known problems?
Nice to have DUG back
Amazon.com maybe
better.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Stephen Bertram
Sent: Thursday, January 25, 2001 9:32 AM
To: Multiple recipients of list delphi
Subject: [DUG]: ADO woes
I am struggling to get ADO working with WIN2000/SQL2
I'm new to ADO and have a quick question.
When I open an ADOQuery and navigate through the result set till eof is true
I cannot close the ADOQuery - it returns the error:
"Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a current record"
If not
Subject: [DUG]: ADO
I'm new to ADO and have a quick question.
When I open an ADOQuery and navigate through the result set till eof is
true
I cannot close the ADOQuery - it returns the error:
"Either BOF or EOF is True, or the current record has been deleted.
Requested operation requires a cu
: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
November 2000 19:05
Subject: [DUG]: ADO and Remote Datasets
I am currently looking at ADO as an alternative to Midas. Ive seen the D5
demo (RDS) where via an RDSconnection they have hooked an ADODataset to a
recordset property on a RemoteServer. However Id like to be able to send
a
dynamic query
3 Tier is what I'm after. Just like in the RDS demo. ADO Express components dont seem
to offer the functionality I'm after in 3-Tier (that is without making your own
modifications). I wondering if D6 will be bring more functionality to the ADO suite?
For now it seems Midas is still my best
recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, 22 November 2000 12:58
Subject: Re: Re: [DUG]: ADO and Remote Datasets
3 Tier is what I'm after. Just like in the RDS demo. ADO Express
components dont seem to offer the functionality I'm after in 3-Tier (that is
without making your own
cEwan" [EMAIL PROTECTED]
Date: 2000/11/22 Wed PM 01:06:14 GMT+12:00
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Subject: Re: Re: [DUG]: ADO and Remote Datasets
So do you want to 'pass thru' the middle tier in this case?
Its prob not a problem with ADOExpress per se what you
I am currently looking at ADO as an alternative to Midas. Ive seen the D5
demo (RDS) where via an RDSconnection they have hooked an ADODataset to a
recordset property on a RemoteServer. However Id like to be able to send a
dynamic query to my server, which then executes my query and returns the
Hello everyone,
How to programicaly retrive ADO version installed on a computer?
Thanks in advance.
Best Regards
Leigh
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website:
: Leigh Wanstead [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, November 01, 2000 2:30 PM
To: Multiple recipients of list delphi
Subject: [DUG]: ADO VERSION
Hello everyone,
How to programicaly retrive ADO version installed on a computer?
Thanks in advance.
Best Regards
Leigh
iple recipients of list delphi" [EMAIL PROTECTED]
Sent: Wednesday, November 01, 2000 2:31 PM
Subject: RE: [DUG]: ADO VERSION
What are you actually trying to do?
Don't know if you can do that (get the version), but if you require say
ADO2.5, then attempt to create a ADO2.5 object and if
;
end;
regards
Chris
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Leigh Wanstead
Sent: Wednesday, 1 November 2000 14:30
To: Multiple recipients of list delphi
Subject: [DUG]: ADO VERSION
Hello everyone,
How to programicaly retrive ADO version
of list delphi
Subject: Re: [DUG]: ADO VERSION
Dear Myles,
Thank you for your quick response.
What are you actually trying to do?
Show to end user what ADO version installed on his computer.
Is that good enough?
No, not good enough.
Leigh
- Original Message -
From: "Myles Penli
Dear Chris,
Thanks. It works great.
Best Regards
Leigh
- Original Message -
From: "Chris Wallis" [EMAIL PROTECTED]
To: "Multiple recipients of list delphi" [EMAIL PROTECTED]
Sent: Wednesday, November 01, 2000 2:40 PM
Subject: RE: [DUG]: ADO VERSION
Try this Leigh
: "Myles Penlington" [EMAIL PROTECTED]
To: "Multiple recipients of list delphi" [EMAIL PROTECTED]
Sent: Wednesday, November 01, 2000 2:47 PM
Subject: RE: [DUG]: ADO VERSION
TADOConnection supports a Version property which according to the help
Indicates the version of ADO used
to be adequate and we have found it to be stable enough.
Using MTS and ADO we have found a lot of performance gains over the BDE.
From: "Neven MacEwan" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Subject: [DUG]: ADO and Interbase
Date: M
-
From: Peter G Jones [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Wednesday, 20 September 2000 20:15
Subject: Re: [DUG]: ADO and Interbase
The Intersolv driver works ok - there are some minor problems with long
varchar fields that we have experienced.
I
Hi All
Just a quick query - has anyone traid ADO/RDO with IB (via ODBC)
Regards Neven
N.K. MacEwan B.E. EE
Ph 649 574 0027
Fax 649 570 2706
Mobile 025 749 062
[EMAIL PROTECTED]
[EMAIL PROTECTED]
---
New Zealand Delphi
G'Day All,
I have a developer with the following problem:
His Env:
NT4 WKS SP5
Delphi 5.0 Enterprisewith Patch #1
MDAC 2.50.4403.12
SQL7 Desktop Edition SP2
Order of installation (In case that broke MDAC in some way)
- D5
- D5 Patch
- M$'s MDAC 2.50.4403.12
Hi All
In the ADO Docs there is a 'dynamic' record set property called 'Update
Criteria' which is provided by the
Cursor engine - I just don't seem to have it in the Properties Collection
ADOQuery.RecordSet.Proprties['Update Criteria'].Value
Anyone else have this problem?
It is useful because
Can that
Something else was setting the cursorType to Keyset which disabled the
cursor engine - Duh
Neven
- Original Message -
From: Neven MacEwan [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Tuesday, 1 August 2000 11:29
Subject: [DUG]: ADO 'Update
Has anyone seen this?
http://msdn.microsoft.com/vstudio/nextgen/technology/adoplus.asp
The interesting bit is that in Visual Studio you can now programmatically
treat Tables as "objects".
instead of :
IF TotalCost Table("Customer").Column("AvailableCredit")
you can now write it as :
IF
: 021.676.418
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Wilfred Verkley
Sent: Tuesday, 18 July 2000 11:59
To: Multiple recipients of list delphi
Subject: [DUG]: ADO+
Has anyone seen this?
http://msdn.microsoft.com/vstudio/nextgen/technology
G'Day All,
I have a class(TObject) which has a private variable which is declared as:
private
FDataSet : TADOQuery;
The class uses that variable to retrieve / maintain information from a SQL
Server database. When the class is created I instantiate FDataSet and use it
to retrieve some info
[EMAIL PROTECTED]
Sent: Monday, June 12, 2000 5:46 PM
Subject: [DUG]: ADO COnnections.
Anybody know the solution to this.
Open TADOConnection do stuff Close the connection.
Then when attempt to re-open the connection. It all goes to '#%#^ Keep
getting "Invalid variant oper
ersist Security Info=Yes" does not help
either - This was using SQL server logins not NT logins.
Myles.
-Original Message-
From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
Sent: Monday, June 12, 2000 7:48 PM
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO C
Anybody know the solution to this.
Open TADOConnection do stuff Close the connection.
Then when attempt to re-open the connection. It all goes to '#%#^ Keep
getting "Invalid variant operation". In the TADOConnection.Open method.
Any ideas anybody?
Regards,
Myles Penlington
Software Engineer
For your info --- Anybody else had this problem??
Just found a rather nasty bug in the ADO stuff when setting parameters, or
attempting to use ftWideString type parameters.
Your parameter may in fact think it is a ftFixedChar instead, so it may
cause OLE Exceptions to be thrown.
Caused by the
When recordset objects go out of scope does Delphi clean them up? Is there
an advantage to explicitly setting RS objects to nil as done in VB?
---
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
lexi Sayle
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Blackie, Nikolai
Sent: Friday, 5 May 2000 15:04
To: Multiple recipients of list delphi
Subject: [DUG]: ADO recordset = nil
When recordset objects go out of scope does Delphi cle
Thanks Dennis. Is this stuff written down anywhere? I wasn't aware of the
implementation... the documentation hardly goes into much detail on the
'how'.
Cheers,
Terry
Terry,
I hope you realise that cached updates requires BDE (because it stores the
cached data in Paradox files). That being
:52
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO Cached Updates
Where do I find TClientDataSet? I only have Professional D5, and I don't
think its included...
Is it available like ADOExpress? Or, the bigger question, is the
Professional version of Delphi 5 just a teaser to make
Thanks Dennis. More stuff I didn't know about the BDE... is it written down
anywhere?
Terry
Terry,
I hope you realise that cached updates requires BDE (because it stores the
cached data in Paradox files). That being the case, why not just stick to
BDE / ODBC to get to SQL server? IMHO, ADO
will be driven by a drawing engine. It must be Friday.
Regards,
Dennis.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
Behalf Of Terry Johnson
Sent: Thursday, 6 April 2000 20:18
To: Multiple recipients of list delphi
Subject: RE: [DUG]: ADO Cached Updates
This is all irrelevant now, because I heard that BDE in the
next version of
Delphi will be driven by a drawing engine. It must be Friday.
Er - what?
I thought the BDE was going the way of the Dodo only basic maintenance was
going to be done?
Where do I find TClientDataSet? I only have Professional D5, and I don't
think its included...
Is it available like ADOExpress? Or, the bigger question, is the
Professional version of Delphi 5 just a teaser to make you get the
Enterprise version?
Terry
Pass on ADO, but the TClientDataSet works
Terry,
I hope you realise that cached updates requires BDE (because it stores the
cached data in Paradox files). That being the case, why not just stick to
BDE / ODBC to get to SQL server? IMHO, ADO is only useful if you can
eliminate BDE from your install. If you use it in addition to BDE,
Does anybody know of problems with SQL7 fields dealing with BINARY,
VARBINARY or TIMESTAMP datatypes.
I am trying to pass these to a STORED PROC adn to get data back from an ADO
STORED PROC, but alas no luck.
The data comes back NULL from the select statement. This is in D5.01 C/S.
The SQL
Myles
Which Provider are you using
Regards Neven
N.K. MacEwan B.E. EE
[EMAIL PROTECTED]
- Original Message -
From: Myles Penlington [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, 6 April 2000 14:52
Subject: [DUG]: ADO Bugs?
Does anybody
')
.
end
- Original Message -
From: Myles Penlington [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, 6 April 2000 16:14
Subject: RE: [DUG]: ADO Bugs?
It's okay now. I have fixed it - it was my bug in the end.
I am using SQLOLEDB.
Also
al Message-
From: Neven MacEwan [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, 6 April 2000 17:26
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO Bugs?
Myles
TDateTime is only accurate to a millisecond what do you mean rounded
BTW is there a better way of just getting the
To: Multiple recipients of list delphi
Subject: Re: [DUG]: ADO Bugs?
Myles
TDateTime is only accurate to a millisecond what do you mean rounded
BTW is there a better way of just getting the date part of a
DateTime than
create proc ReportOnDate @Date DateTime
as
begin
declare
Dennis
2 function calls and a type change so no prize..I'll keep it in mind tho
Thanks
Neven
- Original Message -
From: Dennis Chuah [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Sent: Thursday, 6 April 2000 17:13
Subject: RE: [DUG]: ADO Bugs?
Use
Pass on ADO, but the TClientDataSet works very well and does the equivalent
job better.
Myles.
-Original Message-
From: Terry Johnson [SMTP:[EMAIL PROTECTED]]
Sent: Wednesday, 5 April 2000 09:49
To: Multiple recipients of list delphi
Subject: [DUG]: ADO Cached Updates
Quick question, I've noticed I'm getting "Invalid Page Fault" errors on my
app when its run on Win95+DCOM1.3+MDAC2.5.
Has anyone had anything like this before? The only thing I can think of
that may be causing it that I'm manually calling CoInitialize and
CoUninitialize in one of my datamodules
[EMAIL PROTECTED]
Sent: Friday, 25 February 2000 10:53
Subject: [DUG]: ADO and Errors
Hiya All
I'm using ADOExpress, D5 and MS SQL7 and when I
have an error posting (i.e. trying to set a non null field) all I get is
'Errors Occurred' from ADOExpress
(with the a TQuery I get full text
Heya I'm trying to make a subclass for TADOConnection to add some
automated functionality I want and have come accross something confusing:
I have defined:
TRegADOConnection = class(TADOConnection)
private
procedure SetConnectionString(const Value: WideString); override;
They virtual in the base class?
-Original Message-
From: Mark Derricutt [mailto:[EMAIL PROTECTED]]
Sent: Friday, 18 February 2000 17:01
To: Multiple recipients of list delphi
Subject: [DUG]: ADO and Class strangeness...
Heya I'm trying to make a subclass for TADOConnection
chickens, and, and worst, will he not
disappoint the ladies in the village? --Alexi Sayle
- Original Message -
From: "Mark Derricutt" [EMAIL PROTECTED]
To: "Multiple recipients of list delphi" [EMAIL PROTECTED]
Sent: Friday, February 18, 2000 5:00 PM
Subject:
G'Day,
Just trying to get a handle on what is required when using the above and
what has to be installed on the client machine.
ADO : Has to have drivers installed (Essentially another form of BDE ala M$
style)
IBX : What is required to be installed client side??
delphi" [EMAIL PROTECTED]
Sent: Tuesday, February 01, 2000 1:50 PM
Subject: [DUG]: ADO IBX installation issues.
G'Day,
Just trying to get a handle on what is required when using the above and
what has to be installed on the client machine.
ADO : Has to have drivers installed (Esse
Actually, where I am right now, we have someone specializing
in using ADO,
and this person has been spending more than 12 hours so far trying to
install ADO (without installing Delphi!) onto a Clients
machine. Right now
he is looking pretty pissed with ADO! Personally I have tried it for
Actually, where I am right now, we have someone specializing
ADO snippage
certainly not thinner if using client side cursors.
Hmmm ... doesn't sound like a very thin solution to me
OK, fine - it may not fit your definition of "thin" (I'll give mine later,
which are just as 'valid'
OK, fine - it may not fit your definition of "thin" (I'll
give mine later,
which are just as 'valid' (or not :) ) as yours), but IMO,
and HTML front
end does not come even close to fitting the definition of
RAD, which for me
would be much more important.
RAD, like thin, has many
Better still, have an HTML specialist design you web pages, and have a
programmer do the program. I have seem many applications that work fine,
but have very poor UI - classic case of one designed by programmers. Its
hard to find good programmers who are also good UI designers, and vice
RAD, like thin, has many definitions. For mine (which may or may not
qualify as yours), if a customer comes in and says, I would like you to
use
"ZYX" font which is standard in out 100K person organisation, for HTML, it
is just a simple matter of adding a line, basefont. If different
is really a
bit over the top.
Just my thoughts...
Tony.
-Original Message-
From: Dennis Chuah [EMAIL PROTECTED]
To: Multiple recipients of list delphi [EMAIL PROTECTED]
Date: Wednesday, 26 January 2000 8:40 AM
Subject: RE: [DUG]: ADO access
Terry,
BDE SQL Links to SQL Server is basically
1 - 100 of 159 matches
Mail list logo