MAS_ prefix in SQLSelect

Discussion of open issues, suggestions and bugs regarding IBDAC (InterBase Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
marcodor
Posts: 29
Joined: Tue 29 Oct 2013 20:30

MAS_ prefix in SQLSelect

Post by marcodor » Wed 03 Jun 2015 13:54

Hello Victor,

I see You added MAS_ functionality to gather parameters from master dataset in detail (by the way, my idea :) )
But it does not work for SQLSelect property, can you add it also here?

Thanks!

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MAS_ prefix in SQLSelect

Post by ViktorV » Fri 05 Jun 2015 12:41

Please clarify, what do you mean by using MAS_ prefixes in the SQLSelect property?

marcodor
Posts: 29
Joined: Tue 29 Oct 2013 20:30

Re: MAS_ prefix in SQLSelect

Post by marcodor » Tue 09 Jun 2015 15:59

for example, we have relations
Master (ID, NAME)
Detail (ID, MASTER_ID, AMOUNT)

In detail, SQL to write:

select ID, MASTER_ID, AMOUNT where MASTER_ID = :MAS_ID

Now it works with just :ID, but this param I use for another purposes, detail, has itself such field name.

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: MAS_ prefix in SQLSelect

Post by ViktorV » Fri 12 Jun 2015 13:24

We can add support for MAS_ prefixes in the SQLSelect property. But parameters will point to the master dataset both with MAS_ prefix and without it. We can't implement the requested functinality, since it will break functioning of other users' projects.

Post Reply