>>>>>Can a Database and tables be created on a non-foxpro installed machine only with the installed Visual foxpro ODBC driver i.e. through other development programs like VB etc ?
>>>>>
>>>>>Or atleast from VFP through ODBC ?
>>>>>
>>>>>If So how ?
>>>>>
>>>>>suhashegde
>>>>
>>>>Hi Suhas,
>>>>ODBC driver supports create table..., alter table... etc SQL commands.
>>>>Cetin
>>>
>>>
>>>Hello Cetin,
>>>
>>>Thanx for replying,
>>>Yes I do know that ODBC driver supports SQL commands but does not support CREATE DATABASE. So my think was that if a free table is created with the schema of that of the dbc, Insert the 5 records in to it that it has when freshly created and then renamed the dbf as dbc and the fpt as dct would it work ? The dcx would be created on first opening the dbc.
>>>
>>>Just wanted to ask if someone has done it before rather than burn my energy and then know that it is not possible.
>>>
>>>Suhashegde
>>
>>I've never tried but it's not hard to create dbc. With some lowlevel processing you should be able to create a DBC.
>>Cetin
>
>"LOW LEVEL " That gives me shivers, Any way can U provide me pointers where to start ?
Oh not much scary. In help check
"Table File Structure (.dbc, .dbf, .frx, .lbx, .mnx, .pjx, .scx, .vcx)"
Byte offsett 28 of a database is 0x04.
To make it simple you might create a dummy empty dbc as a template and use its files instead.
Cetin