hi,
thanks,
Select * from myTable into cursor myCursor readwrite where .F.
1.can i put it at myform--->inti
becuse i need to creat it every time,when i run my form.
2.and if this form is sharing evrey user can insert at this grid differant data.
3.what that mean
where .F.
4.and if i want to put it at myform as grid
can i do that
With thisform.grdMyGrid
>> .RecordSource = "csrMyCursor"
>> .Column1.ControlSource = "csrMyCursor.Field1"
>> .Column2.ControlSource = "csrMyCursor.Field2"
>> .Column3.ControlSource = "csrMyCursor.Field3"
>> ... etc.
>>
>>thanks.
>To create an empty cursor with the same structure as your table:
>Select * from myTable into cursor myCursor readwrite where .F.
>
>>hi,
>>thanks.
>>can i make it like uder via form--->inti
>>Select mytable name into cursor csrMyCursor moh.
>>
>>you man i must repait all fields ...
>>
>>With thisform.grdMyGrid
>> .RecordSource = "csrMyCursor"
>> .Column1.ControlSource = "csrMyCursor.Field1"
>> .Column2.ControlSource = "csrMyCursor.Field2"
>> .Column3.ControlSource = "csrMyCursor.Field3"
>> ... etc.
>>
>>thanks.
>>
>>
>>>>hi all,
>>>>
>>>>i need to create temperory table, at my form , and build grid via this table.
>>>>after save ,drop this table, if i run my form again ,creat it again,
>>>>
>>>>if this form sharing ,if any user run this form he get deffirent table ,
>>>>
>>>>thanks.
>>>
>>>You can create your temp table via Select ... into cursor csrMyCursor .... ReadWrite.
>>>
>>>Then you can set up your grid by:
>>>
>>>
>>>With thisform.grdMyGrid
>>> .RecordSource = "csrMyCursor"
>>> .Column1.ControlSource = "csrMyCursor.Field1"
>>> ... etc.
>>>