![]() ![]() ![]() I have not tried writing a Paradox PAL routine with TCursors, trying to set a new Alpha field equal to the existing Memo field - don't know if that would work or not.Īnyhow, sorry for the long post, but I am wondering, has anyone run into this problem and have you found a good solution for getting Memo field data into a SQL text column?ĭale RE: Migrating Paradox 9 Memo Fields to MS SQL Server TonyMcGuire (Programmer) 20 Jan 08 19:18 I've tried adding a large Alpha field to the tables in question then running a Paradox SQL command with a CString() cast to set the new field equal to the Memo field - but no go - Paradox SQL will not accept the command. The Paradox documentation indicates that a Formatted Memo field can only be converted to a Memo or Binary field, both of which are also stored externally. When the Paradox export is done, the Memo fields are not included as an exported column. However, several of the Paradox tables have (F) Formatted Memo fields, which are not stored in the Paradox table proper, but in external. The old application has a fair bit of legacy data, most of which I have been able to export to delimited text files and import into SQL Server via some VB/SQL routines. I am porting a 10 year old Paradox application (presently in Paradox V9) over to VB.Net/ADO.Net/MS SQL Server 2005. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |