Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Simple VFP program to backup SQL Server database
Message
From
10/12/2003 10:56:10
 
 
To
10/12/2003 10:43:38
General information
Forum:
Visual FoxPro
Category:
Client/server
Miscellaneous
Thread ID:
00857511
Message ID:
00857691
Views:
22
The Ns are Unicode constants, provided by SQL-92 standars.
From BOL spanish:
"Las constantes Unicode se especifican con una N a la izquierda: N'Una cadena Unicode'."



>You could try this as well:
>>
>>
>>LOCAL lcSQLScript, loConnection
>>
>>loConnection = CREATEOBJECT('ADODB.CONNECTION')
>>loConnection.Open("Provider=SQLOLEDB.1;User ID=MyUserName"+;
>>	+";PWD=MyPassword"+;
>>	+";Persist Security Info=False"+;
>>	+";Initial Catalog=MyDatabaseName"+;
>>	+";Data Source=MyServerName")
>>
>>lcSQLScript = ;
>>"BACKUP DATABASE [MyDatabase] TO  DISK = N'C:\Backups\BackupFilename' "+;
>>"WITH  INIT ,  NOUNLOAD ,  NAME = N'MyBAckupName',  NOSKIP ,  STATS = 10,  "+;
>>"DESCRIPTION = N'MyBAckupName',  NOFORMAT "
>>
>>loConnection.Execute(lcSQLScript)
>>
>Thank you. Very educational.
>What is the significance of those Ns in front of the quotes?
Apoya a Visual FoxPro usandolo legalmente
--
¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º
Espartaco Palma Martínez
SysOp PortalFox
http://www.portalfox.com
esparta@portalfox.com
Previous
Reply
Map
View

Click here to load this message in the networking platform