Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
V6s5 - How to make Parameterized Views return all record
Message
From
17/03/2004 05:54:38
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
17/03/2004 05:48:04
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00886996
Message ID:
00887005
Views:
21
>Dear cetin;
>
>
>
>I have a grid, I get data from table(trans1) into grid1
>
>
>
>On click(in a grid) I write this code
>
>
>
>select 2
>
>use trans1
>
>locate for upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
>
>if found()
>
>set filter to upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
>
>replace flag with 1 for upper(NAM)=upper(trim(THISFORM.TEXT5.VALUE))
>
>endif
>
>
>
>sometimes it works and I have "1" in the field(flag)
>
>when I try again I have nothing "0"in the field(flag)…….why if you can help
>
>
>
>Remark:-
>
>On AfterRowcolChange(in a grid) I write this code
>
>thisform.text1.value=price
>
>thisform.text2.value=nam1
>
>thisform.text5.value=nam2
>
>thisform.text3.value=nam3
>
>thisform.text7.value=no
>
>thisform.text10.value=sale
>
>
>
>thisform.text3.value=thisform.text4.value
>
>
>
>with thisform.Grid1
>
> .Recordsource = .Recordsource
>
>endwith
>
>
>
>thisform.grid1.refresh

Mohammed,
Would you create this as a new thread and explain your problem a little more organized. ie: What do you want to do, code you wrote and where etc.
Thanks
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform