PSGetTableName BUG

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
Frenk

PSGetTableName BUG

Post by Frenk » Thu 01 Jun 2006 15:29

if i declare UpdatingTable inside TMSQuery, then PSGetTableName must return this property value.
I have a standard version (without sources) so please fix and update this bug ASAP (this is a critical bug and is a showstopper for one of our clients).
Regards,
Frenk

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Fri 02 Jun 2006 10:02

TCustomMSDataSet.PSGetTableName doesn't return value if Dataset was never opened.
Please describe situation in which it is necessary.

Frenk

Post by Frenk » Sun 04 Jun 2006 19:12

when you have an option "ResolveToDataset" = False in dataset provider and you are about to update record, dataset is not opened.
There are even more complex sql-s where TMSQuery doesn't found correct table (eg. select * from (select itemID, ItemDesc from Items where ...) as A union All select ...). So what I was trying to do was that I specified "UpdatingTable" to help selecting correct table. What I expected was that TMSQuery should return this property value (if it is entered) to a resolver. Is there any reason for that?

Jackson
Posts: 512
Joined: Thu 26 Jan 2006 10:06

Post by Jackson » Mon 05 Jun 2006 06:37

This functionality will be added in the next SDAC build.

Post Reply