cannot edit sql query

[petrovlis]

I have to make manual corrections in my Sql Goldmine 7
SQL data base. (Sqlexpress)
I made in Access/2007 an EXTERNAL connection to the Sql database and I have now a query giving the
various tables and fields I need for that operation
I need to EDIT/correct the Contsupp of Goldmine database,but I cannot make any editing/corrections in that column.

How to do this??

Thanks
William

 

[lespaul]

you mean you want to edit the values of a field returned in the query? You'll need to create an UPDATE query for that...

UPDATE TableName SET FieldName = "SomeValue" WHERE SomeCondition

alternatively you could link the tables and work through a table view.

Leslie

Have you met Hardy Heron?

 

[PHV]

I have now a query giving the
various tables and fields I need
Have a look here:

http://support.microsoft.com/kb/148581

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886