hi, 

got problem with query tool

my table calls company and has following fieldnames

CoyID=identifier PK varchar

CoyName= name of the company varchar

CoyEmailMAster= email for master to login, varchar

Password= password to log in varchar

status: the status wether teh company is enabled to login  boolean

when i run the following code no rows are affected:

Update company

set CoyId='ameel'

as the table is empty it is no problem to do this without a "where" clause

CoyID and Coyname cannot be empty

when i execute the code, the code runs but no rows are affected..

anyone any idea what is going on?

eric