Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.clipper.visual-objects > #6273 > unrolled thread
| Started by | "John S." <jsommer_notthis_@alltel.net> |
|---|---|
| First post | 2013-11-23 08:59 -0500 |
| Last post | 2013-11-25 22:14 -0800 |
| Articles | 6 — 4 participants |
Back to article view | Back to comp.lang.clipper.visual-objects
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
| From | "John S." <jsommer_notthis_@alltel.net> |
|---|---|
| Date | 2013-11-23 08:59 -0500 |
| Subject | Varchar(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]
| From | "Jamal" <jamal@examples.net> |
|---|---|
| Date | 2013-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]
| From | Massimo Bighelli <info@arcasistemi.it> |
|---|---|
| Date | 2013-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]
| From | "John S." <jsommer_notthis_@alltel.net> |
|---|---|
| Date | 2013-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]
| From | "Jamal" <jamal@examples.net> |
|---|---|
| Date | 2013-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]
| From | pinlink@gmail.com |
|---|---|
| Date | 2013-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