Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Vfp->sqlserver
Message
From
26/02/2020 07:30:08
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01673150
Message ID:
01673213
Views:
114
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform