I got it.
I am able to use DDE server that I wrote from VB. Even I am able to add the field to the table as you described. Only problem is not able to add a memo field.
I did like this.
abc = space(200)
select *,abc from .....
It worked simply fine.
Thanks a lot....
>Satya,
>
>Sorry, I left the Win3 environment a long time ago. You'll have to use some sort of DDE process. You can always send FoxPro a SELECT command to run that would build a new table and add whatever fields you like:
>
>
select *, .f. as lNewField, 000000 as nNewField ;
> from TheOriginalTable ;
> into table TheNewTable
>
>>My aim is to use FP commands in VB,
>>Here is my critiria.
>>
>>Is it possible that a field can be added to a Foxpro DBF which has data.
>>I tried but in vain, later came to know , it is not possible.
>>I want a better way of modifying Foxpro DBF structure as well as values in fields from VisualBasic.
>>
>>How can it be done ?
>>I thought DDE will be best way. I use Foxpro as Server and VB as client.
>>Remember , all this I am doing in VB 4 version (16 bit) on win 3.1 without any 32 bit support.