Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DELETE FROM ~help
Message
From
01/12/1999 16:37:33
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
DELETE FROM ~help
Miscellaneous
Thread ID:
00297544
Message ID:
00297544
Views:
54
Does anyone see a major prob with the following: It doesn't like the commandtext line...
Dim cn As New ADODB.Connection
Dim cm As New ADODB.Command
cn.Open "Driver=Microsoft Visual Foxpro Driver;UID=;SourceType=DBF;Deleted=YES;Null=NO;SourceDB=D:\"
cm.ActiveConnection = cn
cm.CommandType = adCmdUnknown
cm.CommandText = "DELETE FROM C:\windows\system\Q12.dbf WHERE officeno = " & Chr(34) & cboOfficeNum.List(cboOfficeNum.ListIndex) & Chr(34)
cm2.Execute
My AdvaThanksnce
~Joe Johnston USA

"If ye love wealth better than liberty, the tranquility of servitude better than the animated contest of freedom, go home from us in peace. We ask not your counsel or arms. Crouch down and lick the hands which feed you. May your chains set lightly upon you, and may posterity forget that ye were our countrymen."
~Samuel Adams

Next
Reply
Map
View

Click here to load this message in the networking platform