General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only