Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
PROBLEM: SET EXACT changes seeking result ?
Message
From
08/09/2003 11:06:42
 
 
To
08/09/2003 10:59:29
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00827017
Message ID:
00827111
Views:
13
Hi Fabio,

Then it has been fixed as you noticed

Mind you, padr() behaves as it should and gives an error on any length exceeding 254 (string is too long to fit)

>Hi Gregory,
>
>This is result:
>
>CLEAR
>CREATE CURSOR MyCursor ( MemoField M NOT NULL)
>SELECT	LEFT(MemoField,254);
>	,	LEFT(MemoField,255);
>	,	LEFT(MemoField,256);
>	,	LEFT(MemoField,257);
>FROM MyCursor INTO CURSOR myResult
>DISPLAY STRUCTURE
>
>#IF .F.
>*ON  VFP6SP5 and VFP7SP1
>
>Number of data records: 0
>Date of last update:    01-01-1601
>Code Page:              1252
>Field  Field Name      Type                Width    Dec   Index   Collate Nulls
>    1  EXP_1           Character             254                             No
>* YOU CAN BUILD A FIELD WITH 255 CHARACTERS
>    2  EXP_2           Character             255                             No
>    3  EXP_3           Character               0                             No
>    4  EXP_4           Character               1                             No
>** Total **                                  511
>
>*ON  VFP8
>Number of data records:       0
>Date of last update:          30-11-1617
>Code Page:                    1252
>Field  Field Name       Type                 Width    Dec   Index   Collate Nulls    Next    Step
>    1  EXP_1            Character              254                             No
>    2  EXP_2            Character              254                             No
>    3  EXP_3            Character              254                             No
>    4  EXP_4            Character              254                             No
>** Total **                                   1017
>#ENDIF
>
>
>Then on VFP8 this problem is fixed.
>
>Fabio
Gregory
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform