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)")
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.
Peter Cortiel