entering data in sql vew

dominatrix1 · 4 Dec 2007 at 14:34

WHEN YOU ENTER DATA IN SQL VIEW WHERE TO YOU ENTER IT??
sorry about caps

SiriusB · 4 Dec 2007 at 15:55

As far as I understand them, you can't insert values into a view. They are the result of one or more tables combined.

RockLobster · 4 Dec 2007 at 16:19

I think he means in Access, you can but you need to use Insert statements.

SiriusB · 4 Dec 2007 at 17:00

Ahh, my bad. Only familiar with MySQL.

I shall avoid posting in this thread

dominatrix1 · 5 Dec 2007 at 13:38

in what line do ou insert the the statemants, in a new query??

Haircut · 5 Dec 2007 at 14:54

If you want to enter data in SQL view you would write a SQL INSERT statement and run that as a query.

dominatrix1 · 5 Dec 2007 at 15:37

ok i can enter one piece of data but what do i do if i want to add another piece on the row below?

Haircut · 5 Dec 2007 at 16:25

AFAIK you can only enter one statement at a time in SQL view, so you're limited to adding one row at a time.

Why do you actually want to do this anyway?