Thread View: borland.public.delphi.database.bdp
3 messages
3 total messages
Started by Ralf Kaiser
Thu, 19 Oct 2006 08:48
BDPDataAdapter and query parameters (D2005, ASP.NET)
Author: Ralf Kaiser
Date: Thu, 19 Oct 2006 08:48
Date: Thu, 19 Oct 2006 08:48
36 lines
2585 bytes
2585 bytes
Hello, i am using a BDPDataAdapter in Delphi 2005 in a ASP.NET application. After configuring the adapter, setting up the queries, creating the dataset the application runs fine. All parameters for the queries are created and initialized inside the method "InitializeComponent" When i close Delphi (or the project) and reload the project later all parameters for the queries in the dataadapter are deleted. The proprety "ParameterCount" in "InsertCommand", "UpdateCommad" and "DeleteCommand" still shows the correct count but when i open the parameter collection editor it is empty! When i look into the method "InitializeComponent" all lines that are initializing the parameter objects are deleted. The project was saved correctly before closing Delphi. It seems that the parameters got deleted while loading the project. Of course running the project in this state results in error messages because of the missing parameters. The only workaround i found so far is to copy all lines that initialize the parameters to an own method and call this method insinde the eventhandler for the Page_Load event. This solution works but i have to remember to copy the lines to the method every time i change something inside the adapters parameters. And that is not good. I am using Delphi 2005 Enterprise with all updates + unofficial FastMM updates. Delphi is running with all personalities activated, Together support has been removed. Does anyone know a solution for that (really anoying) problem? Does it still exist in Delphi 2006? (i have added a QC report some time ago but it seems that this report has never been noticed by Borland) Thanks in advance, Ralf
Re: BDPDataAdapter and query parameters (D2005, ASP.NET)
Author: Bob Swart
Date: Thu, 19 Oct 2006 09:40
Date: Thu, 19 Oct 2006 09:40
26 lines
1997 bytes
1997 bytes
Hi Ralf,
> When i close Delphi (or the project) and reload the project later all
> parameters for the queries in the dataadapter are deleted.
While I've never experienced this problem myself, I've seen it happen on
some of my clients' machines using Delphi 2005. Steve Trefethen was
working on reproducing and fix this for Delphi 2006, and I've not heard
of reports that it still happens in Delphi 2006 (but like I said, I was
never able to reproduce it on my machines using Delphi 2005 in the first
place)...
> (i have added a QC report some time ago but it seems that this report
> has never been noticed by Borland)
Do you have the QC number?
> Ralf
Groetjes,
Bob Swart
--
Bob Swart Training & Consultancy (eBob42.com) Forever Loyal to Delphi
Blog: http://www.drbob42.com/blog - RSS: http://drbob42.com/weblog.xml
New Delphi 2006 Courseware e-books at http://www.eBob42.com/courseware
Re: BDPDataAdapter and query parameters (D2005, ASP.NET)
Author: Ralf Kaiser
Date: Thu, 19 Oct 2006 10:08
Date: Thu, 19 Oct 2006 10:08
18 lines
1586 bytes
1586 bytes
"Bob Swart" <b.swart@chello.nl> schrieb im Newsbeitrag news:45374824.5040304@chello.nl... > > Do you have the QC number? > it was QC#16110. I have added it last year. After that i did not much work with .NET and forgot to check if this report had any echo. Now i returned to a ASP.NET project and found that there is still no workaround or fix for D2005. Do you know any other workaround for D2005? Buying D2006 is currently no option, i have payed for a functional D2005 and will not pay a complete update price just to get an error fixed (try to explain something like this to your boss!!) Ciao, Ralf
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads