Hi,

The table pr_rate has another owner, maybe.

MartinaJ

>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.