🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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)
#134
Author: Ralf Kaiser
Date: Thu, 19 Oct 2006 08:48
36 lines
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)
#135
Author: Bob Swart
Date: Thu, 19 Oct 2006 09:40
26 lines
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)
#136
Author: Ralf Kaiser
Date: Thu, 19 Oct 2006 10:08
18 lines
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