Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Server Driver vs more recent ODBC driver
Message
 
 
À
29/11/2018 16:25:21
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Divers
Thread ID:
01663573
Message ID:
01663886
Vues:
43
>The CursorAdapter datasource is the connection handle. No problem.
>
>So the only issue you have is identifying your memofields. If you a) have them uniquely identified (e.g., mMyMemo) or have an active data dictionary, use that information to "map" those fields to Memo data type in VFP. And if not, that information is easy enough to pull from your DBC either dynamically or once, the latter into a cTable, cField table you package into your EXE. That information is used to map from the backend to the CA.
>
>Hank
>
I don't understand you. We do use sqlexec for our data manipulations. sqlexec is not used directly but rather something like mysqlexec and we're passing the sql statement to it, say, 'select * from dbo.myTable where someColumn = 123".

The select * may refer to a table having varchar(max) column in it.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform