Patrick,

I am also lazy. Try following -

=....
=SQLEXEC(gnConnHandle, "SELECT * FROM sqltable","mytable")
=CursorSetProp("Tables","mytable")
	
Local cNameList,cFieldList

for i = 1 to FCount()
   If i = 1
      cNameList = Field(i) + " " + "mytable." + Field(i)
      cFieldList = Field(i)
   Else
      cNameList  = cNameList  +", "+ Field(i) + " " + "mytable." + Field(i)
      cFieldList = cFieldList +", "+ Field(i) 
   EndIf
EndFor
=CursorSetProp("UpdateNameList",cNameList)
=CursorSetProp("KeyFieldList",field(1))		&& just assume
=CursorSetProp("UpdatableFieldList",cFieldList)
=CursorSetProp("SendUpdates",.T.)

Hope this help you.

Manoj

>Hi
> How do i programatic return all the field name from the SQL table ?
>I have create 115 fields in a SQL table. I am lazy to type all the updatablenamelist & the updatablefielddlist.
>Some code with be appreciated...
>
>Thanks