Thanks Nicky.
No computed columns, but it's very likely a named column within the temp
table has been defined elsewhere. I'll go hunt.
As for that second example, I'll alert RBTI re: examples within
R:SYNTAX.
Very Best, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
------ Original Message ------
From "'Nicky Avery' via RBASE-L" <[email protected]>
To [email protected]
Date 3/23/2025 1:46:57 PM
Subject Re: [RBASE-L] - ALTER TABLE for TEMP tables
Hi Bruce,
The second example will fail as you have not indicated what whatTheHey
is. The first example should work but are you sure you have
successfully created your temp tab e.g. do you need to redefine or
rename computed columns or something similar?
Nicky
On 3/23/2025 1:20 PM, Bruce Chitiea wrote:
All:
Will the ALTER TABLE ADD columnName command work on TEMP tables?
These commands fail:
ALTER TABLE targetTable_tt ADD COLUMN whatTheHey TEXT (1)
ALTER TABLE targetTable_tt ADD whatTheHey TEXT (1)
Column whatTheHey is not a Foreign Key column, which would be expected
to fail.
??
Thanks, Bruce
Bruce A. Chitiea
SafeSectors, Inc.
1142 S Diamond Bar Blvd # 442
Diamond Bar CA 91765-2203
[email protected]
(909) 238-9012 m
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/emd299724f-645c-4c41-b29d-aaddb8d95fdf%402d1fcea1.com
<https://groups.google.com/d/msgid/rbase-l/emd299724f-645c-4c41-b29d-aaddb8d95fdf%402d1fcea1.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google
Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send
an email to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/04e87a96-64f8-44d3-a2d3-27e0ee3d6773%40wwavs.com
<https://groups.google.com/d/msgid/rbase-l/04e87a96-64f8-44d3-a2d3-27e0ee3d6773%40wwavs.com?utm_medium=email&utm_source=footer>.
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups "RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion visit
https://groups.google.com/d/msgid/rbase-l/emd261e842-92a7-40a3-85e3-ace85d6b7cc1%402d1fcea1.com.
