Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Append from cursor
Message
From
03/08/2016 02:50:16
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Append from cursor
Environment versions
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Miscellaneous
Thread ID:
01639069
Message ID:
01639069
Views:
118
Sir I have these codes
create cursor pr_rate (date d(8), code  c(7),desc1 c(100),weight n(8,2),rate1 n(4),rate2 n(4),rate3 n(4))

I fill cursor pr_rate with some commands, when cursor has data then I want to insert this cursor into a sqlserver table.
For this I use this command
	cmd="insert into srate select * from pr_rate order by date"
		if sqlexec(con,cmd)<0
			aerror(laerror)
			messagebox(laerror[1,2])
			return.f.
		endif
But it show this error message

Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'pr_rate'.

Please help me.
Next
Reply
Map
View

Click here to load this message in the networking platform