Environment versions
Network:
Windows 2008 Server
>>>>Use a CursorAdapater class if you need memofields from a dynamic query. It was made for that purpose, and you only need to map certain fields.
>>>>
>>>Not an option for us.
>>
>>And why would that be?
>
>Because in that huge application (which is currently being re-written) there are statements like
>
>=mySQLExec('select * from myTable where ', ...)
>
>MyTable can have varchar(max) columns or varbinary(max) columns or text columns (sometimes one table has both types).
>
>So, what exactly you're proposing that will require minimum changes (say, just a change in mySQLExec procedure)?
Yes: you had the good sense to wrap the sqlexec, so making it into a cursoradapter class that does the same work is easily done. The only question is whether you have metadata available (e.g., you are using hungarian notation; you have a data dictionary; etc. -- assuming you have the VFP tables available, it would be short work to get a table with table and fieldnames available where the VFP side is a memofield). From there it's straight-forward.
Hank
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only