Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Re: Problem with "SELECT * INTO" (URGENT)
Thu, Jan 3 2008 7:58 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Ricardo


SELECT INTO essentially deletes and creates a table with the structure of the selected items. If you create the table yourself and simply want to populate it then use INSERT INTO.

Roy Lambert
Fri, Jan 4 2008 4:15 AMPermanent Link

Ricardo Oliveira
Hi Roy,

Thank you for your reply. Problem solved.

Ricardo Oliveira



Roy Lambert wrote:
> Ricardo
>
>
> SELECT INTO essentially deletes and creates a table with the structure of the selected items. If you create the table yourself and simply want to populate it then use INSERT INTO.
>
> Roy Lambert
>
Fri, Feb 8 2008 11:27 AMPermanent Link

Roy Lambert

NLH Associates

Team Elevate Team Elevate

Allan


Looking at the example in the manual the [ and ] need to be ' (a single quote) for the text and " double quote for the field name. If that's not it - waht is the error message?

Roy Lambert
Image