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. ChitieaSafeSectors, Inc.1142 S Diamond Bar Blvd # 442Diamond Bar CA 91765-2203
(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.
--
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.
