Hello,
I am running an app that will add records to SQL Server... however, I believe that it is processing these update as a batch and will not update them unless the batch number reaches a certain level, or the app is closed. Does anybody know how to manipulate this so that is adds the record everytime I tell it to without doing it as a batch? Here is my code snippet:
m.Fax_Number = ALLTRIM(TMPFAXDB.fax_number)
m.FMF_Path = ALLTRIM(TMPFAXDB.FMF_Path)
m.Customer_Name = ALLTRIM(TMPFAXDB.Customer_Name)
m.Customer_Contact = ALLTRIM(TMPFAXDB.Customer_Contact)
IF TMPFAXDB.coverpage = "Y"
m.cover_page = .T.
ELSE
m.cover_page = .F.
ENDIF
IF TMPFAXDB.hardcopy = "Y"
m.hard_copy = .T.
ELSE
m.hard_copy = .F.
ENDIF
m.fax_status = 99
m.server = ""
m.insert_date = DATETIME()
m.original_date = DATETIME()
m.attempts = 0
m.counter = 0
INSERT INTO wgo_fax_server FROM memvar
*wgo_fax_server is my data view.