>the wizard created all table but about of them are empty
>i tied to insert manually but it wont work
>the connection is made (returns a value >0)
>here is the statement
> ? SQLExec( lnHandle , "INSERT INTO dos (os_id,osdate,osname,ostype_id ) values (cc2.os_id,cc2.osdate,cc2.osname,cc2.ostype_id)")
>
The values clause must contain objects that are recognizable to the SQL driver.
They are;
a. SQL server objects - your statements assumes that the values are SQL Server objects
b. SQL server literals e.g. values( '123')
C. VFP parameters e.g.
lc_x = "x"
values (?lc_x")
When converting vfp to SQL server, you can only use C
Check your values clause.
>what could be the problem
>
>
>Thanks
>
>Peter
>
>
>>I don't use the upsize wizard. Instead I created a PRG which goes, table by table, and copies the data from VFP to the SQL DB. I know it takes more time to create such a PRG but if you need to do upsizing multiple times (my case), it pays off.
Anyone who does not go overboard- deserves to.
Malcolm Forbes, Sr.