cCmdLine="command.com /c copy customer.dbf customer.bak >65898934.tmp"
DECLARE INTEGER WinExec IN kernel32 STRING cCmdLine, INTEGER nCmdShow
=WinExec(cCmdLine,0)
RETURN"
where exactly i can place this code?
zhed
is it possible to make backup for my database?in my main program, is it enough to place such as SET AUTOSAVE ON in order to save those file in case of power problem(brownout)? Or anything best way to do that...
zhed
sir olaf...
your suggestion works fine..sir..is it possible to detect if the ctc number is already exist?i know this question is irrelevant in this thread but i just want to know if possible. i have this code to detect if the user inputs the ctc number and when the name is differ with the name...
sir olaf,...
yes sir,, i want to get the new values for my ctc number and date issued.when i remove the code
IF !BOF() then
thisform.txtctcnum.Value = ctcnum
thisform.txtdateissued.Value = dateissued
endif
for my search textbox, it will not get the last record instead the first...
sir olaf,
is that possible when my text boxes properties is not control source to my table?
after i save the record, my form releases that's why i need to search for my record.
zhed
sorry for the late reply....
here's the scenario,i save my record and these records are id which the index in my table,name,CTC number,Date issued, and etc.After i save my record i want to search it for edit and update for my CTC number and date issued.i use LOCATE FOR name =...
I am searching the last record i save using the BOF() but it does not search the last record instead the first record viewed.
whats wrong in my code?
SELECT transaction
SET ORDER to id
LOCATE FOR name = ALLTRIM(thisform.txtname.Value)
IF FOUND()
IF !BOF() then
thisform.txtctcnum.Value =...
how to search the value of check box if the type in the field is logical?i tried the thisform.check1.value to search it but it does not display check, but when i browse it, it is true.
zhed
can anyone help me how to delete mm/dd/yyyy date format?and its type in the table is in DATE. when i run the form and delete the value of my txtdate, the character / is also deleted..how can i remain those two character signs (//)?
thanx for advance...
zhed
how to use set filter....
i have a code in set filter but in the presence on the table..
LPARAMETERS tcFieldName, tcSearchText
SET FILTER TO && clear any previous filters
SET FILTER TO ALLTRIM(UPPER(&tcFieldName)) = ALLTRIM(UPPER("&tcSearchText"))
GO top
thisform.refresh()
i want to use...
sorry sir.....
i got the problem.the code is correct and my mistake is not placing the name of my pad in the menu designer option..thanx for your help...
zhed
sir olaf.....
this is my code in log in form which exactly the code in disabling my menu happens.
with thisform
select staff
IF thisform.text1.value=staff.password then
thisform.Refresh()
SET SKIP OF MENU _msysmenu .f.
thisform.Visible = .f.
thisform.release
thisform.Refresh ()...
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.