Search results for query: *

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,

when trying to go through two arrays (daysft and daysf),both arrays have stored numbers When doing the return calculation I get an error are local variables holidayst, holidays, cvalue, return cvalue = 0 return = 0 select providers scan cvalue = vendors.vpurchase Messagebox(allt(Str(cvalue)))...

Calculate for each month the number of Fridays, Saturdays and Sundays it has. November 2022 has four Fridays, four Saturdays and four Sundays. Is it possible to calculate those days?

Between the dates 11/28/2023 and 12/02/2022 I know how many days there are. DATE(2023, 11, 28) - DATE(2022, 12, 02), how can I calculate how many Fridays, Saturdays, and Sundays there are between those two dates?

sorry for my writing error. Can you do two inner joins with dbfs tables?

i use vfp 6 should i display the vendors name as a subquery of the purchase table select date, value, (select vendor.name from vendor inner join purchase on vendor.type = purchase.vendtype) from purchase where name = "queen" but I get the error invalid subquery