Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Type of column being changed in query
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Divers
Thread ID:
01355343
Message ID:
01355357
Vues:
25
This message has been marked as the solution to the initial question of the thread.
>I am doing a query via a cursor adapter into Sql Server. I have a table named systems that has a column sysid that is of type BIGINT. When I check my cursor after teh .Fill() below the column type on sysid is now C. In fact all my bigint columns are being converted to C. here is the code snippet any one knpw why this is happening? Is it because they are type BIGINT in Sql and Fox cannot interpret them?

Yes. VFP does not support 8 byte integers (bigint in SQL Server).
--sb--
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform