Nicky. A matter of failure to rename PROJECTed computed columns.
Some time back I took to the practice of appending '_calc' to computed
columns. Never fails to alert. Today, working with a table which
predates the practice.
Great wakeup call.
Best, Bruce
------ 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/em6e132e8e-881b-4393-b778-2a82c9993412%402d1fcea1.com.
