Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

insert into ??/

2 posts in Clipper Last posting was on 2007-04-13 14:53:54.0Z
Paulo Posted on 2007-04-13 12:03:30.0Z
Reply-To: "Paulo" <pauloinfoserve@hotmail.com>
From: "Paulo" <pauloinfoserve@hotmail.com>
Newsgroups: advantage.clipper
Subject: insert into ??/
Date: Fri, 13 Apr 2007 09:03:30 -0300
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 201.25.172.227
Message-ID: <461f7080@solutions.advantagedatabase.com>
X-Trace: 13 Apr 2007 05:58:56 -0700, 201.25.172.227
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!201.25.172.227
Xref: solutions.advantagedatabase.com Advantage.Clipper:4193
Article PK: 1106877

Hi

Does anybody has any, hint for execute correct the code above.......

cInsert := "INSERT INTO fil210
(cliente,data,saldo,vendedor,classific,ativo,ult_compra,ult_pagto) "+;
"select
fil150.cliente,fil120.encerra+"+alltrim(str(contador,3))+",fil150.total_db-fil150.total_cr-fil150.credito,fil150.vendedor,fil150.classific,fil150.ativo,fil150.ult_compra,fil150.ult_pagto
from fil150,fil120 where fil150.total_db-fil150.total_cr-fil150.credito <>
0"

adsexecutesqldirect(cInsert )


Thanks


Lance Schmidt Posted on 2007-04-13 14:53:54.0Z
From: "Lance Schmidt" <LanceSc@ExtendSys.com>
Newsgroups: advantage.clipper
References: <461f7080@solutions.advantagedatabase.com>
Subject: Re: insert into ??/
Date: Fri, 13 Apr 2007 08:53:54 -0600
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3028
X-RFC2646: Format=Flowed; Response
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3028
NNTP-Posting-Host: 10.24.38.197
Message-ID: <461f986f@solutions.advantagedatabase.com>
X-Trace: 13 Apr 2007 08:49:19 -0700, 10.24.38.197
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.38.197
Xref: solutions.advantagedatabase.com Advantage.Clipper:4195
Article PK: 1106878

Hello,

What is the error code you are getting?

Best Regards,

Lance Schmidt
Advantage R&D

"Paulo" <pauloinfoserve@hotmail.com> wrote in message
news:461f7080@solutions.advantagedatabase.com...
> Hi
>
> Does anybody has any, hint for execute correct the code
> above.......
>
> cInsert := "INSERT INTO fil210
> (cliente,data,saldo,vendedor,classific,ativo,ult_compra,ult_pagto) "+;
> "select
> fil150.cliente,fil120.encerra+"+alltrim(str(contador,3))+",fil150.total_db-fil150.total_cr-fil150.credito,fil150.vendedor,fil150.classific,fil150.ativo,fil150.ult_compra,fil150.ult_pagto
> from fil150,fil120 where fil150.total_db-fil150.total_cr-fil150.credito <>
> 0"
>
> adsexecutesqldirect(cInsert )
>
>
> Thanks
>