Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Remote View doesn't like Logical Data Type
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Remote View doesn't like Logical Data Type
Versions des environnements
Visual FoxPro:
VFP 9 SP2
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Virtual environment:
Hyper-V
Divers
Thread ID:
01637376
Message ID:
01637376
Vues:
64
The title may not fully describe the issue.

I have DBSETPROP() set up to use a Logical data type, and its real field or column in SQL Server is a BIT data type with NULL allowed. Unfortunately, the GENSADBC program fails at the point where the logical data type is declared in DBSETPROP(). I'll show the code below:

I haven't been on here in a long time, so I am not sure what to use to surround the FoxPro code. maybe someone can clue me in?

* Properties for the PHY_GROUP.suppress_negative_faxing.
DBSetProp("PHY_GROUP.Suppress_Negative_Faxing","Field","DataType","L")
DBSetProp("PHY_GROUP.Suppress_negative_Faxing","Field","UpdateName","dbo.phy_group.suppress_negative_faxing")
DBSetProp("PHY_GROUP.Suppress_negative_Faxing","Field","KeyField",.F.)
DBSetProp("PHY_GROUP.Suppress_negative_Faxing","Field","Updatable",.T.)
Cecil T. Champenois, Jr., MSCS

http://www.champenois.com
http://www.iedotnetug.org/sf
http://www.atoutfox.org
Répondre
Fil
Voir

Click here to load this message in the networking platform