Spell out TEMPORARY ?
'Cept you've probably used TEMP successfully elsewhere.
Then it might be the underscore as a SQL single-character wildcard.
Doug
On 8/4/2020 10:06 PM, Bruce Chitiea wrote:
Can anyone shed light on why this literal code:
*PROJECT TEMP TABLE humpty_tt FROM humpty USING ALL WHERE LIMIT=0*
... is throwing this error message:
*Syntax is incorrect for the command PROJECT (2045)*
The "Humpty" table is itself faithfully PROJECTed from a production
table for test purposes. Note that temp table "humpty_tt" does not
exist prior.
RGBX5E latest.
Thanks, Bruce
--
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 rbase-l+unsubscr...@googlegroups.com
<mailto:rbase-l+unsubscr...@googlegroups.com>.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/em8626974d-1363-4201-b917-a1b260362a33%40pathfinder
<https://groups.google.com/d/msgid/rbase-l/em8626974d-1363-4201-b917-a1b260362a33%40pathfinder?utm_medium=email&utm_source=footer>.
--
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus
--
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 rbase-l+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/rbase-l/40f9dc83-2a3f-59ba-03f8-06b78fd6025a%40wi.rr.com.