Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Stonefield Query GetValuesForField Example
Message
 
To
20/11/2006 12:17:43
General information
Forum:
Visual FoxPro
Category:
Stonefield
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01169377
Message ID:
01173487
Views:
6
I didnt see the line of code you referred to, but at the end of SDTMgr.HowToSyncTable there's an ASORT on an array that holds the DROP and ADD action items. It sorts so that the ADDs happen first, per your code comment about avoiding the issue of potentially dropping all fields out of the DBF structure. I changed the ASORT to perform a descending sort and it looks like it fixed the issue of "too many columns". I'll just have to remember the issue you noted. Thanks for your help on this.

>Hi Chris.
>
>>I suspected that the ADDs were taking place before the DROPs. That explains the error. Any chance of a 'DropBeforeAdd' switch? Is that feasible?
>
>Try this: near the end of SDTMgr.HowToSyncTable is this statement:
>
>
if laToDo[lnI] <> 'drop column'
>
>Change it to:
>
>
if laToDo[lnI] <> 'add column'
>
>and see if that works for you.
>
>>Anyway, thanks for a great product. Highly recommended.
>
>Thanks for the kind words.
>
>Doug
Previous
Reply
Map
View

Click here to load this message in the networking platform