Hi Sarah,
>So no problem with me running from a .exe?
Theoretically there should not be. Though, I would test this thoroughly. < g >
>
>>Hi Sarah,
>>
>>This should be working. The only reason I can think of why this happened would be that the DBC was not opened exclusively. I know that you did specify that, but it happens at times that even after opening the DBC with EXCL command it does not open exclusively.
>>
>>You might want to try SET DATABASE TO before your CREATE TABLE and also look at ADD TABLE.
>>
>>A restart of VFP with the same commands will probably do the job.
>>
>>>I want to release an update to my exe and I've added a new table so I've included this code:
>>> OPEN DATABASE D:\bkstuff\recover\Data\bksystem.DBC exclusive
>>> MODIFY DATABASE
>>> ***** Table setup for TABLESET *****
>>> CREATE TABLE 'data\TABLESET' (TABLE C(8) NOT NULL, ;
>>> FIELD C(10) NOT NULL, ;
>>> CAPTION C(150) NOT NULL, ;
>>> HELPID N(5, 0) NOT NULL)
>>>
>>> ***** Create each index for TABLESET *****
>>> INDEX ON upper(TABLE+FIELD) TAG TABLEFIELD
>>>
>>>however.... my table gets created but isn't added to bksystem. I can change my code to expect tableset to be a free table, it's no big deal but it seems odd. I have 2 databases, one for user data, one for system settings.
>>>
>>>Any explanations?
>>>
>>>Sarah