I see why. sqlquery_delete does not take anything into account except for the
where clause. The join and distinct properties are ignored. I will have to
recode using some other method.
Bob S
> On Nov 28, 2022, at 16:30 , Bob Sneidar via use-livecode
> wrote:
>
> I don't think there is a w
I don't think there is a way to do this with sqlYoga. I tried "...
service.siteid AS siteid1..." and then referring to the columns with their
aliases, but that still does not work.
Bob S
> On Nov 28, 2022, at 16:17 , Bob Sneidar via use-livecode
> wrote:
>
> NVM. Of course, the query is
NVM. Of course, the query is going to rename the second siteid column
for sites to siteid2.
Bob S
> On Nov 28, 2022, at 16:11 , Bob Sneidar via use-livecode
> wrote:
>
> Hi all.
>
> If anyone has any experience in using sqlYoga for joins, I have a curious
> issue. The following code prod
Hi all.
If anyone has any experience in using sqlYoga for joins, I have a curious
issue. The following code produces a variable tFoundOrphans containing a list
of service record IDs with no corresponding siteid in the Sites table, so I
know the query object works. However, when I use sqlquery_d
