Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLEDB Create View ?
Message
General information
Forum:
Visual FoxPro
Category:
Other
Title:
OLEDB Create View ?
Miscellaneous
Thread ID:
00662501
Message ID:
00662501
Views:
49
Trying to create a view with a VBS. Not working (why else would I be here [grin]?). Can anyone say why?
	Set oCacheConn = CreateObject("ADODB.Connection")
	cConnString = "Provider=VFPOLEDB.1;Data Source=v:\remote1\db\alldbc1.dbc"
	With oCacheConn
		.CursorLocation = 2		' adUseServer
		.ConnectionString = cConnString
		.Open
	End With
	cExec = "Create View View01 as Select * from alldbc1!accidentstate Top 1"
	oCacheConn.Execute(cExec)


	
Error is
D:\wintemp\viewmake.vbs(13, 2) Microsoft OLE DB Provider for Visual FoxPro: Command contains unrecognized phrase/keyword.

?

Thanks.
Next
Reply
Map
View

Click here to load this message in the networking platform