Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server Driver vs more recent ODBC driver
Message
 
 
To
29/11/2018 16:25:21
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
MS SQL Server
Miscellaneous
Thread ID:
01663573
Message ID:
01663886
Views:
42
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform