I'm attempting to update a field in one table but the problem is the string
value I want to use is also a fieldname in the same table. How do I let
DBISAM know I just want the string Insured  rather than the contents of the
field Insured? I thought the quotes would do the trick but it didn't.
DBISAM 3.30

UPDATE CLAIMS SET CLAIMTYPE = "INSURED" WHERE DEUCT >0

Thanks,
Don

Hi Don,

Not sure if you are running in DBSys or code, but, if code use parameters
i.e.

UPDATE CLAIMS SET CLAIMTYPE = ClaimType WHERE DEUCT >0;
ParamByName('pmClainType').AsString = 'INSURED';
ExecSQL;

--
Best regards

Steve

"Don Patrick" <donpatrick@cox.net> wrote in message
news:9FED4D39-2A1C-455E-BF7E-50D829297439@news.elevatesoft.com...
> I'm attempting to update a field in one table but the problem is the
> string
> value I want to use is also a fieldname in the same table. How do I let
> DBISAM know I just want the string Insured  rather than the contents of
> the
> field Insured? I thought the quotes would do the trick but it didn't.
> DBISAM 3.30
>
> UPDATE CLAIMS SET CLAIMTYPE = "INSURED" WHERE DEUCT >0
>
> Thanks,
> Don
>
>

Don,

<< I'm attempting to update a field in one table but the problem is the
string value I want to use is also a fieldname in the same table. How do I
let
DBISAM know I just want the string Insured  rather than the contents of the
field Insured? I thought the quotes would do the trick but it didn't.
DBISAM 3.30 >>

Use a parameter like Steve recommends, or put an extra space at the end of
the constant like this:

UPDATE CLAIMS SET CLAIMTYPE = "INSURED " WHERE DEUCT >0

--
Tim Young
Elevate Software
www.elevatesoft.com