Mindaugas,
> I still do not know the difference between SQL_VARCHAR and QL_NVARCHAR
In MS-SQL:
CHAR - Fixed length ASCII field (1 byte per character).
VARCHAR - Variable length ASCII field (1 byte per character).
NCHAR - Fixed length UNICODE field (2 bytes per character).
NVARCHAR - Variable len
I can read all fields from this table :)
Maybe this solution should be make in svn ?
/*
case SQL_CHAR:
case SQL_VARCHAR:
case SQL_LONGVARCHAR:
case -8:
case -9:
pFieldInfo.uiType = HB_FT_STRING;
break;
*/
Using such arbitrary values without kno
Hi,
I can read all fields from this table :)
Maybe this solution should be make in svn ?
/*
case SQL_CHAR:
case SQL_VARCHAR:
case SQL_LONGVARCHAR:
case -8:
case -9:
pFieldInfo.uiType = HB_FT_STRING;
break;
*/
Using such arbitrary val
On 2009 Sep 24, at 20:08, Horodyski Marek (PZUZ) wrote:
-Original Message-
From: Viktor Szakáts [mailto:harbour...@syenar.hu]
Sent: Thursday, September 24, 2009 7:09 PM
To: Harbour Project Main Developer List.
Subject: Re: [Harbour] MS SQL and ODBC.
Viktor, how can I rebuild only
>-Original Message-
>From: Viktor Szakáts [mailto:harbour...@syenar.hu]
>Sent: Thursday, September 24, 2009 7:09 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] MS SQL and ODBC.
>
>> Viktor, how can I rebuild only lib sddodbc ?
>
>j
6:32 PM
To: Harbour Project Main Developer List.
Subject: Re: [Harbour] MS SQL and ODBC.
Hi,
to:
case SQL_CHAR:
case SQL_VARCHAR:
case SQL_LONGVARCHAR:
case -9:
pFieldInfo.uiType = HB_FT_STRING;
break;
in odbcdd.c.
This helped, but only on nvarch
Viktor, how can I rebuild only lib sddodbc ?
>-Original Message-
>From: Mindaugas Kavaliauskas [mailto:dbto...@dbtopas.lt]
>Sent: Thursday, September 24, 2009 6:32 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] MS SQL and ODBC.
>
>Hi,
>
&
Hi,
to:
case SQL_CHAR:
case SQL_VARCHAR:
case SQL_LONGVARCHAR:
case -9:
pFieldInfo.uiType = HB_FT_STRING;
break;
in odbcdd.c.
This helped, but only on nvarchar.
When I make "select *" problem still :
oErr:severity_ 2
oErr:o
>-Original Message-
>From: Mindaugas Kavaliauskas [mailto:dbto...@dbtopas.lt]
>Sent: Thursday, September 24, 2009 2:49 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] MS SQL and ODBC.
>
>Hi,
[ ... ]
>
>Not enough without full documentation
Hi,
I can not check because I do not have MS SQL, but to make
error more informative, I've passed field type to :osCode. You
error log shows it is value 65527. Since it is USHORT value,
it can also mean -9, if it is signed. I can not find nor -9
neither 65527 field type sql.h. Varchar is defi
>-Original Message-
>From: Mindaugas Kavaliauskas [mailto:dbto...@dbtopas.lt]
>Sent: Tuesday, September 22, 2009 7:04 PM
>To: Harbour Project Main Developer List.
>Subject: Re: [Harbour] MS SQL and ODBC.
>
>Hi,
[...]
>> Id_klient is numeric, nazwa is varchar
Hi,
Horodyski Marek (PZUZ) wrote:
I'm try to connect to MS SQL Serwer with code :
> And app crash in dbusearea() with :
oErr:severity_ 2
oErr:osCode___ 65527
oErr:subsystem()__SDDODBC
oErr:subCode__ 1902
oErr:description__Invalid field type
oErr:filename_
oE
I'm try to connect to MS SQL Serwer with code :
*
Local rdd
Cls
rdd := RDDSETDEFAULT( "SQLMIX" )
RDDINFO( 1001, { "ODBC", "Driver={SQL
Server};Server=MSSQL.alias.firma;Database=FIRMY;Trusted_Connection=yes;"
} )
DBUSEAREA( .T., "SQLMIX", "select ID_KLIENT, NAZWA from KLIENT where
nazw
13 matches
Mail list logo
