Who has experience with SQL Server and ODBCDBE?

This forum is for general support of Xbase++
Post Reply
Message
Author
User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Who has experience with SQL Server and ODBCDBE?

#1 Post by rdonnay »

I am working with a VFP developer to help convert one of their applications.

Everything was going well until I ran into a problem with a cursor returned by a stored procedure.

One of the fields is always a NIL value.
They claim that they have assigned a Varchar(max) value to the field in their stored procedure but Xbase++ will not recognize the type. I think it is a type "text", not supported by Xbase++ and not a type Varchar(max) because Xbase++ is reported that at least one of the field types is "text".

Has anyone dealt with this before?
The eXpress train is coming - and it has more cars.

User avatar
HaPe
Posts: 2
Joined: Tue Nov 17, 2015 6:04 am

Re: Who has experience with SQL Server and ODBCDBE?

#2 Post by HaPe »

Hello Roger !
I think it is a type "text", not supported by Xbase++ and not a type Varchar(max) because Xbase++ is reported that at least one of the field types is "text".
I "translate" my VFP-memo-fields into Varchar(max) in $MS-SQL-Server.
This was done by CursorAdapter-Class in VFP.

I think, Xbase++ should support memo-fields.
Hans-Peter

User avatar
rdonnay
Site Admin
Posts: 4722
Joined: Wed Jan 27, 2010 6:58 pm
Location: Boise, Idaho USA
Contact:

Re: Who has experience with SQL Server and ODBCDBE?

#3 Post by rdonnay »

The only way we could make this work was to change it from Varchar(MAX) to Varchar(500).

I agree that Xbase++ needs to at least support Varchar(MAX), but type Text has been deprecated by Microsoft.
The eXpress train is coming - and it has more cars.

Post Reply