Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VARCHAR problem with SQL Server 2003
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
VARCHAR problem with SQL Server 2003
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2003
Network:
Windows 2003 Server
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01504092
Message ID:
01504092
Views:
132
Have a table filled with comments. Use varchar for the comments. Something changed in our testing environment, this has been working fine for at least a year. Now a SQL Select to this table the field returned back in VFP in the cursor returns an empty text field. If I copy the SQL select command out of the code, run it at the command prompt I get a memo field with the text that is there which WAS the behavoir before.

Any ideas what to look for.
What ben makes tracks for what wil be. Words in the air pirnt foot steps on the groun for us to put our feet in to.

Riddley Walker
Next
Reply
Map
View

Click here to load this message in the networking platform