Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Space
Message
 
 
To
28/07/2008 06:01:15
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Space
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01333660
Message ID:
01334463
Views:
14
Sorry, I cannot help you because you are not providing enough information about what you're trying to do.

>i search for the names via
>select stamen as below
>name1 abd alkareem or jon kamel.... mean any name have 2 parts at myfield
>name2 ali
>name3 abd alslam
>name4 bani atia
>
>SELECT F4,F1,name1,name2,name3,name4 from x2;
> where name4=lcName ;
> ORDER by name4;
> into cursor crsMyCursor readwrite
>
>thanks
>
>
>>How would youm search for 'jon kamel' agains those 4 fields?
>>
>>>
>>>many of the Arabic Names have parse name .. ex
>>>name1 abd alkareem
>>>name2 ali
>>>name3 abd alslam
>>>name4 bani atia
>>>
>>>thanks
>>>
>>>>I still not sure what you are doing. Why do you parse name if you want to search on full name?
>>>>
>>>>>thank you for reply,
>>>>>i try to find the filed name4 as (jon kamel) not as (jon) only
>>>>>
>>>>>>What arer you trying to do and what seems to be a problem?
>>>>>>
>>>>>>>
>>>>>>>i try to fitch for name as below put the name4 as (jon kamel) mean 2 parts with space between the name.
>>>>>>>
>>>>>>>
>>>>>>>  if LEN(ALLTRIM(thisform.text10.value)) > =3
>>>>>>>
>>>>>>>     For x=1 to getwordcoun(thisform.text10.value)
>>>>>>>
>>>>>>>           lcName = getwordnum(thisform.text10.value,m.x)
>>>>>>>
>>>>>>>  if m.x=1
>>>>>>>SELECT F4,F1,name4,name3,name2,name1  from x2;
>>>>>>>       where name4=lcName ;
>>>>>>>              ORDER by name4;
>>>>>>>       into cursor crsMyCursor readwrite
>>>>>>>
>>>>>>>else
>>>>>>>
>>>>>>>endif
>>>>>>>endif
>>>>>>>
>>>>>>>thanks
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform