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.