Re: SQL Insert

Article View: borland.public.vdbase.data.sql

Article #872

Back to borland.public.vdbase.data.sql Previous Next

#872

From: Christopher F. Neumann
Date: Fri, 19 Jun 1998 00:00

36 lines
1540 bytes

The workaround is:

do while .not. eof()
   store 1 to currecono
   do while currecono < 601
      set database to SQLTEST
      insert into SQLTABLE (sql_field) values(:LOCALTBL->localfield)
      set database to LOCALTEST
      sele LOCALTBL
      skip
      store currecono + 1 to currecono
   enddo
   set database to SQLTEST
   use SQLTABLE in sele()
   sele SQLTABLE
   go top
   go bottom
   use in SQLTABLE
   set database to LOCALTEST
   sele LOCALTBL
enddo

I was getting the error 148 (stack overflow) after 610 records, so I set it
close, but not TOO close.


>hirschv at mindspring dot com (Ken Mayer [TeamB]) wrote in message
><3589b0b3.1893533@forums.borland.com>...
>>"Christopher F. Neumann" <CNeumann@Physix.com> wrote:
>>
>>>What are the OTHER ways of doing an INSERT INTO to a SQL table?
>>
>>Are you just trying to add records from another table? If so, take a
>>look at the updateset() class -- it allows you to do an append from
>>another table ...

Technical Details

Message-ID: <6me169$c1b1@forums.borland.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <6mbu65$aeb2@forums.borland.com> <3589b0b3.1893533@forums.borland.com> <6mdu4r$bdl21@forums.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: ff5a1,583b75e73a73565c
X-Google-Attributes: gidff5a1,public
From: "Christopher F. Neumann" <CNeumann@Physix.com>
Subject: Re: SQL Insert
Date: 1998/06/19
Message-ID: <6me169$c1b1@forums.borland.com>
X-Deja-AN: 364216367
References: <6mbu65$aeb2@forums.borland.com> <3589b0b3.1893533@forums.borland.com> <6mdu4r$bdl21@forums.borland.com>
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Organization: Physix, Inc.
Newsgroups: borland.public.vdbase.data.sql

Reply to Parent Message