Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Append from cursor
Message
De
03/08/2016 02:50:16
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Append from cursor
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows 7
Network:
Windows XP
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01639069
Message ID:
01639069
Vues:
113
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.
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform