Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
UpdateNameList
Message
From
06/01/2003 12:47:04
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Miscellaneous
Thread ID:
00738407
Message ID:
00738415
Views:
23
This message has been marked as the solution to the initial question of the thread.
>I am trying to set the UpdateNameList property of a remote cursor and can't get the syntax right. The following works for one field:
>
>cursorsetprop('updateNameList','field1','tablename')
>
>I've tried using the following for more than one field but none of them work:
>
>cursorsetprop('updateNameList','field1','field2','tablename')
>cursorsetprop('updateNameList','field1,field2','tablename')
>
>Anybody know the correct syntax?
>
>Gerry Newton

Gerry,
UpdateNameList have fieldnames as "LocalName RemoteTable.RemoteName" pairs. ie: For v_authors that's SQL server pubs database authors table it might look like :
CURSORSETPROP("UpdateNameList", ;
	"myau_id authors.au_id,"+;
	"myau_lname authors.au_lname,"+;
	"myau_fname authors.au_fname",'V_authors')
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform