I have a number of business objects each with their own private datasession. Sometimes I need to create a cursor that needs to be used by the object that has instantiated the biz object. Solution: pass in the number of the datasession being used by the ‘main’ object to the biz object, and have the biz object temporarily use the passed in datasession when creating the cursor.
However sometimes there are situations that after the BIZ Object cursor is created in the Biz Object datasession that the cursor must be ‘moved’ into the main data session. Solution ( This is a common solution ) Copy the Cursor to an actual temp table on the hard drive and Select it into a cursor in the main datasession.
The issue with the common cursor-table-cursor move is that if the original cursor has long field names by the time the new cursor is created the long field names have been reduced to standard 10 characters.
So here are the core questions:
1) Does anyone know of a solution that allows cursor to new datasession copying that does not lose long field name information?
2) If #1 is no, what about the idea of somehow using a VFP Database? I really am not a fan of the VFP Database, I use VFP free tables, but maybe a special Database that is just used for creation of temp tables for Cursor Copying might work.
3) If I come up with a solution (I have some ideas in mind ) should I post it here? Or is this not an issue for most developers.
Lion Crest Software Services
Anthony L. Testi
President
However sometimes there are situations that after the BIZ Object cursor is created in the Biz Object datasession that the cursor must be ‘moved’ into the main data session. Solution ( This is a common solution ) Copy the Cursor to an actual temp table on the hard drive and Select it into a cursor in the main datasession.
The issue with the common cursor-table-cursor move is that if the original cursor has long field names by the time the new cursor is created the long field names have been reduced to standard 10 characters.
So here are the core questions:
1) Does anyone know of a solution that allows cursor to new datasession copying that does not lose long field name information?
2) If #1 is no, what about the idea of somehow using a VFP Database? I really am not a fan of the VFP Database, I use VFP free tables, but maybe a special Database that is just used for creation of temp tables for Cursor Copying might work.
3) If I come up with a solution (I have some ideas in mind ) should I post it here? Or is this not an issue for most developers.
Lion Crest Software Services
Anthony L. Testi
President