How about exporting to DBF as a workaround? You won't affect the size of the db that way.
----- Original Message -----
From: SureData
Sent: Friday, October 04, 2002 7:38 PM
Subject: Re: PROJECT TEMP

Removed McAffee antivirus and firewall-- same results.
 
Reinstalled R:Base --  same results
 
The strangest thing is that projecting to a permanent table or creating temporary tables presents no problem.  The only thing that I cannot do (message is "Syntax incorrect for this command") is projecting to a temporary table.  The syntax is definitely correct.
 
It is Windows XP Professional.  Works without problem at all under Windows 98.  Could some users of Windows XP Professional share their findings?  Badly need to project to temp tables for a project.  Have been projecting to permanent tables for now.
 
Thanks.
 
Stan Loo
 
 
 
----- Original Message -----
Sent: Friday, October 04, 2002 2:36 PM
Subject: Re: PROJECT TEMP

try using all  instead of using *
Is * your wild char  or %
 
Bernie Lis
----- Original Message -----
From: SureData
Sent: Friday, October 04, 2002 2:10 PM
Subject: PROJECT TEMP

When I attempted to project to a temporary table in Windows XP, R:Base gave me this error message: "Syntax is incorrect for this command (2045)".  The syntax is the basic one: PROJECT TEMPORARY TempTable FROM TableName USING *
 
Works fine under Windows 98.
 
BTW, creating temporary tables in Windows XP is not a problem.  RBW 6.5++.
 
Any idea why?
 
TIA.
 
Stan Loo
 
 

Reply via email to