If it's a local cursor, SQL server can't "see" it. You have to scan the cursor, and insert every record separately.
>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.