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.

V8.10.0.18 Fix 36

4 posts in Networking Last posting was on 2008-03-07 22:01:19.0Z
Ricardo Rodriguez Erdmenger Posted on 2008-03-01 06:48:46.0Z
From: "Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com>
Newsgroups: Advantage.Networking
Subject: V8.10.0.18 Fix 36
Date: Sat, 1 Mar 2008 00:48:46 -0600
Lines: 151
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
NNTP-Posting-Host: 189.138.252.138
Message-ID: <47c8faf1@solutions.advantagedatabase.com>
X-Trace: 29 Feb 2008 23:42:57 -0700, 189.138.252.138
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!189.138.252.138
Xref: solutions.advantagedatabase.com Advantage.Networking:745
Article PK: 1132163

Tested in ADS NT.

When I tested this same query in the NLM version sent an error refering to
the size of a numeric field. (Version 8 - older)

36. Fixed an issue that caused the "SELECT ... INTO ... " type of SQL
statement to fail when the client is older than 8.1 and the source
table has DBF numeric field.

Is not working properly.

I ran a query, creates the File m_vtatot

This file can be opened and used in ARC.

NOT in Clipper. (Data Corruption)
/*
Consumos de Ensambles
(Inverso del Archivo)
Positivo es Consumo
Negativo Desensamble
*/
Select 'E' as TOper,a.Sucursal,a.Producto,
Year(a.Fecha) as Year,
Week(a.Fecha) as Week,
Sum(a.Cantidad*-1) as Units,
Sum(a.Cantidad*-1*b.Costo_Prom) as CosTotal,
Count(a.Producto) as NOpers
Into #SumVtas
from m_ensa a
Inner join m_prod b On a.Producto = b.producto
Where b.Kit <> 'S' and
/*
a.Fecha >= :Fecha_Ini and
a.Fecha <= :Fecha_Fin
*/
Year(a.Fecha)*100+Week(a.Fecha) >= :YearN_Ini and
Year(a.Fecha)*100+Week(a.Fecha) <= :YearN_Fin
Group By
2,3,4,5;

/*
Genera la Tabla de Actualizacion
prod-exp-loc-d
*/
Select a.Sucursal,a.Toper,a.Producto,a.Year,
a.Week,Sum(a.Units) as Units,
Sum(a.CosTotal) as CosTotal,
Sum(a.NOpers) as NOpersT
Into m_VtaTot
from #Sumvtas a
Inner Join m_prod b
On a.Producto = b.Producto
Where
b.Inventario = 'S'
Group By
1,2,3,4,5;


Edgar Sherman Posted on 2008-03-03 15:50:21.0Z
From: "Edgar Sherman" <no@email.com>
Newsgroups: Advantage.Networking
References: <47c8faf1@solutions.advantagedatabase.com>
Subject: Re: V8.10.0.18 Fix 36
Date: Mon, 3 Mar 2008 08:50:21 -0700
Lines: 20
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=response
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
NNTP-Posting-Host: 10.24.34.133
Message-ID: <47cc1cec@solutions.advantagedatabase.com>
X-Trace: 3 Mar 2008 08:44:44 -0700, 10.24.34.133
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.133
Xref: solutions.advantagedatabase.com Advantage.Networking:746
Article PK: 1132166

Ricardo,

I don't believe that the "fix" for 36 and your problem are related. The
issue is that there are 3 fields that are of type INTEGER. If I remember
correctly a clipper application is unable to open a DBF with Integer or any
of the "Extended DBF Data Types".

Week(), Year() and Count() all return integer types.

Try converting Week, Year and NoPerst to SQL_NUMERIC in your SQL statement.
I believe this should work. (Not tested)

Select a.Sucursal,a.Toper,a.Producto,
convert(a.Year, SQL_NUMERIC),
convert(a.Week, SQL_NUMERIC),
Sum(a.Units) as Units,
Sum(a.CosTotal) as CosTotal,
convert(Sum(a.NOpers), SQL_NUMERIC) as NOpersT
Into m_VtaTot
from #Sumvtas a
Inner Join m_prod b
On a.Producto = b.Producto
Where
b.Inventario = 'S'
Group By
1,2,3,4,5;


Edgar

"Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com> wrote in message
news:47c8faf1@solutions.advantagedatabase.com...
> Tested in ADS NT.
>
> When I tested this same query in the NLM version sent an error refering to
> the size of a numeric field. (Version 8 - older)
>
> 36. Fixed an issue that caused the "SELECT ... INTO ... " type of SQL
> statement to fail when the client is older than 8.1 and the source
> table has DBF numeric field.
>
> Is not working properly.
>
> I ran a query, creates the File m_vtatot
>
> This file can be opened and used in ARC.
>
> NOT in Clipper. (Data Corruption)
> /*
> Consumos de Ensambles
> (Inverso del Archivo)
> Positivo es Consumo
> Negativo Desensamble
> */
> Select 'E' as TOper,a.Sucursal,a.Producto,
> Year(a.Fecha) as Year,
> Week(a.Fecha) as Week,
> Sum(a.Cantidad*-1) as Units,
> Sum(a.Cantidad*-1*b.Costo_Prom) as CosTotal,
> Count(a.Producto) as NOpers
> Into #SumVtas
> from m_ensa a
> Inner join m_prod b On a.Producto = b.producto
> Where b.Kit <> 'S' and
> /*
> a.Fecha >= :Fecha_Ini and
> a.Fecha <= :Fecha_Fin
> */
> Year(a.Fecha)*100+Week(a.Fecha) >= :YearN_Ini and
> Year(a.Fecha)*100+Week(a.Fecha) <= :YearN_Fin
> Group By
> 2,3,4,5;
>
> /*
> Genera la Tabla de Actualizacion
> prod-exp-loc-d
> */
> Select a.Sucursal,a.Toper,a.Producto,a.Year,
> a.Week,Sum(a.Units) as Units,
> Sum(a.CosTotal) as CosTotal,
> Sum(a.NOpers) as NOpersT
> Into m_VtaTot
> from #Sumvtas a
> Inner Join m_prod b
> On a.Producto = b.Producto
> Where
> b.Inventario = 'S'
> Group By
> 1,2,3,4,5;
>
>
>
>
>
>
>


Ricardo Rodriguez Erdmenger Posted on 2008-03-06 03:48:47.0Z
From: "Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com>
Newsgroups: Advantage.Networking
References: <47c8faf1@solutions.advantagedatabase.com> <47cc1cec@solutions.advantagedatabase.com>
Subject: Re: V8.10.0.18 Fix 36
Date: Wed, 5 Mar 2008 21:48:47 -0600
Lines: 110
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.3138
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198
X-RFC2646: Format=Flowed; Response
NNTP-Posting-Host: 200.62.48.202
Message-ID: <47cf687b@solutions.advantagedatabase.com>
X-Trace: 5 Mar 2008 20:43:55 -0700, 200.62.48.202
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!200.62.48.202
Xref: solutions.advantagedatabase.com Advantage.Networking:747
Article PK: 1132165

Edgar,

I ran the same queries in a version 7.x, and it is working properly.

Only when I run this on a ADS 8.X I can recreate the data corruption.





"Edgar Sherman" <no@email.com> escribi? en el mensaje
news:47cc1cec@solutions.advantagedatabase.com...

> Ricardo,
>
> I don't believe that the "fix" for 36 and your problem are related. The
> issue is that there are 3 fields that are of type INTEGER. If I remember
> correctly a clipper application is unable to open a DBF with Integer or
> any of the "Extended DBF Data Types".
>
> Week(), Year() and Count() all return integer types.
>
> Try converting Week, Year and NoPerst to SQL_NUMERIC in your SQL
> statement. I believe this should work. (Not tested)
>
> Select a.Sucursal,a.Toper,a.Producto,
> convert(a.Year, SQL_NUMERIC),
> convert(a.Week, SQL_NUMERIC),
> Sum(a.Units) as Units,
> Sum(a.CosTotal) as CosTotal,
> convert(Sum(a.NOpers), SQL_NUMERIC) as NOpersT
> Into m_VtaTot
> from #Sumvtas a
> Inner Join m_prod b
> On a.Producto = b.Producto
> Where
> b.Inventario = 'S'
> Group By
> 1,2,3,4,5;
>
>
> Edgar
>
> "Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com> wrote in message
> news:47c8faf1@solutions.advantagedatabase.com...
>> Tested in ADS NT.
>>
>> When I tested this same query in the NLM version sent an error refering
>> to the size of a numeric field. (Version 8 - older)
>>
>> 36. Fixed an issue that caused the "SELECT ... INTO ... " type of SQL
>> statement to fail when the client is older than 8.1 and the source
>> table has DBF numeric field.
>>
>> Is not working properly.
>>
>> I ran a query, creates the File m_vtatot
>>
>> This file can be opened and used in ARC.
>>
>> NOT in Clipper. (Data Corruption)
>> /*
>> Consumos de Ensambles
>> (Inverso del Archivo)
>> Positivo es Consumo
>> Negativo Desensamble
>> */
>> Select 'E' as TOper,a.Sucursal,a.Producto,
>> Year(a.Fecha) as Year,
>> Week(a.Fecha) as Week,
>> Sum(a.Cantidad*-1) as Units,
>> Sum(a.Cantidad*-1*b.Costo_Prom) as CosTotal,
>> Count(a.Producto) as NOpers
>> Into #SumVtas
>> from m_ensa a
>> Inner join m_prod b On a.Producto = b.producto
>> Where b.Kit <> 'S' and
>> /*
>> a.Fecha >= :Fecha_Ini and
>> a.Fecha <= :Fecha_Fin
>> */
>> Year(a.Fecha)*100+Week(a.Fecha) >= :YearN_Ini and
>> Year(a.Fecha)*100+Week(a.Fecha) <= :YearN_Fin
>> Group By
>> 2,3,4,5;
>>
>> /*
>> Genera la Tabla de Actualizacion
>> prod-exp-loc-d
>> */
>> Select a.Sucursal,a.Toper,a.Producto,a.Year,
>> a.Week,Sum(a.Units) as Units,
>> Sum(a.CosTotal) as CosTotal,
>> Sum(a.NOpers) as NOpersT
>> Into m_VtaTot
>> from #Sumvtas a
>> Inner Join m_prod b
>> On a.Producto = b.Producto
>> Where
>> b.Inventario = 'S'
>> Group By
>> 1,2,3,4,5;
>>
>>
>>
>>
>>
>>
>>


Edgar Sherman Posted on 2008-03-07 22:01:19.0Z
From: "Edgar Sherman" <no@email.com>
Newsgroups: Advantage.Networking
References: <47c8faf1@solutions.advantagedatabase.com> <47cc1cec@solutions.advantagedatabase.com> <47cf687b@solutions.advantagedatabase.com>
Subject: Re: V8.10.0.18 Fix 36
Date: Fri, 7 Mar 2008 15:01:19 -0700
Lines: 38
MIME-Version: 1.0
Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=response
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-MSMail-Priority: Normal
Importance: Normal
X-Newsreader: Microsoft Windows Live Mail 12.0.1606
X-MimeOLE: Produced By Microsoft MimeOLE V12.0.1606
NNTP-Posting-Host: 10.24.34.133
Message-ID: <47d1b9df@solutions.advantagedatabase.com>
X-Trace: 7 Mar 2008 14:55:43 -0700, 10.24.34.133
Path: solutions.advantagedatabase.com!solutions.advantagedatabase.com!10.24.34.133
Xref: solutions.advantagedatabase.com Advantage.Networking:748
Article PK: 1132167

Ricardo,

Can you compare the columns from the table created in 7.x with the table
created with 8.1?

What table type are you using in 7.1 ARC vs. the Table Type in 8.1 ARC?
Perhaps this is the difference.

Edgar

"Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com> wrote in message
news:47cf687b@solutions.advantagedatabase.com...
> Edgar,
>
> I ran the same queries in a version 7.x, and it is working properly.
>
> Only when I run this on a ADS 8.X I can recreate the data corruption.
>
>
>
>
>
> "Edgar Sherman" <no@email.com> escribi? en el mensaje
> news:47cc1cec@solutions.advantagedatabase.com...
>> Ricardo,
>>
>> I don't believe that the "fix" for 36 and your problem are related. The
>> issue is that there are 3 fields that are of type INTEGER. If I remember
>> correctly a clipper application is unable to open a DBF with Integer or
>> any of the "Extended DBF Data Types".
>>
>> Week(), Year() and Count() all return integer types.
>>
>> Try converting Week, Year and NoPerst to SQL_NUMERIC in your SQL
>> statement. I believe this should work. (Not tested)
>>
>> Select a.Sucursal,a.Toper,a.Producto,
>> convert(a.Year, SQL_NUMERIC),
>> convert(a.Week, SQL_NUMERIC),
>> Sum(a.Units) as Units,
>> Sum(a.CosTotal) as CosTotal,
>> convert(Sum(a.NOpers), SQL_NUMERIC) as NOpersT
>> Into m_VtaTot
>> from #Sumvtas a
>> Inner Join m_prod b
>> On a.Producto = b.Producto
>> Where
>> b.Inventario = 'S'
>> Group By
>> 1,2,3,4,5;
>>
>>
>> Edgar
>>
>> "Ricardo Rodriguez Erdmenger" <ricardor@adsmexico.com> wrote in message
>> news:47c8faf1@solutions.advantagedatabase.com...
>>> Tested in ADS NT.
>>>
>>> When I tested this same query in the NLM version sent an error refering
>>> to the size of a numeric field. (Version 8 - older)
>>>
>>> 36. Fixed an issue that caused the "SELECT ... INTO ... " type of SQL
>>> statement to fail when the client is older than 8.1 and the source
>>> table has DBF numeric field.
>>>
>>> Is not working properly.
>>>
>>> I ran a query, creates the File m_vtatot
>>>
>>> This file can be opened and used in ARC.
>>>
>>> NOT in Clipper. (Data Corruption)
>>> /*
>>> Consumos de Ensambles
>>> (Inverso del Archivo)
>>> Positivo es Consumo
>>> Negativo Desensamble
>>> */
>>> Select 'E' as TOper,a.Sucursal,a.Producto,
>>> Year(a.Fecha) as Year,
>>> Week(a.Fecha) as Week,
>>> Sum(a.Cantidad*-1) as Units,
>>> Sum(a.Cantidad*-1*b.Costo_Prom) as CosTotal,
>>> Count(a.Producto) as NOpers
>>> Into #SumVtas
>>> from m_ensa a
>>> Inner join m_prod b On a.Producto = b.producto
>>> Where b.Kit <> 'S' and
>>> /*
>>> a.Fecha >= :Fecha_Ini and
>>> a.Fecha <= :Fecha_Fin
>>> */
>>> Year(a.Fecha)*100+Week(a.Fecha) >= :YearN_Ini and
>>> Year(a.Fecha)*100+Week(a.Fecha) <= :YearN_Fin
>>> Group By
>>> 2,3,4,5;
>>>
>>> /*
>>> Genera la Tabla de Actualizacion
>>> prod-exp-loc-d
>>> */
>>> Select a.Sucursal,a.Toper,a.Producto,a.Year,
>>> a.Week,Sum(a.Units) as Units,
>>> Sum(a.CosTotal) as CosTotal,
>>> Sum(a.NOpers) as NOpersT
>>> Into m_VtaTot
>>> from #Sumvtas a
>>> Inner Join m_prod b
>>> On a.Producto = b.Producto
>>> Where
>>> b.Inventario = 'S'
>>> Group By
>>> 1,2,3,4,5;
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>
>