Page 1 of 1

PSGetTableName BUG

Posted: Thu 01 Jun 2006 15:29
by Frenk
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

Posted: Fri 02 Jun 2006 10:02
by Jackson
TCustomMSDataSet.PSGetTableName doesn't return value if Dataset was never opened.
Please describe situation in which it is necessary.

Posted: Sun 04 Jun 2006 19:12
by Frenk
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?

Posted: Mon 05 Jun 2006 06:37
by Jackson
This functionality will be added in the next SDAC build.