Bruce, glad I knew something.
Your idea of a suffix is a good one. Thanks!
On 3/23/2025 2:38 PM, Bruce Chitiea
wrote:
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]>Date 3/23/2025 1:46:57 PMSubject 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. 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.
--
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.
--
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/601c83cd-8e2d-456c-8028-c3e4b622dde9%40wwavs.com.
