Recent content by fanlinux90

With vfp 6 I am trying to find the different values that two tables have but the result is empty, I am using two scans to go through the tables simultaneously. The SopFact table has 100 records and Fac_Bire 102. Inconbi should have 2 records: 1020 and 850 , but it comes out empty select Fact...

I can move the same row of two different grids that use the same cursor as recordsource after clicking on any column of the grid pc and using the keyboard grid pc1 procedure afterrowcolchange LOCAL lcAlias lcAlias = ALIAS() SELECT(this.recordsource) SKIP IF EOF() GO BOTTOM ENDIF IF NOT...

In the form I first click on the approve button and then on the pending button. in a form add a button to show the records with state 0. I use version 6 of visual fox pro. button approved procedure click select f_temp go top scan If f_temp.apprvd = .T. select f_temp replace f_temp.estado with...

form1 init procedure use C:\dbfs\pr in 0 shared select doc, lastn, mname, name, phone, state,obs, apprvd; from pr ; where pr.state = 0 or pr.state = 5 into cursor f_temp1 select f_temp1 afields (f_temp_f) create cursor f_temp from array f_temp_f append from...

I have configured a grid when I click on any check it changes the value of all. but I must change the validation per row, when the check in a grid has been marked only in one row, the status must be changed only for that row. can it be done in vfp6? If thisform.Precustomers.Column1.Check1.Value...

this is the prg code [indent]SET DELETE ON [indent]SET EXCLUSIVE OFF [indent]SET EXACT ON [indent]SET CENTURY ON [indent]CLEAR ALL [indent]CLOSE ALL [indent]CLEAR [indent]DO WHILE .T. [indent]@ 05,01 To 31,150 doub [indent]SET CLOCK ON TO 07,77 [indent]@ 07,05 say "DATE : "+DMY(DATE())...

I must delete from the invent table when class has one of the following values: 'SUS','TB','CAD', 'EF', 'ND' and estado = normal DELETE FROM invent where INLIST(UPPER(ALLTRIM(class)), 'SUS','TB','CAD', 'EF', 'ND' ) and UPPER(estado)=='NORMAL' when i run the command i get the error missing...

This is the code of the init of the form if !used if !used ("supplier_temp") SELECT supplier afields(structure) CREATE cursor supplier_temp from array structure else SELECT supplier_temp for re = 1 to reccount() SELECT supplier_temp go re...

the value that is changed when pressing the process button of the selected record in the cursor supplier_tmp.control is 2 but that record is not copied to the table supplier

excuse my mistake mike lewis in writing it's not count, it's reccount() . I already fixed the code to make it more readable

This is the code of the init of the form if !used if !used ("supplier_temp") SELECT supplier afields(structure) CREATE cursor supplier_temp from array structure else SELECT supplier_temp for re = 1 to reccount() SELECT supplier_temp go re...

in the init of the form I have the following code if !used ("supplier_temp") SELECT supplier afields(structure) CREATE cursor supplier_temp from array structure else SELECT supplier_temp delete all endif SELECT provider_temp APPEND FROM...

dimension diasft(75) dimension diasf(75)

fill the arrays with a for FOR i = 0 TO ALEN(diasft,1) STEP 1 daysf = count ENDFOR

with vartype I check the arrays Messagebox(vartype(diasft)) and Messagebox(vartype(diasf)).with vartype I check the arrays returns L for both,