Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
My table doesn't go into the database
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00135903
Message ID:
00135976
Views:
21
So no problem with me running from a .exe?

>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
Sarah King
pcpropertymanager.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform