Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]


Groups > comp.lang.clipper.visual-objects > #6273 > unrolled thread

Varchar(1) in 2.8 SP4

Started by"John S." <jsommer_notthis_@alltel.net>
First post2013-11-23 08:59 -0500
Last post2013-11-25 22:14 -0800
Articles 6 — 4 participants

Back to article view | Back to comp.lang.clipper.visual-objects


Contents

  Varchar(1) in 2.8 SP4 "John S." <jsommer_notthis_@alltel.net> - 2013-11-23 08:59 -0500
    Re: Varchar(1) in 2.8 SP4 "Jamal" <jamal@examples.net> - 2013-11-24 22:05 -0500
    Re: Varchar(1) in 2.8 SP4 Massimo Bighelli <info@arcasistemi.it> - 2013-11-25 19:19 +0100
      Re: Varchar(1) in 2.8 SP4 "John S." <jsommer_notthis_@alltel.net> - 2013-11-25 17:27 -0500
        Re: Varchar(1) in 2.8 SP4 "Jamal" <jamal@examples.net> - 2013-11-25 18:54 -0500
    Re: Varchar(1) in 2.8 SP4 pinlink@gmail.com - 2013-11-25 22:14 -0800

#6273 — Varchar(1) in 2.8 SP4

From"John S." <jsommer_notthis_@alltel.net>
Date2013-11-23 08:59 -0500
SubjectVarchar(1) in 2.8 SP4
Message-ID<d9dbf$5290b35c$cf9b776d$31075@ALLTEL.NET>
Hi all,


I have and application (2.8 SP1) I have used for years to import client data 
via ODBC. I am not able to get the application running on 2.8 SP4. I finally 
tracked down the issue to querying any table with a varchar(1). It causes 
the application to hang. I was able to use the standard MDI application to 
verify this behavior. Any suggestions or ideas would be appreciated.

Thanks,

John


[toc] | [next] | [standalone]


#6277

From"Jamal" <jamal@examples.net>
Date2013-11-24 22:05 -0500
Message-ID<l6uepk$csh$1@speranza.aioe.org>
In reply to#6273
John,

There is has been several changes to sql classes and fixes since SP1. This 
is according to the the "whatisnew" documents that came with each SP.

So, get the latest version from grafx. Hopefully it fixes your issue.

Jamal

"John S."  wrote in message news:d9dbf$5290b35c$cf9b776d$31075@ALLTEL.NET...

Hi all,


I have and application (2.8 SP1) I have used for years to import client data
via ODBC. I am not able to get the application running on 2.8 SP4. I finally
tracked down the issue to querying any table with a varchar(1). It causes
the application to hang. I was able to use the standard MDI application to
verify this behavior. Any suggestions or ideas would be appreciated.

Thanks,

John

[toc] | [prev] | [next] | [standalone]


#6285

FromMassimo Bighelli <info@arcasistemi.it>
Date2013-11-25 19:19 +0100
Message-ID<l704c1$9jk$1@speranza.aioe.org>
In reply to#6273
John,

IIRC there was an issue with field lenght
(erroneusly +1)
Maybe you compensated that +1 with -1, and now you have a field lenght = 0

:-)

*Massimo Bighelli* ARCA Sistemi S.r.l.

Il 23/11/2013 14:59, John S. ha scritto:
> Hi all,
>
>
> I have and application (2.8 SP1) I have used for years to import client data
> via ODBC. I am not able to get the application running on 2.8 SP4. I finally
> tracked down the issue to querying any table with a varchar(1). It causes
> the application to hang. I was able to use the standard MDI application to
> verify this behavior. Any suggestions or ideas would be appreciated.
>
> Thanks,
>
> John
>
>
>


[toc] | [prev] | [next] | [standalone]


#6287

From"John S." <jsommer_notthis_@alltel.net>
Date2013-11-25 17:27 -0500
Message-ID<bc8f6$5293ce42$cf9b7635$6858@ALLTEL.NET>
In reply to#6285
Hi Massimo,

Was the issue with sp1 or sp4?  I have not compensated anything as I can not 
open and view a table with the standard MDI app if the table contains a 
varchar(1).  I have adjusted my code to not include any varchar(1) fields in 
my field lists for SQL selects and everything else seems to work  I still 
however need the data from the now missing columns.

Thanks,
John

"Massimo Bighelli" <info@arcasistemi.it> wrote in message 
news:l704c1$9jk$1@speranza.aioe.org...
>
> John,
>
> IIRC there was an issue with field lenght
> (erroneusly +1)
> Maybe you compensated that +1 with -1, and now you have a field lenght = 0
>
> :-)
>
> *Massimo Bighelli* ARCA Sistemi S.r.l.
>
> Il 23/11/2013 14:59, John S. ha scritto:
>> Hi all,
>>
>>
>> I have and application (2.8 SP1) I have used for years to import client 
>> data
>> via ODBC. I am not able to get the application running on 2.8 SP4. I 
>> finally
>> tracked down the issue to querying any table with a varchar(1). It causes
>> the application to hang. I was able to use the standard MDI application 
>> to
>> verify this behavior. Any suggestions or ideas would be appreciated.
>>
>> Thanks,
>>
>> John
>>
>>
>>
>
>
> 

[toc] | [prev] | [next] | [standalone]


#6288

From"Jamal" <jamal@examples.net>
Date2013-11-25 18:54 -0500
Message-ID<l70o0j$r4u$1@speranza.aioe.org>
In reply to#6287
May be you should debug it using the parts of SQL SDK by including the 
methods you invoke and see where it hangs.

Jamal

"John S."  wrote in message news:bc8f6$5293ce42$cf9b7635$6858@ALLTEL.NET...

Hi Massimo,

Was the issue with sp1 or sp4?  I have not compensated anything as I can not
open and view a table with the standard MDI app if the table contains a
varchar(1).  I have adjusted my code to not include any varchar(1) fields in
my field lists for SQL selects and everything else seems to work  I still
however need the data from the now missing columns.

Thanks,
John

"Massimo Bighelli" <info@arcasistemi.it> wrote in message
news:l704c1$9jk$1@speranza.aioe.org...
>
> John,
>
> IIRC there was an issue with field lenght
> (erroneusly +1)
> Maybe you compensated that +1 with -1, and now you have a field lenght = 0
>
> :-)
>
> *Massimo Bighelli* ARCA Sistemi S.r.l.
>
> Il 23/11/2013 14:59, John S. ha scritto:
>> Hi all,
>>
>>
>> I have and application (2.8 SP1) I have used for years to import client 
>> data
>> via ODBC. I am not able to get the application running on 2.8 SP4. I 
>> finally
>> tracked down the issue to querying any table with a varchar(1). It causes
>> the application to hang. I was able to use the standard MDI application 
>> to
>> verify this behavior. Any suggestions or ideas would be appreciated.
>>
>> Thanks,
>>
>> John
>>
>>
>>
>
>
>

[toc] | [prev] | [next] | [standalone]


#6289

Frompinlink@gmail.com
Date2013-11-25 22:14 -0800
Message-ID<2011a78a-0c0f-42b0-bbe0-ebe6b79f2cc9@googlegroups.com>
In reply to#6273
Hi John,
Did you try to resolve your problem by using SQL functions to convert VARCHAR(1) to CHAR(1) in SELECT-expression?
F.e. CAST( My_FieldName AS CHAR(1) ) or CONVERT( CHAR(1), My_FieldName )

Ivan.

[toc] | [prev] | [standalone]


Back to top | Article view | comp.lang.clipper.visual-objects


csiph-web