Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to avoid VFP messages with DBC
Message
From
18/10/2002 17:01:03
 
 
To
18/10/2002 10:11:12
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00712547
Message ID:
00713080
Views:
21
Steve,
I tried to use this code
CREATE CURSOR Carrier (M1 M, M2 M)
APPEND BLANK
x = 'c:\JNSK\USERS.DBF'
y = 'c:\JNSK\USERS.CDX'

SELECT Carrier
APPEND MEMO M1 FROM (x) OVERWRITE
APPEND MEMO M2 FROM (y) OVERWRITE

OPEN DATABASE &cDBCLoc
SET DATABASE TO &cDBCLoc

COPY MEMO Carrier.M1 TO USERS.DBF
COPY MEMO Carrier.M2 TO USERS.CDX

but nothing happens, no tables created and command create table is justfor arrays, what could be the code to be use here? am I missing something or
my approach is the wrong one?

Thanks!

>Juan,
>
>I dunno, does SET SAFETY OFF make a difference?
>
>It seems it would be easy to programatically create a new table (in your database) with the same structure as the existing table, use the new table, and append from the old. This should avoid the message altogether.
>
>Do have old versions of Fox that need to read the new table?
>
>>
>> Just as background, the table can be opened in VFO70 with no problem
>>delete and add rows, no problem as long as is a fee table. now we decided to
>>create a database and want to include 'on the fly', but I am getting the message below each time the command ADD TABLE table1.
>>
>>File 'users.dbf' will be updated to a new file format, making it unreadable
>>to previous versions of Foxpro. This can be reversed with a 'COPY TO'
>>command, and the old table will be saved as a .BAK. continue?
>>
>>
>>I click , since I don't want to change the table's properties.
>>I think this is related to the table's code page, but if I run
>>the command ?cpdbf() the value is 1252 which is the same as
>>?CPCURRENT(1).
>>
>>So how can I avoid this message?
>>
>>Thanks!
>>
>>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform