Read Only?

Thread View: borland.public.vdbase.data.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Timo Haavisto Tue, 23 Mar 1999 00:00

#61

Author: Timo Haavisto
Date: Tue, 23 Mar 1999 00:00

14 lines
866 bytes

Hello,

I have built a join of many tables (.dbf) and saved them as sql file.
Then I made a form with the wizard. It looks good, but in every case it
says "table is read-only" or something, when I try to add new record or
edit old ones.

How can I change the table properties so, that it saves the modified
records?

So, what's the solution (if there is)?

Regards,
Timo Haavisto, KTTP CO. LTD.

Re: Read Only?

#62

Author: Gary White [dBVIPS]
Date: Tue, 23 Mar 1999 00:00

26 lines
1273 bytes

On Tue, 23 Mar 1999 20:17:05 +0200, Timo Haavisto wrote:

> I have built a join of many tables (.dbf) and saved them as sql file.
> Then I made a form with the wizard. It looks good, but in every case it
> says "table is read-only" or something, when I try to add new record or
> edit old ones.
> 
> How can I change the table properties so, that it saves the modified
> records?
> 
> So, what's the solution (if there is)?

All SQL generated joins are read-only.  Instead, use the rowset's
MasterRowset, MasterFields, and IndexName properties to join your
tables.


Gary White [dBVIPS]

Some dBASE Stuff at
http://www.AppTools.com/dbase

Please consider moving to
dBASE2000 News Groups at
news://news.dbase2000.com
as soon as possible

Re: Read Only?

#63

Author: Ken Mayer [dBVIPS]
Date: Wed, 24 Mar 1999 00:00

22 lines
1172 bytes

Timo Haavisto <kttp@dlc.com> wrote:

>I have built a join of many tables (.dbf) and saved them as sql file.
>Then I made a form with the wizard. It looks good, but in every case it
>says "table is read-only" or something, when I try to add new record or
>edit old ones.

Joins are *always* read-only. Period. This is a limitation of local
SQL.

Instead, take a look at masterFields and masterRowset (and you may
want to look at the tutorial files at my website as well ...).

Ken
---
Ken Mayer [dBVIPS]
   VdBASE7 Tutorial, HOW TOs, and dUFLP library:
http://www.apptools.com/dbase/kenstuff
   (which is a mirror of:)
http://www.mindspring.com/~hirschv/dbase/dbase.htm

dBASE 2000: http://www.dbase2000.com

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads