Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SCATTER Problem
Message
From
14/12/2005 22:36:08
 
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Title:
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
MySQL
Miscellaneous
Thread ID:
01077598
Message ID:
01078121
Views:
15
Turns out the missing fields were memo fields, and I wasn't using the MEMO keyword because I didn't think I had memo fields. The cursor in question is created on the fly based on a table description from MySQL...and my field mappings make varchars into memos. Somebody used varchars for fields that were supposed to be text, so I ended up with unexpected memos.

Amazing what a browse window can reveal :P

Thanks for the replies.



>Did you use MEMO clause? W/o it MEMOs will not be scattered.
>
>>
>>I'm having a problem with SCATTER on a certain table, available at www.databar.com/junk.zip.
>>
>>Whether I do SCATTER MEMVAR or SCATTER name, it does not create variables for all of the fields in the table. The table was created from a cursor that was returned from a passthrough query.
>>
>>It seems like the code that produced this used to work. I recently put VFP9 SP1 on, but I uninstalled and reinstalled VFP without it, but the problem remains.
>>
>>Anybody know why this might be happening?
>>
>>
>>TIA
Previous
Reply
Map
View

Click here to load this message in the networking platform