Questions tagged as 'visual-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
0
answers

Error consuming a Webservices from vfp9

I am trying to consume a service from vfp9 but it generates an error, which I have not been able to resolve. the service is active and has data when I test it from another application. This is the error that generates from vfp    Error: 1429...
asked by 23.08.2018 / 19:04
0
answers

CALCULATE LRC in VFP

I want to pass this code to vfp to calculate the LRC of a frame that I have to send, so far I have not been able ... I could collaborate since I do not handle vfp. Private Function CheckLCR(ByVal s As String) As String Dim checksum As Integ...
asked by 08.06.2018 / 00:27
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
0
answers

Script tracking in SQL Server Profiler

Because when I execute this stored procedure, it behaves like this: Since C # happens like this declare @p2 char(13) set @p2='AGB17920' exec sp_nuevo_codigo @CodGrupo='AGB',@vcodarticul=@p2 output select @p2 In Visual Fox Pro it goes lik...
asked by 22.06.2017 / 18:25
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