olaf :
yeah, i realize now that i didn't know much about this VFP (such a shame)
but thanks anyway for your help olaf, i really glad i have meet guys like you and mike.. i really really appreciate it... :)
thank you again..
eventhough there is still much trouble in my project but i'm trying...
it's done..... :)
my failt is in the LIKE clause, i changed it to LIKE('*'+cari+'*',ALLTRIM(UPPER(nama_obat)))
and it's work now... :)
thanks mike, i really appreciate your help..
thank you and have a merry Christmas .. :)
thank you Olaf and have a merry Christmas too.. :)
mike
now the all the data can appear in the grid (thanks to you)
and i place this code in
form1.init :
------------------------------------------------------------------
SELECT nama_obat, harga FROM t_obat INTO CURSOR csrResults
Thisform.grdT_obat.RecordSourcetype = 1...
Olaf :
really? then why when i write down SELECT * FROM table INTO CURSOR xyz, it's always shown a message box that said "Syntax Error", until i add a WHERE clause. then the message box disappear?
mike :
like i said, it's just my simple thought just to try your solution and i'm going to bed...
hi lewis..
it's worked.. :)
but it can't be used in my project, because the grid supposed to show all data at the first run, and the searching method is not by clicking a button but with interactive change, thats the requirement.
so i'm trying to adapt your code to my needs it become like this...
olaf
thx for the advice, like you said. i am going to use queries that mike gave me,, ^^
thank you thank you, i really appreciate your help.. :)
mike..
i'm sorry if my attitude disturbing you..i didn't mean to rushing you or what. but you must understand that i am in indonesia, which is GMT...
yup...
i've temporary removed the filtering code from my textbox and run my program once again, but nothing change.. :(
i've been thinking about this and what do you think about this thought:
when i choose one record in the orderitem table, the item table show only the record that relates to...
Olaf :
i didn't do that in code..i did that in property windows.. see that i write it below the ----------- mark
isee, i've already knew it but thanks anyway for your advice.. :)
Mike :
nope, thats not the problem..i've already moved the code in my textbox but the problem still there..
mike..
i have already did what you suggested earlier, at the first run, the textbox was blank, and the color turns out to gray, but when i click the button i made, the data shown. but the grid still empty.. :(
actually i have set that property. check my last post and see below thisform.init...
to make this clear..i'll post the code here..^^
and u should know that this form, is supposed to be a search form
thisform.text1.interactivechange : (doesnt have control source)
------------------------------------------------------------------
IF !EMPTY(this.Value)
SET FILTER TO...
when i used the Data Session windows and run my program, i could see that all table in form 1 are still open when form 3 running.
what am i exactly i saw is just and empty grid and textbox, that grid is supposed to show all data in one table from form 1.
to referencing the table from form 1...
hi mike
thx 4 your answer
i've make sure that the data session in all forms are "1 - Default Data Session"
and when i open form 3, form 1 and form 2 are still open.
any suggestion?
hi there
i'm a newbie in VFP 9.0 programming and now i had a problem in my code..
i have 3 form in this project (not all, but this 3 is the problem)
form 1 called form 2, and form 2 called form 3..
form 2 and 3 doesn't use any data environment because i've read that if the base form had a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.