Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strtran() in SQL where clause
Message
From
28/08/2002 11:23:39
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
 
To
28/08/2002 11:12:51
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00694135
Message ID:
00694488
Views:
18
>Hilmar,
>
>The quandry is that in NEITHER case is there data there for it to make this determination.

If you are at EOF, 30 spaces will be used, for instance, for a 30-byte character field.

>
>In any case I tried adding a + " " to the expression with STRTRANS and the index was creatable then.

So it seems that zero-length index keys are not acceptable. strtrans(space(1), space(0)) will give you a result of space(0) for a 30-byte character field (if you are at EOF).

>
>cheers

Is "cheers" the common way to end a letter/message in Canada? In other English-speeking countries? I see that the people from the US often use "regards".

Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform