Questions tagged as 'foxpro'

1
answer

Search repeated record in a cursor with FOXPRO

CREATE CURSOR oproductos (; codant c(150),; marca c(15),; modelo c(15),; nroserie c(50),; codfab c(15),; nombre c(90)) SELECT oproductos GOTO TOP that cursor filled it in a grid with data when importing from excel, What I need, is to check...
asked by 09.12.2018 / 16:13
1
answer

Consultation based on two parameters VISUAL FOXPRO

Good morning! I would like to know how I can make a query to obtain the results of my records depending on the date. I have PEDPOS which is the order and I have CMOV which is the move that was made (101 delivered 102 returned) I have the...
asked by 10.07.2017 / 18:15
0
answers

Error concatenating I get zeros

I'm doing a concatenation of two fields but when converting it to CSV, it puts me pure zeros. I have the following code: replace pedposdoc WITH ALLTRIM(pedpos)+ALLTRIM(STR(docmat)) all Until there everything goes perfect when I use the comm...
asked by 20.07.2017 / 23:50
2
answers

In a SQL query with Visual FoxPro, how can a record access the information in the previous record?

I am working with an application that is built with Visual FoxPro 6.0 , at this moment I need to make a query that allows a record within a SELECT to obtain information from the immediately previous record to perform a calculation. The...
asked by 07.04.2017 / 15:58