[foxpro] Forum Topics

hello! i am currently working on a simple file make application , this application read data from foxpro .dbf file , i want to get records between two dates , from date and to date , the invoice date field name is fl02 here is my query but this is …

Dear all i'm getting an error with the code below [B]The Error....[/B] [QUOTE][B]SQL Syntax Errors Encountered[/B] Error in Select clause: expression near 'DESC'. Missing from clause Unable to parse query text[/QUOTE] [B]Any ideas....[/B] [B]I'm using...[/B] [LIST] [*]Visual Studio 2010 [*].DBF Database [*]Foxpro [*]Building Windows app [/LIST] [CODE] SELECT product.code, product.DESC, …

Hi. I have written a process that takes a list of values from a spreadsheet and updates a foxpro table, adding records if they do not exist, or updating them if they do. I determine if the record exists by a seek command, which works fine. But if my process …

I have this code in the add button. The recordsource of the grid is a local view. Record is not updated after thisform.grid1.refresh. also tried thisform.refresh but it still not work. [CODE] SELECT teybolinboys APPEND BLANK replace c_id WITH thisform.txtcus.Value replace p_id WITH thisform.txtpro.Value replace selldate WITH thisform.txtdat.Value replace quantity …