Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Batch Update
Message
From
25/03/2004 10:29:11
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
SQL Batch Update
Miscellaneous
Thread ID:
00889611
Message ID:
00889611
Views:
54
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.
Very fitting: http://xkcd.com/386/
Next
Reply
Map
View

Click here to load this message in the networking platform