Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
SQL Batch Update
Message
De
27/03/2004 07:21:02
Cetin Basoz
Engineerica Inc.
Izmir, Turquie
 
 
À
26/03/2004 14:04:15
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, États-Unis
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Divers
Thread ID:
00889611
Message ID:
00890150
Vues:
31
This message has been marked as a message which has helped to the initial question of the thread.
>* Send record to SQL Server
>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
>TABLEUPDATE(.T., 'wgo_fax_server')
>
>
>There is my code and I am getting an error stating Function arguement, type, or count is invalid. Do I have the Tableupdate() in the right place?

Placement is right, parameters are wrong. Alias is 3rd parameter.

TABLEUPDATE(0, .T., 'wgo_fax_server')

Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform