Subject Re: CANT UNDERSTAND ERROR MESSAGE
From Mustansir Ghor <mustan31@hotmail.com>
Date Sun, 11 Mar 2018 15:23:54 -0400
Newsgroups dbase.getting-started

Dear Akshat

Thanks you.

It means read /write conditions are for ADO Connections. I had started with ADO readings but at moment my focus is on a project that I need to transform  DOS application to Window application. So here if I dont use database object will it be ok?

Best Regards
Mustansir



Akshat Kapoor Wrote:

> On 11/03/2018 18:15, Mustansir Ghor wrote:
> > Dear Mervyn
> >
> > I did not have another query pointing to same table. Further I had used this joined query in command window, and in browse mode I was able to update the filed.
> >
> > Best Regards
> > Mustansir
>
> In such situations I would add another simple query (select * from table
> ) to the form giving you access to the table which needs to be updated.
> You can refer to table x using n different queries if you so desire. All
> n queries can have same/different sql.
>
> sql = 'SELECT rapid.key_st, rapid.company, rapid.item , rapid.descrip ,
> inve.company,inve.item , inve.descrip  FROM "rapid" LEFT JOIN inve ON
> (rapid.company=inve.Company AND rapid.item=inve.item AND
> rapid.descrip=inve.descrip) order by rapid.key_st'
>
> The above query cannot be edited so I had to add another query
> sql = 'SELECT * FROM "rapid"'
> to the form so that I could make changes to table rapid
>
> You will have to navigate to the required record and this query being a
> simple query can be edited using beginedit().
> After save() you can requery() your main query
>
>
> If in the near future you are intending to move to ado I would recommend
> that you follow Mervyn's suggestion. So when you switch to ADO changes
> required will be small.
>
> Regards
> Akshat